mysql_connect("localhost","b-kino","grundig")
or die ("Keine Verbindung moeglich");
$bank = "kino";
$tab = "daten";
mysql_select_db($bank) or die
("Die Datenbank existiert nicht");
$co = htmlentities($_REQUEST['co']);
$code=htmlentities($_REQUEST['code']);
$von=htmlentities($_REQUEST['von']);
$bis=htmlentities($_REQUEST['bis']);
$name=htmlentities($_REQUEST['name']);
$ort=htmlentities($_REQUEST['ort']);
$farbe = "rot";
$name = "dani";
if($code != ""){
if($bis != ""){
if($name != ""){
if($ort != ""){
$j = 1;
mysql_query("INSERT INTO $tab (farbe,name,code,von,bis) VALUES('$ort','$name','$code','$von','$bis');");
}}}
$von = "";
$bis = "";
}
if($j != "1"){
if($code != ""){
echo "
Kein Name oder Ort angegeben
";
}}
?>
1 |
#echo"";
#$result=mysql_query("SELECT * FROM $tab ");
$abfrage = "SELECT * FROM $tab WHERE code = '$d'";
$result = mysql_query($abfrage);
$z = "0";
while( $row=mysql_fetch_array($result) )
#print_r($row);
{
$z++;
#echo $row[4];
$plvon[$d][$z] = $row[4];
$plbis[$d][$z] = $row[5];
}
$t = 0;
while($t < "31")
{
$t++;
$s = 0;
$r = 0;
while($s < "31")
{
$s++;
if ($plvon[$d][$s] == $t)
{
$r = 1;
echo "$t | ";
while ($plbis[$d][$s] > $t)
{
$t++;
echo "$t | ";
#echo " $t | ";
}
}
}
if ($r == 0)
{
if ($von == "")
{
echo "$t | ";
}
else
{
echo "$t | ";
}
}
}
?>2 |
#echo"";
#$result=mysql_query("SELECT * FROM $tab ");
$abfrage = "SELECT * FROM $tab WHERE code = '$d'";
$result = mysql_query($abfrage);
$z = "0";
while( $row=mysql_fetch_array($result) )
#print_r($row);
{
$z++;
#echo $row[4];
$plvon[$d][$z] = $row[4];
$plbis[$d][$z] = $row[5];
}
$t = 0;
while($t < "31")
{
$t++;
$s = 0;
$r = 0;
while($s < "31")
{
$s++;
if ($plvon[$d][$s] == $t)
{
$r = 1;
echo "$t | ";
while ($plbis[$d][$s] > $t)
{
$t++;
echo "$t | ";
#echo " $t | ";
}
}
}
if ($r == 0)
{
if ($von == "")
{
echo "$t | ";
}
else
{
echo "$t | ";
}
}
}
?>3 |
#echo"";
#$result=mysql_query("SELECT * FROM $tab ");
$abfrage = "SELECT * FROM $tab WHERE code = '$d'";
$result = mysql_query($abfrage);
$z = "0";
while( $row=mysql_fetch_array($result) )
#print_r($row);
{
$z++;
#echo $row[4];
$plvon[$d][$z] = $row[4];
$plbis[$d][$z] = $row[5];
}
$t = 0;
while($t < "31")
{
$t++;
$s = 0;
$r = 0;
while($s < "31")
{
$s++;
if ($plvon[$d][$s] == $t)
{
$r = 1;
echo "$t | ";
while ($plbis[$d][$s] > $t)
{
$t++;
echo "$t | ";
#echo " $t | ";
}
}
}
if ($r == 0)
{
if ($von == "")
{
echo "$t | ";
}
else
{
echo "$t | ";
}
}
}
?>4 |
#echo"";
#$result=mysql_query("SELECT * FROM $tab ");
$abfrage = "SELECT * FROM $tab WHERE code = '$d'";
$result = mysql_query($abfrage);
$z = "0";
while( $row=mysql_fetch_array($result) )
#print_r($row);
{
$z++;
#echo $row[4];
$plvon[$d][$z] = $row[4];
$plbis[$d][$z] = $row[5];
}
$t = 0;
while($t < "31")
{
$t++;
$s = 0;
$r = 0;
while($s < "31")
{
$s++;
if ($plvon[$d][$s] == $t)
{
$r = 1;
echo "$t | ";
while ($plbis[$d][$s] > $t)
{
$t++;
echo "$t | ";
#echo " $t | ";
}
}
}
if ($r == 0)
{
if ($von == "")
{
echo "$t | ";
}
else
{
echo "$t | ";
}
}
}
?>5 |
#echo"";
#$result=mysql_query("SELECT * FROM $tab ");
$abfrage = "SELECT * FROM $tab WHERE code = '$d'";
$result = mysql_query($abfrage);
$z = "0";
while( $row=mysql_fetch_array($result) )
#print_r($row);
{
$z++;
#echo $row[4];
$plvon[$d][$z] = $row[4];
$plbis[$d][$z] = $row[5];
}
$t = 0;
while($t < "31")
{
$t++;
$s = 0;
$r = 0;
while($s < "31")
{
$s++;
if ($plvon[$d][$s] == $t)
{
$r = 1;
echo "$t | ";
while ($plbis[$d][$s] > $t)
{
$t++;
echo "$t | ";
#echo " $t | ";
}
}
}
if ($r == 0)
{
if ($von == "")
{
echo "$t | ";
}
else
{
echo "$t | ";
}
}
}
?>6 |
#echo"";
#$result=mysql_query("SELECT * FROM $tab ");
$abfrage = "SELECT * FROM $tab WHERE code = '$d'";
$result = mysql_query($abfrage);
$z = "0";
while( $row=mysql_fetch_array($result) )
#print_r($row);
{
$z++;
#echo $row[4];
$plvon[$d][$z] = $row[4];
$plbis[$d][$z] = $row[5];
}
$t = 0;
while($t < "31")
{
$t++;
$s = 0;
$r = 0;
while($s < "31")
{
$s++;
if ($plvon[$d][$s] == $t)
{
$r = 1;
echo "$t | ";
while ($plbis[$d][$s] > $t)
{
$t++;
echo "$t | ";
#echo " $t | ";
}
}
}
if ($r == 0)
{
if ($von == "")
{
echo "$t | ";
}
else
{
echo "$t | ";
}
}
}
?>7 |
#echo"";
#$result=mysql_query("SELECT * FROM $tab ");
$abfrage = "SELECT * FROM $tab WHERE code = '$d'";
$result = mysql_query($abfrage);
$z = "0";
while( $row=mysql_fetch_array($result) )
#print_r($row);
{
$z++;
#echo $row[4];
$plvon[$d][$z] = $row[4];
$plbis[$d][$z] = $row[5];
}
$t = 0;
while($t < "31")
{
$t++;
$s = 0;
$r = 0;
while($s < "31")
{
$s++;
if ($plvon[$d][$s] == $t)
{
$r = 1;
echo "$t | ";
while ($plbis[$d][$s] > $t)
{
$t++;
echo "$t | ";
#echo " $t | ";
}
}
}
if ($r == 0)
{
if ($von == "")
{
echo "$t | ";
}
else
{
echo "$t | ";
}
}
}
?>8 |
#echo"";
#$result=mysql_query("SELECT * FROM $tab ");
$abfrage = "SELECT * FROM $tab WHERE code = '$d'";
$result = mysql_query($abfrage);
$z = "0";
while( $row=mysql_fetch_array($result) )
#print_r($row);
{
$z++;
#echo $row[4];
$plvon[$d][$z] = $row[4];
$plbis[$d][$z] = $row[5];
}
$t = 0;
while($t < "31")
{
$t++;
$s = 0;
$r = 0;
while($s < "31")
{
$s++;
if ($plvon[$d][$s] == $t)
{
$r = 1;
echo "$t | ";
while ($plbis[$d][$s] > $t)
{
$t++;
echo "$t | ";
#echo " $t | ";
}
}
}
if ($r == 0)
{
if ($von == "")
{
echo "$t | ";
}
else
{
echo "$t | ";
}
}
}
?>9 |
#echo"";
#$result=mysql_query("SELECT * FROM $tab ");
$abfrage = "SELECT * FROM $tab WHERE code = '$d'";
$result = mysql_query($abfrage);
$z = "0";
while( $row=mysql_fetch_array($result) )
#print_r($row);
{
$z++;
#echo $row[4];
$plvon[$d][$z] = $row[4];
$plbis[$d][$z] = $row[5];
}
$t = 0;
while($t < "31")
{
$t++;
$s = 0;
$r = 0;
while($s < "31")
{
$s++;
if ($plvon[$d][$s] == $t)
{
$r = 1;
echo "$t | ";
while ($plbis[$d][$s] > $t)
{
$t++;
echo "$t | ";
#echo " $t | ";
}
}
}
if ($r == 0)
{
if ($von == "")
{
echo "$t | ";
}
else
{
echo "$t | ";
}
}
}
?>