PHP - How To Echo Option I Selected, Because Right Now It Shows Blank

I have the following which fils a combo box with years from 1950 to 2100. This is the year box for the date of birth.

Year 
<select name="year_select">
<?php
for( $i=1950; $i<=2100; $i++ )
{
echo "<option value=\"{$i}\" class=\"year\">{$i}</option>";
}
?>
</select>

I want it to automatically display the year that is in the database so instead of automatically displaying 1950 i want their birth year displayed which is $tab_info->user_dob_year. How would i go about this? i dont know where to start since im using a for loop to populate it.

mysql.php
<?php
$con = mysql_connect("localhost","root","");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("ckeditor",$con);
?>
---------------------------------------------------------
add.php
<?php
include("mysql.php");


if(isset($_POST["button2"]))
{
$sql="INSERT INTO cktext (section)
VALUES
('$_POST[select2]')";

if (!mysql_query($sql,$con))
  {
  die('Error: ' . mysql_error());
  }

?>

-----------------------------------------------------------------
home.php

<form id="form1" name="form1" method="post" action="add.php">
<tr>
    <td>Section:</td>
    <td><select name="select2" id="select2">
     <option selected="selected" value="MALE">Male</option>
  <option selected="" value="FEMAIL">FEMAIL</option>
    </select></td>
  </tr>
<input type="submit" name="button2" id="button2" value="Upload" />
  </form>

In DATABASE :- cktext table attribute "section" is varchar type.

BUT IT RETURN ME BLANK OUTPUT.

I'm just attempting to learn how PHP handles things and I can't quite wrap my head around how to apply Selected to the final Option and show the Traits for the Character based on the Selected Option.

I understand this might need POST, if it does, I would appreciate a bit of help on how I would set this up as POST since I didn't think a drop down required a submit button.

Code: [Select]
$character= array (array(Name=>"Barry","Class"=>"Fighter",Level=>1,Str=>10,Dex=>10,"Int"=>10),array(Name=>"Lindehar","Class"=>"Ranger",Level=>1,Str=>10,Dex=>10,"Int"=>10),array(Name=>"Verelden","Class"=>"Mage",Level=>1,Str=>10,Dex=>10,"Int"=>10));

print "Select a Character:<br /><select>";
foreach($character as $array_num)
{
foreach($array_num as $char_trait=>$trait_value)
{
if($char_trait==Name)
{
$selected_value="";
$generated_chars="<option selected=".$selected_value." value='".$char_trait."'>".$char_trait.": ".$trait_value."</option>";
print $generated_chars;
if($selected_value=/".$char_trait.": Barry"/")
{
foreach($char_trait=="Barry")
{
print "<h4>".$char_trait.": ".$trait_value."</h4>";
}
}
}


}
}
print "</select><p />";

Hi,

I wanted to make a dynamic php page. I want the user to choose an option you could select in an option box (html) and after that I wish that down the page some text would change. If I take option 1 -> text 1, option 2 -> text 2, ...
But this doesn't work, do I need a button or something to made my code running, and how do I have to use it on the same page?
Or is it possible to run it automaticly after a new choice?

Thanx, Kevin



My code:

<?php
/*
Template Name: template voor Ieder1Trainer #
*/
get_header(); 

$Tacktiek = "";

$Tacktiek1 = "3-5-2";
$Tacktiek2 = "3-4-3";
$Tacktiek3 = "4-5-1";
$Tacktiek4 = "4-4-2";
$Tacktiek5 = "4-3-3";
$Tacktiek6 = "5-4-1";
$Tacktiek7 = "5-3-2";

$aantalDef;
$aantalMid;
$aantalAtt;

?>

<div id="newsfeed">

<div class="banderol">
<div class="banderol_left"></div>
<h1>Dynamic page</h1>
</div>

<?php if(is_user_logged_in()) { 
get_currentuserinfo();
//echo 'Username: ' . $current_user->user_login . "\n";
//echo 'User email: ' . $current_user->user_email . "\n";
?>

<!-- 
Here you choose a tactiek; 1,2,3, .. after that has been choosen I whise the next php-code would be run (the if-then-elseif-...)
-->

<tr>
<td><p class="formulier">Kies je Tacktiek:</p></td>
<td>
<select size="1" name="$Tacktiek">
<option selected><?php echo $Tacktiek1;?></option>
<option><?php echo $Tacktiek2;?></option>
<option><?php echo $Tacktiek3;?></option>
<option><?php echo $Tacktiek4;?></option>
<option><?php echo $Tacktiek5;?></option>
<option><?php echo $Tacktiek6;?></option>
<option><?php echo $Tacktiek7;?></option>
</select>
</td>
</tr>

<!--
This must be run after choosen a tactiek.
-->

<?php
if($Tacktiek == '3-5-2') {
$aantalDef = 3;
$aantalMid = 5;
$aantalAtt = 2;
} elseif($Tacktiek == '3-4-3') {
$aantalDef = 3;
$aantalMid = 4;
$aantalAtt = 3;
} elseif($Tacktiek == '4-5-1') {
$aantalDef = 4;
$aantalMid = 5;
$aantalAtt = 1;
} elseif($Tacktiek == '4-4-2') {
$aantalDef = 4;
$aantalMid = 4;
$aantalAtt = 2;
} elseif($Tacktiek == '4-3-3') {
$aantalDef = 4;
$aantalMid = 3;
$aantalAtt = 3;
} elseif($Tacktiek == '5-4-1') {
$aantalDef = 5;
$aantalMid = 4;
$aantalAtt = 1;
} elseif($Tacktiek == '5-3-2') {
$aantalDef = 5;
$aantalMid = 3;
$aantalAtt = 2;
}

?>

<!--
After this run, the next code must be run and made a choose of text
-->

<tr>
<td><p class="formulier">
<?php if($aantalDef == '3') {
echo "3 defs";   //Choosen text if aantalDef == 3
}
elseif($aantalDef == '4') {
echo "4 defs";   //Choosen text if aantalDef == 4
}
elseif($aantalDef == '5') {
echo "5 defs";   //Choosen text if aantalDef == 5
}
?>
</p></td>

<!--
Other choose of options, but always the same options.
-->
<td>
<select size="1" name="$Speler4">
<option selected><?php echo $NaamDef1;?></option>
<option><?php echo $NaamDef2;?></option>
<option><?php echo $NaamDefMid1;?></option>
<option><?php echo $NaamDefMid2;?></option>
<option><?php echo $NaamDefMid3;?></option>
<option><?php echo $NaamDefMid4;?></option>
<option><?php echo $NaamDefMid5;?></option>
<option><?php echo $NaamDefMid6;?></option>
<option><?php echo $NaamDefMid7;?></option>
<option><?php echo $NaamDefMid8;?></option>
<option><?php echo $NaamDefMidAtt1;?></option>
<option><?php echo $NaamDefMidAtt2;?></option>
<option><?php echo $NaamDefMidAtt3;?></option>
</select>
</td>
</tr>


<?php
} 
else{
echo 'U dient in te loggen.';
}
?>


</div>

<?php get_footer(); ?>

If I have a variable and a hard coded select dropdown, what is the easiest way to compare the variable with the value and set that particular option's selected attributed to selected?

Not sure exactly where this problem is coming from, but php seems the most likely candidate to fix it.  My php loads, from a MySQL database, a list of names (students in a class) and a drop-down for each student with attendance options.  Based on the information in the database, the appropriate attendance option is selected (<option selected></option>).  Everything works fine on the initial page load. 

Next, I want to update the status, so I select a new option from the drop-down list and click submit.  The php code updates the database correctly, but the selected option (in HTML) is still the original one.  If I change the option to something different and submit again, I get the previously selected option (that I selected the first time) - in essence, the HTML is always one step behind the database.

I've attached the snippet of relevant code - again, I know that the code works when the page loads initially and that the database is getting updated correctly.  Any help or comments are appreciated.

I have a form that contains 3 text fields and 7 populated lists (that are dependent on the choice of the previous lists).  When I post the information to MySQL and to my processing page, it posts the table "ids" instead of the selected option. 

Here's the php code for the form:

<form action="gccsuccess_form.php" method="post" enctype="multipart/form-data" name="gcc" id="gcc">
  <table width="700" border="0" align="center" cellpadding="3" cellspacing="3">
    <tr>
      <td><label for="date">Today's Date:</label>
 <input type="text" name="date" id="date"></td>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <td>Week Number:
       <select name="week" size="1" id="week">
         <option value="0" selected>Week 0 - 3/26 - 4/1</option>
         <option value="1">Week 1 - 4/2 - 4/8</option>
         <option value="2">Week 2 - 4/9 - 4/15</option>
         <option value="3">Week 3 - 4/16 - 4/22</option>
         <option value="4">Week 4 - 4/23 - 4/29</option>
         <option value="5">Week 5 - 4/30 - 5/6</option>
         <option value="6">Week 6 - 5/7 - 5/13</option>
      </select></td>
      <td><label for="location"></label>
      </td>
    </tr>
    <tr>
      <td>Location:
        <select id='locations' name='location'>
      </select></td>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <td><label for="label8">Team Name</label>
<select id='team_names' name='team_name'>
</select></td>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <td><em>*Please enter each team member's first and last name:</em></td>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <td><label for="mem_1"> Team <strong>Captain:</strong></label>
        <select id='team_members 1' name='capt'>
        </select></td>
      <td><label for="label4"><strong>Steps:</strong></label>
        <input type="text" name="steps_1" id="steps_1"></td>
    </tr>
    <tr>
      <td><label for="mem_2">Team Member #2 <strong>Name: 
        <select id='team_members 2' name='mem_2'>
        </select>
      </strong></label></td>
      <td><label for="label5"><strong>Steps:</strong></label>
        <input type="text" name="steps_2" id="steps_2"></td>
    </tr>
    <tr>
      <td><label for="mem_3">Team Member #3 <strong>Name:
            <select id='team_members 3' name='mem_3'>
        </select>
      </strong></label></td>
      <td><label for="label6"><strong>Steps:</strong></label>
        <input type="text" name="steps_3" id="steps_3"></td>
    </tr>
    <tr>
      <td><label for="mem_4">Team Member #4<strong> Name</strong>:
        <select id='team_members 4' name='mem_4'>
        </select>
      </label></td>
      <td><label for="label7"><strong>Steps:</strong></label>
        <input type="text" name="steps_4" id="steps_4"></td>
    </tr>
    <tr>
      <td><label for="label">Team Member #5<strong> Name</strong>:
        <select id='team_members 5' name='mem_5'>
        </select>
      </label></td>
      <td><label for="label7"><strong>Steps:</strong></label>
          <input type="text" name="steps_5" id="steps_5"></td>
    </tr>
    <tr>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <td>&nbsp;</td>
      <td><em>* Maximum steps for each team member per week is <strong>105,000. </strong></em></td>
    </tr>
    <tr>
      <td>&nbsp;</td>
      <td><input type="submit" name="Submit Form" id="Submit Form" value="Submit"></td>
    </tr>
  </table>
  <label></label>
  <div align="center"><br>
    If you have questions about the competition or reporting please contact KC   WELLNESS, INC&nbsp;toll free at <SPAN id="lw_1237248942_0">877-634-1412.</SPAN><br>
    <br>
  </div>
</form>


And here's the code for the page it is posted in:

<?php
      
      $date = $_POST['date'];
      $week = $_POST['week'];
      $location = $_POST['location'];
      $team_name = $_POST['team_name'];
      $capt = $_POST['capt'];
      $mem_2 = $_POST['mem_2'];
      $mem_3 = $_POST['mem_3'];
      $mem_4 = $_POST['mem_4'];
      $mem_5 = $_POST['mem_5'];
      $steps_1= $_POST['steps_1'];
      $steps_2= $_POST['steps_2'];
      $steps_3= $_POST['steps_3'];
      $steps_4 = $_POST['steps_4'];
      $steps_5 = $_POST['steps_5'];
      
      mysql_connect("mysql1.myregisteredsite.com", "49200_kandace", "Leonardo56")
      or die(mysql_error());
      mysql_select_db("49200_GCC") or die(mysql_error());
      mysql_query("INSERT INTO `walkathon` VALUES ('$date', '$week', '$location', '$team_name', '$capt','$mem_2','$mem_3',  '$mem_4', '$mem_5', '$steps_1','$steps_2', '$steps_3','$steps_4', '$steps_5' )"); 

      Print "Thank you for your entry. <br>
      Report summary: <br/><br/>";    
      
         echo "<strong> Date: </strong>   {$date} 
         <br/> <br/><strong> Week: </strong>   {$week}
         <br/> <br/><strong> Location: </strong>  {$location}
         <br/> <br/><strong> Team Name: </strong>   {$team_name}
         <br/> <br/><strong> Team Captain: </strong>  {$capt} / <strong> Steps: </strong> {$steps_1} 
         <br /> <br/><strong> Team Member 2 Name: </strong>  {$mem_2} / <strong> Steps: </strong> {$steps_2} 
         <br /> <br/><strong> Team Member 3 Name: </strong>  {$mem_3} / <strong> Steps: </strong> {$steps_3}
         <br /> <br/><strong> Team Member 4 Name: </strong>  {$mem_4} / <strong> Steps: </strong> {$steps_4}
         <br /> <br/><strong> Team Member 5 Name: </strong>  {$mem_5} / <strong> Steps: </strong> {$steps_5}"
         
               ?>

How do I get the processing page to echo the selected option instead of the id?

I'm trying to create a dynamic option menu with one alert selected based on the first query to the db. Any help would be greatly appreciated. 

Code: [Select]
//function to get alerts and create select menu with current alerts pre-selected
function getALERTS1($id){
    require('db.php');
    $alert = mysqli_query($conn, "SELECT alert1 FROM visit_data WEHERE patientid = $id AND discharged IS NULL");
    $row = mysqli_fetch_array($alert);
   
    $selects=null;
    $query = mysqli_query($conn, "SELECT alertid, name FROM alerts");

while($row1 = mysqli_fetch_array($query)) {
    $selects .= "<option value=\"" . $row1['alertid'] . "\">
    if($row1['alertid']==$row['alert1'])
            {
                echo ' selected';
            }
   
    ".$row1['name']."</option>";
  }
  return $selects;
}

Good day all,

I am really in need of some help here with my website. I am new to the php and mysql environs, but an avid supporter and learner.

I have a problem making my drop down 'category' option to work - as in when I select an option from the drop down list, it should pull the data from the mysql database which works magically with the keyword searches, etc...its just the category search not working - below is the coding which I am working with currently:

action=search.php method=get>         Keyword : <input type=text name=k />         Category :                   <select name=b>            <option value=0>All</option>         <?php            $connection = mysql_connect('127.0.0.1', 'vale_view', '8hw9er1' );            if (!$connection)            {               die ("Could not connect to the database: <br />". mysql_error());            }            $db_select=mysql_select_db('vale_view');            if (!$db_select)            {               die ("Could not select the database: <br />". mysql_error());            }                        $query = "SELECT catid,catname FROM categories order by catname";            $result = mysql_query( $query ) or die('die');                        if (!$result)            {               die ("Could not query the database: <br />". mysql_error());            }            while ($result_row = mysql_fetch_row($result)) {               echo "<option value=".$result_row[0].">".$result_row[1]."</option>";            }                        mysql_close($connection);         ?>

 

Hi, I have an html form in "send.htm" that sends data to "retrieve.php" with the following structu

send.htm:
Code: [Select]
<html>
<body>

<form method="post" action="retrieve.php"
<select id='select' name='select' >
                        <option>option1</option>
                        <option>option2</option>
                        <option>option3</option>
                        <option>etc...</option>
</select>
<input type="submit">
</form>

</body>
</html>
retrieve.php:
Code: [Select]
<?php

$selectedoption        = $_POST['select']; 

print"

<html>
<body>
<select id='select' name='select' >
                        <option>option1</option>
                        <option>option2</option>
                        <option>option3</option>
                        <option>etc...</option>
</select>
</body>
</html>
";
?>
How do I specify that the select menu in retrieve.php should have the option selected that was chosen from the select menu in send.htm?

I'm guessing this is probably quite straightforward, but I can't quite work it out. Please help!
Thanks.

hi all i am having a big problem that i have been trying to find out what is going on for weeks. i have a echo script that echos data that is in my database, and if i have to refresh the page it will add blank data in my database and the top echo info is blank as well. how can i fix this, and i was wanting to know how do i echo out my info in a textarea. i added a jepg to show you what i mean.

here is my code

echoforms.php

<?php

error_reporting(0);


require_once('demo.php');
/*Open the connection to our database use the info from the config file.*/
$link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);

