user.php - SoftXS GmbH

<html><head><title>MySQL user table</title></head>
<body>
<table border=1>
<tr><th>Host</th><th>User</th><th>Password</th></tr>
<?php
 // connect
 require_once('DB.php');
 $db = DB::connect("mysql://root:sqladmin@localhost/mysql");
 if (DB::iserror($db)) {
   die($db->getMessage( ));
 }

 // issue the query
 $sql = "SELECT Host, User, Password FROM user";

 $q = $db->query($sql);
 if (DB::iserror($q)) {
   die($q->getMessage( ));
 }

 // generate table
 while ($q->fetchInto($row)) {
echo "<tr><td>$row[0]</td>";
echo "    <td>$row[1]</td>";
echo "    <td>$row[2]</td>";
echo "</tr>";
 }
?>
</table>
</body></html>