Server IP : 162.240.98.243 / Your IP : 3.16.76.138 Web Server : Apache System : Linux server.bti.yaw.mybluehostin.me 3.10.0-1160.119.1.el7.x86_64 #1 SMP Tue Jun 4 14:43:51 UTC 2024 x86_64 User : btiyawmy ( 1003) PHP Version : 7.2.34 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /home/btiyawmy/public_html/patient.easenup.in/ |
Upload File : |
<?php // Include the database config file include("dbconnection.php"); if(!empty($_POST["country_id"])){ // Fetch state data based on the specific country $query = "SELECT * FROM states WHERE country_id = ".$_POST['country_id']." AND status = 1 ORDER BY state_name ASC"; $result = $con->query($query); // Generate HTML of state options list if($result->num_rows > 0){ echo '<option value="">Select State</option>'; while($row = $result->fetch_assoc()){ echo '<option value="'.$row['state_id'].'">'.$row['state_name'].'</option>'; } }else{ echo '<option value="">State not available</option>'; } }elseif(!empty($_POST["state_id"])){ // Fetch city data based on the specific state $query = "SELECT * FROM cities WHERE state_id = ".$_POST['state_id']." AND status = 1 ORDER BY city_name ASC"; $result = $con->query($query); // Generate HTML of city options list if($result->num_rows > 0){ echo '<option value="">Select city</option>'; while($row = $result->fetch_assoc()){ echo '<option value="'.$row['city_id'].'">'.$row['city_name'].'</option>'; } }else{ echo '<option value="">City not available</option>'; } } ?>