RobinNixon
28 lines
550 B
PHP
28 lines
550 B
PHP
<?php
|
|
require_once 'login.php';
|
|
|
|
try
|
|
{
|
|
$pdo = new PDO($attr, $user, $pass, $opts);
|
|
}
|
|
catch (PDOException $e)
|
|
{
|
|
throw new PDOException($e->getMessage(), (int)$e->getCode());
|
|
}
|
|
|
|
$query = "SELECT * FROM cats";
|
|
$result = $pdo->query($query);
|
|
|
|
echo "<table><tr> <th>Id</th> <th>Family</th><th>Name</th><th>Age</th></tr>";
|
|
|
|
while ($row = $result->fetch(PDO::FETCH_NUM))
|
|
{
|
|
echo "<tr>";
|
|
for ($k = 0 ; $k < 4 ; ++$k)
|
|
echo "<td>" . htmlspecialchars($row[$k]) . "</td>";
|
|
echo "</tr>";
|
|
}
|
|
|
|
echo "</table>";
|
|
?>
|