<?php
require 'DB.php';
$host = 'localhost';
$db_name = 'xanadu';
$user = 'root';
$pass = '';
$dsn = "mysql://$user:$pass@$host/$db_name";
$db = DB::connect($dsn,
true);
if (DB::isError($db))
{
die
($db->getMessage());
}
$sql = 'SELECT
* FROM vokabeln ORDER BY deutsch';
$result = $db->query($sql);
if (DB::isError($result))
{
die
($result->getMessage());
}
?>
<table border=1>
<tr><td>Deutsch</td><td>Englisch</td><td>Erläuterung</td></tr>
<?php
while ($row =
$result->fetchRow()) {
?>
<tr><td><?=$row[1]?></td>
<td><?=$row[2]?></td>
<td><?=$row[3]?></td></tr>
<?php
}
$db->disconnect();
?>
</table>
|