public function getAmountOfPages()
{
try {
$dbconn = DatabaseConnection::getConnection();
$stmt = $dbconn->prepare('SELECT car_id FROM cars');
$stmt->execute();
$totalRecords = $stmt->rowCount();
return ceil($totalRecords / $this->_limitRecords);
} catch (\PDOException $e) {
return false;
echo 'Database error: ' . $e->getMessage();
die;
}
}
public function update()
{
try {
$dbconn = DatabaseConnection::getConnection();
$stmt = $dbconn->prepare('UPDATE cars SET
price=:price,
cond=:cond,
img_url=:img_url WHERE vin=:vin');
$stmt->bindParam(':price', $this->price);
$stmt->bindParam(':cond', $this->cond);
$stmt->bindParam(':img_url', $this->img_url);
$stmt->bindParam(':vin', $this->vin);
$stmt->execute();
return true;
} catch (\PDOException $e) {
echo 'Database error: ' . $e->getMessage();
return false;
die;
}
}
public function checkUsersCar($vin)
{
try {
$dbconn = DatabaseConnection::getConnection();
$stmt = $dbconn->prepare('SELECT car_id FROM cars WHERE created_by=:user_id AND vin=:vin LIMIT 1');
$stmt->bindParam(':user_id', $this->user_id);
$stmt->bindParam(':vin', $vin);
$stmt->execute();
if ($stmt->rowCount() > 0) {
return true;
} else {
return false;
}
} catch (\PDOException $e) {
echo 'Database error: ' . $e->getMessage();
return false;
die;
}
}