'; // print_r($_POST); // die(); $company_name = $_POST['company_name']; $company_address = $_POST['company_address']; $status = $_POST['status']; $created_at = date('Y-m-d H:i:s'); $stmt = $conn->prepare("INSERT INTO `vendor_master` (`company_name`, `company_address`, `status`, `created_at`) VALUES (?, ?, ?, ?)"); if ($stmt) { // Bind parameters: s = string, s = string, s = string $stmt->bind_param("ssss", $company_name, $company_address, $status, $created_at); // Execute the statement if ($stmt->execute()) { echo ""; // 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'); ?>

Vendor Dashboard

Vendor's Inventory
query($query); if ($result->num_rows > 0) { while ($row = $result->fetch_assoc()) { // Determine status label and badge class if ($row['status'] == 1) { $statusLabel = 'Active'; $badgeClass = 'bg-success'; } else { $statusLabel = 'Deactive'; $badgeClass = 'bg-danger'; } echo ""; } } else { echo ''; } ?>
ID Name Address Status Actions
{$row['id']} {$row['company_name']} {$row['company_address']} {$statusLabel}
No records found.