public function createLoginByIp($ip, $customerId = null, $status = 0) { $database = new Database(); return $database->executeSql(' INSERT INTO Login (LoginIp, LoginTime, Customer_Id, status) VALUES (?,NOW(),?,?)', [$ip, $customerId, $status]); }
public function getTotalAmountByOrderId($order_Id) { $total = 0; $database = new Database(); $allOrderMeals = $database->query('SELECT Meal_id, Quantite, UnitPrice FROM `OrderLine` WHERE Order_Id = ?', [$order_Id]); foreach ($allOrderMeals as $oneMeal) { $total += $oneMeal['Quantite'] * $oneMeal['UnitPrice']; } $database->executeSql('UPDATE `Order` SET TotalAmount = ?, TaxeAmount = (?*`Order`.TaxeRate/100), CompliteTimestamp = NOW() WHERE Id = ?', [$total, $total, $order_Id]); }
public function registerCustomer($FirstName, $LastName, $Birthdate, $Phone, $Address, $Address2, $City, $ZipCode, $Email, $password) { //HASH PHP5.5 //$passwordHash = password_hash($password, PASSWORD_DEFAULT); //HASH MANO <PHP5.5 $passwordHash = $this->hasPassword($password); $Database = new Database(); return $Database->executeSql(' INSERT INTO Customer (FirstName, LastName, Birthdate, Phone, Address, Address2, City, ZipCode, Email, password, CreationTimestamp, LastLoginTimestamp) VALUES (?,?,?,?,?,?,?,?,?,?,NOW(),NOW())', [$FirstName, $LastName, $Birthdate, $Phone, $Address, $Address2, $City, $ZipCode, $Email, $passwordHash]); }
public static function getPostBySql($sql) { $database = new Database(); return $database->executeSql($sql); }
public function addMeal($name, $description, $photo, $quantityInStock, $buyPrice, $salePrice) { $query = new Database(); return $query->executeSql('INSER INTO Meal (Name, Description, Photo, QuantityInStock, BuyPrice, SalePrice) VALUES (?,?,?,?,?)', [$name, $description, $photo, $quantityInStock, $buyPrice, $salePrice]); }
public static function logIn($email, $password) { $db = new Database(); $sql = sprintf("SELECT * FROM users where email = '%s' AND password = '******'", $email, $password); return $db->executeSql($sql); }
public static function getBySql($sql) { $db = new Database(); return $db->executeSql($sql); }
public function deletBooking($bookingId) { $database = new Database(); $database->executeSql('DELETE FROM Booking WHERE Id = ?', [$bookingId]); }
public function register($Customer_Id, $BookingDate, $BookingTime, $NumberOfSeats) { $query = new Database(); return $query->executeSql('INSERT INTO Booking (Customer_Id, BookingDate, BookingTime, CreationTimestamp, NumberOfSeats) VALUES (?,?,?,?,?) ', [$Customer_Id, $BookingDate, $BookingTime, date("Y-m-d G:i:s"), $NumberOfSeats]); }
private function updateLastLoginTimestamp($Id) { $Database = new Database(); $Database->executeSql('UPDATE Customer SET LastLoginTimestamp = NOW() WHERE Id = ?', [$Id]); }