public function AddUser() { $success = false; $sql = "insert into tblusers (FirstName,LastName,City,Address,Province,Country,Username,Password,Contact,Email) values ('{$this->Firstname}','{$this->Lastname}','{$this->City}','{$this->Address}','{$this->Province}','{$this->Country}','{$this->Username}','{$this->Password}','{$this->Contact}','{$this->Email}')"; try { include '../connection.php'; $query = mysqli_query($conn, $sql); $success = true; } catch (mysqliException $ex) { $success = false; $ex - getMesssage(); } mysqli_close($conn); return $success; }
public function DeleteCategory() { $success = false; $sql = "delete from tblcategories where Category_ID='{$this->CategoryID}'"; try { include '../../connection.php'; $query = mysqli_query($conn, $sql); $success = true; } catch (mysqliException $ex) { $success = false; $ex - getMesssage(); } mysqli_close($conn); return $success; }
public function NotifyUser() { $success = false; $datenow = date('Y-m-d'); $s = 1; $sql = "insert into tblnotifications (FromUser,ToUser,Message,DateRecieved,Unread) values ('{$this->FromUser}','{$this->ToUser}','{$this->Message}','{$datenow}',2)"; try { include '../../connection.php'; $query = mysqli_query($conn, $sql); $success = true; } catch (mysqliException $ex) { $success = false; $ex - getMesssage(); } mysqli_close($conn); return $success; }
public function DeleteAddon() { $success = false; $sql = "delete from tbladdons where addon_id='{$this->AddonID}'"; try { include '../connection.php'; $query = mysqli_query($conn, $sql); $success = true; } catch (mysqliException $ex) { $success = false; $ex - getMesssage(); } mysqli_close($conn); return $success; }
public function AddReserve() { $success = false; //$from = DateTime::createFromFormat('d/m/Y', $this->Arrival)->format('Y-m-d'); //$to = DateTime::createFromFormat('d/m/Y', $this->Departure)->format('Y-m-d'); $from = $this->Arrival; $to = $this->Departure; $datenow = date('Y-m-d'); $sql = "insert into tblreservation (Customer_ID,CategoryName,Room_ID,ReservationDate,Arrival,Departure,NumberofDay,No_Adult,No_Child,Status, " . "AddonPayable,Downpayment,Payable,Confirmation,transaction) values (" . "'{$this->CustomerID}','{$this->CategoryName}','{$this->RoomID}','{$datenow}','" . $from . "','" . $to . "','{$this->NumberofDays}','{$this->NumberofAdult}','{$this->NumberofChild}','{$this->Status}','{$this->Addonpayable}','{$this->Downpayment}','{$this->Payable}','{$this->Confirmation}',null)"; try { include '../../connection.php'; $query = mysqli_query($conn, $sql); $success = true; } catch (mysqliException $ex) { $success = false; $ex - getMesssage(); } mysqli_close($conn); return $success; }
public static function commentDelete($comment_ID) { $success = false; $sql = "DELETE FROM tblcomment WHERE Comment_ID='{$comment_ID}'"; try { include '../../connection.php'; $query = mysqli_query($conn, $sql); $success = true; } catch (mysqliException $ex) { $success = false; $ex - getMesssage(); } mysqli_close($conn); return $success; }