getConnection();
// Get products
$query = "SELECT p.*, c.name as category_name
FROM products p
LEFT JOIN categories c ON p.category_id = c.id
ORDER BY p.created_at DESC";
$stmt = $db->prepare($query);
$stmt->execute();
$all_products = $stmt->fetchAll(PDO::FETCH_ASSOC);
// Get categories
$query_cat = "SELECT * FROM categories ORDER BY name";
$stmt_cat = $db->prepare($query_cat);
$stmt_cat->execute();
$all_categories = $stmt_cat->fetchAll(PDO::FETCH_ASSOC);
// Get statistics
$total_products = count($all_products);
$active_products = count(array_filter($all_products, fn($p) => $p['status'] === 'active'));
$low_stock = count(array_filter($all_products, fn($p) => isset($p['stock']) && $p['stock'] < 10));
$total_value = array_sum(array_map(fn($p) => $p['price'] * ($p['stock'] ?? 0), $all_products));
} catch (Exception $e) {
$error = "خطأ في الاتصال بقاعدة البيانات: " . $e->getMessage();
$all_products = [];
$all_categories = [];
}
// Handle delete
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['delete_product'])) {
try {
$product_id = $_POST['product_id'];
$query = "DELETE FROM products WHERE id = ?";
$stmt = $db->prepare($query);
$stmt->execute([$product_id]);
header("Location: index-new.php?deleted=1");
exit;
} catch (Exception $e) {
$error = "خطأ في حذف المنتج: " . $e->getMessage();
}
}
$page_title = 'إدارة المنتجات';
$breadcrumb = [
['title' => 'الرئيسية', 'url' => '../dashboard.php'],
['title' => 'المنتجات']
];
include '../includes/header.php';
?>
![<?php echo htmlspecialchars($product['name']); ?>](../../uploads/products/<?php echo htmlspecialchars($product['image']); ?>)