function getTokenValid($username, $token)
{
$db = new Database();
$username = $db->link->real_escape_string($username);
$db->doSQL("SELECT * FROM `Token` WHERE `userID` = '{$username}' AND `token` = '{$token}'");
$result = $db->getRecord();
if (mysqli_num_rows($result) == 0) {
return false;
} else {
return true;
}
$db->closeConnection();
}
<ul class="nav">
<li class="active">
<a class="brand" href="#">$$$$</a>
</li>
<ul class="nav">
<li class="dropdown">
<a href="#"
class="dropdown-toggle"
data-toggle="dropdown">
MERKEN
<b class="caret"></b>
</a>
<ul class="dropdown-menu">
<?php
$query = "SELECT * FROM MERK;";
$database->doSQL($query);
while ($row = $database->getRecord()) {
echo "<li><a href=merken.php?naam=" . $row['naam'] . ">" . $row['naam'] . "</a></li>";
}
?>
</li>
</ul>
<?php
$d = "SELECT * FROM CATEGORY";
$database->doSQL($d);
while ($row = $database->getRecord()) {
echo "<li><a href=category.php?naam=" . $row['naam'] . ">" . $row['naam'] . "</a></li>";
}
?>
<li><a href="cart.class.php">Winkelwagentje</a></li>
</ul>
function payedStats()
{
$db = new Database();
$db->doSQL("SELECT `payed`, COUNT(`payed`) as 'amount' FROM `Invoices` GROUP BY `payed`");
$db->closeConnection();
$result = $db->getRecord();
error_log(print_r($result, true));
if (mysqli_num_rows($result) == 0) {
return false;
} else {
return $result;
}
}