FileXXXXXXXXXXX

?????????????? ?????????????? ?????????????? ?????????????? FileXXXXXXXXXXX

File manager - Edit - /home/toptrendingappst/.trash/getSpeciality.php

Back
<?php error_reporting(1); include('db_connect.php'); $response = array(); $ratingSum; $ratingAvg; $no; $profileArray = array(); $ratingArray = array(); if(isset($_GET['speciality'])){ $speciality = $_GET['speciality']; $query="Select u.user_id,dp.name,dp.profile_photo, dp.title, dp.experience_years, dp.primary_specialization, dp.secondary_specialization, dp.city, dp.country ,dp.services_offered, dp.conditions_treated,dp.spoken_language, dp.professional_statement,dp.country_code, dp.phone_no from users u inner join doctors_profile dp on u.user_id=dp.user_id where dp.primary_specialization='$speciality' or dp.secondary_specialization='$speciality'"; $r=mysqli_query($con,$query); while($row=mysqli_fetch_assoc($r)) { $profileArray[]=$row; $id=$row['user_id']; $query2="Select doctor_id,rating from doctor_rating where doctor_id='$id'"; $r2=mysqli_query($con,$query2); $no=(mysqli_num_rows($r2)); while($row2=mysqli_fetch_assoc($r2)) { $rating=$row2['rating']; $ratingSum=$ratingSum+$rating; } $ratingAvg= $ratingSum/$no; $ratingArray[]=$ratingAvg; } $response['error']=false; $response['profile']=$profileArray; $response['rating']=$ratingArray; } else { $response['error']=true; } echo json_encode($response); mysqli_close($con); ?>