prepare("INSERT INTO rental_categories (name, slug, description) VALUES (?,?,?)"); $stmt->bind_param("sss",$name,$slug,$desc); }
else { $id = intval($_POST['id']); $stmt = $conn->prepare("UPDATE rental_categories SET name=?, slug=?, description=? WHERE id=?"); $stmt->bind_param("sssi",$name,$slug,$desc,$id); }
$stmt->execute();
} elseif ($action == 'add_item' || $action == 'edit_item') {
$cat = intval($_POST['category_id']); $name = cleanInput($_POST['name']); $slug = cleanInput($_POST['slug']);
$desc = cleanInput($_POST['description']); $price = floatval($_POST['price']); $qty = intval($_POST['quantity']); $avail = intval($_POST['available_quantity']);
$features = cleanInput($_POST['features']); $image = '';
if (!empty($_FILES['image']['name'])) {
$upload = uploadFile($_FILES['image'], __DIR__ . '/../uploads/packages/');
if ($upload) $image = 'uploads/packages/'.$upload;
}
if ($action == 'add_item') {
$stmt = $conn->prepare("INSERT INTO rental_items (category_id, name, slug, description, price, quantity, available_quantity, features, image) VALUES (?,?,?,?,?,?,?,?,?)");
$stmt->bind_param("isssdiiss", $cat, $name, $slug, $desc, $price, $qty, $avail, $features, $image);
} else {
$id = intval($_POST['id']);
if ($image) { $stmt = $conn->prepare("UPDATE rental_items SET category_id=?, name=?, slug=?, description=?, price=?, quantity=?, available_quantity=?, features=?, image=? WHERE id=?"); $stmt->bind_param("isssdiissi", $cat, $name, $slug, $desc, $price, $qty, $avail, $features, $image, $id); }
else { $stmt = $conn->prepare("UPDATE rental_items SET category_id=?, name=?, slug=?, description=?, price=?, quantity=?, available_quantity=?, features=? WHERE id=?"); $stmt->bind_param("isssdiisi", $cat, $name, $slug, $desc, $price, $qty, $avail, $features, $id); }
}
$stmt->execute();
} elseif ($action == 'delete_cat') { $conn->query("DELETE FROM rental_categories WHERE id=" . intval($_POST['id'])); }
elseif ($action == 'delete_item') { $conn->query("DELETE FROM rental_items WHERE id=" . intval($_POST['id'])); }
$msg = 'Saved!
';
}
$rentalCats = getRentalCategories();
$rentalItems = getRentalItems();
$inquiries = $conn->query("SELECT * FROM rental_inquiries ORDER BY created_at DESC")->fetch_all(MYSQLI_ASSOC);
?>
Rental Management
Items
| ID | Name | Category | Price | Qty | Avail | Action |
|---|
| | | | | |
|
| ID | Name | Email | Phone | Items | Date | Status | Action |
|---|
| | | |
... | | |
|