Trouble with getting values from a select/option pulldown :(
Posted: Wed Jan 14, 2004 9:39 am
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:
Thank you so much in advance!
Greets,
kaspar
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++)
{
$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);
}
for($x=0;$x<mysql_num_rows($ptemp);$x++)
{
$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);
}
?>
<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ählen</option>
<option disabled></option>
<?php
for($i=0;$i<count($p_array);$i++)
{
echo '<option value="' . $p_arrayї$i] . '">';
echo $p_arrayї$i] . ' ї' . $ptyp_arrayї$i] . '] ';
if (strlen($pname_arrayї$i])>15)
{ echo substr($pname_arrayї$i], 0, 12) . '...'; }
else
{ echo $pname_arrayї$i] . '</option>'; }
}
?>
<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ählen</option>
<option disabled></option>
<?php
for($i=0;$i<count($k_array);$i++)
{
echo '<option value="' . $k_arrayї$i] . '">';
echo $vname_arrayї$i] . ' ' . $name_arrayї$i]. '</option>';
}
?>
</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ählen</option>
<option disabled></option>
<option disabled>Tätlichkeiten</option>
<option value="Tätlichkeiten" <?php if($pb_typ == "Tätlichkeiten") { echo ' selected="selected"'; } ?> > Tätlichkeiten</option>
<option disabled></option>
<option disabled>Konzeption</option>
<option value="Art Direction" <?php if($pb_typ == "Art Direction") { echo ' selected="selected"'; } ?>> Art Direction</option>
<option value="Layout" <?php if($pb_typ == "Layout") { echo ' selected="selected"'; } ?>> Layout</option>
<option value="Text" <?php if($pb_typ == "Text") { echo ' selected="selected"'; } ?>> Text</option>
<option disabled></option>
<option disabled>Beratung</option>
<option value="Assistenz/Innenkontakt" <?php if($pb_typ == "Text") { echo ' selected="selected"'; } ?>> Assistenz/Innenkontakt</option>
<option value="Beratung" <?php if($pb_typ == "Layout") { echo ' selected="selected"'; } ?>> Beratung</option>
<option value="Geschäftsführung" <?php if($pb_typ == "Geschäftsführung") { echo ' selected="selected"'; } ?>> Geschäftsführung</option>
<option disabled></option>
<option disabled>Realisierung</option>
<option value="Art Buying" <?php if($pb_typ == "Art Buying") { echo ' selected="selected"'; } ?>> Art Buying</option>
<option value="DTP/HTML" <?php if($pb_typ == "DTP/HTML") { echo ' selected="selected"'; } ?>> DTP/HTML</option>
<option value="Mediaplanung" <?php if($pb_typ == "Mediaplanung") { echo ' selected="selected"'; } ?>> Mediaplanung</option>
<option value="Produktion" <?php if($pb_typ == "Produktion") { echo ' selected="selected"'; } ?>> Produktion</option>
<option value="Reinzeichnung" <?php if($pb_typ == "Reinzeichnung") { echo ' selected="selected"'; } ?>> Reinzeichnung</option>
<option value="Recherche" <?php if($pb_typ == "Recherche") { echo ' selected="selected"'; } ?>> Recherche</option>
<option value="Satz" <?php if($pb_typ == "Satz") { echo ' selected="selected"'; } ?> > Satz</option>
<option value="Traffic" <?php if($pb_typ == "Traffic") { echo ' selected="selected"'; } ?>> Traffic</option>
<option disabled></option>
<option disabled>Büro</option>
<option value="Büro" <?php if($pb_typ == "Büro") { echo ' selected="selected"'; } ?>> Bü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)
{
$today = date("Y-m-d");
$jahr = substr("$today", 0, 4);
$monat = substr("$today", -5, -3);
$tag = substr("$today", -2);
}
?>
<select name="jahr" size="1" class="button">
<option value="2000"<?php if($jahr == "2000") { echo ' selected="selected"'; } ?>>2000</option>
<option value="2001"<?php if($jahr == "2001") { echo ' selected="selected"'; } ?>>2001</option>
<option value="2002"<?php if($jahr == "2002") { echo ' selected="selected"'; } ?>>2002</option>
<option value="2003"<?php if($jahr == "2003") { echo ' selected="selected"'; } ?>>2003</option>
<option value="2004"<?php if($jahr == "2004") { echo ' selected="selected"'; } ?>>2004</option>
<option value="2005"<?php if($jahr == "2005") { echo ' selected="selected"'; } ?>>2005</option>
<option value="2006"<?php if($jahr == "2006") { echo ' selected="selected"'; } ?>>2006</option>
<option value="2007"<?php if($jahr == "2007") { echo ' selected="selected"'; } ?>>2007</option>
<option value="2008"<?php if($jahr == "2008") { echo ' selected="selected"'; } ?>>2008</option>
<option value="2009"<?php if($jahr == "2009") { echo ' selected="selected"'; } ?>>2009</option>
<option value="2010"<?php if($jahr == "2010") { echo ' selected="selected"'; } ?>>2010</option>
<option value="2011"<?php if($jahr == "2011") { echo ' selected="selected"'; } ?>>2011</option>
<option value="2012"<?php if($jahr == "2012") { echo ' selected="selected"'; } ?>>2012</option>
<option value="2013"<?php if($jahr == "2013") { echo ' selected="selected"'; } ?>>2013</option>
<option value="2014"<?php if($jahr == "2014") { echo ' selected="selected"'; } ?>>2014</option>
<option value="2015"<?php if($jahr == "2015") { echo ' selected="selected"'; } ?>>2015</option>
</select>
<select name="monat" size="1" class="button">
<option value="Jan"<?php if($monat == "Jan") { echo ' selected="selected"'; } ?>>Jan</option>
<option value="Feb"<?php if($monat == "Feb") { echo ' selected="selected"'; } ?>>Feb</option>
<option value="Mar"<?php if($monat == "Mar") { echo ' selected="selected"'; } ?>>Mar</option>
<option value="Apr"<?php if($monat == "Apr") { echo ' selected="selected"'; } ?>>Apr</option>
<option value="Mai"<?php if($monat == "Mai") { echo ' selected="selected"'; } ?>>Mai</option>
<option value="Jun"<?php if($monat == "Jun") { echo ' selected="selected"'; } ?>>Jun</option>
<option value="Jul"<?php if($monat == "Jul") { echo ' selected="selected"'; } ?>>Jul</option>
<option value="Aug"<?php if($monat == "Aug") { echo ' selected="selected"'; } ?>>Aug</option>
<option value="Sep"<?php if($monat == "Sep") { echo ' selected="selected"'; } ?>>Sep</option>
<option value="Okt"<?php if($monat == "Okt") { echo ' selected="selected"'; } ?>>Okt</option>
<option value="Nov"<?php if($monat == "Nov") { echo ' selected="selected"'; } ?>>Nov</option>
<option value="Dez"<?php if($monat == "Dez") { echo ' selected="selected"'; } ?>>Dez</option>
</select>
<select name="tag" size="1" class="button">
<option value="01"<?php if($tag == "1") { echo ' selected="selected"'; } ?>>01</option>
<option value="02"<?php if($tag == "2") { echo ' selected="selected"'; } ?>>02</option>
<option value="03"<?php if($tag == "3") { echo ' selected="selected"'; } ?>>03</option>
<option value="04"<?php if($tag == "4") { echo ' selected="selected"'; } ?>>04</option>
<option value="05"<?php if($tag == "5") { echo ' selected="selected"'; } ?>>05</option>
<option value="06"<?php if($tag == "6") { echo ' selected="selected"'; } ?>>06</option>
<option value="07"<?php if($tag == "7") { echo ' selected="selected"'; } ?>>07</option>
<option value="08"<?php if($tag == "8") { echo ' selected="selected"'; } ?>>08</option>
<option value="09"<?php if($tag == "9") { echo ' selected="selected"'; } ?>>09</option>
<option value="10"<?php if($tag == "10") { echo ' selected="selected"'; } ?>>10</option>
<option value="11"<?php if($tag == "11") { echo ' selected="selected"'; } ?>>11</option>
<option value="12"<?php if($tag == "12") { echo ' selected="selected"'; } ?>>12</option>
<option value="13"<?php if($tag == "13") { echo ' selected="selected"'; } ?>>13</option>
<option value="14"<?php if($tag == "14") { echo ' selected="selected"'; } ?>>14</option>
<option value="15"<?php if($tag == "15") { echo ' selected="selected"'; } ?>>15</option>
<option value="16"<?php if($tag == "16") { echo ' selected="selected"'; } ?>>16</option>
<option value="17"<?php if($tag == "17") { echo ' selected="selected"'; } ?>>17</option>
<option value="18"<?php if($tag == "18") { echo ' selected="selected"'; } ?>>18</option>
<option value="19"<?php if($tag == "19") { echo ' selected="selected"'; } ?>>19</option>
<option value="20"<?php if($tag == "20") { echo ' selected="selected"'; } ?>>20</option>
<option value="21"<?php if($tag == "21") { echo ' selected="selected"'; } ?>>21</option>
<option value="22"<?php if($tag == "22") { echo ' selected="selected"'; } ?>>22</option>
<option value="23"<?php if($tag == "23") { echo ' selected="selected"'; } ?>>23</option>
<option value="24"<?php if($tag == "24") { echo ' selected="selected"'; } ?>>24</option>
<option value="25"<?php if($tag == "25") { echo ' selected="selected"'; } ?>>25</option>
<option value="26"<?php if($tag == "26") { echo ' selected="selected"'; } ?>>26</option>
<option value="27"<?php if($tag == "27") { echo ' selected="selected"'; } ?>>27</option>
<option value="28"<?php if($tag == "28") { echo ' selected="selected"'; } ?>>28</option>
<option value="29"<?php if($tag == "29") { echo ' selected="selected"'; } ?>>29</option>
<option value="30"<?php if($tag == "30") { echo ' selected="selected"'; } ?>>30</option>
<option value="31"<?php if($tag == "31") { echo ' selected="selected"'; } ?>>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">
<input name="uebertragen" type="submit" value="speichern" class="button"></form></td>
</tr>
</table></td>
</tr>
</table>
<?php
if ($uebertragen)
{
if ($minuten>=45) { $minuten=75; }
elseif ($minuten>=30) { $minuten=5; }
elseif ($minuten>=15) { $minuten=25; }
elseif ($minuten>0) { $minuten=0; }
elseif ($minuten<=0) { $minuten=0; }
if ($p_nr=="bitte w‰hlen" || $m_nr=="bitte w‰hlen" || $p_typ=="bitte w‰hlen")
{
echo "<script>window.alert('Bitte alle Felder ausfüllen.');</script>";
}
else
{
// 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");
}
}
elseif ($cancel)
{
Header("location: stunden.php");
}
?>
</body>
</html>
<?php
mysql_close();
ob_end_flush();
?>Greets,
kaspar