note 48710 deleted from function.mysql-free-result by cece
| From: | cece@php.net | Date: | Wed, 05 Jan 2005 12:11:08 +0000 |
| Subject: | note 48710 deleted from function.mysql-free-result by cece | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-82752@lists.php.net to get a copy of this message | ||
Note Submitter: info at vainhost dot com
Reason: useless example
----
DB Datensatzauslesen rest v. eben:
// Anfrage an db stellen inkl
//WHERE-Klausel und Order BY
$mysqlQuery = mysql_query($Query.$QueryOrder) or
die (mysql_error());
// normale html -anzeige
echo "<form name=edit action=edit.php
method=post>\r\n";
echo "<table cellpadding=2 cellspacing=2
border=1>\r\n";
// wenn $mysqlInsert belegt -
//dann schreibe hinweistext
if ($mysqlInsert) {
echo " <tr>\r\n";
echo " <td colspan=7 align=center>
User '$Vorname,
$Nachname' was Inserted!
</td>
\r\n";
echo " </tr>\r\n";}
// wenn $mysqlUpdate belegt - d
//dann schreibe hinweistext
elseif ($mysqlUpdate) {
echo "<tr>\r\n";
echo "<td colspan=7 align=center>
User '$Vorname,
$Nachname' was Updated! /td>\r\n";
echo " </tr>\r\n";
}
// normale html -anzeige
echo " <tr>\r\n";
echo " <td colspan=7>
ALL DB USERES:
</td>\r\n";
echo " </tr>\r\n";
echo " <tr>\r\n";
echo "<td> </td>\r\n";
echo "<td>Vorname</td>\r\n";
echo "<td>Nachname</td>\r\n";
echo "<td>Strasse</td>\r\n";
echo "<td>PLZ</td>\r\n";
echo "<td>ORT</td>\r\n";
echo "<td> </td>\r\n";
echo " </tr>\r\n";
// solange nicht das datenbank ende erreicht,
//auslesen und anzeigen
while ($row=mysql_fetch_array
($mysqlQuery, MYSQL_ASSOC)) {
echo " <tr>\r\n";
echo " <td><input type=
radio name=usernr
value=".$row["kundennr"]."></td>\r\n";
echo "<td>" . $row["vorname"] . " </td>\r\n";
echo "<td>" . $row["nachname"] ." </td>\r\n";
echo "<td>" . $row["strasse"] . " </td>\r\n";
echo "<td>" . $row["plz"] . " </td>\r\n";
echo "<td>" . $row["ort"] ." </td>\r\n";
echo "<td>
<a href='eintragen.php?
typ=delete&kundennr=".$row["kundennr"]."'>
delete</a></td>\r\n";
echo " </tr>\r\n";
}
// normale html -anzeige
echo "<tr>\r\n";
echo " <td colspan=3>
<a href='javascript:document.forms[0].submit
();'>editieren</a></td>\r\n";
echo " <td colspan=4>
<a href='kunde.php'>
Kunden hinzufügen</a>
</td>\r\n";
echo "</tr>\r\n";
echo "</table>\r\n";
echo "</form>\r\n";
}
// wenn user eindeutig dann schreibe
elseif ($foundUser===true) {
//HTML darstellung - \r\n bewirkt
//einen zeilenumbruch
echo "<table cellpadding=2
cellspacing=2 border=1>\r\n";
echo "<tr>\r\n";
echo "<td colspan=5 align=center>
User <br><br>First-Name: '$Vorname'
<br>AND
<br> Last-Name: '$Nachname' <br>
<br> already exists in DB!</td>\r\n";
echo "</tr>\r\n";
echo "<tr>\r\n";
echo "<td colspan=5 align=center>
<a href=javascript:history.back();>
Zurück
</a></td>\r\n";
echo " </tr>\r\n";
echo "</table>\r\n";
}
?>