⚠️ Database Connection Failed

Could not find db.php in public/config/.

Please check your folder structure.

"); } // --- 3. HANDLE ADD CATEGORY --- $msg = ""; $msg_type = ""; if (isset($_POST['add_category'])) { $name = trim($_POST['name']); $icon = isset($_POST['icon']) ? trim($_POST['icon']) : 'fa-folder'; $status = $_POST['status']; // Slug Generator (e.g. "PHP Script" -> "php-script") $slug = strtolower(trim(preg_replace('/[^A-Za-z0-9-]+/', '-', $name))); // Default Icon Check if(empty($icon)) { $icon = 'fa-folder'; } if (!empty($name)) { try { // Pehle check karein ki table me 'icon' column hai ya nahi // (Yeh code automatic adjust karega) $sql = "INSERT INTO categories (name, slug, icon, status) VALUES (?, ?, ?, ?)"; $stmt = $pdo->prepare($sql); if ($stmt->execute([$name, $slug, $icon, $status])) { $msg = "Category added successfully!"; $msg_type = "success"; } } catch (PDOException $e) { $msg = "Error: " . $e->getMessage(); $msg_type = "danger"; } } else { $msg = "Category name is required."; $msg_type = "danger"; } } // --- 4. HANDLE DELETE CATEGORY --- if (isset($_GET['delete'])) { $id = $_GET['delete']; try { $pdo->prepare("DELETE FROM categories WHERE id = ?")->execute([$id]); $msg = "Category deleted successfully!"; $msg_type = "warning"; } catch (PDOException $e) { $msg = "Error: " . $e->getMessage(); $msg_type = "danger"; } } ?> Manage Categories - SejiStore

Product Categories

Manage categories for your Shop

query("SELECT * FROM categories ORDER BY id DESC"); $count = 0; while($row = $stmt->fetch()): $count++; $statusClass = ($row['status'] == 1) ? 'status-active' : 'status-inactive'; $statusText = ($row['status'] == 1) ? 'Active' : 'Hidden'; // Fallback for icon if column is empty $iconClass = !empty($row['icon']) ? $row['icon'] : 'fa-folder'; ?> "; } } catch(Exception $e) { echo ""; } ?>

Icon	Category Name	Slug	Status	Actions
		/
No categories found. Click 'Add New' to create one.
Table Error: Please ensure the 'categories' table exists in your DB. " . $e->getMessage() . "