$sql = "SELECT company_name, contact_name, address, street_number, postcode, contact_number, contact_email, budget, description FROM 3dartactforms";

$results = mysql_query($sql);
      
if (!$results) {
   die('Invalid query: ' . mysql_error());
}



while($result = mysql_fetch_array( $results )){
   echo '<div style="border: 1px solid #e4e4e4; padding: 15px; margin-bottom: 10px;">';
   echo date("d/m/y");
   echo '<p>Company Name: ' . $_POST['company_name'] . '</p>';
   echo '<p>Contact Name: ' . $_POST['contact_name'] . '</p>';
   echo '<p>Address: ' . $_POST['address'] . '</p>';
   echo '<p>Street Number: ' . $_POST['street_number'] . '</p>';
   echo '<p>Postcode: ' . $_POST['postcode'] . '</p>';
   echo '<p>Contact Number: ' . $_POST['contact_number'] . '</p>';
   echo '<p>Contact Email: ' . $_POST['contact_email'] . '</p>';
   echo '<p>Budget: ' . $_POST['budget'] . '</p>';
   echo '<p>Description: ' . $_POST['description'] . '</p>';
   echo '</div>';
}


?>

Hi I have a list of states using the array method in a form. The drop down menu works fine.  I want to save the user choice,if the form is re-displayed due to a blank field or pattern mismatch.  I know I can use the selected=selected, but don't know wher to put the statement:
My array is:
state_province = array ("list of states", "provinces")
Var in my labels array is "state"=>"state"
Here is my code for the select/option statement:

