Untitled
unknown
plain_text
6 months ago
36 kB
2
Indexable
I'll send you code of my website, fix all the bugs and make it look good
categories.php:
<?php
include_once 'connection/db.php'; // Ensure your DB connection file is included
if (isset($_POST['add_category'])) {
$category_name = trim($_POST['category_name']);
if (!DB::query('SELECT name FROM categories WHERE name = :name', [':name' => $category_name])) {
DB::query('INSERT INTO categories (name) VALUES (:name)', [':name' => $category_name]);
$success = "Category added successfully!";
} else {
$error = "Category already exists!";
}
}
if (isset($_POST['update_category'])) {
$category_id = $_POST['category_id'];
$new_name = trim($_POST['new_name']);
DB::query('UPDATE categories SET name = :name WHERE id = :id', [':name' => $new_name, ':id' => $category_id]);
$success = "Category updated successfully!";
}
if (isset($_POST['delete_category'])) {
DB::query('DELETE FROM categories WHERE id = :id', [':id' => $_POST['category_id']]);
$success = "Category deleted successfully!";
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Manage Categories</title>
<link rel="stylesheet" href="vendor/bootstrap/css/bootstrap.min.css">
</head>
<body>
<div class="container">
<h1>Manage Categories</h1>
<!-- Display Success or Error Messages -->
<?php if (isset($success)): ?>
<div class="alert alert-success"><?= $success ?></div>
<?php elseif (isset($error)): ?>
<div class="alert alert-danger"><?= $error ?></div>
<?php endif; ?>
<!-- Add Category Form -->
<h2>Add Category</h2>
<form method="POST" action="categories.php">
<input type="text" name="category_name" placeholder="New Category Name" required>
<button type="submit" name="add_category" class="btn btn-success">Add</button>
</form>
<!-- Edit/Delete Categories -->
<h2>Existing Categories</h2>
<table class="table table-bordered">
<thead>
<tr>
<th>Category Name</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
<?php
$categories = DB::query('SELECT * FROM categories');
foreach ($categories as $category):
?>
<tr>
<form method="POST" action="categories.php">
<td>
<input type="text" name="new_name" value="<?= $category['name'] ?>" required>
<input type="hidden" name="category_id" value="<?= $category['id'] ?>">
</td>
<td>
<button type="submit" name="update_category" class="btn btn-primary">Update</button>
<button type="submit" name="delete_category" class="btn btn-danger">Delete</button>
</td>
</form>
</tr>
<?php endforeach; ?>
</tbody>
</table>
</div>
</body>
</html>
now header.php:
<?php include_once 'connection/db.php'; ?>
<?php include_once 'connection/mysqli.php'; ?>
<?php
session_start();
if ($_SESSION['logged_in'] != 1) {
header('location:index.php');
} else {
$getfullname = $_SESSION['get_fullname'];
$getage = $_SESSION['get_age'];
$getaddress = $_SESSION['get_address'];
$getposition = $_SESSION['get_position'];
}
?>
<?php
if (isset($_POST['logout'])) {
$_SESSION['logged_in'] = 0;
header('location: index.php');
}
?>
<div class="container-fluid">
<!-- Header Section -->
<div class="row">
<div class="col-12 text-center">
<h1 class="brand mb-4">Ingredients Stock Management System</h1>
</div>
</div>
<!-- Navigation Section -->
<div class="row mb-3">
<div class="col-12">
<div class="btn-group">
<!-- Home, Add Ingredients, Manager, User Management -->
<a class="btn btn-default" href="home.php">
<span class="fa fa-home"></span> Home
</a>
<a class="btn btn-default" href="add_stock.php">
<span class="fa fa-cart-plus"></span> Add Ingredients Stock
</a>
<a class="btn btn-default" href="stock_manager.php">
<span class="fa fa-area-chart"></span> Ingredients Stock Manager
</a>
<?php if ($_SESSION['get_position'] != 'USER') { ?>
<a class="btn btn-default" href="account_registration.php">
<span class="fa fa-user-secret"></span> User Management
</a>
<?php } ?>
<!-- User Info and Dropdown -->
<div class="btn-group ml-auto">
<button type="button" class="btn btn-default dropdown-toggle" data-toggle="dropdown">
<span class="fa fa-user-circle"></span> <?php echo $getfullname; ?>
<img src="images/online.png" width="10"> <span class="caret"></span>
</button>
<ul class="dropdown-menu" role="menu">
<li><a href="#" data-toggle="modal" data-target="#change">Change Password</a></li>
<li>
<form action="header.php" method="post">
<button class="btn btn-link" type="submit" name="logout">Logout</button>
</form>
</li>
</ul>
</div>
</div>
</div>
</div>
</div>
<!-- Change Password Modal (You can add this modal code where you need it) -->
<div id="change" class="modal fade" role="dialog">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal">×</button>
<h4 class="modal-title"><span class="fa fa-gear"></span> Change Password</h4>
</div>
<div class="modal-body">
<!-- Form for password change goes here -->
</div>
<div class="modal-footer">
<button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
</div>
</div>
</div>
</div>
<!-- Add Bootstrap JS and jQuery for dropdown, modal functionality -->
<script src="vendor/jquery-3.2.1.min.js" charset="utf-8"></script>
<script src="vendor/bootstrap/js/bootstrap.min.js" charset="utf-8"></script>
style.css:
/* Global Body */
body {
background-color: #f4f7f6; /* Light gray background */
font-family: 'Roboto', sans-serif; /* Modern font */
color: #333; /* Default text color */
margin: 0;
padding: 0;
}
/* Title Container */
#title_container {
background: #3A6A5D; /* Modern green shade */
padding: 30px 20px;
box-shadow: 0 2px 10px rgba(0, 0, 0, 0.1); /* Light shadow for depth */
}
#title_container .container-fluid .brand {
font-size: 32px;
font-weight: bold;
color: #fff;
letter-spacing: 1px;
margin-bottom: 10px;
}
#title_container .container-fluid .system {
font-size: 18px;
font-weight: normal;
color: #fff;
}
/* Main Container */
#main_container {
margin-top: 50px;
padding: 0 20px;
}
.panel {
border-radius: 8px;
border: 1px solid #e1e1e1; /* Lighter border color */
margin-bottom: 30px;
background: #fff;
box-shadow: 0 4px 10px rgba(0, 0, 0, 0.05); /* Subtle shadow */
}
/* Panel Heading */
.panel .panel-heading {
background-color: #3A6A5D;
color: #fff;
font-size: 18px;
font-weight: bold;
border-radius: 8px 8px 0 0;
padding: 15px;
}
label {
font-size: 14px;
font-weight: normal;
color: #555;
}
/* Button Links */
.btn-link {
text-decoration: none;
color: #007bff; /* Link color */
margin-left: 8px;
}
.btn-link:hover {
text-decoration: underline;
color: #0056b3;
}
/* User Profile Section */
.user_name {
font-size: 20px;
font-weight: bold;
color: #333;
}
.user_position,
.user_age,
.user_address {
font-size: 14px;
font-weight: normal;
color: #555;
}
/* Table Styles */
#panel_table .panel-body {
padding: 0px;
}
#readonly {
border: none;
background: none;
}
/* Input Fields and Buttons */
input[type="text"],
input[type="number"],
input[type="date"],
select {
width: 100%;
padding: 10px;
border-radius: 5px;
border: 1px solid #ddd;
font-size: 16px;
margin-bottom: 15px;
box-sizing: border-box;
transition: all 0.3s ease-in-out;
}
input[type="text"]:focus,
input[type="number"]:focus,
input[type="date"]:focus,
select:focus {
border-color: #007bff; /* Blue border on focus */
outline: none;
box-shadow: 0 0 8px rgba(0, 123, 255, 0.4); /* Subtle glow on focus */
}
/* Buttons */
.btn {
background-color: #007bff; /* Modern blue color */
border-radius: 5px;
color: #fff;
font-size: 16px;
font-weight: bold;
padding: 10px 20px;
border: none;
cursor: pointer;
transition: all 0.3s ease;
}
.btn:hover {
background-color: #0056b3; /* Darker blue on hover */
}
.btn-sm {
padding: 5px 10px;
font-size: 14px;
}
/* Table Styles */
.table {
width: 100%;
margin-bottom: 30px;
}
.table th,
.table td {
text-align: left;
padding: 12px 15px;
vertical-align: middle;
}
.table-striped tbody tr:nth-child(odd) {
background-color: #f9f9f9; /* Light gray rows */
}
.table-bordered {
border: 1px solid #ddd;
}
.table-hover tbody tr:hover {
background-color: #f1f1f1; /* Highlight row on hover */
}
/* Modal Styles */
.modal-content {
border-radius: 8px;
box-shadow: 0 4px 12px rgba(0, 0, 0, 0.1);
}
.modal-header {
background-color: #3A6A5D;
color: #fff;
font-size: 18px;
font-weight: bold;
border-radius: 8px 8px 0 0;
}
.modal-body {
padding: 20px;
}
.modal-footer {
background-color: #f4f7f6;
border-radius: 0 0 8px 8px;
padding: 15px;
}
/* Responsive Design */
@media (max-width: 768px) {
#title_container .container-fluid {
text-align: center;
}
.btn-group {
display: flex;
flex-direction: column;
align-items: center;
}
.btn-group a {
margin: 5px 0;
}
.user_name {
font-size: 18px;
}
.user_position,
.user_age,
.user_address {
font-size: 12px;
}
}
deleteitem.php:
<?php
session_start();
include ('connection/mysqli.php');
if (isset($_GET['id']))
{
$id=$_GET['id'];
$deleteQuery="DELETE FROM stock_ingredients WHERE Id=$id";
mysqli_query($mysqli, $deleteQuery);
echo "<script>window.location = 'add_stock.php';</script>";
} else {
echo "ERROR!";
}
?>
home.php:
<!DOCTYPE html>
<html lang="en" dir="ltr">
<head>
<title>Ingredients Stock Management System</title>
<meta charset="utf-8">
<link rel="stylesheet" href="vendor/bootstrap/css/bootstrap.min.css">
<link rel="stylesheet" href="css/style.css">
<link rel="stylesheet" href="vendor/font-awesome/css/font-awesome.min.css">
<script src="vendor/jquery-3.2.1.min.js" charset="utf-8"></script>
<script src="vendor/bootstrap/js/bootstrap.min.js" charset="utf-8"></script>
</head>
<body>
<?php include 'header.php'; ?>
<!-- Code ni para sa pag Change Password -->
<?php
if(isset($_POST['btnchangepassword'])){
$old_password = md5($_POST['old_password']);
$new_password = $_POST['new_password'];
$confirm_password = $_POST['confirm_password'];
if(DB::query('SELECT Password FROM account_registration WHERE Fullname=:Fullname AND Password=:Password', array(':Fullname'=>$getfullname, ':Password'=>$old_password))){
if($new_password == $confirm_password){
$new_password = md5($new_password);
DB::query('UPDATE account_registration SET Password=:Password WHERE Fullname=:Fullname', array(':Fullname'=>$getfullname,':Password'=>$new_password));
$success = "Your Password is Updated Successully!";
}
else{
$warning = "Your New Password did not match! Try again...";
}
}
else{
$warning = "Your Old Password did not match! Try again...";
}
}
?>
<div class="container" id="main_container">
<div class="container">
<?php
if(isset($success)){
echo '
<div class="row">
<div class="col-sm-12">
<div class="alert alert-success">
<strong>Success!</strong> '. $success .'
</div>
</div>
</div>
';
}
?>
<?php
if(isset($warning)){
echo '
<div class="row">
<div class="col-sm-12">
<div class="alert alert-warning">
<strong>Warning!</strong> '. $warning .'
</div>
</div>
</div>
';
}
?>
</div>
<div class="container">
<div class="row">
<div class="col-sm-4"></div>
<div class="col-sm-4">
<div class="panel panel-default">
<div class="panel-heading"><span class="fa fa-user"></span> Account Information</div>
<div class="panel-body">
<p class="user_name"><?php echo $getfullname; ?></p>
<p class="mean">Fullname</p>
<p class="user_position"><?php echo $getposition; ?></p>
<p class="mean">Position</p>
<p class="user_age"><?php echo $getage; ?> Years Old</p>
<p class="mean">Age</p>
<p class="user_address"><?php echo $getaddress; ?></p>
<p class="mean">Address</p>
</div>
</div>
</div>
<div class="col-sm-4"></div>
</div>
</div>
</div>
<!-- Change Password Modal -->
<div id="change" class="modal fade" role="dialog">
<div class="modal-dialog">
<!-- Modal content-->
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal">×</button>
<h4 class="modal-title"><span class="fa fa-gear"></span> Change Password</h4>
</div>
<div class="modal-body">
<?php
if(isset($warning)){
echo '
<div class="row">
<div class="col-sm-12">
<div class="alert alert-warning">
<strong>Warning!</strong> '. $warning .'
</div>
</div>
</div>
';
}
?>
<form class="form" action="home.php" method="POST">
<div class="row">
<div class="col-sm-12">
<div class="col-sm-12">
<div class="form-group">
<label for="old_password">Old Password</label>
<input class="form-control" type="password" name="old_password" id="old_password" required>
</div>
<div class="form-group">
<label for="new_password">New Password</label>
<input class="form-control" type="password" name="new_password" id="new_password" required>
</div>
<div class="form-group">
<label for="confirm_password">Confirm Password</label>
<input class="form-control" type="password" name="confirm_password" id="confirm_password" required>
</div>
<div class="form-group">
<input class="form-control btn btn-danger" type="submit" name="btnchangepassword" value="Change Password">
</div>
</div>
</div>
</div>
</form>
</div>
<div class="modal-footer">
<button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
</div>
</div>
</div>
</div>
</body>
</html>
index.php:
<!DOCTYPE html>
<?php include_once 'connection/db.php'; ?>
<html lang="en" dir="ltr">
<head>
<title>Ingredients Stock Management System</title>
<meta charset="utf-8">
<link rel="stylesheet" href="vendor/bootstrap/css/bootstrap.min.css">
<link rel="stylesheet" href="css/style.css">
<link rel="stylesheet" href="vendor/font-awesome/css/font-awesome.min.css">
<script src="vendor/jquery-3.2.1.min.js" charset="utf-8"></script>
<script src="vendor/bootstrap/js/bootstrap.min.js" charset="utf-8"></script>
</head>
<!-- Code ni para sa LOGIN -->
<?php
session_start();
if(isset($_POST['login'])){
$username = $_POST['username'];
$password = $_POST['password'];
$password = md5($_POST['password']);
if(DB::query('SELECT Username FROM account_registration WHERE Username=:Username', array(':Username'=>$username))){
if(DB::query('SELECT Password FROM account_registration WHERE Username=:Username AND Password=:Password', array(':Username'=>$username, ':Password'=>$password))){
$_SESSION['get_fullname'] = DB::query('SELECT Fullname FROM account_registration WHERE Username=:Username', array(':Username'=>$username))[0]['Fullname'];
$_SESSION['get_age'] = DB::query('SELECT Age FROM account_registration WHERE Username=:Username', array(':Username'=>$username))[0]['Age'];
$_SESSION['get_address'] = DB::query('SELECT Address FROM account_registration WHERE Username=:Username', array(':Username'=>$username))[0]['Address'];
$_SESSION['get_position'] = DB::query('SELECT Position FROM account_registration WHERE Username=:Username', array(':Username'=>$username))[0]['Position'];
// This is how we'll know the user is logged in
$_SESSION['logged_in'] = true;
header('Location:home.php');
}
else{
$alert = 'Your password is incorrect!';
}
}
else{
$alert = "Admin account doesn't exist!";
}
}
?>
<body>
<div class="container">
<div class="container" id="title_container">
<div class="container-fluid">
<h1 class="brand">Ingredients Stock Management System</h1>
</div>
<div class="btn -group">
<a class="btn btn-success" href="#" data-toggle="modal" data-target="#contact"><span class="fa fa-phone"></span> Contact Us</a>
<a class="btn btn-success" href="#" data-toggle="modal" data-target="#about"><span class="fa fa-info-circle"></span> About Us</a>
</div>
</div>
</div>
<div class="container" id="main_container">
<div class="container">
<div class="row">
<div class="col-sm-4"></div>
<div class="col-sm-4">
<div class="panel panel-default">
<div class="panel-heading"><span class="fa fa-lock"></span> Login</div>
<div class="panel-body">
<?php
if(isset($alert)){
echo '
<div class="row">
<div class="col-sm-12">
<div class="alert alert-danger">
<strong>Login Failed!</strong> '.$alert .'
</div>
</div>
</div>
';
}
?>
<form class="form" action="index.php" method="post">
<div class="form-group">
<label for="username">Username</label>
<input class="form-control" type="text" name="username" id="username" required>
</div>
<div class="form-group">
<label for="password">Password</label>
<input class="form-control" type="password" name="password" id="password" required>
</div>
<div class="form-group">
<button class="form-control btn btn-success" style="border-radius:0%;" type="submit" name="login">Login</button>
</div>
</form>
</div>
</div>
<div class="col-sm-4"></div>
</div>
</div>
</div>
</div>
<!-- Contact Us Modal -->
<div id="contact" class="modal fade" role="dialog">
<div class="modal-dialog">
<!-- Modal content-->
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal">×</button>
<h4 class="modal-title"><span class="fa fa-phone"></span> Contact Us</h4>
</div>
<div class="modal-body">
<p>Some text in the modal.</p>
</div>
<div class="modal-footer">
<button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
</div>
</div>
</div>
</div>
<!-- About Us Modal -->
<div id="about" class="modal fade" role="dialog">
<div class="modal-dialog">
<!-- Modal content-->
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal">×</button>
<h4 class="modal-title"><span class="fa fa-info-circle"></span> About Us</h4>
</div>
<div class="modal-body">
<p>Some text in the modal.</p>
</div>
<div class="modal-footer">
<button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
</div>
</div>
</div>
</div>
</body>
</html>
manage_categories.php
<?php include_once 'connection/db.php'; ?>
<!DOCTYPE html>
<html lang="en">
<head>
<title>Manage Categories</title>
<link rel="stylesheet" href="vendor/bootstrap/css/bootstrap.min.css">
<script src="vendor/jquery-3.2.1.min.js"></script>
<script src="vendor/bootstrap/js/bootstrap.min.js"></script>
</head>
<body>
<div class="container">
<h1 class="text-center">Manage Categories</h1>
<!-- Add Category Form -->
<form action="manage_categories.php" method="POST" class="mb-4">
<div class="form-group">
<label for="category_name">Category Name</label>
<input type="text" class="form-control" id="category_name" name="category_name" required>
</div>
<div class="form-group">
<label for="category_description">Category Description</label>
<textarea class="form-control" id="category_description" name="category_description"></textarea>
</div>
<button type="submit" name="add_category" class="btn btn-primary">Add Category</button>
</form>
<hr>
<!-- Category List -->
<h2>Existing Categories</h2>
<table class="table table-bordered">
<thead>
<tr>
<th>ID</th>
<th>Name</th>
<th>Description</th>
<th>Actions</th>
</tr>
</thead>
<tbody>
<?php
// Fetch all categories
$categories = DB::query('SELECT * FROM categories');
foreach ($categories as $category) {
echo "<tr>
<td>{$category['id']}</td>
<td>{$category['name']}</td>
<td>{$category['description']}</td>
<td>
<a href='edit_category.php?id={$category['id']}' class='btn btn-warning btn-sm'>Edit</a>
<a href='manage_categories.php?delete_id={$category['id']}' class='btn btn-danger btn-sm' onclick='return confirm(\"Are you sure?\")'>Delete</a>
</td>
</tr>";
}
?>
</tbody>
</table>
</div>
<?php
// Handle Add Category
if (isset($_POST['add_category'])) {
$name = $_POST['category_name'];
$description = $_POST['category_description'];
DB::query('INSERT INTO categories (name, description) VALUES (:name, :description)', [
':name' => $name,
':description' => $description
]);
header('Location: manage_categories.php');
}
// Handle Delete Category
if (isset($_GET['delete_id'])) {
$delete_id = $_GET['delete_id'];
DB::query('DELETE FROM categories WHERE id = :id', [':id' => $delete_id]);
header('Location: manage_categories.php');
}
?>
</body>
</html>
stock_manager.php
<!DOCTYPE html>
<html lang="en" dir="ltr">
<head>
<title>Ingredients Stock Management System | Add Stock</title>
<meta charset="utf-8">
<link rel="stylesheet" href="vendor/bootstrap/css/bootstrap.min.css">
<link rel="stylesheet" href="css/style.css">
<link rel="stylesheet" href="vendor/font-awesome/css/font-awesome.min.css">
<script src="vendor/jquery-3.2.1.min.js" charset="utf-8"></script>
<script src="vendor/bootstrap/js/bootstrap.min.js" charset="utf-8"></script>
</head>
<script>
function Generate(){
var quantity = document.getElementById('item_quantity').value;
var set = document.getElementById('how_much').value;
var sum = 0;
sum = (quantity - set);
document.getElementById('item_quantity').value = sum;
}
</script>
<body>
<?php include_once 'header.php'; ?>
<!-- Code ni para sa pag select ug Item -->
<?php
if(isset($_POST['select'])){
$txtSelect = $_POST['txtSelect'];
$getItemName = DB::query('SELECT ItemName FROM stock_ingredients WHERE ItemName=:ItemName', array(':ItemName'=>$txtSelect))[0]['ItemName'];
$getItemCategory = DB::query('SELECT Category FROM stock_ingredients WHERE ItemName=:ItemName', array(':ItemName'=>$txtSelect))[0]['Category'];
$getItemQuantity = DB::query('SELECT Quantity FROM stock_ingredients WHERE ItemName=:ItemName', array(':ItemName'=>$txtSelect))[0]['Quantity'];
}
?>
<?php
if(isset($_POST['btnchangepassword'])){
$old_password = md5($_POST['old_password']);
$new_password = $_POST['new_password'];
$confirm_password = $_POST['confirm_password'];
if(DB::query('SELECT Password FROM account_registration WHERE Fullname=:Fullname AND Password=:Password', array(':Fullname'=>$getfullname, ':Password'=>$old_password))){
if($new_password == $confirm_password){
$new_password = md5($new_password);
DB::query('UPDATE account_registration SET Password=:Password WHERE Fullname=:Fullname', array(':Fullname'=>$getfullname,':Password'=>$new_password));
$success = "Your Password is Updated Successully!";
}
else{
$warning = "Your New Password did not match! Try again...";
}
}
else{
$warning = "Your Old Password did not match! Try again...";
}
}
?>
<!-- Code ni para sa pag update ng Quantity kung pila na lang nahabilin -->
<?php
if(isset($_POST['setStock'])){
$item_name = $_POST['item_name'];
$item_quantity = $_POST['item_quantity'];
$how_much = $_POST['how_much'];
if($item_quantity < 0){
$warning = "Sorry 0 Quantity | Out of Stock for this Item...";
}
else{
DB::query('UPDATE stock_ingredients SET Quantity=:Quantity WHERE ItemName=:ItemName', array(':ItemName'=>$item_name, ':Quantity'=>$item_quantity));
$success = "Stock Manager Updated the Quantity of this Item...";
}
}
?>
<div class="container">
<div class="container-fluid">
<h3>Ingredients Stock Manager</h3>
</div>
</div>
<div class="container">
<?php
if(isset($success)){
echo '
<div class="row">
<div class="col-sm-12">
<div class="alert alert-success">
<strong>Success!</strong> '. $success .'
</div>
</div>
</div>
';
}
?>
<?php
if(isset($warning)){
echo '
<div class="row">
<div class="col-sm-12">
<div class="alert alert-warning">
<strong>Warning!</strong> '. $warning .'
</div>
</div>
</div>
';
}
?>
</div>
<div class="container">
<div class="row">
<div class="col-sm-4">
<div class="panel panel-default">
<div class="panel-heading"><span class="fa fa-area-chart"></span> Ingredients Stock Manager</div>
<div class="panel-body">
<div class="col-sm-15">
<form class="form-inline" action="stock_manager.php" method="POST">
<div class="form-group">
<label for="txt_search_category">Search Stock Category</label>
<select class="form-control" id="txt_search_category" name="txt_search_category" required>
<option value="">Please Select..</option>
<option value="Bread">Bread</option>
<option value="Meat">Meat</option>
<option value="Sea Food">Sea Food</option>
<option value="Patty">Patty</option>
<option value="Fruits">Fruits</option>
<option value="Vegetables">Vegetables</option>
<option value="DairyProducts">Dairy Products</option>
<option value="Others">Others</option>
</select>
</div>
<div class="form-group">
<button class="btn btn-primary" style="border-radius:0%;" type="submit" name="btn_search_category">Search</button>
</div>
</form>
</div>
</div>
</div>
</div>
<div class="col-sm-8">
<div class="panel panel-danger">
<div class="panel-heading"><span class="fa fa-globe"></span> Manage Section</div>
<div class="panel-body">
<form class="form" action="stock_manager.php" method="POST">
<div class="col-sm-4">
<div class="form-group">
<label for="item_name">Item Name</label>
<input class="form-control text-center" type="text" name="item_name" id="item_name" value="<?php if(isset($getItemName)){echo $getItemName;} ?>" readonly>
</div>
</div>
<div class="col-sm-4">
<div class="form-group">
<label for="item_quantity">Quantity</label>
<input class="form-control text-center" min="1" type="number" name="item_quantity" id="item_quantity" value="<?php if(isset($getItemQuantity)){echo $getItemQuantity;} ?>" readonly>
</div>
</div>
<div class="col-sm-4">
<div class="form-group">
<label for="how_much">How Much?</label>
<input class="form-control text-center" min="1" type="number" name="how_much" id="how_much" required>
</div>
</div>
<div class="col-sm-12 text-center">
<div class="form-group">
<button class="btn btn-success" style="border-radius:0%;" type="button" name="" onclick="Generate()">Generate</button>
<button class="btn btn-danger" style="border-radius:0%;" type="submit" name="setStock">Set Stock</button>
</div>
</div>
</form>
</div>
</div>
</div>
</div>
<div class="col-sm-15">
<div class="panel panel-danger" id="panel_table">
<div class="panel-heading"><span class="fa fa-desktop"></span> Items List</div>
<div class="panel-body">
<div class="table-responsive">
<table class="table table-striped table-hover table-bordered">
<thead>
<tr>
<th>Item Name</th>
<th>Item Category</th>
<th>Quantity</th>
<th>Date</th>
<th>Action</th>
</tr>
</thead>
<tbody>
<?php
if(isset($_POST['btn_search_category'])){
$txt_search_category = $_POST['txt_search_category'];
$posts_display = $mysqli->query("SELECT ItemName, Category, Quantity, Date FROM stock_ingredients WHERE Category='$txt_search_category' ORDER BY Id DESC");
while($posting = $posts_display->fetch_assoc()){
echo '
<form action="" method="POST">
<tr>
<td><input id="readonly" type="text" name="txtSelect" value='. $posting['ItemName'] .' readonly></td>
<td>'. $posting['Category'] .'</td>
<td>'. $posting['Quantity'] .'</td>
<td>'. $posting['Date'] .'</td>
<td><button class="btn btn-info" style="border-radius:0%;" type="submit" name="select">Select</button></td>
</tr>
</form>
';
}
}
?>
</tbody>
</table>
</div>
</div>
</div>
</div>
</div>
</body>
<!-- Change Password Modal -->
<div id="change" class="modal fade" role="dialog">
<div class="modal-dialog">
<!-- Modal content-->
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal">×</button>
<h4 class="modal-title"><span class="fa fa-gear"></span> Change Password</h4>
</div>
<div class="modal-body">
<?php
if(isset($warning)){
echo '
<div class="row">
<div class="col-sm-12">
<div class="alert alert-warning">
<strong>Warning!</strong> '. $warning .'
</div>
</div>
</div>
';
}
?>
<form class="form" action="home.php" method="POST">
<div class="row">
<div class="col-sm-12">
<div class="col-sm-12">
<div class="form-group">
<label for="old_password">Old Password</label>
<input class="form-control" type="password" name="old_password" id="old_password" required>
</div>
<div class="form-group">
<label for="new_password">New Password</label>
<input class="form-control" type="password" name="new_password" id="new_password" required>
</div>
<div class="form-group">
<label for="confirm_password">Confirm Password</label>
<input class="form-control" type="password" name="confirm_password" id="confirm_password" required>
</div>
<div class="form-group">
<input class="form-control btn btn-danger" type="submit" name="btnchangepassword" value="Change Password">
</div>
</div>
</div>
</div>
</form>
</div>
<div class="modal-footer">
<button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
</div>
</div>
</div>
</html>
Editor is loading...
Leave a Comment