getConnection();
echo "
فحص حقول المنتجات
";
echo "🔍 فحص حقول جدول products
";
try {
// Get table structure
$query = "DESCRIBE products";
$stmt = $db->prepare($query);
$stmt->execute();
$columns = $stmt->fetchAll(PDO::FETCH_ASSOC);
echo "";
echo "
📋 الحقول الموجودة في الجدول:
";
echo "
";
echo "| اسم الحقل | النوع | Null | Key | Default |
|---|
";
$required_fields = [
'name', 'description', 'price', 'discount_price', 'category_id',
'stock_quantity', 'status', 'sku', 'image', 'gallery_images',
'size', 'certification', 'short_description', 'detailed_description',
'how_to_use', 'additional_tips'
];
$existing_fields = [];
foreach ($columns as $col) {
$existing_fields[] = $col['Field'];
$is_required = in_array($col['Field'], $required_fields);
$style = $is_required ? "background: #d4edda;" : "";
echo "";
echo "| {$col['Field']} | ";
echo "{$col['Type']} | ";
echo "{$col['Null']} | ";
echo "{$col['Key']} | ";
echo "{$col['Default']} | ";
echo "
";
}
echo "
";
echo "
";
echo "
❌ حقول مفقودة:
";
echo "
";
foreach ($missing_fields as $field) {
echo "- {$field}
";
}
echo "
";
echo "
⚠️ هذه الحقول مطلوبة في صفحة التعديل ولكنها غير موجودة في الجدول!
";
echo "
";
echo "
✅ جميع الحقول المطلوبة موجودة!
";
echo "";
}
} catch (Exception $e) {
echo "";
echo "
❌ خطأ:
";
echo "
" . $e->getMessage() . "
";
echo "