<?php // Include the database config file include_once 'includes/pdo_connection.php'; if(!empty($_POST["therapist_id"])){ // Fetch state data based on the specific country $query = "SELECT tbl_client.client_nameFROM tbl_clientINNER JOIN tbl_therapist_clientON tbl_therapist_client.client_id=tbl_client.client_idWHERE tbl_therapist_client.therapist_id = ".$_POST['therapist_id']."ORDER BY tbl_client.client_name ASC"; $result = $db->query($query); // Generate HTML of state options list if($result->num_rows > 0){ echo '<option value="">Select Client</option>'; while($row = $result->fetch_assoc()){ echo '<option value="'.$row['client_id'].'">'.$row['client_name'].'</option>'; } }else{ echo '<option value="">Client not available</option>'; } }elseif(!empty($_POST["client_id"])){ // Fetch city data based on the specific state $query = "SELECT * FROM tbl_session WHERE client_id = ".$_POST['client_id']." ORDER BY client_name ASC"; $result = $db->query($query); // Generate HTML of city options list if($result->num_rows > 0){ echo '<option value="">Select Session</option>'; while($row = $result->fetch_assoc()){ echo '<option value="'.$row['session_id'].'">'.$row['session_date'].'</option>'; } }else{ echo '<option value="">Session not available</option>'; } } ?>
Open in new window