<!DOCTYPE html>
<html>
<head>
<title>View Records</title>
</head>
<body>
<h1>View Records</h1>
<?php
$db = new PDO('mysql:host=localhost;dbname=records2', 'root', '');
$players = $db -> query('SELECT * FROM players');
echo "<table border='1' cellpadding='10>"; echo "<tr><th>ID</th><th>First name</th><th>Last name</th></tr>";
foreach($players->fetchAll() as $row){
echo "<td>".$row['id']."</td>"; echo "<td>".$row['firstname']. "</td>"; echo "<td>".$row['lastname']."</td>"; }
$player -> closeCursor();
?>
</body>
</html>
Dlaczego nie wyświetla mi tabeli z danymi?
Z PDO raczej wszystko ok.
Z góry dzięki za pomoc