Файловый менеджер

Файловый менеджер - Редактировать - /home/d46091/invoice.ecogenix.in/company.php

Назад
<?php require_once('includes/connection.php'); if ($_SERVER['REQUEST_METHOD'] == 'POST') { $c_name = $_POST['c_name']; $c_short = $_POST['c_short']; $c_address = $_POST['c_address']; $c_email = $_POST['c_email']; $c_mobile = $_POST['c_mobile']; $c_pincode = $_POST['c_pincode']; $c_gstin = $_POST['c_gstin']; $c_state = $_POST['c_state']; $c_inv = $_POST['c_inv']; $created_at = date('Y-m-d H:i:s'); $stmt = $conn->prepare("INSERT INTO `company_master` (`c_name`, `c_short`, `c_address`, `c_email`, `c_mobile`, `c_pincode`, `c_gstin`, `c_state`, `c_inv`, `created_at`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"); if ($stmt) { // Bind parameters: s = string, s = string, s = string $stmt->bind_param("ssssssssss", $c_name, $c_short, $c_address, $c_email, $c_mobile, $c_pincode, $c_gstin, $c_state, $c_inv, $created_at); // Execute the statement if ($stmt->execute()) { echo "<script> alert('Company added successfully!'); window.location.href = 'company.php'; </script>"; // Optionally redirect or clear form here } else { echo "Error executing query: " . $stmt->error; } $stmt->close(); } else { echo "Failed to prepare statement: " . $conn->error; } } require_once('includes/header.php'); ?> <!-- Content --> <div class="content"> <nav class="navbar navbar-expand-lg navbar-light bg-light mb-4"> <div class="container-fluid"> <button id="sidebarToggle" class="btn btn-outline-secondary d-md-none mr-auto"> <span class="navbar-toggler-icon"></span> </button> <a class="navbar-brand d-md-none" href="#">ECOGENIX</a> <div class="d-flex"> <!-- <input class="form-control me-2" type="search" placeholder="Search" aria-label="Search"> --> <!-- <button class="btn btn-outline-success" type="submit">Search</button> --> </div> </div> </nav> <div class="container-fluid"> <div class="row"> <div class="col-12"> <h2 class="mb-4">Company Dashboard</h2> </div> </div> <!-- <div class="row mb-4"> <div class="col-md-3 col-sm-6 mb-3"> <div class="card text-white bg-primary"> <div class="card-body"> <h5 class="card-title">Total Products</h5> <h3 class="card-text">-</h3> </div> </div> </div> <div class="col-md-3 col-sm-6 mb-3"> <div class="card text-white bg-success"> <div class="card-body"> <h5 class="card-title">Active Products</h5> <h3 class="card-text">-</h3> </div> </div> </div> <div class="col-md-3 col-sm-6 mb-3"> <div class="card text-white bg-warning"> <div class="card-body"> <h5 class="card-title">Low Stock</h5> <h3 class="card-text">-</h3> </div> </div> </div> <div class="col-md-3 col-sm-6 mb-3"> <div class="card text-white bg-danger"> <div class="card-body"> <h5 class="card-title">Out of Stock</h5> <h3 class="card-text">-</h3> </div> </div> </div> </div> --> <div class="row"> <div class="col-12"> <div class="card"> <div class="card-header d-flex justify-content-between align-items-center"> <span>Company's Inventory</span> <div> <!-- <button class="btn btn-sm btn-outline-primary">Export</button> --> <button class="btn btn-sm btn-primary" data-bs-toggle="modal" data-bs-target="#addItemModal">Add New</button> </div> </div> <div class="card-body"> <div class="table-responsive"> <table class="table table-striped table-hover"> <thead> <tr> <th>ID</th> <th>Name</th> <th>Short Code</th> <th>Address</th> <th>Email</th> <th>Mobile No.</th> <th>Pincode</th> <th>GSTIN</th> <th>State Type</th> <th>INV Head</th> <th>Actions</th> </tr> </thead> <tbody> <?php $query = "SELECT * FROM `company_master`"; $result = $conn->query($query); if ($result->num_rows > 0) { while ($row = $result->fetch_assoc()) { echo "<tr> <td>{$row['id']}</td> <td>{$row['c_name']}</td> <td>{$row['c_short']}</td> <td>{$row['c_address']}</td> <td>{$row['c_email']}</td> <td>{$row['c_mobile']}</td> <td>{$row['c_pincode']}</td> <td>{$row['c_gstin']}</td> <td>{$row['c_state']}</td> <td>{$row['c_inv']}</td> <td> <a href='company_edit.php?id={$row['id']}' class='btn btn-sm btn-warning'><i class='fa-solid fa-pen'></i></a> </td> </tr>"; } } else { echo '<tr><td colspan="7" class="text-center">No records found.</td></tr>'; } ?> </tbody> </table> </div> <!-- <nav> <ul class="pagination justify-content-center"> <li class="page-item disabled"> <a class="page-link" href="#" tabindex="-1">Previous</a> </li> <li class="page-item active"><a class="page-link" href="#">1</a></li> <li class="page-item"><a class="page-link" href="#">2</a></li> <li class="page-item"><a class="page-link" href="#">3</a></li> <li class="page-item"> <a class="page-link" href="#">Next</a> </li> </ul> </nav> --> </div> </div> </div> </div> </div> </div> <!-- Add Item Modal --> <div class="modal fade" id="addItemModal" tabindex="-1" aria-labelledby="addItemModalLabel" aria-hidden="true"> <div class="modal-dialog"> <div class="modal-content"> <form action="" method="POST"> <!-- Replace with your actual form handler --> <div class="modal-header"> <h5 class="modal-title" id="addItemModalLabel">Add New Company</h5> <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button> </div> <div class="modal-body"> <!-- Item Name --> <div class="mb-3"> <label for="c_name" class="form-label">Company Name</label> <input type="text" class="form-control" id="c_name" name="c_name" required> </div> <!-- Item Name --> <div class="mb-3"> <label for="c_short" class="form-label">Short Code</label> <input type="text" class="form-control" id="c_short" name="c_short" required> </div> <!-- Unit --> <div class="mb-3"> <label for="c_address" class="form-label">Address</label> <textarea type="text" class="form-control" id="c_address" name="c_address" required></textarea> </div> <!-- Description --> <div class="mb-3"> <label for="c_email" class="form-label">Email</label> <input type="text" class="form-control" id="c_email" name="c_email"> </div> <!-- Description --> <div class="mb-3"> <label for="c_mobile" class="form-label">Mobile No.</label> <input type="text" class="form-control only-number" minlength="10" maxlength="10" id="c_mobile" name="c_mobile"> </div> <div class="mb-3"> <label for="c_pincode" class="form-label">Pincode</label> <input type="text" class="form-control only-number" minlength="6" maxlength="6" id="c_pincode" name="c_pincode"> </div> <div class="mb-3"> <label for="c_gstin" class="form-label">GSTIN</label> <input type="text" class="form-control" id="c_gstin" name="c_gstin"> </div> <div class="mb-3"> <label for="c_state" class="form-label">State Type</label> <select type="text" class="form-select" id="c_state" name="c_state"> <option value="" selected disabled>--Select Type--</option> <option value="Intrastate">Intrastate </option> <option value="Outerstate">Outerstate</option> </select> </div> <div class="mb-3"> <label for="c_inv" class="form-label">INVOICE Short Format (ABC)</label> <input type="text" class="form-control" id="c_inv" name="c_inv"> </div> </div> <div class="modal-footer"> <button type="submit" class="btn btn-success">Save Item</button> <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Cancel</button> </div> </form> </div> </div> </div> <?php require_once('includes/footer.php'); ?>

| ver. 1.4 | Github | . | PHP 8.1.32 | Генерация страницы: 0 | proxy | phpinfo | Настройка