eM

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<script type="text/javascript" src="calendar.js"></script>

</head>
<body>

<?php
if(isset($_POST['odeslat'])){
foreach($_POST['interpret'] as $key=>$value){                                             //výpis pole
echo $key."+".$value.$_POST['cas_ood'][$key].$_POST['cas_doo'][$key]."<br>";
}
//$cilovy_adresar= $_SERVER['DOCUMENT_ROOT']."/vos09/vos09zapletam/databaze/party/images/";
//$cilovy_soubor= $cilovy_adresar. $_FILES['soubor']['name'];
//$adresa="images/".$_FILES['soubor']['name'];
//move_uploaded_file($_FILES['soubor']['tmp_name'], $cilovy_soubor);


//include("../../mysql_connect.php");
//$datum1=$_POST['datum_od']." ".$_POST['hh1'].":".$_POST['mm1'].":00";
//$datum2=$_POST['datum_do']." ".$_POST['hh2'].":".$_POST['mm2'].":00";
//mysql_query("INSERT INTO list_akce(nazev,misto,mesto,id_kraje,id_zanru,datum_a_cas_od,datum_a_cas_do,popis,vstupne,letak,mapa)
//VALUES('$_POST[nazev]','$_POST[misto]','$_POST[mesto]','$_POST[kraj]','$_POST[zanr]','$datum1','$datum2','$_POST[popis]','$_POST[vstupne]','$adresa','$_POST[mapa]')");
}
?>

<table>
<form action="akce.php" name="insertForm" method="post" enctype="multipart/form-data">
<tr><td>Název:</td><td><input type="text" name="nazev"></td></tr>
<tr><td>Místo:</td><td><input type="text" name="misto"></td></tr>
<tr><td>Město:</td><td><input type="text" name="mesto"></td></tr>
<tr><td>Žánr:</td>
<td>
<select name="zanr">
<?php
include("../../mysql_connect.php");
$sql1="SELECT*FROM list_zanry";
if($vys = mysql_query("$sql1")){
while ($zanr = mysql_fetch_array($vys)){
echo "<option value='".$zanr['id_zanru']."'>".$zanr['nazev']."</option>";
}
}else echo mysql_error();
?>
</select>
</td>
</tr>
<tr><td>Kraj:</td>
<td>
<select name="kraj">
<?php
$sql="SELECT*FROM list_kraje";
if($vysledek = mysql_query("$sql")){
while ($kraj = mysql_fetch_array($vysledek)){
echo "<option value='".$kraj['id_kraje']."'>".$kraj['nazev']."</option>";
}
}
?>
</select>
</td>
</tr>
<tr><td>Datum od:</td><td><input type="text" name='datum_od' value='0000-00-00'>
  <script type="text/javascript">
                    <!--
   document.write('<a title="Kalendář" href="javascript:openCalendar(\'lang=cs-utf-8&amp;server=1&amp;collation_connection=utf8_general_ci\', \'insertForm\', \'datum_od\', \'date\')"><img border="0" class="calendar" src="kalendar/kalendar.png" alt="Kalendář"/></a>')
                    //-->
    </script>
<select name="hh1">
<?php
for($h=1;$h<=23;$h++){
$hod=($h<10) ? "0".$h : $h;
echo "<option value='".$hod."'>$hod</option>\n";
}

?>

</select>
:
<select name="mm1">
<?php
for($m=1;$m<=23;$m++){
$min=($m<10) ? "0".$m : $m;
echo "<option value='".$min."'>$min</option>\n";
}

?>

</select>

</tr>

<tr><td>Datum do:</td><td><input type="text" name='datum_do' value='0000-00-00'>
  <script type="text/javascript">
                    <!--
   document.write('<a title="Kalendář" href="javascript:openCalendar(\'lang=cs-utf-8&amp;server=1&amp;collation_connection=utf8_general_ci\', \'insertForm\', \'datum_do\', \'date\')"><img border="0" class="calendar" src="kalendar/kalendar.png" alt="Kalendář"/></a>')
                    //-->
    </script>
<select name="hh2">
<?php
for($h2=1;$h2<=23;$h2++){
$hod2=($h2<10) ? "0".$h2 : $h2;
echo "<option value='".$hod2."'>$hod2</option>\n";
}

?>

</select>
:
<select name="mm2">
<?php
for($m2=1;$m2<=23;$m2++){
$min2=($m2<10) ? "0".$m2 : $m2;
echo "<option value='".$min2."'>$min2</option>\n";
}

?>

</select>

</tr>
</tr>
<tr><td>Vstupné:<td><input type="text" name="vstupne"></td></td></tr>
<tr><td>Leták</td><td><input type="file" name="soubor"></td></tr>
<tr><td>Mapa:</td><td><input type="text" name="mapa"></td></tr>
<tr><td>Popis:</td><td><textarea name="popis"></textarea></td></tr>
</table>

<?php
$sql2="SELECT*FROM list_interpreti";
if($vys2 = mysql_query("$sql2")){
$option="";
while($list = mysql_fetch_array($vys2)){
$option.="<option value='".$list['id_interpreta']."'>".$list['jmeno']."</option>";
}
}else echo mysql_error();
?>
<script>
 function rozbal() {//javascript na přidání selectu
  var txt = "<select name=\"interpret[]\"> <?php echo $option;?></select> od <input type=\"text\" size=\"2\" name=\"cas_ood[]\"> do <input type=\"text\" size=\"2\" name=\"cas_doo[]\"><br><br>";
  document.getElementById("dvFile").innerHTML += txt;
}
</script>
<input type="button" value="Přidej odpověď" name="rozbalit" onClick="rozbal();"><br><br>
<?php

echo '<div id="dvFile">' ;
echo "<select name='interpret[]'>";//problematická část
echo $option;
echo "</select> od <input type=\"text\" size=\"2\" name=\"cas_ood[]\"> do <input type=\"text\" size=\"2\" name=\"cas_doo[]\"><br><br>";
echo '</div>';

?>

<input type="submit" name="odeslat" value="Přidat akci">

</form>


</body>
</html>