prepare("SELECT `company_name`, `company_address`, `status` FROM `vendor_master` WHERE `id` = ?"); $stmt->bind_param("i", $vendor_id); $stmt->execute(); $result = $stmt->get_result(); if ($result->num_rows === 1) { $row = $result->fetch_assoc(); $company_name = $row['company_name']; $company_address = $row['company_address']; $status = $row['status']; } else { echo ""; exit; } $stmt->close(); // Handle form submission if ($_SERVER['REQUEST_METHOD'] == 'POST') { $updated_company_name = $_POST['company_name']; $updated_company_address = $_POST['company_address']; $updated_status = $_POST['status']; $updated_at = date('Y-m-d H:i:s'); $stmt = $conn->prepare("UPDATE vendor_master SET company_name = ?, company_address = ?, status = ?, updated_at = ? WHERE id = ?"); $stmt->bind_param("ssssi", $updated_company_name, $updated_company_address, $updated_status, $updated_at, $vendor_id); if ($stmt->execute()) { echo ""; } else { echo "Error updating vendor: " . $stmt->error; } $stmt->close(); } require_once('includes/header.php'); ?>

Edit Vendor