'; if($row['bankruptcy']=='Yes' ){ $bankruptcy='Yes'; $bankruptcy_sym=''; } if( $row['licence_validated']=='y' || $row['licence_validated']=='Y' ) $dot1='style="background-color:green;"'; else $dot1='style="background-color:red;"'; if( $row['review_impact']=='g' || $row['review_impact']=='G' ) $dot2='style="background-color:green;"'; else $dot2='style="background-color:yellow;"'; if( $row['review_courteous']=='g' || $row['review_courteous']=='G' ) $dot3='style="background-color:green;"'; else $dot3='style="background-color:yellow;"'; if( $row['review_patient_centric']=='g' || $row['review_patient_centric']=='G' ) $dot4='style="background-color:green;"'; else $dot4='style="background-color:yellow;"'; if( $row['review_patient_opinion']=='g' || $row['review_patient_opinion']=='G' ) $dot5='style="background-color:green;"'; else $dot5='style="background-color:yellow;"'; $stmt1 = pg_query_params($conn, "select feedback,count(*) from tfa_customer_feedback where verified='Y' and td_email=$1 group by feedback", array($user_email)); if (!$stmt1) { echo "An query2 error occurred.\n"; echo pg_last_error($conn); exit; } $row1=pg_fetch_all($stmt1); $count_L=0; $count_D=0; $count_C=0; if($row1){ foreach ($row1 as $this_data){ if($this_data['feedback']=='L') $count_L=$this_data['count']; if($this_data['feedback']=='D') $count_D=$this_data['count']; if($this_data['feedback']=='C') $count_C=$this_data['count']; } } pg_free_result($stmt1); $stmt2 = pg_query_params($conn, "select distinct t.user_email,c.user_email as patient_email,c.review_date,cli.name as first_name,t.name as td_name,encode('cli.photo_in_db','hex') as patient_photo,t.photo as td_photo,c.feedback,c.feedback_details,c.td_feedback_reponse from tfa t right join tfa_customer_feedback c on (t.user_email=c.td_email) left join user_table cli on ( c.user_email=cli.email) and (c.verified='Y' OR c.verified is NULL) and t.user_email=$1 order by c.review_date desc", array($user_email)); if (!$stmt2) { echo "An query3 error occurred.\n"; echo pg_last_error($conn); exit; } $row2=pg_fetch_all($stmt2); pg_free_result($stmt2); $stmt3 = pg_query_params($conn, "select count(*) from tfa_customer_feedback where verified='Y' and td_email=$1", array($user_email)); if (!$stmt3) { echo "An query4 error occurred.\n"; echo pg_last_error($conn); exit; } $row3=pg_fetch_all($stmt3); $total_reviews=0; if($row3) $total_reviews=$row3[0]['count']; pg_free_result($stmt3); ?>
Verified Reviews ( )
.
.