note 48753 added to function.mysql-close

------- KUNDE: ------- <html> <head> <title>Kunde</title> </head> <body> <?php if ($_POST['absenden']){ include('db_connect.php'); // Formdaten $vorname = $_POST['vorname']; $nachname = $_POST['nachname']; $ort = $_POST['ort']; $plz = $_POST['plz']; $street = $_POST['street']; if (!$_POST['vorname'] && !$_POST['nachname'] && !$_POST['street'] && !$_POST['plz'] && !$_POST['ort']){ echo "You did not fill in a required field! Try again<br><br>"; echo "<a href=kunde.php>back</a>"; }else{ $querystring = "INSERT into kunde(vorname, nachname, strasse, plz, ort) values ('".$vorname."','".$nachname."','".$street."', '".$plz."', '".$ort."')"; mysql_query($querystring); header("Location: auslesen.php"); } }else{ ?> <form action="<?= $_SERVER['PHP_SELF'] ?>" method=post> <table cellspacing=2 cellpadding=2> <tr><td>Vorname: </td> <td><input type=text name=vorname></td></tr> <tr><td>Nachname: </td> <td><input type=text name=nachname></td></tr> <tr><td>Straße: </td> <td><input type=text name=street></td></tr> <tr><td>Plz: </td> <td><input type=text name=plz></td></tr> <tr><td>Ort: </td> <td><input type=text name=ort></td></tr> <tr><td colspan=2 height=10></td></tr> <tr><td></td> <td><input type=submit name=absenden value="Add to DB"> <input type=reset name=reset value="reset"></td> </tr> </table> </form> <br><a href=auslesen.php>Datensätze anzeigen / bearbeiten / löschen</a> <?php } ?> </body> </html> ------ EDIT: ------ <html> <head> <title>Edit</title> <style> .button {color:blue; background:white; border:1px ridge black; font-weight:bold;} </style> </head> <body> <?php include('db_connect.php'); $kundennr = $_POST['id']; $anfrage = "SELECT * from kunde WHERE kundennr =".$kundennr; $erg = mysql_query($anfrage); $daten = mysql_fetch_array($erg); echo "<form action=\"update.php\" method=\"post\">"; echo "<table border=1>"; echo "<tr><td>ID:</td> <td>Vorname:</td> <td>Nachname:</td> <td>Straße:</td> <td>Plz:</td> <td>Ort:</td></tr>"; echo "<tr><td>".$daten['kundennr']."</td>"; echo "<td> <input type=text name=vorname value=\"".$daten['vorname']."\"></td>"; echo "<td> <input type=text name=nachname value=\"".$daten['nachname']."\"></td>"; echo "<td> <input type=text name=street value=\"".$daten['strasse']."\"></td>"; echo "<td> <input type=text name=plz value=\"".$daten['plz']."\"></td>"; echo "<td> <input type=text name=ort value=\"".$daten['ort']."\"></td></tr>"; echo "<tr><td colspan=6 align=right>"; ?> <input type="button" class="button" value="Delete" onclick="javascript:location.href='delete.php?id=<?=$kundennr ?>'"> <?php echo "&nbsp;&nbsp;<input type=submit name=update value='Update' class='button'></td></tr>"; echo "</table>"; echo "<input type=hidden name=id value=\"".$daten['kundennr']."\">"; echo "</form>"; ?> <br><a href=auslesen.php> Datensätze anzeigen / bearbeiten / löschen</a> <br><a href=kunde.php>Datensatz eintragen</a> </body> </html> ---- Manual Page -- http://www.php.net/manual/en/function.mysql-close.php Edit -- http://master.php.net/manage/user-notes.php?action=edit+48753 Delete -- http://master.php.net/manage/user-notes.php?action=delete+48753&report=yes Reason: bad code -- http://master.php.net/manage/user-notes.php?action=delete+48753&report=yes&reason=bad+code Reason: spam -- http://master.php.net/manage/user-notes.php?action=delete+48753&report=yes&reason=spam Reason: useless example -- http://master.php.net/manage/user-notes.php?action=delete+48753&report=yes&reason=useless+example Reason: contains commercial links -- http://master.php.net/manage/user-notes.php?action=delete+48753&report=yes&reason=contains+commercial+links Reason: useless note -- http://master.php.net/manage/user-notes.php?action=delete+48753&report=yes&reason=useless+note Reject -- http://master.php.net/manage/user-notes.php?action=reject+48753&report=yes Search -- http://master.php.net/manage/user-notes.php