PHP - Problem With Html Option Selected Not Updating

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?

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;
}

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?

<?php  
                              if(mysqli_num_rows($result) )  
                          {  
                               while($row = mysqli_fetch_array($result))  
                               {  
                          ?>  
                          <form method="POST">
                              <select name="inv"> 
                               <option><?php echo $row["rizikos_lygis"];?></option>
                               <option value=<?php echo $row["sugeneruoja"]; ?>><?php echo $row["pavadinimas"];?>&nbsp<?php echo $row["sugeneruoja"]; ?></option>
                              </select>
                              <input type="submit" name="submit" value="Apskaičiuoti">    
                          </form>
                          <?php  
                               }  
                          }  
  ?> 
<?php
if(isset($_POST['submit'])){
 echo $row["sugeneruoja"];
}
?>

Edited January 27 by Lukeishen

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 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'  ";
     }          

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

I have a test database, I have two names in the database which get returned just fine in my html dropdown. I am trying to figure out how to figure out which item in the list was selected so that I can return information from another table based on the selected id. This is what I am trying now but I don't know how to proceed or if it is correct

Code: [Select]

$result = $mysql->query("SELECT * FROM names") or die($mysql->error);
?>
<select>
<?php
if($result){
while($row = $result->fetch_object()){
$id = $row->nameID;
$name = $row->firstName . " " . $row->lastName;
?>

<option value"<?php $id ?>"><?php echo $name ?></option>

<?php
}?>
</select>
<?php } ?>

Hi,
My output in html is :
Code: [Select]
<uL><li id="B1"></li>
<li id="B2"></li>
<li id="B3"></li>
<li id="B4"></li>
<li id="B5"></li>
<li id="B6"></li>
<li id="B7"></li>
<li id="B8"></li>
<li id="B9"></li>
<li id="B10"></li>
<li id="B11"></li>
<li id="B12" class="active"></li>
<li id="B13" class="no"></li>
<li id="B14" class="no"></li>
<li id="B15" class="no"></li>
<li id="B16" class="no"></li>
<li id="B17" class="no"></li>
<li id="B18" class="no"></li>
<li id="B19" class="no"></li>
<li id="B20" class="no"></li>
</ul>
If MySQL query result is equal to `6`, then `<li>` tag with `id` equal to "`B12`" should have class "`active`". All the `<li>` elements occuring after this active element should have class "`no`".

This shows images of horizontal rating between `0` and `10` and between 0.5
Example : 0 .5 1 1.5 2 2.5 3 3.5 4 4.5 5 5.5 6 6.5 7 7.5 8 8.5 9 9.5 10
In the example above elements from `0` to `5` will be blue, element `6` will be white and elements from `7` to `10` are black.

How could I generate this using PHP and/or MySQL?

Thanks, XXXX chirstmas XXXX

I’m trying to insert from a multiple option form into MySQL. I’ve tried numerous methods and have had issues such as blank entries being inserted for each specified column, to the last value selected from the form being inserted multiple times, but I never get the desired outcome. Any guidance on how to insert from this type of HTML form? I know that there are issues regarding SQL injection - I'll worry about that later. I'd like to understand how to insert data from this kind of HTML form into MySQL, as i can't seem to find any guidance. There's plenty on how to insert from a standard HTML form i.e. where either every value is selected or left blank, but each entry corresponds to a column in MySQL which either receives a value or NULL. I'm really struggling with when a user can select more than one option from a list. 

 

Quote

<form action ='insert.php' method='POST'>
<select name= 'choices[]' multiple ="multiple"> 
<option value ="Red" >Red</option>
<option value ="Blue" >Blue</option>
<option value ="Green" >Green</option>
<input type="submit" name="send" value="submit" /> </form>

 

Here’s one option I’ve tried for PHP

 

Quote

<?php
$servername ="localhost";
$username = "test";
$password = "test";
$dbname = "Test_DB";

$conn = new mysqli ($servername, $username, $password, $dbname);

if($conn-> connect_error)
  { die("Connection failed: " . $conn->connect_error);
}

