note 48754 added to function.mysql-close
| From: | carlos at spain dot es | Date: | Thu, 06 Jan 2005 05:51:16 +0000 |
| Subject: | note 48754 added to function.mysql-close | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-82813@lists.php.net to get a copy of this message | ||
--------
UPDATE:
--------
<html>
<head>
<title>Update</title>
</head>
<body>
<?php
include('db_connect.php');
$update = "UPDATE kunde
SET vorname = '$vorname',
nachname = '$nachname',
strasse = '$street',
plz = '$plz',
ort = '$ort'
WHERE kundennr = '$id'";
mysql_query($update) or die("Fehler");
header("Location: auslesen.php");
?>
</body>
</html>
----------
AUSLESEN:
----------
<html>
<head>
<title>Auslesen</title>
</head>
<body>
<?php
include('db_connect.php');
$anfrage = "SELECT * from kunde";
$result = mysql_query($anfrage, $verbindung) or die(mysql_error());
$anz_daten = mysql_num_rows($result);
echo "<form action=\"edit.php\" method=\"post\">";
echo "<table border=1>";
echo "<tr><td></td><td>ID:</td>
<td>Vorname:</td>
<td>Nachname:</td>
<td>Straße:</td>
<td>Plz:</td>
<td>Ort:</td></tr>";
for ($i=0; $i<$anz_daten; $i++){
$daten = mysql_fetch_array($result);
//var_dump($daten)."<br><br><br>";
echo "<tr>
<td>
<input type=radio name=id
value=".$daten['kundennr']."></td>
<td>".$daten['kundennr']."</td>
<td>".$daten['vorname']."</td>
<td>".$daten['nachname']."</td>
<td>".$daten['strasse']."</td>
<td>".$daten['plz']."</td>
<td>".$daten['ort']."</td></tr>";
}
echo "<tr><td colspan=7 align=right>
<input type=submit name=edit value=edit><td></tr>";
echo "</table>";
echo "</form>";
?>
<br><a href=kunde.php>Datensatz eintragen</a>
</body>
</html>
--------
DELETE:
--------
<html>
<head>
<title>Delete</title>
</head>
<body>
<?php
include('db_connect.php');
$delete = "DELETE from kunde
WHERE kundennr = '$id'";
mysql_query($delete) or die("Fehler");
header("Location: auslesen.php");
?>
</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+48754
Delete -- http://master.php.net/manage/user-notes.php?action=delete+48754&report=yes
Reason: bad code -- http://master.php.net/manage/user-notes.php?action=delete+48754&report=yes&reason=bad+code
Reason: spam -- http://master.php.net/manage/user-notes.php?action=delete+48754&report=yes&reason=spam
Reason: useless example -- http://master.php.net/manage/user-notes.php?action=delete+48754&report=yes&reason=useless+example
Reason: contains commercial links -- http://master.php.net/manage/user-notes.php?action=delete+48754&report=yes&reason=contains+commercial+links
Reason: useless note -- http://master.php.net/manage/user-notes.php?action=delete+48754&report=yes&reason=useless+note
Reject -- http://master.php.net/manage/user-notes.php?action=reject+48754&report=yes
Search -- http://master.php.net/manage/user-notes.php