getConnection();
$message = '';
// الحصول على المنتجات
$stmt = $conn->query("SELECT id, name FROM products ORDER BY name");
$products = $stmt->fetchAll(PDO::FETCH_ASSOC);
// الحصول على الوصفات
$stmt = $conn->query("SELECT pr.*, p.name as product_name FROM product_recipes pr LEFT JOIN products p ON pr.product_id = p.id ORDER BY pr.id DESC");
$recipes = $stmt->fetchAll(PDO::FETCH_ASSOC);
?>
وصفات المنتجات