getConnection(); $message = ''; $message_type = 'success'; // Get categories try { $query = "SELECT * FROM categories WHERE type = 'product' ORDER BY name"; $stmt = $db->prepare($query); $stmt->execute(); $categories = $stmt->fetchAll(PDO::FETCH_ASSOC); } catch (Exception $e) { $categories = []; } // Handle form submission if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['add_product'])) { try { $name = $_POST['name']; $description = $_POST['description'] ?? ''; $price = $_POST['price']; $discount_price = !empty($_POST['discount_price']) ? $_POST['discount_price'] : null; $category_id = !empty($_POST['category_id']) ? $_POST['category_id'] : null; $stock_quantity = $_POST['stock_quantity'] ?? 0; $status = $_POST['status'] ?? 'active'; $sku = !empty($_POST['sku']) ? $_POST['sku'] : null; // New fields $size = $_POST['size'] ?? null; $certification = $_POST['certification'] ?? null; $short_description = $_POST['short_description'] ?? null; $detailed_description = $_POST['detailed_description'] ?? null; $how_to_use = $_POST['how_to_use'] ?? null; $additional_tips = $_POST['additional_tips'] ?? null; // Handle main image upload $image = null; if (isset($_FILES['image']) && $_FILES['image']['error'] === UPLOAD_ERR_OK) { $upload_dir = '../../uploads/products/'; if (!file_exists($upload_dir)) { mkdir($upload_dir, 0777, true); } $file_extension = pathinfo($_FILES['image']['name'], PATHINFO_EXTENSION); $new_filename = uniqid() . '.' . $file_extension; $upload_path = $upload_dir . $new_filename; if (move_uploaded_file($_FILES['image']['tmp_name'], $upload_path)) { $image = 'uploads/products/' . $new_filename; } } // Handle gallery images upload $gallery_images = []; if (isset($_FILES['gallery_images'])) { $upload_dir = '../../uploads/products/'; foreach ($_FILES['gallery_images']['tmp_name'] as $key => $tmp_name) { if ($_FILES['gallery_images']['error'][$key] === UPLOAD_ERR_OK) { $file_extension = pathinfo($_FILES['gallery_images']['name'][$key], PATHINFO_EXTENSION); $new_filename = uniqid() . '.' . $file_extension; $upload_path = $upload_dir . $new_filename; if (move_uploaded_file($tmp_name, $upload_path)) { $gallery_images[] = 'uploads/products/' . $new_filename; } } } } $gallery_json = !empty($gallery_images) ? json_encode($gallery_images) : null; // Insert product $query = "INSERT INTO products (name, description, price, discount_price, category_id, stock_quantity, status, sku, image, size, certification, short_description, detailed_description, how_to_use, additional_tips, gallery_images, created_at) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, NOW())"; $stmt = $db->prepare($query); $stmt->execute([$name, $description, $price, $discount_price, $category_id, $stock_quantity, $status, $sku, $image, $size, $certification, $short_description, $detailed_description, $how_to_use, $additional_tips, $gallery_json]); header('Location: index.php?added=1'); exit; } catch (Exception $e) { $message = 'خطأ في إضافة المنتج: ' . $e->getMessage(); $message_type = 'error'; } } ?> إضافة منتج جديد - Roz Skin

إضافة منتج جديد

💡 سيظهر السعر الأصلي مشطوب والسعر الجديد بارز

JPG, PNG, GIF (الحد الأقصى: 5MB)

يمكنك اختيار عدة صور (Ctrl/Cmd + Click)

إلغاء