]]jkjjgdjffksdkdxmnnnnnnnnnnnmnmmnmnmnmnmbnwqeqwewqskfgj

<?php include_once 'Config.php'; // Include database connection if (isset($_POST['state_id'])) { $state_id = $mysqli->real_escape_string($_POST['state_id']); // Sanitize input // Fetch cities based on the selected state $city_query = $mysqli->query("SELECT * FROM city WHERE state_id = '$state_id' ORDER BY city_name ASC"); if ($city_query->num_rows > 0) { echo "<option value=''>Select City</option>"; // Default option while ($city = $city_query->fetch_assoc()) { echo "<option value='" . $city['city_id'] . "'>" . $city['city_name'] . "</option>"; } } else { echo "<option value=''>No cities available</option>"; // If no cities found } } ?>