PHP - Retaining Values In Drop Down Menu

Hey,
Im needing some help with an update form that I have created using PHP/MySQL. Basically the form is working great (updating records, retrieving records and showing errors) but there is a problem with the errors.

If there are no errors and I edit the existing text input values, the database updates fine. However if I edit the existing text input values and there is an error, the edited input values dont save, they revert back to the values of the database.

I understand why this is happening, its because the text inputs are set to show the values of the database so if i edit the existing values and an error occurs or the page is refreshed, the values revert back to the database values. However id like it so that if any text in the text field have been edited and an error occurs, the text stays to how it is until the user by passes any errors and then the database is updated.

Hopefully this makes sense. I have attached the php page just incase anybody wants to look into it but any help would be much appreciated!

Also, im not looking for someone to just to fix this for me but if someone knows my problem and can guide me in the right direction, that would be great.

Hi guys,

I am having a real problem with this and I can't figure it out. I am not that much of a techie so take it easy on me.

I am building a survey form for a website to get feedback on the service, and naturally it can fail validation if the email address is misspelled or the security question is answered wrong. Retaining text values was easy and I managed to dig around for some solutions to retain radio button values. The problem is IT ONLY WORKS ON ONE OPTION! I tried everything including coming up with completely separate value names, yet the page still loads with all radio options set to the same shared value (usually of the last radio button question).

Here is my code:

<?PHP

$Excellent_status = 'unchecked';
$VeryGood_status = 'unchecked';
$Satisfactory_status = 'unchecked';
$Weak_status = 'unchecked';
$Horrible_status = 'unchecked';

if (isset($_POST['send'])) 
{

$selected_tk = $_POST['tk'];

if ($selected_tk == 'Excellent') {
$Excellent_status = 'checked';
}
else if ($selected_tk == 'VeryGood') {
$VeryGood_status = 'checked';
}
else if ($selected_tk == 'Satisfactory') {
$Satisfactory_status = 'checked';
}
else if ($selected_tk == 'Weak') {
$Weak_status = 'checked';
}
else if ($selected_tk == 'Horrible') {
$Horrible_status = 'checked';
}
}

$Excellent2_status = 'unchecked';
$VeryGood2_status = 'unchecked';
$Satisfactory2_status = 'unchecked';
$Weak2_status = 'unchecked';
$Horrible2_status = 'unchecked';

if (isset($_POST['send']))
{

$selected_ts = $_POST['ts'];

if ($selected_ts == 'Excellent') {
$Excellent2_status = 'checked';
}
else if ($selected_ts == 'VeryGood') {
$VeryGood2_status = 'checked';
}
else if ($selected_ts == 'Satisfactory') {
$Satisfactory2_status = 'checked';
}
else if ($selected_ts == 'Weak') {
$Weak2_status = 'checked';
}
else if ($selected_ts == 'Horrible') {
$Horrible2_status = 'checked';
}
}

?>


     <h1 align="center">Feedback Form:</h1>
     <p align="center">We highly value your input. Your feedback can help us serve you better and provide you with a holistic experience that meets or exceeds all your expectations. <br />
Please take the time to fill out the form below.</p>
     <br />
  <br />
  <p align="center"><strong>(Fields marked with a <span class="required">*</span> are necessary. The course information is to validate which course and batch the survey is regarding, and the name and email allows our admin to verify the details and gain more information from you if needed)</strong></p>
  <p align="center"><strong>The identity in this form is strictly confidential, and it will not be revealed to course trainer, co-ordinator, or your sponsor.</strong></p>
  <!--Error Message-->
  <?php echo $error;?>
  <form  method="post" name="contFrm" id="contFrm" action="">
    <label><span class="required">*</span>Name:</label>
    <input name="name" type="text" class="box" id="name" size="40" value="<?php echo $name;?>" /><br />
    <label><span class="required">*</span>Email: </label>
    <input name="email" type="text" class="box" id="email" size="40" value="<?php echo $email;?>" /><br />
    <label><span class="required">*</span>Course attended: </label>
    <input name="course" type="text" class="box" id="course" size="40" value="<?php echo $course;?>" /><br />
    <label><span class="required">*</span>Course Date and City: </label>
    <input name="dateplace" type="text" class="box" id="dateplace" size="40" value="<?php echo $dateplace;?>" /><br /><br /><br />

    <table width="980" border="1" cellpadding="5" cellspacing="1" bgcolor="#FFFFFF">