{
 if($field == "state")
   {
      echo "<div class='province_state'><label for='state' size='10'>* Province/State</label><select>";
            
      foreach($state_province as $state)
         {
         echo "\n<option value='$state_province' /> ";   
          echo $state ;
          echo "</option>";
         }
      echo "</select></div>\n";   

   }
?Is this the correct code to add and where would I add  it?
          if(@$_POST['state'] == $value)
     {
         echo "selected='selected'  ";
     }          

here is the code

Code: [Select]

<label for="rank">Font</label>
<select class="element select medium" id="fonts" onchange="<?php echo 'selected'; ?>" name="fonts">
<option value="Arial" selected="selected">Arial</option>
<option value="times" selected="selected">Times New Roman</option>
</select>

It is supposed to echo the value selected but it does nothing any ideas regarding what i should do?
Also what i really want to do is create a cookie which will contain the selected value and then use this value of the cookie later. But I cant even manage to echo the values so thought it would be better to first learn how to echo and then try to create a cookie out of it

Hi all,

I have a html drop down menu and want to show the initially selected value as the one stored in the mysql database that a member selected.

I have 180+ rows in mysql that a member could have selected and would like to basically do this:

IF (value of option == $row['value'] ) { echo "selected=\"selected\"; }
I could put this in every one of the rows it would be much better to have an if statement. As there are so many values I do not know where to begin.

Can someone point me in the right direction?

Thanks