<HTML>
<HEAD>
<TITLE>Test formular</TITLE>
</HEAD>
<BODY>
<?php error_reporting(E_ALL);
if (isset ($_POST['submit'])) {
$sql = "INSERT INTO _cds
(name , year , cdcover)
VALUES " ;
foreach($_POST['cd'] as $cd){
//testen ob der Eintrag OK ist
if(trim($cd['name']) == '') continue;
if(trim($cd['year']) == '') continue;
if(trim($cd['cover']) == '') continue;
//
$sql .="('".mysql_escape_string($cd['name'])."',";
$sql .=" '".mysql_escape_string($cd['year'])."',";
$sql .=" '".mysql_escape_string($cd['cover'])."') ,";
}
// jetzt haben wir am Ende von $sql ein Komma zuviel
$sql = substr($sql,0,-1);
echo $sql ;
}
?>
<hr>
<form action="<?php echo $_SERVER['PHP_SELF'] ?>" method=post>
Name: <input type="text" name="cd[1][name]"> Jahr: <input type="text" name="cd[1][year]" size="4" maxlength="4"> CD Cover: <input type="text" name="cd[1][cover]"><br>
Name: <input type="text" name="cd[2][name]"> Jahr: <input type="text" name="cd[2][year]" size="4" maxlength="4"> CD Cover: <input type="text" name="cd[2][cover]"><br>
Name: <input type="text" name="cd[3][name]"> Jahr: <input type="text" name="cd[3][year]" size="4" maxlength="4"> CD Cover: <input type="text" name="cd[3][cover]"><br>
Name: <input type="text" name="cd[4][name]"> Jahr: <input type="text" name="cd[4][year]" size="4" maxlength="4"> CD Cover: <input type="text" name="cd[4][cover]"><br>
Name: <input type="text" name="cd[5][name]"> Jahr: <input type="text" name="cd[5][year]" size="4" maxlength="4"> CD Cover: <input type="text" name="cd[5][cover]"><br>
<input type=submit name="submit" value="abschicken">
</form>
<hr>
<?php highlight_file(__FILE__) ?>
</BODY>
</HTML>