{
if(isset($_POST['submit']))
//check if any option is selected

if(isset($_POST['choices']))
//Retrieving each selected option

foreach ($_POST['choices'] as $choice)

$sql = "INSERT INTO Colours_test (Choice1, Choice2, Choice3, Choice4) VALUES ('$choice','$choice', '$choice','$choice')";

if ($conn->query($sql) === TRUE)

{

}

$conn->close();

?>

 

 

 

 

Evening People

I have this drop downbox on a HTML page, it is populated from a PHP page, if the user makes a selection i want that selection to be retained once the page refreshed.

What i have is

while ($row = $db->sql_fetchrow($result))
{
     if(isset($_GET["REGION_FILTER"]) AND $_GET["REGION_FILTER"] = $row['region'] AND strlen($_GET["REGION_FILTER"]) > 0)
     //if($region_filter = $row['region'] AND strlen($region_filter) > 0)
                {
$region_filter_options .= '<option value="' . $row['region'] . '" SELECTED>' . $row['region'] . '</option>';
                }
                else
                {
                $region_filter_options .= '<option value="' . $row['region']. '">' . $row['region'] . '</option>';
                   
                }
               
}

REGION_FILTER is the ID of the option box

The drop down box is populated from the database but i cant seem to get the selected bit working. Can someone help identify what i have done wrong ?

regards

I got a form which people can use to send a request for information to one or more recipients, depending on which recipients have been selected in the form. At the moment the HTML checkboxes all have a different name attribute and e-mails are sent using an if statement:


<input type="checkbox" name="mr-a" value="A" /> A<br />
<input type="checkbox" name="mr-b" value="B" /> B<br />
<input type="checkbox" name="mr-c" value="C" /> C<br />

if (isset($_POST['mr-a'])) {
// Send e-mail to A
}
if (isset($_POST['mr-b'])) {
// Send e-mail to B
}
if (isset($_POST['mr-c'])) {
// Send e-mail to C
}

I'm sure there's a much better way of doing this, and I think I should start by creating an array of checkboxes. But I can't figure out how to then use a loop to send the e-mails. Here's the code I got so far. I'm hoping that all I need is a loop where is says 'Send e-mails using a foreach loop?':


<?php

// Minimal validation:
if (isset($_POST['submit'])) {

$errors = array();

if (!$_POST['name'] ) {

$errors[] = 'Error: no name entered';

} else {

$name = $_POST['name'];

}

if (!$_POST['email'] ) {

$errors[] = 'Error: no e-mail address entered';

} else {

$email = $_POST['email'];

}

if (!count($errors)) {

// Send e-mails using a foreach loop?

}
?>

<!DOCTYPE html>
<html lang="en">
<head>
 <meta charset="utf-8" />
 <title>Lorem Ipsum</title>
 <!--[if lt IE 9]><script src="http://html5shiv.googlecode.com/svn/trunk/html5.js"></script><![endif]-->
 <link rel="stylesheet" href="style.css" type="text/css" />
</head>
 
<body id="index" class="home">

<h1>Lorem Ipsum</h1>
<p>Confirmation message.</p>

</body>
</html>

<?php

// Get out!

exit(0);
}
?>

<!DOCTYPE html>
<html lang="en">
<head>
 <meta charset="utf-8" />
 <title>Lorem Ipsum</title>
 <!--[if lt IE 9]><script src="http://html5shiv.googlecode.com/svn/trunk/html5.js"></script><![endif]-->
 <link rel="stylesheet" href="style.css" type="text/css" />
</head>
 
<body id="index" class="home">

<h1>Lorem Ipsum</h1>
<p>Contact A, B and/or C.</p>

<?php

if (isset($errors)) {

foreach ($errors as $error) {

echo("<p class=\"red\">$error<p>");

}

}
?>

<form method="post" action="<?php echo htmlentities($_SERVER['PHP_SELF']); ?>">
 <fieldset>
  <legend>Who do you want to contact</legend>
  <input type="checkbox" name="mr[]" value="A" /> A<br />
  <input type="checkbox" name="mr[]" value="B" /> B<br />
  <input type="checkbox" name="mr[]" value="C" /> C<br />
 </fieldset>
 
 <br />
 
 <fieldset>
  <legend>Your Details</legend>
  <label for="name">Name</label><input type="text" name="name" value="<?php if (isset($_POST['name'])) {echo $_POST['name'];}?>"><br />
  <label for="email">Email</label><input type="email" name="email" value="<?php if (isset($_POST['email'])) {echo $_POST['email'];}?>"><br />
  <input type="submit" name="submit" value="Next" />
 </fieldset>
</form>

</body>
</html>

I have three pages;

edit_records.php (list of records, user picks one ready to edit, works fine)

update.php (by in large works fine, heres the code for it anyway)

Code: [Select]
<?php

require_once ('./includes/config.inc.php');

require_once (MYSQL);

if($id = isset($_GET['prodID']))
{
$query = "SELECT * FROM product WHERE prodID='{$_GET['prodID']}'";
$r = mysqli_query($dbc, $query);

while ($row = mysqli_fetch_array($r))
{
$id = $row['prodID'];
$product = $row ['product'];

?>

<form action="update_save.php" method="post">
    ID: <input type="text" value="<?php echo $id;?>" name="id" disabled="disabled" />
Product: <input type="text" value="<?php echo $product;?>" name="product" />
<br />
<input type="submit" value="submit changes" />
</form>
   
    <?php

}

}
and finally

update_save.php (this is where the actual updating takes place)

Code: [Select]
<?php

require_once ('./includes/config.inc.php');

require_once (MYSQL);

$product = $_POST['product'];

$query = "UPDATE product SET product = $product WHERE prodID = '$id'";
$r = mysqli_query($dbc, $query);

echo 'Database Updated!!';
?>
however, on line 19 of update save, i get this error;

Quote

An error occurred in script 'C:\Users\David Morgan\Desktop\WEBSITES\hairz_&_graces\site\admin\update_save.php' on line 9:
Undefined variable: id


now I am aware i should really create a variable but since i already stored it in update.php, i had hoped it would work but it hasnt.

what should i do? help would be much appreciated please