'; // print_r($_POST); // die(); $cus_name = $_POST['cus_name']; $cus_address = $_POST['cus_address']; $cus_destination = $_POST['cus_destination']; $cus_state = $_POST['cus_state']; $created_at = date('Y-m-d H:i:s'); $stmt = $conn->prepare("INSERT INTO `customer_master` (`cus_name`, `cus_address`, `cus_destination`, `cus_state`, `created_at`) VALUES (?, ?, ?, ?, ?)"); if ($stmt) { // Bind parameters: s = string, s = string, s = string $stmt->bind_param("sssss", $cus_name, $cus_address, $cus_destination, $cus_state, $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'); ?>

Customer Dashboard

Customer'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 Customer Name Customer Address Destination State Type Actions
{$row['id']} {$row['cus_name']} {$row['cus_address']} {$row['cus_destination']} {$row['cus_state']}
No records found.