public function store() { $conn = mysql_connect("localhost", "root", "") or die("Cannot connect database."); $lnk = mysql_select_db("db_quantity") or die("Cannot select database."); $query = "INSERT INTO `db_quantity`.`tbl_quantity` (`id`, `week`, `date`, `manager`, `quantity`) VALUES ('" . $this->id . "', '" . $this->week . "', '.{$this->date}.', '" . $this->manager . "', '" . $this->quantity . "');"; $result = mysql_query($query); if ($result) { $_message = "All data is added successfully."; } else { $_message = "There is an error while saving data. Please try again later."; } Utility::redirect('../../index.php'); }
public function delete($id = null) { if (is_null($id)) { Utility::message("<div class=\"message_error\">No id avaiable. Sorry !</div>"); Utility::redirect('index.php'); } $conn = mysql_connect("localhost", "root", "") or die("Cannot connect database."); $lnk = mysql_select_db("atomicproject") or die("Cannot select database."); $query = "DELETE FROM `atomicproject`.`summary` WHERE `summary`.`id` = " . $id; $result = mysql_query($query); if ($result) { Utility::message("<div class=\"message_success\">Summary is deleted successfully.</div>"); } else { Utility::message("<div class=\"message_error\">Cannot delete.</div>"); } Utility::redirect('index.php'); }
use App\Connection\Connection; use App\Utility\Utility; use App\LoginRegistration\LoginRegistration; $dbConnect = new Connection(); // Utility::dd($dbConnect); $message = isset($dbConnect->message) ? $dbConnect->message : ""; ?> <?php if (isset($dbConnect) && $_SERVER["REQUEST_METHOD"] == "POST" && isset($_REQUEST["login"])) { if (!empty($_REQUEST["username"]) && !empty($_REQUEST["password"])) { $newUser = new LoginRegistration($_POST); $dbUser = $newUser->loginQuery(); if ($dbUser) { if ($dbUser["username"] == $newUser->username && password_verify($newUser->password, $dbUser["password"])) { Utility::redirect("welcome.php"); } else { $message = "Error...Username/Password doesn't match!"; } } else { $message = "Error...There is no user like this!"; } } else { $message = "Username/Password can't be empty"; } } ?> <!DOCTYPE html> <html lang="en-US"> <head> <meta charset="utf-8">