D7net
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
home3
/
encodto1
/
inventory.tapaslights.com
/
Filename :
add_category.php
back
Copy
<?php require 'config.php'; // Database connection file // Initialize variables for messages $success_message = ''; $error_message = ''; // Handle form submission if ($_SERVER['REQUEST_METHOD'] === 'POST') { $category_name = mysqli_real_escape_string($conn, $_POST['category_name']); $category_description = mysqli_real_escape_string($conn, $_POST['category_description']); // Validate form fields if (empty($category_name)) { $error_message = "Category name is required."; } else { // Insert category into database with current timestamp $query = "INSERT INTO categories (category_name, category_description, created_at) VALUES ('$category_name', '$category_description', NOW())"; if (mysqli_query($conn, $query)) { // Redirect on success header("Location: my_categories.php"); exit; } else { $error_message = "Error: " . mysqli_error($conn); } } } ?> <!DOCTYPE html> <html lang="en" data-layout="vertical" data-topbar="light" data-sidebar="light" data-sidebar-size="lg" data-sidebar-image="none"> <head> <?php include 'style.php'; ?> </head> <body> <!-- Main Wrapper --> <div class="main-wrapper"> <!-- Header --> <?php include 'header.php'; ?> <!-- /Header --> <!-- Sidebar --> <?php include 'sidebar.php'; ?> <!-- /Sidebar --> <!-- Page Wrapper --> <div class="page-wrapper"> <div class="content container-fluid"> <div class="row"> <div class="col-lg-12"> <div class="card"> <div class="card-header"> <h5 class="card-title">Create Category</h5> <?php if (!empty($success_message)): ?> <p class="message success"><?php echo $success_message; ?></p> <?php elseif (!empty($error_message)): ?> <p class="message error text-danger"><?php echo $error_message; ?></p> <?php endif; ?> </div> <div class="card-body"> <form action="" method="POST"> <div class="input-block mb-3 row"> <label class="col-form-label col-md-2">Category Name</label> <div class="col-md-10"> <input type="text" name="category_name" id="category_name" class="form-control" placeholder="Enter Category Name" required> </div> </div> <div class="input-block mb-3 row"> <label class="col-form-label col-md-2">Category Description</label> <div class="col-md-10"> <textarea rows="5" name="category_description" id="category_description" class="form-control" placeholder="Enter Category Description" required></textarea> </div> </div> <div class="input-block mb-3 mb-0 row"> <div class="col-md-10 offset-md-2"> <div class="input-group mb-3 d-flex justify-content-end"> <button class="btn btn-success m-2" type="submit">Add Category</button> <button class="btn btn-danger m-2" type="reset">Reset</button> </div> </div> </div> </form> </div> </div> </div> </div> </div> </div> <!-- /Page Wrapper --> </div> <!-- /Main Wrapper --> <?php include 'footer.php'; ?> </body> </html>