Untitled
unknown
plain_text
5 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