public static function create($username, $total) { $sql = 'INSERT INTO orders ' . '(username, total) ' . 'VALUES (:username, :total)'; $params = array('username' => $username, 'total' => $total); $id = Database::update($sql, $params); return new Order($username, $total, $id, Database::now()); }
public static function create($username, $password, $address) { if (static::exist($username)) { throw new \Lib\Exceptions\DuplicateException(); } $salt = Security::generate_salt(); $hashed_password = self::generate_hash($password, $salt); $sql = 'INSERT INTO users ' . '(username, password, salt, address) ' . 'VALUES(:username, :password, :salt, :address)'; $params = array('username' => $username, 'password' => $hashed_password, 'salt' => $salt, 'address' => $address); Database::update($sql, $params); return new User($username, $address); }
public static function decrease_quantity($id, $quantity) { $sql = 'UPDATE products SET quantity=quantity - :quantity WHERE id=:id'; $params = array('id' => $id, 'quantity' => $quantity); return Database::update($sql, $params); }