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

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

Назад
<?php // transportar_edit.php require_once('includes/connection.php'); // 1) Get the broker ID from the query string if (!isset($_GET['id']) \|\| !is_numeric($_GET['id'])) { header('Location: transporter.php'); exit; } $broker_id = (int)$_GET['id']; // 2) Fetch existing data (join broker_master ↔ vehicle_master) $sql = "SELECT b.transporter_name, b.status AS broker_status, v.id AS vehicle_id, v.vehicle_no, v.vehicle_model, v.vehicle_capacity, v.vehicle_insurance_validy, v.status AS vehicle_status FROM broker_master b JOIN vehicle_master v ON v.id = b.vehicle_id WHERE b.id = ? "; $stmt = $conn->prepare($sql); $stmt->bind_param("i", $broker_id); $stmt->execute(); $res = $stmt->get_result(); if ($res->num_rows !== 1) { echo "<script> alert('Record not found.'); window.location.href = 'transporter.php'; </script>"; exit; } $row = $res->fetch_assoc(); $stmt->close(); // 3) If form submitted, process updates if ($_SERVER['REQUEST_METHOD'] === 'POST') { // Read POSTed values $transporter_name = $_POST['transporter_name']; $vehicle_no = $_POST['vehicle_no']; $vehicle_model = $_POST['vehicle_model']; $vehicle_capacity = $_POST['vehicle_capacity']; $vehicle_insurance_validy = $_POST['vehicle_insurance_validy']; $vehicle_status = $_POST['vehicle_status']; $broker_status = $_POST['broker_status']; $updated_at = date('Y-m-d H:i:s'); // a) Update vehicle_master $upd1 = $conn->prepare(" UPDATE vehicle_master SET vehicle_no = ?, vehicle_model = ?, vehicle_capacity = ?, vehicle_insurance_validy = ?, status = ?, updated_at = ? WHERE id = ? "); $upd1->bind_param( "ssssssi", $vehicle_no, $vehicle_model, $vehicle_capacity, $vehicle_insurance_validy, $vehicle_status, $updated_at, $row['vehicle_id'] ); $ok1 = $upd1->execute(); $upd1->close(); // b) Update broker_master $upd2 = $conn->prepare(" UPDATE broker_master SET transporter_name = ?, status = ?, updated_at = ? WHERE id = ? "); $upd2->bind_param( "sisi", $transporter_name, $broker_status, $updated_at, $broker_id ); $ok2 = $upd2->execute(); $upd2->close(); if ($ok1 && $ok2) { echo "<script> alert('Transporter updated successfully!'); window.location.href = 'transporter.php'; </script>"; exit; } else { $error = $conn->error; } } // 4) Show form require_once('includes/header.php'); ?> <div class="content mt-4"> <h2>Edit Transporter</h2> <?php if (!empty($error)): ?> <div class="alert alert-danger"><?php echo htmlspecialchars($error); ?></div> <?php endif; ?> <form method="POST"> <div class="row g-3"> <!-- Transporter Name --> <div class="col-md-6"> <label for="transporter_name" class="form-label">Transporter Name</label> <input type="text" id="transporter_name" name="transporter_name" class="form-control" required value="<?php echo htmlspecialchars($row['transporter_name']); ?>"> </div> <!-- Vehicle No --> <div class="col-md-6"> <label for="vehicle_no" class="form-label">Vehicle Number</label> <input type="text" id="vehicle_no" name="vehicle_no" class="form-control" required value="<?php echo htmlspecialchars($row['vehicle_no']); ?>"> </div> <!-- Vehicle Model --> <div class="col-md-6"> <label for="vehicle_model" class="form-label">Vehicle Model</label> <input type="text" id="vehicle_model" name="vehicle_model" class="form-control" required value="<?php echo htmlspecialchars($row['vehicle_model']); ?>"> </div> <!-- Vehicle Capacity --> <div class="col-md-6"> <label for="vehicle_capacity" class="form-label">Vehicle Capacity</label> <input type="text" id="vehicle_capacity" name="vehicle_capacity" class="form-control" required value="<?php echo htmlspecialchars($row['vehicle_capacity']); ?>"> </div> <!-- Insurance Validity --> <div class="col-md-6"> <label for="vehicle_insurance_validy" class="form-label">Insurance Validity</label> <input type="date" id="vehicle_insurance_validy" name="vehicle_insurance_validy" class="form-control" required value="<?php echo htmlspecialchars($row['vehicle_insurance_validy']); ?>"> </div> <!-- Vehicle Status --> <div class="col-md-6"> <label for="vehicle_status" class="form-label">Vehicle Status</label> <select id="vehicle_status" name="vehicle_status" class="form-select" required> <option value="1" <?php if ($row['vehicle_status'] == 1) echo 'selected'; ?>>Active</option> <option value="0" <?php if ($row['vehicle_status'] == 0) echo 'selected'; ?>>Deactive</option> </select> </div> <!-- Broker Status --> <div class="col-md-6"> <label for="broker_status" class="form-label">Transporter Status</label> <select id="broker_status" name="broker_status" class="form-select" required> <option value="1" <?php if ($row['broker_status'] == 1) echo 'selected'; ?>>Active</option> <option value="0" <?php if ($row['broker_status'] == 0) echo 'selected'; ?>>Deactive</option> </select> </div> <!-- Submit --> <div class="col-12 mt-3"> <button type="submit" class="btn btn-primary">Update Transporter</button> <a href="transporter.php" class="btn btn-secondary ms-2">Cancel</a> </div> </div> </form> </div> <?php require_once('includes/footer.php'); ?>

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