note 48756 deleted from function.mysql-fetch-object by nlopess
| From: | nlopess@php.net | Date: | Thu, 06 Jan 2005 09:00:28 +0000 |
| Subject: | note 48756 deleted from function.mysql-fetch-object by nlopess | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-82826@lists.php.net to get a copy of this message | ||
Note Submitter: help at hh dot com
----
------------------
Eintrag erfassen |
------------------
<html><head><title>Erfassen</title></head>
<body>
<?php
include('db_connect.php');
$querystring = "SELECT * from pkwtyp";
$result = mysql_query($querystring);
?>
<form action="PKW_eintragen.php" method=post>
<table cellspacing=2 cellpadding=2>
<tr><td>Kennzeichen:
<input type=text name="kennzeichen"></td></tr>
<tr><td>Zulassungsdatum:
<input type=text name="zulassungsdatum">
<br><br></td></tr>
<tr><td>Bitte Hersteller/Modell auswählen:<br>
<select name="box" size="5" width="20">
<?
while($row = mysql_fetch_row($result)){
echo
"<option value=$row[0]>$row[1] - $row[2]</option>";
}
?>
</select>
</td></tr>
<tr>
<td>
<input type=submit name=absenden value="Eintragen">
</td>
</tr>
</table>
</form>
<br><br>
<a href="anzeigen.php">Anzeigen</a>
</body>
</html>
-----------
Eintragen |
-----------
<html><head><title>PWK_eintragen</title></head>
<body>
<?php
include('db_connect.php');
$kennzeichen = $_POST['kennzeichen'];
$zulassungsdatum = $_POST['zulassungsdatum'];
$typnr = $_POST['box'];
if (!$_POST['kennzeichen'] && !$_POST['zulassungsdatum']){
echo "You did not fill in a required field!";
echo "<a href=erfassen.php>back</a>";
}else{
$querystring = "INSERT into pkw(kennzeichen, typnr, zugelassen)
values (
'".$kennzeichen."','".$typnr."','".$zulassungsdatum."'
)";
mysql_query($querystring);
}
header("Location: anzeigen.php");
?>
</body>
</html>
----------
Anzeigen |
----------
<html><head><title>Anzeigen</title></head>
<body>
<?php
include('db_connect.php');
$anfrage = "SELECT * from pkw";
$result = mysql_query($anfrage, $verbindung)
or die(mysql_error());
$anz_daten = mysql_num_rows($result);
echo "<table border=1>";
echo "<tr><td>Kennzeichen</td>
<td>Typnr</td>
<td>Zulassungsdatum</td></tr>";
for ($i=0; $i<$anz_daten; $i++){
$daten = mysql_fetch_row($result);
echo "<tr><td>".$daten[0]."</td>";
echo "<td>".$daten[1]."</td>";
echo "<td>".$daten[2]."</td></tr>";
}
echo "<table>";
?>
<br><a href=erfassen.php>Datensatz erfassen</a>
</body>
</html>