Untitled

<!DOCTYPE HTML>
<html lang="pl">
<head>
<meta charset="utf-8" />
<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1" />

<title></title>

<meta name="description" content="Opis w Google" />
<meta name="keywords" content="słowa, kluczowe, wypisane, po, porzecinku" />

</head>

<body>


</body>
</html>

<?php

$dsn = "mysql:host=localhost;dbname=books";
$uzytkownik = "root";
$haslo = "abc";

try
{
$dbo = new PDO($dsn, $uzytkownik, $haslo);
}
catch(PDOException $e)
{
echo 'Błąd podczas otwierania połącznia: '. $e->getMessage();
exit;
}

//$query = "use books;";

$query = 'select * from ksiazki';

$result = $dbo->query($query);

echo<<<END
<table id="myTable2">
<tr>
<th>Id</th>
<th>Zdjęcie</th>
<th onclick="sortTable(2)">Tytuł</th>
<th onclick="sortTable(3)">Autor</th>
<th onclick="sortTable(4)">Wydawnictwo</th>
<th>Opis</th>
<th onclick="sortTable(6)">Kategoria</th>
<th onclick="sortTable(7)">Typ</th>
</tr>
END;

$i = 1;

while($row = $result->fetch(PDO::FETCH_NUM))
{
echo "<tr>";
echo "<td>".$i."</td>";
echo "<td><a href='$row[8]'><img src='$row[8]' width='80' /></a></td>";
echo "<td>$row[1]</td>";
echo "<td>$row[2]</td>";
echo "<td>$row[3]</td>";
echo "<td style='width: 300px; font-size: 11px; text-align: justify;'>$row[4]</td>";
echo "<td>$row[5]</td>";
echo "<td>$row[6]</td>";

//echo '<td><img src="/download/agh.jpg"></td>"';
echo "</tr>";
$i++;
}

echo "</table>";

$dbo = null;
?>