query("SHOW COLUMNS FROM packages LIKE 'sort_order'"); if ($check_sort && $check_sort->num_rows == 0) { $conn->query("ALTER TABLE packages ADD COLUMN sort_order INT DEFAULT 0"); } $check_type = $conn->query("SHOW COLUMNS FROM packages LIKE 'tour_type'"); if ($check_type && $check_type->num_rows == 0) { $conn->query("ALTER TABLE packages ADD COLUMN tour_type VARCHAR(20) DEFAULT 'group'"); } // Handle Delete if (isset($_GET['delete'])) { $del_id = (int)$_GET['delete']; $conn->query("DELETE FROM packages WHERE id = $del_id"); header("Location: packages.php"); exit(); } // Handle Order Update if (isset($_POST['update_order'])) { if (isset($_POST['sort_order']) && is_array($_POST['sort_order'])) { foreach ($_POST['sort_order'] as $pkg_id => $order_val) { $pkg_id = (int)$pkg_id; $order_val = (int)$order_val; $conn->query("UPDATE packages SET sort_order = $order_val WHERE id = $pkg_id"); } $_SESSION['success_msg'] = "Tour order updated successfully!"; header("Location: packages.php"); exit(); } } $packages = $conn->query("SELECT p.*, d.name as country_name FROM packages p JOIN destinations d ON p.country_id = d.id ORDER BY p.sort_order DESC, p.id DESC"); ?>

Manage International Tours

Add New Package

num_rows > 0): ?> fetch_assoc()): ?>

Cover	Tour Title	Destination	Type	Duration	Price	Order No.	Actions
			Tour		LKR
No tour packages found. Click "Add New Package" to get started.