An error har occured. ', $e->getMessage(), '
';
die();
}
$sth = $dbh->query("SELECT id FROM Category WHERE name = '$category'");
$sth->setFetchMode(PDO::FETCH_ASSOC);
$result = $sth->fetchAll();
if (count($result) > 0) {
foreach ($result as $r) {
echo "Category Id: " . $r['id'] . "\n";
}
}
$realHash = md5($_GET['name'] . $_GET['score'] . $secretKey);
if ($realHash == $hash) {
$sth = $dbh->prepare('INSERT INTO scores VALUES (null, :name, :score)');
try {
$sth->execute($_GET);
} catch (Exception $e) {
echo 'An error has ocurred.
', $e->getMessage(), '
';
}
}
?>