Trouble with getting values from a select/option pulldown :(

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
imme
Forum Newbie
Posts: 14
Joined: Fri Nov 21, 2003 11:51 am

Trouble with getting values from a select/option pulldown :(

Post by imme »

Hi everyone,
I have trouble getting the values from a select/option pulldown.
It works perfectly fine for the preselected current date (which is set as "selected") but once you change the values nothing is submitted.

Here's my code:

Code: Select all

<?php
// works like magic
ob_start();
// include der MySQL Verbindungsdaten
include("connect.php");

$ktemp = @mysql_query
("SELECT m_nr,k_vname,k_name FROM mitarbeiter,kontakt
  WHERE mitarbeiter.k_nr=kontakt.k_nr ORDER BY k_name");

$ptemp = @mysql_query
("SELECT * FROM projekt ORDER BY p_nr");

$k_array = array();
$vname_array = array();
$name_array = array();

$p_array = array();
$pname_array = array();
$ptyp_array = array();

for($x=0;$x<mysql_num_rows($ktemp);$x++)
&#123; 
    $string_1 = mysql_result($ktemp,$x,0); 
    array_push($k_array,$string_1);
    $string_2 = mysql_result($ktemp,$x,1); 
    array_push($vname_array,$string_2);
    $string_3 = mysql_result($ktemp,$x,2); 
    array_push($name_array,$string_3);  
&#125;

for($x=0;$x<mysql_num_rows($ptemp);$x++)
&#123; 
    $string_4 = mysql_result($ptemp,$x,0); 
    array_push($p_array,$string_4);
    $string_5 = mysql_result($ptemp,$x,1); 
    array_push($pname_array,$string_5);
    $string_6 = mysql_result($ptemp,$x,2); 
    array_push($ptyp_array,$string_6);  
&#125;
?>

<html>
<head>
<link href="main.css" rel="stylesheet" type="text/css">
</head>
<body>

<table width="360" height="250" border="0" align="left" cellpadding="0" cellspacing="0">
<tr><form method="post" action="<?php echo $PHP_SELF ?>" target="stunden">
  <td valign="top"><img src="images/spacer.gif" height="20" width="360"></td>
</tr>
<tr>
  <td valign="top"><table width="360" border="0" cellpadding="5" cellspacing="0" bgcolor="#EEEEEE" class="norm">
<tr>
<td colspan="2" width="360" class="norm_bold">Stunden eintragen</td>
</tr>
<tr>
  <td colspan="2" height="10"><img src="images/spacer.gif" height="10" width="360"></td>
</tr>
<tr>
<td width="100" class="norm_bold">Projekt</td>
<td width="260" class="norm">
<select name="p_nr" size="1" class="button">
  <option>bitte w&auml;hlen</option>
  <option disabled></option>
  <?php
  for($i=0;$i<count($p_array);$i++)
  &#123;
    echo '<option value="' . $p_array&#1111;$i] . '">';
    echo $p_array&#1111;$i] . ' &#1111;' . $ptyp_array&#1111;$i] . '] ';
    
    if (strlen($pname_array&#1111;$i])>15)
    &#123; echo substr($pname_array&#1111;$i], 0, 12) . '...'; &#125;
    else
    &#123; echo $pname_array&#1111;$i] . '</option>'; &#125;
  &#125; 
  ?>
  <option disabled></option>
</select></td>
</tr>
<tr>
<td width="100" class="norm_bold">Mitarbeiter</td>
<td width="260" class="norm">
<select name="m_nr" size="1" class="button">
  <option>bitte w&auml;hlen</option>
  <option disabled></option>
  <?php
  for($i=0;$i<count($k_array);$i++)
  &#123;
  echo '<option value="' . $k_array&#1111;$i] . '">';
  echo $vname_array&#1111;$i] . ' ' . $name_array&#1111;$i]. '</option>';
  &#125; 
  ?>
</select></td>
</tr>
<tr>
<td width="100" class="norm_bold">Typ</td>
<td width="260" class="norm"><select name="pb_typ" size="1" class="button">
    <option selected="selected">bitte w&auml;hlen</option>
    <option disabled></option>
    <option disabled>T&auml;tlichkeiten</option>
    <option value="T&auml;tlichkeiten" <?php if($pb_typ == "T&auml;tlichkeiten") &#123; echo ' selected="selected"'; &#125; ?> >&nbsp;&nbsp;T&auml;tlichkeiten</option>
    <option disabled></option>
    <option disabled>Konzeption</option>
    <option value="Art Direction" <?php if($pb_typ == "Art Direction") &#123; echo ' selected="selected"'; &#125; ?>>&nbsp;&nbsp;Art Direction</option>
    <option value="Layout" <?php if($pb_typ == "Layout") &#123; echo ' selected="selected"'; &#125; ?>>&nbsp;&nbsp;Layout</option>
    <option value="Text" <?php if($pb_typ == "Text") &#123; echo ' selected="selected"'; &#125; ?>>&nbsp;&nbsp;Text</option>
    <option disabled></option>
    <option disabled>Beratung</option>
    <option value="Assistenz/Innenkontakt" <?php if($pb_typ == "Text") &#123; echo ' selected="selected"'; &#125; ?>>&nbsp;&nbsp;Assistenz/Innenkontakt</option>
    <option value="Beratung" <?php if($pb_typ == "Layout") &#123; echo ' selected="selected"'; &#125; ?>>&nbsp;&nbsp;Beratung</option>
    <option value="Geschäftsführung" <?php if($pb_typ == "Geschäftsführung") &#123; echo ' selected="selected"'; &#125; ?>>&nbsp;&nbsp;Gesch&auml;ftsf&uuml;hrung</option>
    <option disabled></option>
    <option disabled>Realisierung</option>
    <option value="Art Buying" <?php if($pb_typ == "Art Buying") &#123; echo ' selected="selected"'; &#125; ?>>&nbsp;&nbsp;Art Buying</option>
    <option value="DTP/HTML" <?php if($pb_typ == "DTP/HTML") &#123; echo ' selected="selected"'; &#125; ?>>&nbsp;&nbsp;DTP/HTML</option>
    <option value="Mediaplanung" <?php if($pb_typ == "Mediaplanung") &#123; echo ' selected="selected"'; &#125; ?>>&nbsp;&nbsp;Mediaplanung</option>
    <option value="Produktion" <?php if($pb_typ == "Produktion") &#123; echo ' selected="selected"'; &#125; ?>>&nbsp;&nbsp;Produktion</option>
    <option value="Reinzeichnung" <?php if($pb_typ == "Reinzeichnung") &#123; echo ' selected="selected"'; &#125; ?>>&nbsp;&nbsp;Reinzeichnung</option>
    <option value="Recherche" <?php if($pb_typ == "Recherche") &#123; echo ' selected="selected"'; &#125; ?>>&nbsp;&nbsp;Recherche</option>
    <option value="Satz" <?php if($pb_typ == "Satz") &#123; echo ' selected="selected"'; &#125; ?> >&nbsp;&nbsp;Satz</option>
    <option value="Traffic" <?php if($pb_typ == "Traffic") &#123; echo ' selected="selected"'; &#125; ?>>&nbsp;&nbsp;Traffic</option>
    <option disabled></option>
    <option disabled>B&uuml;ro</option>
    <option value="Büro" <?php if($pb_typ == "Büro") &#123; echo ' selected="selected"'; &#125; ?>>&nbsp;&nbsp;B&uuml;ro</option>
</select></td>
</tr>
<tr>
<td width="100" class="norm_bold">Dauer</td>
<td width="260" class="norm"><input name="stunden" size="5" type="text" value="<?php echo $stunden ?>" class="textfield"> h
                             <input name="minuten" size="5" type="text" value="<?php echo $minuten ?>" class="textfield"> min</td>
</tr>
<tr>
<td width="100" class="norm_bold">Datum</td>
<td width="260" class="norm">
<?php
if(!$uebertragen)
&#123;
    $today = date("Y-m-d");
    $jahr = substr("$today", 0, 4);
    $monat = substr("$today", -5, -3);
    $tag = substr("$today", -2);
&#125;
?>
<select name="jahr" size="1" class="button">
    <option value="2000"<?php if($jahr == "2000") &#123; echo ' selected="selected"'; &#125; ?>>2000</option>
    <option value="2001"<?php if($jahr == "2001") &#123; echo ' selected="selected"'; &#125; ?>>2001</option>
    <option value="2002"<?php if($jahr == "2002") &#123; echo ' selected="selected"'; &#125; ?>>2002</option>
    <option value="2003"<?php if($jahr == "2003") &#123; echo ' selected="selected"'; &#125; ?>>2003</option>
    <option value="2004"<?php if($jahr == "2004") &#123; echo ' selected="selected"'; &#125; ?>>2004</option>
    <option value="2005"<?php if($jahr == "2005") &#123; echo ' selected="selected"'; &#125; ?>>2005</option>
    <option value="2006"<?php if($jahr == "2006") &#123; echo ' selected="selected"'; &#125; ?>>2006</option>
    <option value="2007"<?php if($jahr == "2007") &#123; echo ' selected="selected"'; &#125; ?>>2007</option>
    <option value="2008"<?php if($jahr == "2008") &#123; echo ' selected="selected"'; &#125; ?>>2008</option>
    <option value="2009"<?php if($jahr == "2009") &#123; echo ' selected="selected"'; &#125; ?>>2009</option>
    <option value="2010"<?php if($jahr == "2010") &#123; echo ' selected="selected"'; &#125; ?>>2010</option>
    <option value="2011"<?php if($jahr == "2011") &#123; echo ' selected="selected"'; &#125; ?>>2011</option>
    <option value="2012"<?php if($jahr == "2012") &#123; echo ' selected="selected"'; &#125; ?>>2012</option>
    <option value="2013"<?php if($jahr == "2013") &#123; echo ' selected="selected"'; &#125; ?>>2013</option>
    <option value="2014"<?php if($jahr == "2014") &#123; echo ' selected="selected"'; &#125; ?>>2014</option>
    <option value="2015"<?php if($jahr == "2015") &#123; echo ' selected="selected"'; &#125; ?>>2015</option>
</select>
<select name="monat" size="1" class="button">
    <option value="Jan"<?php if($monat == "Jan") &#123; echo ' selected="selected"'; &#125; ?>>Jan</option>
    <option value="Feb"<?php if($monat == "Feb") &#123; echo ' selected="selected"'; &#125; ?>>Feb</option>
    <option value="Mar"<?php if($monat == "Mar") &#123; echo ' selected="selected"'; &#125; ?>>Mar</option>
    <option value="Apr"<?php if($monat == "Apr") &#123; echo ' selected="selected"'; &#125; ?>>Apr</option>
    <option value="Mai"<?php if($monat == "Mai") &#123; echo ' selected="selected"'; &#125; ?>>Mai</option>
    <option value="Jun"<?php if($monat == "Jun") &#123; echo ' selected="selected"'; &#125; ?>>Jun</option>
    <option value="Jul"<?php if($monat == "Jul") &#123; echo ' selected="selected"'; &#125; ?>>Jul</option>
    <option value="Aug"<?php if($monat == "Aug") &#123; echo ' selected="selected"'; &#125; ?>>Aug</option>
    <option value="Sep"<?php if($monat == "Sep") &#123; echo ' selected="selected"'; &#125; ?>>Sep</option>
    <option value="Okt"<?php if($monat == "Okt") &#123; echo ' selected="selected"'; &#125; ?>>Okt</option>
    <option value="Nov"<?php if($monat == "Nov") &#123; echo ' selected="selected"'; &#125; ?>>Nov</option>
    <option value="Dez"<?php if($monat == "Dez") &#123; echo ' selected="selected"'; &#125; ?>>Dez</option>
</select>
<select name="tag" size="1" class="button">
    <option value="01"<?php if($tag == "1") &#123; echo ' selected="selected"'; &#125; ?>>01</option>
    <option value="02"<?php if($tag == "2") &#123; echo ' selected="selected"'; &#125; ?>>02</option>
    <option value="03"<?php if($tag == "3") &#123; echo ' selected="selected"'; &#125; ?>>03</option>
    <option value="04"<?php if($tag == "4") &#123; echo ' selected="selected"'; &#125; ?>>04</option>
    <option value="05"<?php if($tag == "5") &#123; echo ' selected="selected"'; &#125; ?>>05</option>
    <option value="06"<?php if($tag == "6") &#123; echo ' selected="selected"'; &#125; ?>>06</option>
    <option value="07"<?php if($tag == "7") &#123; echo ' selected="selected"'; &#125; ?>>07</option>
    <option value="08"<?php if($tag == "8") &#123; echo ' selected="selected"'; &#125; ?>>08</option>
    <option value="09"<?php if($tag == "9") &#123; echo ' selected="selected"'; &#125; ?>>09</option>
    <option value="10"<?php if($tag == "10") &#123; echo ' selected="selected"'; &#125; ?>>10</option>
    <option value="11"<?php if($tag == "11") &#123; echo ' selected="selected"'; &#125; ?>>11</option>
    <option value="12"<?php if($tag == "12") &#123; echo ' selected="selected"'; &#125; ?>>12</option>
    <option value="13"<?php if($tag == "13") &#123; echo ' selected="selected"'; &#125; ?>>13</option>
    <option value="14"<?php if($tag == "14") &#123; echo ' selected="selected"'; &#125; ?>>14</option>
    <option value="15"<?php if($tag == "15") &#123; echo ' selected="selected"'; &#125; ?>>15</option>
    <option value="16"<?php if($tag == "16") &#123; echo ' selected="selected"'; &#125; ?>>16</option>
    <option value="17"<?php if($tag == "17") &#123; echo ' selected="selected"'; &#125; ?>>17</option>
    <option value="18"<?php if($tag == "18") &#123; echo ' selected="selected"'; &#125; ?>>18</option>
    <option value="19"<?php if($tag == "19") &#123; echo ' selected="selected"'; &#125; ?>>19</option>
    <option value="20"<?php if($tag == "20") &#123; echo ' selected="selected"'; &#125; ?>>20</option>
    <option value="21"<?php if($tag == "21") &#123; echo ' selected="selected"'; &#125; ?>>21</option>
    <option value="22"<?php if($tag == "22") &#123; echo ' selected="selected"'; &#125; ?>>22</option>
    <option value="23"<?php if($tag == "23") &#123; echo ' selected="selected"'; &#125; ?>>23</option>
    <option value="24"<?php if($tag == "24") &#123; echo ' selected="selected"'; &#125; ?>>24</option>
    <option value="25"<?php if($tag == "25") &#123; echo ' selected="selected"'; &#125; ?>>25</option>
    <option value="26"<?php if($tag == "26") &#123; echo ' selected="selected"'; &#125; ?>>26</option>
    <option value="27"<?php if($tag == "27") &#123; echo ' selected="selected"'; &#125; ?>>27</option>
    <option value="28"<?php if($tag == "28") &#123; echo ' selected="selected"'; &#125; ?>>28</option>
    <option value="29"<?php if($tag == "29") &#123; echo ' selected="selected"'; &#125; ?>>29</option>
    <option value="30"<?php if($tag == "30") &#123; echo ' selected="selected"'; &#125; ?>>30</option>
    <option value="31"<?php if($tag == "31") &#123; echo ' selected="selected"'; &#125; ?>>31</option>
</select>
</td>
</tr>
<tr>
  <td colspan="2"><img src="images/spacer.gif" height="15" width="360"></td>
</tr>
<tr>
<td width="100" class="norm_bold"></td>
<td width="260" class="norm"><input name="cancel" type="submit" class="button" value="abbrechen">&nbsp;
<input name="uebertragen" type="submit" value="speichern" class="button"></form></td>
</tr>
</table></td>
</tr>
</table>

<?php

if ($uebertragen)
&#123;
  if ($minuten>=45) &#123; $minuten=75; &#125;
  elseif ($minuten>=30) &#123; $minuten=5; &#125;
  elseif ($minuten>=15) &#123; $minuten=25; &#125;
  elseif ($minuten>0) &#123; $minuten=0; &#125;
  elseif ($minuten<=0) &#123; $minuten=0; &#125;
  if ($p_nr=="bitte w‰hlen" || $m_nr=="bitte w‰hlen" || $p_typ=="bitte w‰hlen")
  &#123;
    echo "<script>window.alert('Bitte alle Felder ausfüllen.');</script>";
  &#125;
  else
  &#123;
      // Speicherung der eingegebenen Werte
      @mysql_query
      ("INSERT into projektbearb (p_nr,m_nr,pb_typ,pb_zeit,pb_datum)
      VALUES ('$p_nr','$m_nr','$pb_typ','$stunden.$minuten','$jahr-$monat-$tag')");
      
      Header("location: stunden.php");
  &#125;
&#125;
elseif ($cancel)
&#123;
    Header("location: stunden.php");
&#125;
?>

</body>
</html>

<?php
mysql_close();
ob_end_flush();
?>
Thank you so much in advance!
Greets,
kaspar
imme
Forum Newbie
Posts: 14
Joined: Fri Nov 21, 2003 11:51 am

Post by imme »

forgot to tell you:

the date is being saved as "date" in the MySQL database
User avatar
dull1554
Forum Regular
Posts: 680
Joined: Sat Nov 22, 2003 11:26 am
Location: 42:21:35.359N, 76:02:20.688W

Post by dull1554 »

have you tried not using the "selected" attribute, and then place the one you want to be the default at the top of the <option> list?

i'm not sure if that will help, i had trouble reading your code, next time please place your php in the php tags so the syntax is highlighted!!!
Post Reply