Create Services Table"; try { $database = new Database(); $conn = $database->getConnection(); // Create services table $sql = "CREATE TABLE IF NOT EXISTS services ( id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(255) NOT NULL, description TEXT, price DECIMAL(10,2) NOT NULL, discount_percentage DECIMAL(5,2) DEFAULT 0, duration INT DEFAULT 60 COMMENT 'Duration in minutes', category VARCHAR(50) DEFAULT 'skin_care', image VARCHAR(255) NULL, additional_images TEXT NULL, variations TEXT NULL, available_branches TEXT NULL, is_limited_stock TINYINT(1) DEFAULT 0, is_free_shipping TINYINT(1) DEFAULT 1, is_medicinal TINYINT(1) DEFAULT 0, medicinal_leaflet TEXT NULL, usage_instructions TEXT NULL, stock_quantity INT DEFAULT 0, is_active TINYINT(1) DEFAULT 1, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci"; $conn->exec($sql); echo "

✓ Services table created successfully!

"; // Check if table has data $stmt = $conn->query("SELECT COUNT(*) FROM services"); $count = $stmt->fetchColumn(); if ($count == 0) { echo "

Adding sample services...

"; // Insert sample services $services = [ [ 'name' => 'تنظيف البشرة العميق', 'description' => 'جلسة تنظيف عميق للبشرة تزيل الشوائب والرؤوس السوداء وتنقي المسام', 'price' => 250, 'discount_percentage' => 20, 'duration' => 60, 'category' => 'skin_care' ], [ 'name' => 'المساج والاسترخاء', 'description' => 'جلسات مساج علاجية تساعد على الاسترخاء والتخلص من التوتر والإرهاق اليومي', 'price' => 300, 'discount_percentage' => 15, 'duration' => 45, 'category' => 'massage' ], [ 'name' => 'صبغة الشعر', 'description' => 'صبغة شعر احترافية بأحدث الألوان والتقنيات مع حماية كاملة للشعر', 'price' => 400, 'discount_percentage' => 0, 'duration' => 120, 'category' => 'hair_care' ], [ 'name' => 'مكياج سهرة', 'description' => 'مكياج احترافي للمناسبات والسهرات بأحدث صيحات الموضة', 'price' => 350, 'discount_percentage' => 10, 'duration' => 90, 'category' => 'makeup' ], [ 'name' => 'ماسك الوجه المغذي', 'description' => 'ماسك طبيعي يغذي البشرة ويعيد لها نضارتها وحيويتها', 'price' => 180, 'discount_percentage' => 0, 'duration' => 45, 'category' => 'skin_care' ], [ 'name' => 'باديكير وماني كير', 'description' => 'عناية كاملة بالأظافر والقدمين مع تلميع وتزيين احترافي', 'price' => 150, 'discount_percentage' => 25, 'duration' => 60, 'category' => 'nails' ], [ 'name' => 'علاج الشعر بالكيراتين', 'description' => 'علاج متقدم للشعر بالكيراتين لفرد وتنعيم الشعر وإعطائه لمعان طبيعي', 'price' => 800, 'discount_percentage' => 15, 'duration' => 180, 'category' => 'hair_care' ], [ 'name' => 'تقشير البشرة الكيميائي', 'description' => 'تقشير كيميائي لطيف يزيل خلايا الجلد الميتة ويجدد البشرة', 'price' => 450, 'discount_percentage' => 0, 'duration' => 75, 'category' => 'skin_care' ] ]; $stmt = $conn->prepare(" INSERT INTO services (name, description, price, discount_percentage, duration, category, is_active) VALUES (?, ?, ?, ?, ?, ?, 1) "); foreach ($services as $service) { $stmt->execute([ $service['name'], $service['description'], $service['price'], $service['discount_percentage'], $service['duration'], $service['category'] ]); echo "

✓ Added: " . htmlspecialchars($service['name']) . "

"; } echo "

✓ Sample services added successfully!

"; } else { echo "

ℹ Table already has $count services

"; } // Show all services echo "

Current Services:

"; $stmt = $conn->query("SELECT id, name, price, discount_percentage, category, is_active FROM services ORDER BY id"); $all_services = $stmt->fetchAll(PDO::FETCH_ASSOC); echo ""; echo ""; foreach ($all_services as $s) { echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "
IDNamePriceDiscountCategoryActive
" . $s['id'] . "" . htmlspecialchars($s['name']) . "" . number_format($s['price'], 2) . " ج.م" . $s['discount_percentage'] . "%" . $s['category'] . "" . ($s['is_active'] ? '✓' : '✗') . "
"; echo "
"; echo "

→ View Services Page

"; } catch (Exception $e) { echo "

❌ ERROR: " . $e->getMessage() . "

"; } ?>