prepare("INSERT INTO categories (name) VALUES (?)");
$stmt->execute([$name]);
header("Location: admin.php");
exit;
}
// Handle Category Update
if (isset($_POST['update_category'])) {
$id = $_POST['category_id'];
$name = $_POST['category_name'];
$stmt = $db->prepare("UPDATE categories SET name = ? WHERE id = ?");
$stmt->execute([$name, $id]);
header("Location: admin.php");
exit;
}
// Handle Category Delete
if (isset($_GET['delete_category'])) {
$id = $_GET['delete_category'];
$db->prepare("DELETE FROM product_images WHERE product_id IN (SELECT id FROM products WHERE category_id = ?)")->execute([$id]);
$db->prepare("DELETE FROM products WHERE category_id = ?")->execute([$id]);
$db->prepare("DELETE FROM categories WHERE id = ?")->execute([$id]);
header("Location: admin.php");
exit;
}
// Handle Product Addition
if (isset($_POST['add_product'])) {
$code = $_POST['product_code'];
$name = $_POST['product_name'];
$description = $_POST['product_desc'];
$category_id = $_POST['category_id'];
$main_image = "";
if ($_FILES['main_image']['name']) {
$main_image = 'uploads/' . time() . '_' . $_FILES['main_image']['name'];
move_uploaded_file($_FILES['main_image']['tmp_name'], $main_image);
}
$stmt = $db->prepare("INSERT INTO products (code, name, description, category_id, main_image) VALUES (?, ?, ?, ?, ?)");
$stmt->execute([$code, $name, $description, $category_id, $main_image]);
$product_id = $db->lastInsertId();
if (!empty($_FILES['sub_images']['name'][0])) {
foreach ($_FILES['sub_images']['tmp_name'] as $key => $tmp_name) {
$sub_image = 'uploads/sub_' . time() . '_' . $_FILES['sub_images']['name'][$key];
move_uploaded_file($tmp_name, $sub_image);
$stmt = $db->prepare("INSERT INTO product_images (product_id, image_path) VALUES (?, ?)");
$stmt->execute([$product_id, $sub_image]);
}
}
header("Location: admin.php");
exit;
}
// Handle Product Update
if (isset($_POST['update_product'])) {
$id = $_POST['product_id'];
$code = $_POST['product_code'];
$name = $_POST['product_name'];
$description = $_POST['product_desc'];
$category_id = $_POST['category_id'];
$main_image = $_POST['existing_main_image'];
if ($_FILES['main_image']['name']) {
$main_image = 'uploads/' . time() . '_' . $_FILES['main_image']['name'];
move_uploaded_file($_FILES['main_image']['tmp_name'], $main_image);
}
$stmt = $db->prepare("UPDATE products SET code = ?, name = ?, description = ?, category_id = ?, main_image = ? WHERE id = ?");
$stmt->execute([$code, $name, $description, $category_id, $main_image, $id]);
header("Location: admin.php");
exit;
}
// Handle Product Delete
if (isset($_GET['delete_product'])) {
$id = $_GET['delete_product'];
$db->prepare("DELETE FROM product_images WHERE product_id = ?")->execute([$id]);
$db->prepare("DELETE FROM products WHERE id = ?")->execute([$id]);
header("Location: admin.php");
exit;
}
// Handle Settings
if (isset($_POST['save_settings'])) {
$c_name = $_POST['company_name'];
$c_phone = $_POST['company_phone'];
if ($_FILES['background']['name']) {
$bg = 'uploads/bg_' . time() . '_' . $_FILES['background']['name'];
move_uploaded_file($_FILES['background']['tmp_name'], $bg);
$db->prepare("UPDATE company_settings SET background = ? WHERE id = 1")->execute([$bg]);
}
$db->prepare("UPDATE company_settings SET name = ?, phone = ? WHERE id = 1")->execute([$c_name, $c_phone]);
header("Location: admin.php");
exit;
}
$categories = $db->query("SELECT * FROM categories")->fetchAll(PDO::FETCH_ASSOC);
$settings = $db->query("SELECT * FROM company_settings WHERE id = 1")->fetch(PDO::FETCH_ASSOC);
$products = $db->query("SELECT p.*, c.name as cat_name FROM products p LEFT JOIN categories c ON p.category_id = c.id")->fetchAll(PDO::FETCH_ASSOC);
// Auto-generate product code
$lastProduct = $db->query("SELECT code FROM products ORDER BY id DESC LIMIT 1")->fetch(PDO::FETCH_ASSOC);
if ($lastProduct) {
$lastCode = intval(substr($lastProduct['code'], 1));
$newCode = 'P' . str_pad($lastCode + 1, 3, '0', STR_PAD_LEFT);
} else {
$newCode = 'P001';
}
?>
لوحة التحكم - المجلة التفاعلية
لوحة التحكم
إدارة المجلة التفاعلية
المجلة