Файловый менеджер - Редактировать - /home/d46091/invoice.ecogenix.in/driver.php
Назад
<?php require_once('includes/connection.php'); if ($_SERVER['REQUEST_METHOD'] == 'POST') { // echo '<pre>'; // print_r($_POST); // die(); $driver_name = $_POST['driver_name']; $mobile_no = $_POST['mobile_no']; $aadhar_no = $_POST['aadhar_no']; $pan_no = $_POST['pan_no']; $dl_no = $_POST['dl_no']; $dl_exp_date = $_POST['dl_exp_date']; $created_at = date('Y-m-d H:i:s'); $stmt = $conn->prepare("INSERT INTO `driver_master` (`driver_name`, `mobile_no`, `aadhar_no`, `pan_no`, `dl_no`, `dl_exp_date`, `created_at`) VALUES (?, ?, ?, ?, ?, ?, ?)"); if ($stmt) { // Bind parameters: s = string, s = string, s = string $stmt->bind_param("sssssss", $driver_name, $mobile_no, $aadhar_no, $pan_no, $dl_no, $dl_exp_date, $created_at); // Execute the statement if ($stmt->execute()) { echo "<script> alert('Driver added successfully!'); window.location.href = 'driver.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'); ?> <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">Driver Dashboard</h2> </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>Driver'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="#addVendorModal">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>Aadhar No.</th> <th>PAN No.</th> <th>DL No.</th> <th>DL EXP Date</th> <th>Action</th> </tr> </thead> <tbody> <?php $query = "SELECT * FROM `driver_master`"; $result = $conn->query($query); if ($result->num_rows > 0) { while ($row = $result->fetch_assoc()) { echo "<tr> <td>{$row['id']}</td> <td>{$row['driver_name']}</td> <td>{$row['aadhar_no']}</td> <td>{$row['pan_no']}</td> <td>{$row['dl_no']}</td> <td>{$row['dl_exp_date']}</td> <td> <a href='driver_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="addVendorModal" tabindex="-1" aria-labelledby="addVendorModalLabel" 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="addVendorModalLabel">Add Driver Details</h5> <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button> </div> <div class="modal-body"> <!-- Company Name --> <div class="mb-3"> <label for="driver_name" class="form-label">Name</label> <input type="text" class="form-control" id="driver_name" name="driver_name" required> </div> <div class="mb-3"> <label for="mobile_no" class="form-label">Mobile No.</label> <input type="text" class="form-control only-number" id="mobile_no" name="mobile_no" minlength="10" maxlength="10" required> </div> <div class="mb-3"> <label for="aadhar_no" class="form-label">Aadhar No.</label> <input type="text" class="form-control only-number" id="aadhar_no" name="aadhar_no" required> </div> <div class="mb-3"> <label for="pan_no" class="form-label">PAN No.</label> <input type="text" class="form-control" id="pan_no" name="pan_no" required> </div> <div class="mb-3"> <label for="dl_no" class="form-label">DL No.</label> <input type="text" class="form-control" id="dl_no" name="dl_no" required> </div> <div class="mb-3"> <label for="dl_exp_date" class="form-label">DL Expiry Date.</label> <input type="date" class="form-control" id="dl_exp_date" name="dl_exp_date" required> </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
|
Настройка