Untitled

<?php
    // Configuration
    $hostname = 'localhost';
    $username = 'haarkh_lfuser';
    $password = 'litflame';
    $database = 'haarkh_litflame';

    try {
        $dbh = new PDO('mysql:host='. $hostname .';dbname='. $database, $username, $password);
    } catch(PDOException $e) {
        echo '<h1>An error has occurred.</h1><pre>', $e->getMessage() ,'</pre>';
    }

    $sth = $dbh->query('SELECT * FROM scores ORDER BY score DESC LIMIT 5');
    $sth->setFetchMode(PDO::FETCH_ASSOC);

    $result = $sth->fetchAll();
?>
<!DOCTYPE html>
<html lang="nl">

<head>
    <meta charset="UTF-8">
	<title>ScoreBoard</title>
	<link href="./css/styleGame.css" rel="stylesheet">
</head>

<body>
 <header>
      <div class="container">
        <div id="branding">
          <h1><img src="img/LogoPink.png" alt="Logo LitFlame Memory"></h1>
        </div>
        <nav>
          <ul>
            <li><a href="index.html">Home</a></li>
			<li><a href="Game.html">Game</a></li>
			<li class="current"><a href="#">ScoreBoard</a></li>
          </ul>
        </nav>
      </div>
    </header>

	<div>
		<h1>ScoreBoard</h1>
	</div>

	<div class="scores">
		<ol>
			<?php
				if(count($result) > 0) {
					foreach($result as $r) {
						echo "<li>"$r['naam'], " heeft", $r['score'], " punten gehaald!";
				}
			}
			?>
		</ol>
	</div>

</body>

</html>