PHP - Select Menus

Hi I was just wondering if someone could send me a good tutorial on pulling several fields from a table and displaying them all in one drop down menu for people to select one of them.  I dont know what this is called to I dont know what to research online.

I got some help here about 6 months ago with drop down menus & I need a little more.
I'm working on a form that has about 20 drop down menus,  each populated from a mysql database table with about 50 entries each.
I need to keep the selected menu option on the form after the form is submitted but each time the form is submitted the selected  menu option reverts back to the first item in the database table. Is there any practical way to fix this problem other than using javascript to finish  up? 

Hi Everyone,   Someone is asking me a bit of help on a website, I know a bit php and HTML5, I would like to know what would be the best of doing this please:     1)I need to create 2 big buttons, according to the choice of the buttons a different dropbox menu with towns will showup.   2)When the user chooses one of the town, in any drop down, I would like to show a different DIV with content in it.     Here is a practical example:      BUTTON A              BUTTON B   if Button A is pressed, show dropdown menu A if BUTTON B is pressed, show dropdown menu B   If town 1 from dropdown menu A is chosen show DIV 1 If town 2 from dropdown menu A is chosen show DIV 1 If town 3 from dropdown menu A is chosen show DIV 2 If town 4 from dropdown menu A is chosen show DIV 3 If town 5 from dropdown menu A is chosen show DIV 1     If town 1 from dropdown menu B is chosen show DIV 6 If town 2 from dropdown menu B is chosen show DIV 5 If town 3 from dropdown menu B is chosen show DIV 5 If town 4 from dropdown menu B is chosen show DIV 6 If town 5 from dropdown menu B is chosen show DIV 4         How to do this without reloading the page please?       Thank you,   Bambinou

I have 3 dropdown menus which have the same name <select name="dropdown">, how to get the value from 3 of them by using php for loop and array? I did try to put array on them before, but seem it can't work. My codes :

<?php
for ( $counter = 1; $counter <= 3; $counter ++) {   
   if (isset($_POST['submit'])) { //Form has been submitted.
      $dropvalue = $_POST['dropdown[$counter]'];
        echo $dropvalue;
   }
}
?>

<form action="test8.php" name="frmtest8" method='post'>
<select name="dropdown[1]">
   <option value="1st">first</option>
    <option value="2nd">second</option>
    <option value="3rd">third</option>
</select>


<select name="dropdown[2]">
   <option value="1st">first</option>
    <option value="2nd">second</option>
    <option value="3rd">third</option>
</select>

<select name="dropdown[3]">
   <option value="1st">first</option>
    <option value="2nd">second</option>
    <option value="3rd">third</option>
</select>

<input type="submit" name="submit"  value="Send" />
</form>

It gives error message Parse error: parse error in C:\wamp\www\plekz\test8.php on line 23

I guess the error is because of $_POST['dropdown[$counter]']; I cannot put the two symbols [] inside  $_POST[' '] right? How to call the array if cannot put the two symbols?

Hi all,

I'm new to PHP and just looking for any advice anyone might have on the following problem I'm having.

I have created a database and tables for registering and logging in users. Each record has three different User Types (or roles): 1, 2 and 3. Once the session has started, I would like to make certain menu items available to certain User Types. I suppose it is some sort of if...elseif statement such as:

<?php if($UserType==1) echo {"<p>Menu1</p>"}
elseif($UserType==2) echo {"<p>Menu2</p>"}
elseif($UserType==3) echo {"<p>Menu3</p>"}; ?>

Would anybody be able to point me in the right direction? I'd really appreciate any help at all.

I have created a css menu for the top of my site that is included on each page with a php include.  What I am wanting to do now is create the side menu options for each page from the one file.

Each page will have different links side links based on what section of the site you are in however I want to administer them all from one php file if that is possible.  I'm quite new to php and am not sure if I can even do this.  Any ideas on how this can be done?

Hello everyone,
I am trying triple drop down menu first and second menus are working but third one is not working and also the data is not being displayed on the webpage even though I have used "echo" command.. I am unsure what is the problem and how to correct it. So I am attaching my code in this email, could you please look into it and help me with it.

I have 1st drop menu for State :
Tennessee
Alabama
Georgia

2nd Drop down list for County:
Anderson
Bredford
Benton

3rd Drop down list for Genus
Acer
Aristida
                                             
Eg:   Tennnesse -> Anderson, Bredford, Benton
        and  Anderson -> Acer, Aristida
        and when I select Tennesse->Anderson->Acer
it has to display all the information of the table based on these selected values.

Could you please help me with this.

This is my link for the complete code
http://pastebin.com/vvLrpCcr

The execution link is
http://sozog.utc.edu/~tdv131/MYSQL/genus1c.htm

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 a single page submission update page which incorporates 7 drop down menus and 2 text input fields,  everything works fine with the data updating back to the database,  the only thing is that when the page is updated  all the drop down menus are updated which includes ones that I don't want updated?

I need to only update the drop down menus that have been selected?  but am unsure how I do it?

This is the code from the page,  sorry if its a mess but I am not that experienced at the moment. 
This is a snippet of one of the drop down menus


Code: [Select]
<tr>
  <td class="heading">Current Status</td>
  <td><?php echo   $statusdescrip ['status_description']; ?>
  <select name="status_id" >
    <?php 
$status_set = findstatus();
$statuslist = mysql_fetch_assoc ($status_set);
?>
<?php 
do { 
?>   <option value="<?php echo $statuslist ['status_id']; ?>" ><?php echo $statuslist ['status_description']; ?></option>
<?php 
} while ($statuslist = mysql_fetch_assoc ($status_set)); 
?></select>
    <span class="compuls">*</span></td>
  </tr>

I am trying to insert a date into a mySQL table from html drop downs with php. Right now when I enter the date it goes into the database as 0000-00-00. Can anybody see why it might be doing this?