<tr>
  <td width="280" align="left" bgcolor="#285A80"><strong><font color="#FFFFFF" size="+1">Attribute</font></strong></td>      
        <td width="115">
          <div align="center">EXCELLENT! 
          </div></td>
        <td width="115">
          <div align="center">Really Good. 
          </div></td>
        <td width="115">
          <div align="center">Satisfactory. 
          </div></td>
        <td width="115">
          <div align="center">Weak, needs attention. 
          </div></td>
        <td width="115">
          <div align="center">Horrible! Unacceptable. 
          </div></td>
      </tr>
<tr>
  <td width="280" align="left" bgcolor="#71C4CD"><strong><font color="#333333">Trainer Knowledge</font></strong></td>      
        <td>
          <div align="center">
            <input type="radio" name="tk" id="Excellent" value="Excellent" <?PHP print $Excellent_status; ?>/>
          </div>
        </td>
        <td>
          <div align="center">
            <input type="radio" name="tk" id="VeryGood" value="VeryGood" <?PHP print $VeryGood_status; ?>/>
          </div>
        </label></td>
        <td>
          <div align="center"> 
            <input type="radio" name="tk" id="Satisfactory" value="Satisfactory" <?PHP print $Satisfactory_status; ?>/>
          </div>
        </td>
        <td>
          <div align="center"> 
            <input type="radio" name="tk" id="Weak" value="Weak" <?PHP print $Weak_status; ?>/>
          </div>
        </td>
        <td>
          <div align="center"> 
            <input type="radio" name="tk" id="Horrible" value="Horrible" <?PHP print $Horrible_status; ?>/>
          </div>
        </td>
      </tr>
<tr>
  <td width="280" align="left" bgcolor="#71C4CD"><strong><font color="#333333">Trainer Style and Presentation</font></strong></td>      
        <td>
          <div align="center">
            <input type="radio" name="ts" id="Excellent2" value="Excellent2" <?PHP print $Excellent2_status; ?>/>
          </div>
        </td>
        <td>
          <div align="center">
            <input type="radio" name="ts" id="VeryGood2" value="VeryGood2" <?PHP print $VeryGood2_status; ?>/>
          </div>
        </label></td>
        <td>
          <div align="center"> 
            <input type="radio" name="ts" id="Satisfactory2" value="Satisfactory2" <?PHP print $Satisfactory2_status; ?>/>
          </div>
        </td>
        <td>
          <div align="center"> 
            <input type="radio" name="ts" id="Weak2" value="Weak2" <?PHP print $Weak2_status; ?>/>
          </div>
        </td>
        <td>
          <div align="center"> 
            <input type="radio" name="ts" id="Horrible2" value="Horrible2" <?PHP print $Horrible2_status; ?>/>
          </div>
        </td>
      </tr>
    </table>
    <br /><br />
    <label>Particularly positive points you appreciated: </label>
    <textarea name="message1" cols="80" rows="3"  id="message1"><?php echo $message1;?>
</textarea><br />
    <label>Particularly negative points you found disappointing: </label>
    <textarea name="message2" cols="80" rows="3"  id="message2"><?php echo $message2;?>
</textarea><br />
    <label>Any specific message you would like to provide us: </label>
    <textarea name="message3" cols="80" rows="3"  id="message3"><?php echo $message3;?>
</textarea><br />
<label><span class="required">* Security Question</span></label><? require_once ("ClassMathGuard.php"); MathGuard::insertQuestion(); ?>
    <br />
    <br />
    <!-- Submit Button-->
    <input name="send" type="submit" class="button" id="send" value="" />
  </form>


Fact is there are 8 questions (all multiple choice with radio button answers) but I decided to save you a long code read. Basically what I get is that despite choosing different answers for each question, the retention is only of the last option or question, and all the above question choices are set to that choice button.

What is wrong?

I've got two tables (classOfferings, instructors). The fields I'm dealing with are 'co.instructorId', 'i.instructorId', 'i.fName', 'i.lName'.
I have a form with dynamically generated drop downs.
What I would like to do is check classOfferings table to see which instructors are teaching classes then display them in drop down with the 'instructorId' as the value and 'fName' and 'lName' as the user selectable part.  So I have found the distinct 'instructorId', but I can't make 'fName' and 'lName' appear as the user selectable part.
The code below produces a drop down which has invisible values, but still posts a value.

<select size="1" name="instructor">
<option value="" selected>Search By Teacher...</option>
<?

$instrList=mysql_query("select distinct instructorId from classOfferings order by instructorId asc");
$instrNameList=mysql_query("select fName, lName from instructors where classOfferings.instructorId = instructors.instructorId order by lName asc");

