public function edit($user, $pass, $email, $firstName, $lastName, $id)
{
$db = \NewCart\Core\Database::getInstance('app');
$result = $db->prepare("\r\n UPDATE users\r\n SET password = ?, username = ?, email = ?, firstName = ?, lastName = ?\r\n WHERE id = ?");
$result->execute([$pass, $user, $email, $firstName, $lastName, $id]);
return $result->rowCount() > 0;
}
public function getTopProducts()
{
$db = \NewCart\Core\Database::getInstance('app');
$result = $db->prepare("\r\n SELECT\r\n id, productName, productPrice, discount, quantity\r\n FROM\r\n products\r\n WHERE soldQuantity > 0\r\n LIMIT 5;\r\n ");
//echo 1 . '<br/>';
$result->execute([]);
if ($result->rowCount() <= 0) {
throw new \Exception('No results');
}
//echo 2 . '<br/>';
return $result->fetchAll();
}