My html:
Code: [Select]
<label for='birthdate' >Birthdate (Optional):</label><br/>
    <select name='month' id='month' value='<?php echo $fgmembersite->SafeDisplay('month') ?>'>
<option value="01" selected="January">January</option>
<option value="02">February</option>
<option value="03">March</option>
        etc...
    </select>&nbsp;&nbsp;
    <select name='day' id='day' value='<?php echo $fgmembersite->SafeDisplay('day') ?>'>
<option value="01" selected="1">1</option>
<option value="02">2</option>
<option value="03">3</option>
etc...
    </select>&nbsp;&nbsp;
    <select name='year' id='year' value='<?php echo $fgmembersite->SafeDisplay('year') ?>'>
<option value="2010" selected="2010">2010</option>
<option value="2009">2009</option>
<option value="2008">2008</option>
etc...
    </select>

And my php to collect info:
Code: [Select]
$formvars['birthdate'] = $this->Sanitize($_POST['year'], $_POST['month'], $_POST['day']);
php where I make table:
Code: [Select]
"birthdate DATE NOT NULL ,".

php to insert into mysql:
Code: [Select]
$insert_query = 'insert into '.$this->tablename.'(
                name,
address,
birthdate,
sex,
program,
guide,
                email,
                username,
                password,
                confirmcode
                )
                values
                (
                "' . $this->SanitizeForSQL($formvars['name']) . '",
"' . $this->SanitizeForSQL($formvars['address']) . '",
"' . $this->SanitizeForSQL($formvars['birthdate']) . '",
"' . $this->SanitizeForSQL($formvars['sex']) . '",
"' . $this->SanitizeForSQL($formvars['program']) . '",
"' . $this->SanitizeForSQL($formvars['guide']) . '",
                "' . $this->SanitizeForSQL($formvars['email']) . '",
                "' . $this->SanitizeForSQL($formvars['username']) . '",
                "' . md5($formvars['password']) . '",
                "' . $confirmcode . '"
                )'; 

Thank you!

Ok, I have one database three tables.

Table 1 is ncmr the main table where everything is to be entered.

Table 2 is companies, where all the companies in pull down menu 1 is located.

Table 3 is fabricators, where all the people who have had hands on the product are residing.

I want the selected choices of table 2 and 3 to be inputed into table 1. I know this has to be possible, but I don't know how.  I thought I wrote the code correctly, but it seems not.

Can someone review my code and show me where my mistake is?

Here is the page:

http://kaboomlabs.com/PDI/post2.php

Thanks.

