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(); }