query("CREATE TABLE IF NOT EXISTS local_tour_gallery ( id INT AUTO_INCREMENT PRIMARY KEY, tour_id INT NOT NULL, image VARCHAR(255) NOT NULL, FOREIGN KEY (tour_id) REFERENCES local_tours(id) ON DELETE CASCADE )"); // Handle Delete if (isset($_GET['delete'])) { $del_id = (int)$_GET['delete']; $conn->query("DELETE FROM local_tours WHERE id = $del_id"); header("Location: local-tours.php"); exit(); } $tours = $conn->query("SELECT * FROM local_tours ORDER BY id DESC"); ?>

Manage Local Tours

Add New Tour

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

Image	Title	Location	Price	Actions
			LKR
No local tours found. Click "Add New Tour" to get started.