prepare("UPDATE vendors SET name=?, whatsapp_number=?, email=?, notes=?, is_active=? WHERE id=?");
$stmt->execute([$name, $phone, $email, $notes, $active, $_POST['vendor_id']]);
$msg = "Vendor updated!"; $msgClass = "success";
} else {
// INSERT
$stmt = $pdo->prepare("INSERT INTO vendors (name, whatsapp_number, email, notes, is_active) VALUES (?, ?, ?, ?, ?)");
$stmt->execute([$name, $phone, $email, $notes, $active]);
$msg = "Vendor added!"; $msgClass = "success";
}
}
// 2. DELETE VENDOR
if (isset($_GET['delete'])) {
$pdo->prepare("DELETE FROM vendors WHERE id=?")->execute([$_GET['delete']]);
header("Location: vendors.php?msg=deleted"); exit();
}
// 3. FETCH DATA
$edit_vendor = null;
if (isset($_GET['edit'])) {
$edit_vendor = $pdo->query("SELECT * FROM vendors WHERE id=" . $_GET['edit'])->fetch();
}
$vendors = $pdo->query("SELECT * FROM vendors ORDER BY id DESC")->fetchAll();
?>
Manage Vendors
Vendor Management
Vendor List
| Name | WhatsApp | Notes | Status | Action |
|---|
|
|
|
Active' : 'Inactive'; ?> |
Edit |
Delete
|