// Show records by while loop.
while($instructor_list=mysql_fetch_assoc($instrList)){
$instrNames = ($instr_Name['fName']) . ($instr_Name['lName']);
?>
<option value="<? echo $instructor_list['instructorId']; ?>" <? if($instructor_list['instructorId']==$select){ echo "selected"; } ?>>
<? echo $instrNames; ?></option>
<?
// End while loop.
}
?>

</select>

i'm trying to print out values from a table into a drop down box, but my code doesnt seem to work. when i test it, there are no values in the drop down box.

if someone could find the problem, that would be great.

<form name="add_sub_section" method="post" action="<?php echo $_SERVER['../PHP_SELF']; ?>">
Sub Section Name <input type="text" name="sub_section_title" maxlength="200" /><br/><br/>
Sub Section desc <textarea name="sub_section_desc" rows="4" columns="30" /></textarea><br/><br/>
SECTION 
<?php
$list = "SELECT section_title FROM section_main";
echo "<select name='section_title'>";
while ($a = mysql_fetch_row($list)) {
for ($j = 0; $j < mysql_num_fields($list); $j++) {
echo "<option value=". $a[$j] . ">". $a[$j] . "</option>";
}
}
echo "</select>";
?>
<br/><br/>
<input type="submit" name="submit" value="Add Section"/>
</form>


the connection to the table works, so i havnt put that code in.
 there's no formatting for the html yet, i just want to get the php working first
Thanks

Basically,

I have a database table called 'users' and I would like to populate a drop down box with these values of 'users'.

How?? - to call upon the values is this: 'upduser2'

Right now, all I am using is a text box, in where you have to type in the users name manually (this is so an admin can change variables and settings according to that current user). This is what I am using so far:


<h3>Update User Level</h3>
                                                    <? echo $form->error("upduser"); ?>
                                                    <table>
                                                      <form action="adminprocess.php" method="post">
                                                        <tr>
                                                          <td> Username:<br />
                    <input type="text" name="upduser" maxlength="30" value="<? echo $form->value("upduser"); ?>" /></td>
                                                          <td> Level:<br />
                                                          <select name="updlevel">
                                                              <option value="1">1 </option> //example settings
                                                              <option value="9">9 </option>
                                                            </select></td>
                                                          <td><br />
                                                            <input type="hidden" name="subupdlevel" value="1" />
                                                            <input type="submit" value="Update Level" /></td>
                                                        </tr>
                                                      </form>
                                                    </table></td>
                                                </tr>


Much help would be appreciated.

I am trying to make a Web Form for people to fill out that has two drop down menus where i want the first drop down menu's selection changes the values of the selections in the second drop down. ((IE. If the first drop down value is "product 01" then the second drop down shows values "Red, Green, Blue" while if the first drop down value is "product 02" then the second drop down shows values "Yellow, Green"))
Anyone have any ideas? Thanks in Advance.

Hi guys,
Im currently doing a project for college and i have experienced some problems with saving my php drop down values to my database. im am getting no error but my values are not being stored to my db.If anyone could help me or point me in the correct direction then id be grateful. 
Ive attached my code.

