$id]); $used = (int)db_value('SELECT COUNT(*) FROM listings WHERE category_slug=:s', ['s'=>$slug]); if ($used > 0) { header('Location: categories.php?err=' . urlencode("Can't delete — {$used} listing(s) are in this category. Move them first.")); exit; } $img = db_value('SELECT image_path FROM categories WHERE id=:id', ['id'=>$id]); if ($img) { $p = __DIR__ . '/../' . ltrim($img, '/'); if (file_exists($p)) @unlink($p); } db_exec('DELETE FROM categories WHERE id=:id', ['id'=>$id]); header('Location: categories.php?msg=deleted'); exit; } if ($do === 'reorder' && !empty($_POST['order'])) { $order = json_decode($_POST['order'], true); if (is_array($order)) { foreach ($order as $pos => $cid) { db_exec('UPDATE categories SET sort_order=:o WHERE id=:id', ['o' => (int)$pos, 'id' => (int)$cid]); } } exit; } } $categories = db_all( "SELECT c.*, (SELECT COUNT(*) FROM listings l WHERE l.category_slug = c.slug AND l.published = 1) AS listing_count FROM categories c ORDER BY c.sort_order, c.name" ); ?>

Categories ()

Drag rows to reorder · the order controls tile order on the homepage and directory.

+ Add category

	Image	Name	Slug	Listings	Actions
⋮⋮	No image				Edit ·

No categories yet. Click "+ Add category" to create one.