note 48710 added to function.mysql-free-result
| From: | info at vainhost dot com | Date: | Wed, 05 Jan 2005 11:44:18 +0000 |
| Subject: | note 48710 added to function.mysql-free-result | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-82747@lists.php.net to get a copy of this message | ||
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";
}
?>
----
Manual Page -- http://www.php.net/manual/en/function.mysql-free-result.php
Edit -- http://master.php.net/manage/user-notes.php?action=edit+48710
Delete -- http://master.php.net/manage/user-notes.php?action=delete+48710&report=yes
Reason: bad code -- http://master.php.net/manage/user-notes.php?action=delete+48710&report=yes&reason=bad+code
Reason: spam -- http://master.php.net/manage/user-notes.php?action=delete+48710&report=yes&reason=spam
Reason: useless example -- http://master.php.net/manage/user-notes.php?action=delete+48710&report=yes&reason=useless+example
Reason: contains commercial links -- http://master.php.net/manage/user-notes.php?action=delete+48710&report=yes&reason=contains+commercial+links
Reason: useless note -- http://master.php.net/manage/user-notes.php?action=delete+48710&report=yes&reason=useless+note
Reject -- http://master.php.net/manage/user-notes.php?action=reject+48710&report=yes
Search -- http://master.php.net/manage/user-notes.php