note 111238 added to mysql.examples
| From: | Henk | Date: | Tue, 29 Jan 2013 20:24:19 +0000 |
| Subject: | note 111238 added to mysql.examples | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-193429@lists.php.net to get a copy of this message | ||
To vieuw a list form your database use this:
<html>
<head>
<title>Een eenvoudig voorbeeld van een PHP script</title>
</Head>
<body>
<h2>Lijst van alle landen per werelddeel</h2>
<table border="1" cellpadding="3">
<tr>
<strong>
<th>land_id</th>
<th>land</th>
</strong>
</tr>
<?php
mysql_connect("server","username","password");
mysql_select_db("Enigma09_");
$query = "SELECT * FROM landen ORDER BY werelddeel";
$resultaat = mysql_query($query);
while ($row = mysql_fetch_array($resultaat)) {
?>
<tr>
<td><?php echo $row["land_id"]; ?></td>
<td><?php echo $row["land"]; ?></td>
<td align="right"><?php echo $row["inwoners"]; ?></td>
</tr>
<?php
}
?>
</table>
</body>
</html>
----
Server IP: 69.147.83.199
Probable Submitter: 77.162.167.28
----
Manual Page -- http://php.net/manual/en/mysql.examples.php
Edit -- https://master.php.net/note/edit/111238
Del: integrated -- https://master.php.net/note/delete/111238/integrated
Del: useless -- https://master.php.net/note/delete/111238/useless
Del: bad code -- https://master.php.net/note/delete/111238/bad+code
Del: spam -- https://master.php.net/note/delete/111238/spam
Del: non-english -- https://master.php.net/note/delete/111238/non-english
Del: in docs -- https://master.php.net/note/delete/111238/in+docs
Del: other reasons-- https://master.php.net/note/delete/111238
Reject -- https://master.php.net/note/reject/111238
Search -- https://master.php.net/manage/user-notes.php