getConnection();
$message = '';
// Handle actions
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
if (isset($_POST['add_service'])) {
$query = "INSERT INTO beauty_services (name, description, price, duration, category, is_active) VALUES (?, ?, ?, ?, ?, 1)";
$stmt = $db->prepare($query);
$stmt->execute([$_POST['name'], $_POST['description'], $_POST['price'], $_POST['duration'], $_POST['category']]);
$message = 'تم إضافة الخدمة بنجاح!';
} elseif (isset($_POST['delete_service'])) {
$query = "DELETE FROM beauty_services WHERE id = ?";
$stmt = $db->prepare($query);
$stmt->execute([$_POST['service_id']]);
$message = 'تم حذف الخدمة بنجاح!';
} elseif (isset($_POST['update_service'])) {
$query = "UPDATE beauty_services SET name = ?, description = ?, price = ?, duration = ?, category = ? WHERE id = ?";
$stmt = $db->prepare($query);
$stmt->execute([$_POST['name'], $_POST['description'], $_POST['price'], $_POST['duration'], $_POST['category'], $_POST['service_id']]);
$message = 'تم تحديث الخدمة بنجاح!';
}
}
$stmt = $db->prepare("SELECT * FROM beauty_services WHERE is_active = 1 ORDER BY id DESC");
$stmt->execute();
$services = $stmt->fetchAll(PDO::FETCH_ASSOC);
?>
خدمات البيوتي
💆♀️
ج.م
⏱️ دقيقة | 🏷️