I have several drop down boxes. When submit is clicked it execute query on another page. Problem is when submit is clicked selected values are return to defaults. Is it possible for the values to be remembered after submitting them? Part of the drop down code:
Code: [Select]
  <?php
            $result = mysql_query("SELECT *
 FROM product
GROUP BY Rim");
            ?>
           
  <select id="Rim" name="Rim"  selected="selected" style="width:158px;position:static;z-index:-1;">
  <option value="rim" selected="selected"><?php echo "Rim"; ?></option>

 <?php
 
 while ($row = mysql_fetch_array($result)) {
  echo "<option>" . $row['Rim']  . "</option>";
  echo "<br />";
  } ?>
 
       </select>  

Ive been scanning over and over this code and I cant work out why my 2nd drop down menu doesnt have unique values.
Please if anyone can give me guidance, you never know I may be able to get rid of my headache!

Code: [Select]
<body>
<p>
<form action="" method="post">
<select name="drop_1" id="drop_1">
<option value="" selected="selected" disabled="disabled">Select a Category</option> 
<?php getTierOne(); ?>
</select>
<span id="wait_1" style="display: none;">
<img alt="Please Wait" src="ajax-loader.gif"/>
</span>
<span id="result_1" style="display: none;"></span>   
</form>
</p>
<p>
<?php if(isset($_POST['submit'])){
$drop = $_POST['drop_1'];
$tier_two = $_POST['Subtype'];
echo "You selected ";
echo $drop." & ".$tier_two;
}
?>
</body>
Code: [Select]
<?php
function getTierOne()
{
$result = mysql_query("SELECT DISTINCT Type FROM business") 
or die(mysql_error());
while($tier = mysql_fetch_array( $result ))   
{
echo '<option value="'.$tier['Type'].'">'.$tier['Type'].'</option>';
}
}
if($_GET['func'] == "drop_1" && isset($_GET['func'])) { 
   drop_1($_GET['drop_var']); 
}
function drop_1($drop_var)
{  
include_once('db.php');
$result = mysql_query("SELECT DISTINCT Subtype FROM business WHERE Type='$drop_var'") 
or die(mysql_error());
echo '<select name="Subtype" id="Subtype">
<option value=" " disabled="disabled" selected="selected">Choose one</option>';
while($drop_2 = mysql_fetch_array( $result )) 
{
echo '<option value="'.$drop_2['Subtype'].'">'.$drop_2['Subtype'].'</option>';
}
echo '</select> ';
echo '<input type="submit" name="submit" value="Submit" />';
}
?>

I'm simply trying to set up a form where, if when a user clicks 'Submit', and then 'Back', the values from the form are preserved. My question is, how do I preserve the values of drop down menus. The following is a snippet of my code:

Code: [Select]
<select name="dropdown_dept" id="dept_list">
<option value=0><?php echo "Please select one..."?></option>
 <?php
    $dropdown_dept = "select dept_name from departments";
    $result_dept = $db_conn->query($dropdown_dept);
      
    if (!$result_dept)
    {
      echo '<p>Unable to get department data.</p>';
      return false;
    }
  
    for($i=0; $i<$result_dept->num_rows; $i++)
    { 
      $app_name_row = $result_dept -> fetch_array();
      ?>
        <option><?php echo($app_name_row[0]); ?></option>
      <? }

      ?>
      </select>


Above is where I have set up a drop down menu of departments. Given that code, how can I preserve the department name after a user clicks 'Submit'?

Hi i have this drop down list for date which contain 3 selects DAY MONTH YEAR hwo can i make so that when update form select keeps the same value has before help please

<?php
$months = array('','January','February','March','April','May','June','July','August','September','October','November','December');
echo '<select name="month_of_birth">';
for ($i=1;$i<13;++$i) {
   echo '<option value="' . sprintf("%02d",$i) . '">' . $months[$i] . '</option>';
}
echo '</select>';
echo '<select name="day_of_birth">';
for ($i=1;$i<32;++$i) {
   echo '<option value="' . sprintf("%02d",$i) . '">' . $i . '</option>';
}
echo '</select>';
echo '<select name="year_of_birth">';
$year = date("Y");
for ($i = $year;$i > $year-50;$i--) {
   $s = ($i == $year)?' selected':'';
   echo '<option value="' . $i . '" ' . $s . '>' . $i . '</option>';
}
echo '</select>';
?>

Hi all,
i want my list/menu field values to come from my database. how can i accomplish that?
thanks

i did
Code: [Select]
<select name="select">
                  <option value="0">--select below--</option>
  <option value="1">Me</option>
  <?php
  
                  require_once '../konnect/konex.php';

$result = mysql_query("SELECT * FROM is_clients");

while($row = mysql_fetch_array($result))
  {
  echo "<option value ='2'>".$row"['name']</option>";
  echo "<br />";
  }

?>
                  </select>

Hi i currenlty have adrop box filled with companies so the user can select which company they woudl like services from but the default is currently 0 and is to selecvt all firms but im unsure how to do this.

Current code: Code: [Select]
<td>Taxi Firm</td><td> <select name="taxifirm">
<option value="0" selected>All Taxi Firms</option>
<?php
 $sql = mysql_query("SELECT * FROM taxi_Firms"); 
while($row = mysql_fetch_array($sql)){
$uid = $row["Firm_ID"];
$username = $row["Firm_Name"]; 
echo '<option value="'.$uid.'">'.$username.'</option>' ;

}
?>

amny help is welcomed

thanx

I did search this up but all of them were lists. I want to make a menu drop down like so.... Non-clicked... Clicked...   The grey boxes would be images (unless it is easier to code them). I am a complete noob so please don't use technical terms   Thanks

helo
i a newbie in php. i need some help regarding my system. i want my data from database to display in drop down menu form.anyone have idea how to do that? i really need some help. i have search all over and couldn't find any solution. any suggestions would be helpful