note 48711 deleted from function.mysql-free-result by cece
| From: | cece@php.net | Date: | Wed, 05 Jan 2005 12:10:37 +0000 |
| Subject: | note 48711 deleted from function.mysql-free-result by cece | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-82751@lists.php.net to get a copy of this message | ||
Note Submitter: info at vainhost dot com
Reason: useless example
----
<?
// error-variable wir auf false gesetzt
$err = false;
// falls keine kundennr uebertragen worden ist, dann setze
// error-variable auf true uns gebe error-msg aus
if ($usernr == "") {
echo "Es wurde kein User selektiert<br><br>";
echo "<a href='javascript:history.back();'>ZURÜCK</a>";
$err = true;
}
// wenn kein fehler aufgetreten ist
if ($err=== false) {
// Standart DB Connect variablen
$server = "localhost";
$database = "autovermietung";
$username = "";
$password = "";
// SQL Connect Anweisung - Wahl der Datenbank
$Verbindung=mysql_connect($server) or die (mysql_error());
$DB = mysql_select_db($database,$Verbindung);
// Select Statements
$Query = "SELECT kundennr, nachname, vorname, strasse,
plz, ort FROM kunde WHERE kundennr=$usernr";
$QueryOrder = " ORDER BY Nachname ASC";
// Anfrage an db stellen inkl WHERE-Klausel und Order BY
$mysqlQuery = mysql_query($Query.$QueryOrder) or die (mysql_error());
// wenn user gefunden - anzeigen
if ($row=mysql_fetch_array($mysqlQuery, MYSQL_ASSOC)) {
echo
"<html><head><title>EDITIEREN</title></head><body>";
echo "<form name=edit action=eintragen.php?typ=edit method=post>\r\n";
echo "<input type=hidden name=kundennr value=$usernr>\r\n";
echo "<table cellpadding=2 cellspacing=2 border=1>\r\n";
echo "<tr>\r\n";
echo "<td colspan=2>EDIT DB USER:</td>\r\n";
echo "</tr>\r\n";
echo "<tr>\r\n";
echo "<td>Vorname</td>\r\n";
echo "<td><input type=text name=Vorname value=" . $row["vorname"] .
">
</td>\r\n";
echo "</tr>\r\n";
echo "<tr>\r\n";
echo "<td>Nachname</td>\r\n";
echo "<td><input type=text name=Nachname value=" . $row["nachname"]
.">
</td>\r\n";
echo "</tr>\r\n";
echo "<tr>\r\n";
echo "<td>Strasse</td>\r\n";
echo "<td><input type=text name=Strasse value=" . $row["strasse"] .
">
</td>\r\n";
echo "</tr>\r\n";
echo "<tr>\r\n";
echo "<td>PLZ</td>\r\n";
echo "<td><input type=text name=PLZ value=" . $row["plz"] . ">
</td>\r\n";
echo "</tr>\r\n";
echo "<tr>\r\n";
echo "<td>ORT</td>\r\n";
echo "<td><input type=text name=Ort value=" . $row["ort"] .">
</td>\r\n";
echo "</tr>\r\n";
echo "<tr>\r\n";
echo "<td><a href='javascript:history.back();'>zurück</a>
</td>\r\n";
echo "<td><a
href='javascript:document.forms[0].submit();'>senden</a>
</td>\r\n";
echo "</tr>\r\n";
echo "</table>\r\n";
echo "</body>\r\n";
echo "</html>\r\n";
}
} // ende if err===false
?>