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

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

Назад
<?php require_once('includes/connection.php'); if (!isset($_GET['id']) \|\| empty($_GET['id'])) { echo "Invalid item ID."; exit; } $id = intval($_GET['id']); // Handle form submission if ($_SERVER['REQUEST_METHOD'] == 'POST') { $company_name = $_POST['company_name']; $customer_name = $_POST['customer_name']; $po_no = $_POST['po_no']; $po_date = $_POST['po_date']; $rate = $_POST['rate']; $updated_at = date('Y-m-d H:i:s'); // Note the comma after `rate = ?` $stmt = $conn->prepare("UPDATE `purchase_order_master` SET `company_name` = ?, `customer_name` = ?, `po_no` = ?, `po_date` = ?, `rate` = ?, `updated_at` = ? WHERE `id` = ? "); if ($stmt) { $stmt->bind_param( "ssssssi", $company_name, $customer_name, $po_no, $po_date, $rate, $updated_at, $id ); if ($stmt->execute()) { echo "<script> alert('Order updated successfully!'); window.location.href = 'purchase_order.php'; </script>"; } else { echo "Error updating record: " . $stmt->error; } $stmt->close(); } else { echo "Failed to prepare statement: " . $conn->error; } exit; } // Fetch existing data $stmt = $conn->prepare("SELECT * FROM `purchase_order_master` WHERE `id` = ?"); $stmt->bind_param("i", $id); $stmt->execute(); $result = $stmt->get_result(); if ($result->num_rows === 0) { echo "Item not found."; exit; } $item = $result->fetch_assoc(); $stmt->close(); require_once('includes/header.php'); ?> <div class="content"> <div class="container mt-4"> <h2>Edit Purchase Order Details</h2> <form method="POST"> <div class="mb-3"> <label for="company_name" class="form-label">Company Name</label> <select class="form-control" id="company_name" name="company_name" required> <option value="" selected disabled>--Select Company Name--</option> <?php $selected_company = $item['company_name'] ?? ''; $vendor_query = "SELECT `id`, `c_name` FROM `company_master`"; $result = $conn->query($vendor_query); if ($result && $result->num_rows > 0) { while ($row = $result->fetch_assoc()) { $c_name = htmlspecialchars($row['c_name']); $selected = ($c_name === $selected_company) ? 'selected' : ''; echo "<option value='$c_name' $selected>$c_name</option>"; } } ?> </select> </div> <div class="mb-3"> <label for="customer_name" class="form-label">Customer Name</label> <select class="form-control" id="customer_name" name="customer_name" required> <option value="" selected disabled>--Select Customer Name--</option> <?php $selected_customer = $item['customer_name'] ?? ''; $vendor_query = "SELECT `id`, `cus_name` FROM `customer_master`"; $result = $conn->query($vendor_query); if ($result && $result->num_rows > 0) { while ($row = $result->fetch_assoc()) { $cus_name = htmlspecialchars($row['cus_name']); $selected = ($cus_name === $selected_customer) ? 'selected' : ''; echo "<option value='$cus_name' $selected>$cus_name</option>"; } } ?> </select> </div> <div class="mb-3"> <label for="po_no" class="form-label">Purchase Order No.</label> <input type="text" class="form-control" id="po_no" name="po_no" value="<?php echo htmlspecialchars($item['po_no']); ?>" required> </div> <div class="mb-3"> <label for="po_date" class="form-label">Purchase Order Date</label> <input type="date" class="form-control" id="po_date" name="po_date" value="<?php echo htmlspecialchars($item['po_date']); ?>" required> </div> <div class="mb-3"> <label for="rate" class="form-label">Rate</label> <input type="text" class="form-control" id="rate" name="rate" value="<?php echo htmlspecialchars($item['rate']); ?>" required> </div> <button type="submit" class="btn btn-primary">Update Company</button> <a href="purchase_order.php" class="btn btn-secondary">Cancel</a> </form> </div> </div> <?php require_once('includes/footer.php'); ?>

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