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">
