note 48754 deleted from function.mysql-close by nlopess
| From: | nlopess@php.net | Date: | Thu, 06 Jan 2005 09:00:15 +0000 |
| Subject: | note 48754 deleted from function.mysql-close by nlopess | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-82824@lists.php.net to get a copy of this message | ||
Note Submitter: carlos at spain dot es
----
--------
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>