Code: [Select]
    <?php
    
    require_once('connectvars.php');
     $dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME)
     or die('Error connecting to MySQL server.');
    ?>
   
    <!DOCTYPE html
         PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
         "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
   
    <html xmlns="http://www.w3.org/1999/xhtml">
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
    <title>PDI Non-Conforming Materials Report</title>
    <link rel="stylesheet" type="text/css" href="CSS/postie.css" />
   
    </head>
   
    <body>
    <div id="logo">
    <img src="images/PDI_Logo_2.1.gif" alt="PDI Logo" />
    </div>
   
    <div id="title">
    <h3 id="NCMR2">Non-Conforming Materials Report (NCMR)</h3>
    </div>
    <?php
    //Post Data
     if (isset($_POST['submit'])) {
     $ab = mysqli_real_escape_string($dbc,$_POST['ab']);
     $date = mysqli_real_escape_string($dbc,date('Y-m-d',strtotime ($_POST['date'])));
     $part = mysqli_real_escape_string($dbc,$_POST['part']);
     $rev = mysqli_real_escape_string($dbc,$_POST['rev']);
     $partdesc = mysqli_real_escape_string($dbc,$_POST['partdesc']);
     $ncmrqty = mysqli_real_escape_string($dbc,$_POST['ncmrqty']);
     $comp = mysqli_real_escape_string($dbc,$_POST['comp']);
     $ncmrid = mysqli_real_escape_string($dbc,$_POST['ncmrid']);
     $rma = mysqli_real_escape_string($dbc,$_POST['rma']);
     $jno = mysqli_real_escape_string($dbc,$_POST['jno']);
     $fdt = mysqli_real_escape_string($dbc,$_POST['fdt']);
     $cof = mysqli_real_escape_string($dbc,$_POST['cof']);
     $fab1= mysqli_real_escape_string($dbc,$_POST['fab1']);
     $fab2= mysqli_real_escape_string($dbc,$_POST['fab2']);
     $fab3= mysqli_real_escape_string($dbc,$_POST['fab3']);
     $non= mysqli_real_escape_string($dbc,$_POST['non']);
     $dis= mysqli_real_escape_string($dbc,$_POST['dis']);
     $comm= mysqli_real_escape_string($dbc,$_POST['comm']);
     $caad= mysqli_real_escape_string($dbc,$_POST['caad']);
     $po= mysqli_real_escape_string($dbc,$_POST['po']);
     $pod = mysqli_real_escape_string($dbc,date('Y-m-d',strtotime($_POST['pod'])));
     $dri = mysqli_real_escape_string($dbc,date('Y-m-d',strtotime($_POST['dri'])));
    
     $output_form = 'no';
     if (empty($ab) || empty($date) || empty($part) || empty($partdesc)){
    
    // We know at least one of the input fields is blank 
    echo '<div id="alert">';
    echo 'Please fill out all of the required NCMR information.<br />';
     echo '</div>';
    
    }
     $output_form = 'yes';
    
    }
    
    //Access the Database
     if (!empty($ab) && !empty($date) && !empty($pod)) {
     $dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME)
     or die('Error connecting to MySQL server.');
    
     $query = "INSERT INTO ncmr (ab, date, part, rev, partdesc, ncmrqty, comp, ncmrid, rma, jno, fdt, cof, fab1, fab2, fab3, non, dis, comm, caad, po, pod, dri)
    
     VALUES ('$ab','$date','$part','$rev','$partdesc','$ncmrqty','$comp','$ncmrid','$rma','$jno','$fdt','$cof','$fab1','$fab2','$fab3','$non','$dis','$comm','$caad','$po','$pod','$dri')";
    
     $data = mysqli_query($dbc, $query) or die("MySQL error: " . mysqli_error($dbc) . "<hr>\nQuery: $query");
    
    
          // Confirm success with the user
     echo '<tr><td class="thank">';
     echo '<p>Thank you for adding the NCRM, the correct person will be informed.</p>';
     echo '<p><a href="post.php">&lt;&lt; Back to the form</a></p>';
     $output_form = 'no';
     echo '</td></tr>';
    
     mysqli_close($dbc);
    }
      if ($output_form == 'yes') {
    echo "<form action='".$_SERVER['PHP_SELF']."' method='post'>";
     echo '<fieldset>';
     //Part, Rev, Part Description, NCMR Qty
     echo '<div id="box1">';
     echo '<div id="ab"><span class="b">Added By:&nbsp;&nbsp;</span><input type="text" name="ab" value="" /></div>';
     echo '<div id="date"><span class="b">Date Filed:&nbsp;&nbsp;</span><input type="text" name="date" value="" /></div>';
     echo '<div id="part"><span class="b">Part Number:&nbsp;&nbsp;</span><input type="text" name="part" value="" /></div>';
     echo '<div id="rev"><span class="b">Part Revision:&nbsp;&nbsp;</span><input type="text" name="rev" value="" /></div>';
     echo '<div id="partdesc"><span class="b">Part Description:&nbsp;&nbsp;</span><textarea name="partdesc" rows="3" cols="22" ></textarea></div>';
     echo '<div id="ncmrqty"><span class="b">NCMR Qty:&nbsp;&nbsp;</span><input type="text" name="ncmrqty" value="" /></div>';
     echo '</div>';
    
    
    //Company, Customer NCMR, Internal RMA, and Job Number
     echo '<div id="box2">';
     echo'<div id="comp">';
     echo '<span class="b">Company:&nbsp;&nbsp;</span>';
     $mysqli->select_db('comp');
     $result = $mysqli->query("SELECT * FROM comp"); 
     $i = 0;
     echo "<SELECT name='comp'>\n";
     while($row = $result->fetch_assoc()) {
     if ($i == 4) echo '<option value="lines">-----</option>';
     echo "<option value='{$row['user_id']}'>{$row['name']}</option>\n";
     $i++;
     }
     echo "</select>\n";
     echo '</div>';
    
     echo '<div id="ncmrid"><span class="b">Customer NCMR ID:&nbsp;&nbsp;</span><input type="text" name="ncmrid" value="" /></div>';
     echo '<div id="rma"><span class="b">Internal RMA #:&nbsp;&nbsp;</span><input type="text" name="rma" value="" /></div>';
     echo '<div id="jno"><span class="b">Job #:&nbsp;&nbsp;</span><input type="text" name="jno" value="" /></div>';
     echo '</div>';
    
    
    //Type of Failure and Class of Failure
     echo '<div id="box3">';
     echo '<h2>Failure</h2>';
     echo '<div id="fdt">';
     echo '<span class="b">Failure Due To:&nbsp;&nbsp;</span><br />';
     echo '<select name="fdt">';
     echo '<option value="none">----None----</option>';
     echo '<option value="In House">In House</option>';
     echo '<option value="Third Party">Third Party</option>';
     echo '</select>';
     echo '</div>';
    
     echo'<div id="cof">';
     echo '<span class="b">Class of Failu &nbsp;&nbsp;</span><br />';
     echo '<select name="cof">';
     echo '<option value="none">----None----</option>';
     echo '<option value="Materials">Materials</option>';
     echo '<option value="Fabrication">Fabrication</option>';
     echo '<option value="Drawing">Drawing</option>';
     echo '<option value="Assembly">Assembly</option>';
     echo '<option value="Testing">Testing</option>';
     echo '<option value="Electrical">Electrical</option>';
     echo '<option value="Programming">Programming</option>';
     echo '<option value="Machining">Machining</option>';
     echo '<option value="Inspection">Inspection</option>';
     echo '<option value="Purchasing">Purchasing</option>';
     echo '<option value="Administrator">Administrator</option>';
     echo '</select>';
     echo '</div>';
     echo '</div>';
    
     //Fabricators
     echo '<div id="box4">';
     echo '<h2>Fabricators</h2>';
     echo'<div id="fab1">';
     $mysqli->select_db('user');
     $result = $mysqli->query("SELECT * FROM user"); 
     echo "<SELECT name='fab1'>\n";
     while($row = $result->fetch_assoc()) { 
     echo "<option value='{$row['user_id']}'>{$row['user']}</option>\n";}
     echo "</select>\n";
     echo '</div>';
    
     echo'<div id="fab2">';
     $mysqli->select_db('user');
     $result = $mysqli->query("SELECT * FROM user"); 
     echo "<SELECT name='fab2'>\n";
     while($row = $result->fetch_assoc()) { 
     echo "<option value='{$row['user_id']}'>{$row['user']}</option>\n";}
     echo "</select>\n";
     echo '</div>';
    
     echo'<div id="fab3">';
     $mysqli = new mysqli(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
     $mysqli->select_db('user');
     $result = $mysqli->query("SELECT * FROM user"); 
     echo "<SELECT name='fab3'>\n";
     while($row = $result->fetch_assoc()) { 
     echo "<option value='{$row['user_id']}'>{$row['user']}</option>\n";}
     echo "</select>\n";
     echo '</div>';
     echo '</div>';
    
      //Nonconformity, Disposition, Comments and Comments & Additional Details
                echo '<div id="box5">';
     echo '<div id="non"><span class="b">Nonconformity:&nbsp;&nbsp;</span><br /><textarea name="non" rows="3" cols="110" ></textarea><br /></div>';
     echo '<div id="dis"><span class="b">Disposition:&nbsp;&nbsp;</span><br /><textarea name="dis" rows="3" cols="110" ></textarea></div>';
     echo '<div id="comm"><span class="b">Comments:&nbsp;&nbsp;</span><br /><textarea name="comm" rows="3" cols="110" ></textarea></div>';
     echo '<div id="caad"><span class="b">Comments and/or Additional Details:&nbsp;&nbsp;</span><br /><textarea name="caad" rows="3" cols="110" ></textarea></div>';
     //PO, PO Date, and Date Recieved
                echo '<div id="podr">';
     echo '<div id="po"><span class="b">PO:&nbsp;&nbsp;</span><input type="text" name="po"  size="7" value="" /></div>';
     echo '<div id="pod"><span class="b">PO Date:&nbsp;&nbsp;</span><input type="text" name="pod"  size="7" value="" /></div>';
     echo '<div id="dri"><span class="b">Date Received:&nbsp;&nbsp;</span><input type="text" name="dri"  size="7" value=""';
     echo '</div>';
     echo '<div id="button"><input type="submit" value="Submit NCMR" name="submit" /></div>';
     echo '</div>';
     echo '</fieldset>';
    echo '</form>';
     }
    
    
    
    
    ?>
    </body>
    </html>

Dear All,

I wish to have 2 drop down boxes, Country Select Box and Locality Select Box. The locality select box will be affected by the value chosen in the country select box.

All is working fine except that the locality select box is not being populated.
I know that the problem is in the sql statement

WHERE country_id='$co'

because i am having an error that $co is an undefined variable.

All the rest works fine because i have replaced the $co variable directly with a number (say 98) for a particular country id and it worked fine. In what way can i define this variable $co so that it is accepted by my sql statement?

Thank you for your help in advance.

MySQL Tables indicated below:

CREATE TABLE countries(
country_id INT(3) UNSIGNED NOT NULL AUTO_INCREMENT,
country_name VARCHAR(30) NOT NULL,
PRIMARY KEY(country_id),
UNIQUE KEY(country_name),
INDEX(country_id),
INDEX(country_name))
ENGINE=MyISAM;

CREATE TABLE localities(
locality_id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
country_id INT(3) UNSIGNED NOT NULL,
locality_name VARCHAR(50),
PRIMARY KEY (locality_id),
INDEX (country_id),
INDEX (locality_name))
ENGINE=MyISAM;

Extract PHP script included below:

// connect to database
require_once(MYSQL);

if(isset($_POST['submitted']))

{

// trim the incoming data

/* this line runs every element in $_POST through the trim() function, and assigns the returned result to the new $trimmed array */
$trimmed=array_map('trim',$_POST);

// clean the data

$co=mysqli_real_escape_string($dbc,$trimmed['country']);

$lc=mysqli_real_escape_string($dbc,$trimmed['locality']);

}

?>

<form action="form.php" method="post">

<p>Country
<select name="country">
<option>Select Country</option>

<?php

$q="SELECT country_id, country_name
FROM countries";

$r=mysqli_query($dbc,$q) or
trigger_error("Query: $q\n<br />MySQL Error: " . mysqli_error($dbc));

while($row=mysqli_fetch_array($r))

{

$country_id=$row[0];
$country_name=$row[1];
echo '<option value="' . $country_id . '"';
if(isset($trimmed['country']) && ($trimmed['country']==$country_id))
echo 'selected="selected"';
echo '>' . $country_name . '</option>\n';

}

?>

</select>
</p>

<p>Locality
<select name="locality">
<option>Select Locality</option>

<?php

$ql="SELECT locality_id, country_id, locality_name
FROM localities
WHERE country_id='$co'
ORDER BY locality_name";

$rl=mysqli_query($dbc,$ql) or
trigger_error("Query: $q\n<br />MySQL Error: " . mysqli_error($dbc));

while($row=mysqli_fetch_array($rl))

{

$locality_id=$row[0];
$country_id=$row[1];
$locality_name=$row[2];
echo '<option value="' . $locality_id . '"';
if(isset($trimmed['locality']) && ($trimmed['locality']==$locality_id))
echo 'selected="selected"';
echo '>' . $locality_name . '</option>\n';

}

// close database connection
mysqli_close($dbc);

?>

</select>
</p>

<p><input type="submit" name="submit" value="Submit" /></p>

<input type="hidden" name="submitted" value="TRUE" />

</form>

This is actually a page to edit the drama details.
Database-  3 tables

1. drama                           dramaID    drama_title
                                              1              friends

2. drama_genre             drama_genreID     dramaID    genreID
                                               1                        1               2
                                               2                        1               1
                                               3                        1               3
3. genre                              genreID       genre
                                                1            comedy
                                                2            romance
                                                3            family
                                                4            suspense
                                                5            war
                                                6            horror

<?php       

$dbhost = 'localhost';
$dbuser = 'root';
$dbpass = '';
$dbname = 'drama';
$link = mysqli_connect($dbhost, $dbuser, $dbpass, $dbname) or trigger_error('Error connecting to mysql');

$id = $_GET['dramaID'];

$link2 = mysqli_connect($dbhost, $dbuser, $dbpass, $dbname) or trigger_error('Error connecting to mysql');
$sql2 = "SELECT * from drama , drama_genre , genre
WHERE drama.dramaID='".$id."' AND drama_genre.dramaID='".$id."' AND drama.dramaID = drama_genre.dramaID AND drama_genre.genreID = genre.genreID";
$status2 = mysqli_query($link2,$sql2) or die (mysqli_error($link2));

$link3 = mysqli_connect($dbhost, $dbuser, $dbpass, $dbname) or trigger_error('Error connecting to mysql');
$sql3 = "SELECT * from genre ";
$status3 = mysqli_query($link3,$sql3) or die (mysqli_error($link3));

<form method='Post' action='doUpdate.php' enctype="multipart/form-data">

<?php while ($row2 = mysqli_fetch_assoc($status2)) { ?>
                  <td height="1"></td>
               
                             <td><select name="gdrop">      
                     
      <option value="<?php echo $row2['genreID'];?>"><?php echo $row2['genre'];?></option>
                     
      <?php while ($row3 = mysqli_fetch_assoc($status3)) { ?>
                        
      <option value="<?php echo $row3['genreID'];?>"><?php echo $row3['genre'];?></option>
                     
                     
      <?php }   mysqli_close($link3);  ?>
                     
 <input type='hidden' id='drama_genreID' name='drama_genreID' value = "<?php echo          $row2['drama_genreID']; ?>"/>
                 </select>

<input type="hidden" id="dramaID" name="dramaID" value = "<?php echo $row['dramaID'];?>"/>
<input type="submit" Value="Update"/>
 
The result was there were 3 dropdown menus but only the first dropdown menu has all 6 genres from my database and also the genre that belongs to the drama.

I'm also wondering how I can bring all the drama_genreIDs to my save(doupdate.php) page and update all 3 of them because it seems like only the last dropdown menu's data is saved.

And also how can I display only 6 genres instead of 7 with the genre that belongs to the drama , being set as the default selection.


                                       

Hi I have an update page with multipule drop down menus,  I am looking for a way to allow only the drop down menus that have been altered to be sent to the database.  One way was to add the following code, where the $type_id equals 0 then add nothing to the database.

Code: [Select]
if ($type_id == 0) 
{
$type_id = "";
}

However I am getting a syntex error with this,  if I enter a value into the $type_id it selects that fine.  eg.

Code: [Select]
if ($type_id == 0) 
{
$type_id = "2";
}

What is the right way to send nothing to the database?

Fuller code of the page is here

<?php require_once("includes/sessions.php"); ?>
<?php require_once("includes/connections.php"); ?>
<?php require_once("includes/functions.php"); ?>
<?php confirm_logged_in();?>
<?php usersid(); ?>
<?php find_selected_event();
     find_selected_region();
     ?>
<?php $selected_event = getevent_byid ($url_eventid);
     $orgdescrip = orgdescription($url_eventid);
     $leveldescrip = leveldescription($url_eventid);
     $typedescrip = typedescription($url_eventid);
     $champdescrip = champdescription($url_eventid);
     $disdescrip = disdescription($url_eventid);
     $venuedescrip = venuedescription($url_eventid);
     $statusdescrip = statusdescription($url_eventid);
?>
<?php if (!isset($new_event)) {$new_event = false;} ?>
<?php
   // make sure the subject id sent is an integer
   if (intval($_GET['url_eventid']) == 0) {
      redirect_to('controlpanel.php');
   }

   include_once("includes/form_functions.inc.php");

   // START FORM PROCESSING
   // only execute the form processing if the form has been submitted
   if (isset($_POST['submit'])) {
      // initialize an array to hold our errors
      $errors = array();
   
      // perform validations on the form data
      
      $required_fields = array('title');
      $errors = array_merge($errors, check_required_fields($required_fields, $_POST));
      
      $required_numberfields = array();
      $errors = array_merge($errors, check_number_fields($required_numberfields, $_POST));
      
      $fields_with_lengths = array();
      $errors = array_merge($errors, check_max_field_lengths($fields_with_lengths, $_POST));
      
      // clean up the form data before putting it in the database
      
      
      $url_eventid = mysql_prep($_GET['url_eventid']);
      $user_id = mysql_prep($_POST['user_id']);
      $title = trim(mysql_prep($_POST['title']));
      $event_details = mysql_prep($_POST['event_details']);
      $type_id = mysql_prep($_POST['type_id']);
      $champ_id = mysql_prep($_POST['champ_id']);      
      $dis_id = mysql_prep($_POST['dis_id']);
      $org_id = mysql_prep($_POST['org_id']);
      $venue_id = mysql_prep($_POST['ven_id']);
      $level_id = mysql_prep($_POST['level_id']);
      $status_id = mysql_prep($_POST['status_id']);
      
      if ($type_id == 0) 
      {
      $type_id = "";
      }
      // Database submission only proceeds if there were NO errors.
      if (empty($errors)) {
         
         $sql = "UPDATE events SET \n"
               . "title = '{$title}',\n"
               . "event_details = '{$event_details}',\n"
                . "type_id = {$type_id},\n"
               . "champ_id = {$champ_id},\n"
               . "dis_id = {$dis_id},\n"
               . "org_id = {$org_id},\n"
               . "ven_id = {$venue_id},\n"
               . "user_id = {$url_userid},\n"
               . "level_id = {$level_id},\n"
               . "status_id = {$status_id}\n"
               . "WHERE event_id = {$url_eventid} \n"
               . "LIMIT 1";


      if ($result = mysql_query($sql, $connection)) {
            // as is, $message will still be discarded on the redirect
            $message = "The event was successfully updated.";
            // get the last id inserted over the current db connection
            $new_event_id = mysql_insert_id();
            redirect_to("newevent.php");
         } else {
            $message = "I am sorry but the event could not be updated.";
            $message .= "<br />" . mysql_error();
         }
      } else {
         if (count($errors) == 1) {
            $message = "There was 1 error in the form.";
         } else {
            $message = "There were " . count($errors) . " errors in the form.";
         }
      }
      // END FORM PROCESSING
   }
   
?>

<?php   /*THIS CODE WITH RETURN IN THE BROWSER THE URLS THAT ARE BEING
      PULLED DOWN*/

if(empty($_GET))
    echo "No GET variables";
else
    print_r($_GET);

?>
<?php include("includes/header.inc.php"); ?>
<title>Horse Events</title>
<?php include_once("includes/meta.inc.php");?>
<?php include_once("includes/cssfavgoogle.inc.php");?>
<link href="css/adminpanel.css" rel="stylesheet" type="text/css" />
<style>
input[type="number"] {
   width:40px;
}
</style>
</head>
<body>
<div id="wrapper">
<div id="header">
<img src="images/horseevents_wheretogo.png" align="right" />
<?php require_once ("includes/adminmenu.inc.php"); ?>
   
</div>
   
    <div id="adminleft">
      <h2>YOUR UPCOMING EVENTS
      <?php echo "<a href=\"newevent.php?url_userid={$url_userid}\"><img src=\"images/pink/add_event.png\" align=\"right\" width=\"131\" height=\"19\" /></a>" ?></h2>       
    <table id="datetable" width="300" border="0" >
    <?php   
        $event_users_set = get_upcomingeventsforuser ($url_userid);
        while ($eventid = mysql_fetch_array ($event_users_set)){
        echo"<tr class=\'date\'>";
        echo"<td>" . $eventid["stdate"] ."</td>";   
        echo"<td><a href=\"editevent.php?url_userid={$url_userid}&url_eventid=". urlencode ($eventid['event_id']) . "\">". $eventid ['title'] . "</td>";
        echo"</tr></a>";
        }
   ?>
   </table>
    <br />
          <h2>YOUR PAST EVENTS</h2>       
    <table id="datetable" width="300" border="0" >
    <?php   
        $event_users_set = get_pasteventsforuser ($url_userid);
        while ($eventid = mysql_fetch_array ($event_users_set)){
        echo"<tr class=\'date\'>";
        echo"<td>" . $eventid["stdate"] ."</td>";   
        echo"<td><a href=\"editevent.php?url_userid={$url_userid}&url_eventid=". urlencode ($eventid['event_id']) . "\">". $eventid ['title'] . "</td>";
        echo"</tr></a>";
        }
   ?>
   </table>
    </div>
    <div id="admincontent">
    <span class="h1pln">Edit Your Event</span><a class="delete" href="deleteevent.php?url_eventid=<?php echo $url_eventid; ?>" onClick="return confirm('Are you sure you want to delete?')">Delete</a><br />
    <span class="h3pln">Please make sure you complete all the compulary fields<span class="compuls">*</span>.<br />
 The more accurately you enter your event the more people will be able to then find it.  <br />
<br />
If there are any selections we do not currently have available please click here and I will add them to your drop down menus.</span>
       <?php if (!empty($message)) {echo "<p class=\"message\">" . $message . "</p>";} ?>
      <?php if (!empty($errors)) { display_errors($errors); } ?>
<form id="newevent" action="editevent.php?url_eventid=<?php  echo urlencode ($selected_event ['event_id']); ?>" method="post">
      <table id="neweventdisplay" cellpadding="5" width="400" border="0">
   <tr>
  <td><input type="text" name="event_id"  value="<?php echo $url_eventid; ?>" /></td>
  <td><input type="text" name="user_id"  value="<?php echo $url_userid;  ?>" /></td>
  </tr>
  <tr>
    <td class="heading">Event Title</td>
    <td><input id="titleinput" name="title" type="text" value="<?php echo $selected_event ['title']; ?>" /><span class="compuls">*</span><span class="smalltext">Enter up to 36 characters</span></td>
  </tr>
  <tr>
  <td class="heading">Current Status</td>
  <td><?php echo   $statusdescrip ['status_description']; ?>
  <select name="status_id" >
    <?php
      $status_set = findstatus();
      $statuslist = mysql_fetch_assoc ($status_set);
   ?>
   <?php
   do {
   ?>   <option value="<?php echo $statuslist ['status_id']; ?>" ><?php echo $statuslist ['status_description']; ?></option>
   <?php
   } while ($statuslist = mysql_fetch_assoc ($status_set));
   ?></select>
    <span class="compuls">*</span></td>
  </tr>
      <tr>
    <td class="heading">Organiser</td>
    <td><?php echo  $orgdescrip ['org_name']; ?>
    <select name="org_id">
    <?php
      $organisers_set = findorganisers();
      $orglist = mysql_fetch_assoc ($organisers_set);
   ?>
   <?php
   do {
   ?>   <option value="<?php echo $orglist ['org_id']; ?>" ><?php echo $orglist ['org_name']; ?></option>
   <?php
   } while ($orglist = mysql_fetch_assoc ($organisers_set));
   ?></select></td>
  </tr>
    <tr>
    <td class="heading">Start Date</td>
    <td id="dateinput"><?php echo $selected_event ['stdate']; ?></td>
  </tr>
    <tr>
    <td class="heading">Type Of Event</td>
    <td><?php echo  $typedescrip ['type_description']; ?>
    <select name="type_id">
    <?php
      $type_set = findtype();
      $typelist = mysql_fetch_assoc ($type_set);
   ?>
   <?php
   do {
   ?>   <option value="<?php echo $typelist ['type_id']; ?>" ><?php echo $typelist ['type_description'], $typelist ['type_id']; ?></option>
   <?php
   } while ($typelist = mysql_fetch_assoc ($type_set));
   ?></select><span class="compuls">*</span></td>
  </tr>
  <tr>
    <td class="heading">Venue</td>
    <td><?php echo  $venuedescrip ['ven_name']; ?><select name="ven_id">
    <?php
      $venues_set = findvenues();
      $venuelist = mysql_fetch_assoc ($venues_set);
   ?>
   <?php
   do {
   ?>   <option value="<?php echo $venuelist ['ven_id']; ?>" ><?php echo $venuelist ['ven_name'], $venuelist ['ven_id']; ?></option>
   <?php
   } while ($venuelist = mysql_fetch_assoc ($venues_set));
   ?></select></td>
  </tr>

  <tr>
    <td class="heading">Discipline</td>
    <td><?php echo  $disdescrip ['dis_description']; ?><select name="dis_id">
    <?php
       $discipline_set = finddisciplines();
      $dislist = mysql_fetch_assoc ($discipline_set);
   ?>
   <?php
   do {
   ?>   <option value="<?php echo $dislist ['dis_id']; ?>" ><?php echo $dislist ['dis_description'], $dislist ['dis_id']; ?></option>
   <?php
   } while ($dislist = mysql_fetch_assoc ($discipline_set));
   ?></select><span class="compuls">*</span></td>
  </tr>
  <tr>
    <td class="heading">Level</td>
    <td><?php echo  $leveldescrip ['level_description']; ?> <select name="level_id">
    <?php
       $level_set = findlevels();
      $levellist = mysql_fetch_assoc ($level_set);
   ?>
   <?php
   do {
   ?>   <option value="<?php echo $levellist ['level_id']; ?>" ><?php echo $levellist ['level_description'], $levellist ['level_id']; ?></option>
   <?php
   } while ($levellist = mysql_fetch_assoc ($level_set));
   ?></select></td>
  </tr>
    <tr>
    <td class="heading">Is This A Championship</td>
    <td><?php echo  $champdescrip ['champ_description']; ?><select name="champ_id">
    <?php
      $championship_set = findchampionships();
      $champlist = mysql_fetch_assoc ($championship_set);
   ?>
   <?php
   do {
   ?>   <option value="<?php echo $champlist ['champ_id']; ?>" ><?php echo $champlist ['champ_description'], $champlist ['champ_id']; ?></option>
   <?php
   } while ($champlist = mysql_fetch_assoc ($championship_set));
   ?></select></td>
  </tr>
  <tr>
    <td class="heading">Event Details</td>
    <td><textarea name="event_details" cols="45" rows="15" ><?php echo $selected_event ['event_details']; ?>  </textarea></td>
  </tr>
  <tr>
    <td class="heading">Upload Schedule</td>
    <td></td>
  </tr>

  <tr>
  <td></td>
  <td><input type="submit" name="submit" id="convert" value="Update Your Event"></td>
  </tr>
</table>
<a  class="delete" href="controlpanel.php">Cancel</a>
</form>
    </div>
    <div id="adminright">
    </div>
<br clear="all" />
<?php require("includes/lowerlistings.inc.php"); ?>
<?php require("includes/footer.inc.php"); ?>
</div><!--End of Wrapper-->
</body>
</html>

Hello I have an issue with a form that has been built by someone else on Wordpress. 

using contact form 7 plugin there's a for to fill out and it emails a PDF copy to the customer.

however on the pdf any information from dropdown selections shows "Array" instead of what was selected, everything looks fine to me (with my very minimal knowledge of PHP) the title & Preferred Payment Method:  doesn't show on the pdf 

here is the contact form 7 code.


 

<div class="steps">
    <div class="step gap-large step-1">
        <h2 class="step-title"><span class="gold">Step 1.</span> Calculate the value of your <span class="gold">gold</span></h2>
        [gold_calculator your-items]    
    </div>
    <div class="step gap-large step-2">
        <h2 class="step-title"><span class="gold">Step 2.</span> Submit your details</h2>
        <div class="row">
            <div class="column col-xs-12 col-sm-2 col-lg-4">
                <label class="required" for="sell-title">Title</label>
                [select* your-title id:sell-title class:form-control "Mr" "Mrs" "Miss" "Ms"]
            </div>
            <div class="column col-first-name col-xs-12 col-sm-5 col-lg-4">
                <label class="required" for="sell-first-name">First Name</label>
                [text* your-first-name id:sell-first-name class:form-control placeholder "Enter your first name"]
            </div>
            <div class="column col-last-name col-xs-12 col-sm-5 col-lg-4">
                <label class="required" for="sell-last-name">Last Name</label>
                [text* your-last-name id:sell-last-name class:form-control placeholder "Enter your last name"]
            </div>
            <div class="column col-xs-12 col-sm-12 col-lg-4">
                <label class="required" for="sell-email">Email Address</label>
                [email* your-email id:sell-email class:form-control placeholder "Enter your email address"]
            </div>
            <div class="column col-xs-12 col-sm-6 col-lg-4">
                <label class="required" for="sell-daytime-phone">Daytime Telephone</label>
                [tel* your-daytime-phone id:sell-daytime-phone class:form-control placeholder "Enter your telephone number"]
            </div>
            <div class="column col-xs-12 col-sm-6 col-lg-4">
                <label class="" for="sell-mobile-phone">Mobile Telephone</label>
                [tel your-mobile-phone id:sell-mobile-phone class:form-control placeholder "Enter your mobile number"]
            </div>
            <div class="column col-xs-12 col-sm-6 col-lg-6">
                <label class="required" for="sell-address-1">Address Line 1</label>
                [text* your-address-1 id:sell-address-1 class:form-control placeholder "Enter your address"]
            </div>
            <div class="column col-xs-12 col-sm-6 col-lg-6">
                <label class="" for="sell-address-2">Address Line 2</label>
                [text your-address-2 id:sell-address-2 class:form-control placeholder "Enter your address"]
            </div>
            <div class="column col-xs-12 col-sm-12 col-lg-4">
                <label class="required" for="sell-city">Town/City</label>
                [text* your-city id:sell-city class:form-control placeholder "Enter your town/city"]
            </div>
            <div class="column col-xs-12 col-sm-6 col-lg-4">
                <label class="required" for="sell-county">County</label>
                [text* your-county id:sell-county class:form-control placeholder "Enter your county"]
            </div>
            <div class="column col-xs-12 col-sm-6 col-lg-4">
                <label class="required" for="sell-postcode">Postcode</label>
                [text* your-postcode id:sell-postcode class:form-control placeholder "Enter your postcode"]
            </div>
            <div class="column col-xs-12 col-sm-12 col-lg-6">
                <label class="required" for="sell-method">Choose your method of payment</label>
                [select* your-method id:sell-method class:form-control "Instant Bank Transfer" "Cash" "Cheque"]
            </div>
            <div class="column col-xs-12 ccol-sm-12 col-lg-6">
                <div class="input-label required">Terms &amp; Conditions</div>
                [acceptance your-price-acceptance id:sell-price-acceptance]I accept the price offered above for my gold.[/acceptance]
                [acceptance your-terms-acceptance id:sell-terms-acceptance]I accept the <a href="/terms-conditions/" target="_blank">terms &amp; conditions</a>.[/acceptance]
                [acceptance your-acknowledgement id:sell-acknowledgement]I declare and acknowledge that: 1. I confirm the property enclosed is mine to sell, 2. I believe the items(s) to be genuine gold or platinum 3. You will contact me if the value calculated upon receipt differs in weight or carat 4. I accept payment will only be made to the person named on the submission form.[/acceptance]
            </div>
            <div class="column col-submit col-xs-12 col-sm-12">
                <div class="alert alert-info">After clicking the ‘Submit’ button below, we'll email you a form to print off and include with the package you send to us. If you wish to be paid by bank transfer, please write your bank details on the form once printed.</div>
                <div class="submit">[submit class:btn class:btn-gold "Submit"]</div>
            </div>
        </div>
    </div>
</div>

here is the pdf php form code. 

 

<?php /** @var \Strive\Sections\Pdf_Form $this */ ?>
<head>
    <style>
        h1, h2 {
            margin-top: 0;
        }

        th, td {
            text-align: left;
            vertical-align: top;
        }

        .section {
            padding: 20px 0;
        }

        .border-top {
            border-top: solid 1px #E7E7E7;
        }

        .cut-top {
            border-top: dashed 1px #E7E7E7;
        }

        .text-placeholder {
            background-color: #F7F7F7;
        }

        .cut-note {
            text-align: center;
            font-size: 80%;
            margin-bottom: 5px;
        }
    </style>
</head>
<body>
<h1>Step 3. Print &amp; post this form with your gold</h1>
<div class="section quote border-top">
    <h2 class="section-title">Customer Quote:</h2>
    <div>
        <?php if ( $this->calculator['empty'] 😞 ?>
            <p>You didn't weigh your gold - don't worry, we'll do it for you and call you with an offer. </p>
        <?php else: ?>
            <ol>
                <?php foreach ( $this->calculator['items'] as $item 😞 ?>
                    <li><?php echo $item['weight']; ?>g of <?php echo $item['name']; ?> -
                        &pound;<?php echo $item['price']; ?></li>
                <?php endforeach; ?>
            </ol>
            <p>Total: &pound;<?php echo $this->calculator['total']; ?></p>
        <?php endif; ?>
    </div>
</div>
<div class="section details border-top">
    <h2 class="section-title">Customer Details:</h2>
    <table width="100%">
        <tr>
            <td width="50%">
                <table width="100%">
                    <tr>
                        <th>Reference:</th>
                        <td><?php echo $this->reference; ?></td>
                    </tr>
                    <tr>
                        <th>Name:</th>
                        <td></td><?php echo empty( $this->title ) ? '' : $this->title; ?>
                            <?php echo empty( $this->first_name ) ? '' : $this->first_name; ?>
                            <?php echo empty( $this->last_name ) ? '' : $this->last_name; ?></td>
                    </tr>
                    <tr>
                        <th>Email:</th>
                        <td><?php echo empty( $this->email ) ? '-' : $this->email; ?></td>
                    </tr>
                    <tr>
                        <th>Telephone:</th>
                        <td><?php echo empty( $this->daytime_phone ) ? '-' : $this->daytime_phone; ?></td>
                    </tr>
                    <tr>
                        <th>Mobile:</th>
                        <td><?php echo empty( $this->mobile_phone ) ? '-' : $this->mobile_phone; ?></td>
                    </tr>
                </table>
            </td>
            <td width="50%">
                <table width="100%">
                    <tr>
                        <th>Address 1:</th>
                        <td><?php echo empty( $this->address_1 ) ? '' : $this->address_1; ?></td>
                    </tr>
                    <tr>
                        <th>Address 2:</th>
                        <td><?php echo empty( $this->address_2 ) ? '' : $this->address_2; ?></td>
                    </tr>
                    <tr>
                        <th>Town/City:</th>
                        <td><?php echo empty( $this->city ) ? '' : $this->city; ?></td>
                    </tr>
                    <tr>
                        <th>County:</th>
                        <td><?php echo empty( $this->county ) ? '' : $this->county; ?></td>
                    </tr>
                    <tr>
                        <th>Postcode:</th>
                        <td><?php echo empty( $this->postcode ) ? '' : $this->postcode; ?></td>
                    </tr>
                </table>
            </td>
        </tr>
    </table>
</div>
<div class="section payment border-top">
    <p>Preferred Payment Method: <?php echo empty( $this->method ) ? '' : $this->method; ?></p>
    <?php if ( $this->method === 'Instant Bank Transfer' 😞 ?>
        <p>Write down your bank details below for the account in which you wish funds to be deposited.</p>
        <table width="100%">
            <tr>
                <th width="25%">Bank:</th>
                <td width="75%" class="text-placeholder">&nbsp;</td>
            </tr>
            <tr>
                <th>Name on Account:</th>
                <td width="75%" class="text-placeholder">&nbsp;</td>
            </tr>
            <tr>
                <th>Sort Code:</th>
                <td width="75%" class="text-placeholder">&nbsp;</td>
            </tr>
            <tr>
                <th>Account No:</th>
                <td width="75%" class="text-placeholder">&nbsp;</td>
            </tr>
        </table>
    <?php endif; ?>
</div>
<div class="cut-note">Print this form, include the above part in your package and post to the address below.</div>
<div class="section address cut-top">
    <p>
        SMG<br><br>
        <?php echo empty( $this->send_address ) ? '' : $this->send_address ?>
    </p>
</div>
</body>

 

 

 

any help would be appreciated. 

Edited July 28 by Barand
code tags added