Choose Appointment Date :

= '$MALA_CU_DAY_AR_KAR' and date='$tod_day' ) and status='0' "); // // // $num_rows = mysql_num_rows($objitem); $objitem = mysql_query("select * from tbl_doctor_appointment where date='$tod_day'"); $num_rows = mysql_num_rows($objitem); $get_stats = mysqli_query($conn, "select * from tbl_doctor_appointment t1 inner join tbl_appointment t2 on t1.date = t2.appointment_date where t2. appointment_date = '$tod_day' and t2.status = 1"); // echo "select * from tbl_appointment where appointment_date='$tod_day' and status in (0,1,2,3,4)"; $get_num_stats = mysqli_num_rows($get_stats); $get_tot_app = get_tot_app($tod_day, $conn); $timing = calc_timing($tod_day, $conn); ?> = '$MALA_CU_DAY_AR_KAR' and date='$tod_day' ) and status='0'"); // $num_rows = mysql_num_rows($objitem); $objitem = mysql_query("select * from tbl_doctor_appointment where date='$tod_day'"); $num_rows = mysql_num_rows($objitem); $get_stats = mysqli_query($conn, "select * from tbl_doctor_appointment t1 inner join tbl_appointment t2 on t1.date = t2.appointment_date where t2. appointment_date = '$tod_day' and t2.status = 1"); // echo "select * from tbl_appointment where appointment_date='$tod_day' and status in (0,1,2,3,4)"; $get_num_stats = mysqli_num_rows($get_stats); $get_tot_app = get_tot_app($tod_day, $conn); $timing = calc_timing($tod_day, $conn); ?> = '$MALA_CU_DAY_AR_KAR' and date='$tod_day' ) and status='0'"); // // $num_rows = mysql_num_rows($objitem); $objitem = mysql_query("select * from tbl_doctor_appointment where date='$tod_day'"); $num_rows = mysql_num_rows($objitem); $get_stats = mysqli_query($conn, "select * from tbl_doctor_appointment t1 inner join tbl_appointment t2 on t1.date = t2.appointment_date where t2. appointment_date = '$tod_day' and t2.status = 1"); // echo "select * from tbl_appointment where appointment_date='$tod_day' and status in (0,1,2,3,4)"; $get_num_stats = mysqli_num_rows($get_stats); $get_tot_app = get_tot_app($tod_day, $conn); $timing = calc_timing($tod_day, $conn); ?> = '$MALA_CU_DAY_AR_KAR' and date='$tod_day' ) and status='0'"); // // $num_rows = mysql_num_rows($objitem); $objitem = mysql_query("select * from tbl_doctor_appointment where date='$tod_day'"); $num_rows = mysql_num_rows($objitem); $get_stats = mysqli_query($conn, "select * from tbl_doctor_appointment t1 inner join tbl_appointment t2 on t1.date = t2.appointment_date where t2. appointment_date = '$tod_day' and t2.status = 1"); // echo "select * from tbl_appointment where appointment_date='$tod_day' and status in (0,1,2,3,4)"; $get_num_stats = mysqli_num_rows($get_stats); $get_tot_app = get_tot_app($tod_day, $conn); $timing = calc_timing($tod_day, $conn); ?> = '$MALA_CU_DAY_AR_KAR' and date='$tod_day' ) and status='0'"); // $num_rows = mysql_num_rows($objitem); $objitem = mysql_query("select * from tbl_doctor_appointment where date='$tod_day'"); $num_rows = mysql_num_rows($objitem); $get_stats = mysqli_query($conn, "select * from tbl_doctor_appointment t1 inner join tbl_appointment t2 on t1.date = t2.appointment_date where t2. appointment_date = '$tod_day' and t2.status = 1"); // echo "select * from tbl_appointment where appointment_date='$tod_day' and status in (0,1,2,3,4)"; $get_num_stats = mysqli_num_rows($get_stats); $get_tot_app = get_tot_app($tod_day, $conn); $timing = calc_timing($tod_day, $conn); ?> = '$MALA_CU_DAY_AR_KAR' and date='$tod_day' ) and status='0'"); // // $num_rows = mysql_num_rows($objitem); $objitem = mysql_query("select * from tbl_doctor_appointment where date='$tod_day'"); $num_rows = mysql_num_rows($objitem); $get_stats = mysqli_query($conn, "select * from tbl_doctor_appointment t1 inner join tbl_appointment t2 on t1.date = t2.appointment_date where t2. appointment_date = '$tod_day' and t2.status = 1"); // echo "select * from tbl_appointment where appointment_date='$tod_day' and status in (0,1,2,3,4)"; $get_num_stats = mysqli_num_rows($get_stats); $get_tot_app = get_tot_app($tod_day, $conn); $timing = calc_timing($tod_day, $conn); ?> = '$MALA_CU_DAY_AR_KAR' and date='$tod_day' ) and status='0'"); // // $num_rows = mysql_num_rows($objitem); $objitem = mysql_query("select * from tbl_doctor_appointment where date='$tod_day'"); $num_rows = mysql_num_rows($objitem); $get_stats = mysqli_query($conn, "select * from tbl_doctor_appointment t1 inner join tbl_appointment t2 on t1.date = t2.appointment_date where t2. appointment_date = '$tod_day' and t2.status = 1"); // echo "select * from tbl_appointment where appointment_date='$tod_day' and status in (0,1,2,3,4)"; $get_num_stats = mysqli_num_rows($get_stats); $get_tot_app = get_tot_app($tod_day, $conn); $timing = calc_timing($tod_day, $conn); ?> = '$MALA_CU_DAY_AR_KAR' and date='$tod_day' ) and status='0'"); // // $num_rows = mysql_num_rows($objitem); $objitem = mysql_query("select * from tbl_doctor_appointment where date='$tod_day'"); $num_rows = mysql_num_rows($objitem); $get_stats = mysqli_query($conn, "select * from tbl_doctor_appointment t1 inner join tbl_appointment t2 on t1.date = t2.appointment_date where t2. appointment_date = '$tod_day' and t2.status = 1"); // echo "select * from tbl_appointment where appointment_date='$tod_day' and status in (0,1,2,3,4)"; $get_num_stats = mysqli_num_rows($get_stats); $get_tot_app = get_tot_app($tod_day, $conn); $timing = calc_timing($tod_day, $conn); ?> = '$MALA_CU_DAY_AR_KAR' and date='$tod_day' ) and status='0'"); // // $num_rows = mysql_num_rows($objitem); $objitem = mysql_query("select * from tbl_doctor_appointment where date='$tod_day'"); $num_rows = mysql_num_rows($objitem); $get_stats = mysqli_query($conn, "select * from tbl_doctor_appointment t1 inner join tbl_appointment t2 on t1.date = t2.appointment_date where t2. appointment_date = '$tod_day' and t2.status = 1"); // echo "select * from tbl_appointment where appointment_date='$tod_day' and status in (0,1,2,3,4)"; $get_num_stats = mysqli_num_rows($get_stats); $get_tot_app = get_tot_app($tod_day, $conn); $timing = calc_timing($tod_day, $conn); ?> = '$MALA_CU_DAY_AR_KAR' and date='$tod_day' ) and status='0'"); // // $num_rows = mysql_num_rows($objitem); $objitem = mysql_query("select * from tbl_doctor_appointment where date='$tod_day'"); $num_rows = mysql_num_rows($objitem); $get_stats = mysqli_query($conn, "select * from tbl_doctor_appointment t1 inner join tbl_appointment t2 on t1.date = t2.appointment_date where t2. appointment_date = '$tod_day' and t2.status = 1"); // echo "select * from tbl_appointment where appointment_date='$tod_day' and status in (0,1,2,3,4)"; $get_num_stats = mysqli_num_rows($get_stats); $get_tot_app = get_tot_app($tod_day, $conn); $timing = calc_timing($tod_day, $conn); ?> = '$MALA_CU_DAY_AR_KAR' and date='$tod_day' ) and status='0'"); // // $num_rows = mysql_num_rows($objitem); $objitem = mysql_query("select * from tbl_doctor_appointment where date='$tod_day'"); $num_rows = mysql_num_rows($objitem); $get_stats = mysqli_query($conn, "select * from tbl_doctor_appointment t1 inner join tbl_appointment t2 on t1.date = t2.appointment_date where t2. appointment_date = '$tod_day' and t2.status = 1"); // echo "select * from tbl_appointment where appointment_date='$tod_day' and status in (0,1,2,3,4)"; $get_num_stats = mysqli_num_rows($get_stats); $get_tot_app = get_tot_app($tod_day, $conn); $timing = calc_timing($tod_day, $conn); ?> $MALA_CU_DAY_AR_KAR) { } if($mas_1_par<$MALA_CU_DAY_AR_KAR) { /*$mas_1_par=strtotime($mas_1_par);*/ ?> = '$MALA_CU_DAY_AR_KAR' and date='$tod_day' ) and status='0'"); // // $num_rows = mysql_num_rows($objitem); $objitem = mysql_query("select * from tbl_doctor_appointment where date='$tod_day'"); $num_rows = mysql_num_rows($objitem); $get_stats = mysqli_query($conn, "select * from tbl_doctor_appointment t1 inner join tbl_appointment t2 on t1.date = t2.appointment_date where t2. appointment_date = '$tod_day' and t2.status = 1"); // echo "select * from tbl_appointment where appointment_date='$tod_day' and status in (0,1,2,3,4)"; $get_num_stats = mysqli_num_rows($get_stats); $get_tot_app = get_tot_app($tod_day, $conn); $timing = calc_timing($tod_day, $conn); ?> = '$MALA_CU_DAY_AR_KAR' and date='$tod_day' ) and status='0'"); // // $num_rows = mysql_num_rows($objitem); ?> = '$MALA_CU_DAY_AR_KAR' and date='$tod_day' ) and status='0'"); // // $num_rows = mysql_num_rows($objitem); $objitem = mysql_query("select * from tbl_doctor_appointment where date='$tod_day'"); $num_rows = mysql_num_rows($objitem); $get_stats = mysqli_query($conn, "select * from tbl_doctor_appointment t1 inner join tbl_appointment t2 on t1.date = t2.appointment_date where t2. appointment_date = '$tod_day' and t2.status = 1"); // echo "select * from tbl_appointment where appointment_date='$tod_day' and status in (0,1,2,3,4)"; $get_num_stats = mysqli_num_rows($get_stats); $get_tot_app = get_tot_app($tod_day, $conn); $timing = calc_timing($tod_day, $conn); ?> = '$MALA_CU_DAY_AR_KAR' and date='$tod_day' ) and status='0'"); // // $num_rows = mysql_num_rows($objitem); $objitem = mysql_query("select * from tbl_doctor_appointment where date='$tod_day'"); $num_rows = mysql_num_rows($objitem); $get_stats = mysqli_query($conn, "select * from tbl_doctor_appointment t1 inner join tbl_appointment t2 on t1.date = t2.appointment_date where t2. appointment_date = '$tod_day' and t2.status = 1"); // echo "select * from tbl_appointment where appointment_date='$tod_day' and status in (0,1,2,3,4)"; $get_num_stats = mysqli_num_rows($get_stats); $get_tot_app = get_tot_app($tod_day, $conn); $timing = calc_timing($tod_day, $conn); ?> = '$MALA_CU_DAY_AR_KAR' and date='$tod_day' ) and status='0'"); // // $num_rows = mysql_num_rows($objitem); $objitem = mysql_query("select * from tbl_doctor_appointment where date='$tod_day'"); $num_rows = mysql_num_rows($objitem); $get_stats = mysqli_query($conn, "select * from tbl_doctor_appointment t1 inner join tbl_appointment t2 on t1.date = t2.appointment_date where t2. appointment_date = '$tod_day' and t2.status = 1"); // echo "select * from tbl_appointment where appointment_date='$tod_day' and status in (0,1,2,3,4)"; $get_num_stats = mysqli_num_rows($get_stats); $get_tot_app = get_tot_app($tod_day, $conn); $timing = calc_timing($tod_day, $conn); ?> = '$MALA_CU_DAY_AR_KAR' and date='$tod_day' ) and status='0'"); // // $num_rows = mysql_num_rows($objitem); $objitem = mysql_query("select * from tbl_doctor_appointment where date='$tod_day'"); $num_rows = mysql_num_rows($objitem); $get_stats = mysqli_query($conn, "select * from tbl_doctor_appointment t1 inner join tbl_appointment t2 on t1.date = t2.appointment_date where t2. appointment_date = '$tod_day' and t2.status = 1"); // echo "select * from tbl_appointment where appointment_date='$tod_day' and status in (0,1,2,3,4)"; $get_num_stats = mysqli_num_rows($get_stats); $get_tot_app = get_tot_app($tod_day, $conn); $timing = calc_timing($tod_day, $conn); ?> = '$MALA_CU_DAY_AR_KAR' and date='$tod_day' ) and status='0'"); $num_rows = mysql_num_rows($objitem); ?> = '$MALA_CU_DAY_AR_KAR' and date='$tod_day' ) and status='0'"); // $num_rows = mysql_num_rows($objitem); $objitem = mysql_query("select * from tbl_doctor_appointment where date='$tod_day'"); $num_rows = mysql_num_rows($objitem); $get_stats = mysqli_query($conn, "select * from tbl_doctor_appointment t1 inner join tbl_appointment t2 on t1.date = t2.appointment_date where t2. appointment_date = '$tod_day' and t2.status = 1"); // echo "select * from tbl_appointment where appointment_date='$tod_day' and status in (0,1,2,3,4)"; $get_num_stats = mysqli_num_rows($get_stats); $get_tot_app = get_tot_app($tod_day, $conn); $timing = calc_timing($tod_day, $conn); ?> = '$MALA_CU_DAY_AR_KAR' and date='$tod_day' ) and status='0'"); // // $num_rows = mysql_num_rows($objitem); $objitem = mysql_query("select * from tbl_doctor_appointment where date='$tod_day'"); $num_rows = mysql_num_rows($objitem); $get_stats = mysqli_query($conn, "select * from tbl_doctor_appointment t1 inner join tbl_appointment t2 on t1.date = t2.appointment_date where t2. appointment_date = '$tod_day' and t2.status = 1"); // echo "select * from tbl_appointment where appointment_date='$tod_day' and status in (0,1,2,3,4)"; $get_num_stats = mysqli_num_rows($get_stats); $get_tot_app = get_tot_app($tod_day, $conn); $timing = calc_timing($tod_day, $conn); ?> = '$MALA_CU_DAY_AR_KAR' and date='$tod_day' ) and status='0'"); // // $num_rows = mysql_num_rows($objitem); $objitem = mysql_query("select * from tbl_doctor_appointment where date='$tod_day'"); $num_rows = mysql_num_rows($objitem); $get_stats = mysqli_query($conn, "select * from tbl_doctor_appointment t1 inner join tbl_appointment t2 on t1.date = t2.appointment_date where t2. appointment_date = '$tod_day' and t2.status = 1"); // echo "select * from tbl_appointment where appointment_date='$tod_day' and status in (0,1,2,3,4)"; $get_num_stats = mysqli_num_rows($get_stats); $get_tot_app = get_tot_app($tod_day, $conn); $timing = calc_timing($tod_day, $conn); ?> = '$MALA_CU_DAY_AR_KAR' and date='$tod_day' ) and status='0'"); // // $num_rows = mysql_num_rows($objitem); $objitem = mysql_query("select * from tbl_doctor_appointment where date='$tod_day'"); $num_rows = mysql_num_rows($objitem); $get_stats = mysqli_query($conn, "select * from tbl_doctor_appointment t1 inner join tbl_appointment t2 on t1.date = t2.appointment_date where t2. appointment_date = '$tod_day' and t2.status = 1"); // echo "select * from tbl_appointment where appointment_date='$tod_day' and status in (0,1,2,3,4)"; $get_num_stats = mysqli_num_rows($get_stats); $get_tot_app = get_tot_app($tod_day, $conn); $timing = calc_timing($tod_day, $conn); ?> = '$MALA_CU_DAY_AR_KAR' and date='$tod_day' ) and status='0'"); // // $num_rows = mysql_num_rows($objitem); $objitem = mysql_query("select * from tbl_doctor_appointment where date='$tod_day'"); $num_rows = mysql_num_rows($objitem); $get_stats = mysqli_query($conn, "select * from tbl_doctor_appointment t1 inner join tbl_appointment t2 on t1.date = t2.appointment_date where t2. appointment_date = '$tod_day' and t2.status = 1"); // echo "select * from tbl_appointment where appointment_date='$tod_day' and status in (0,1,2,3,4)"; $get_num_stats = mysqli_num_rows($get_stats); $get_tot_app = get_tot_app($tod_day, $conn); $timing = calc_timing($tod_day, $conn); ?> = '$MALA_CU_DAY_AR_KAR' and date='$tod_day' ) and status='0'"); // // $num_rows = mysql_num_rows($objitem); $objitem = mysql_query("select * from tbl_doctor_appointment where date='$tod_day'"); $num_rows = mysql_num_rows($objitem); $get_stats = mysqli_query($conn, "select * from tbl_doctor_appointment t1 inner join tbl_appointment t2 on t1.date = t2.appointment_date where t2. appointment_date = '$tod_day' and t2.status = 1"); // echo "select * from tbl_appointment where appointment_date='$tod_day' and status in (0,1,2,3,4)"; $get_num_stats = mysqli_num_rows($get_stats); $get_tot_app = get_tot_app($tod_day, $conn); $timing = calc_timing($tod_day, $conn); ?> = '$MALA_CU_DAY_AR_KAR' and date='$tod_day' ) and status='0'"); // // $num_rows = mysql_num_rows($objitem); $objitem = mysql_query("select * from tbl_doctor_appointment where date='$tod_day'"); $num_rows = mysql_num_rows($objitem); $get_stats = mysqli_query($conn, "select * from tbl_doctor_appointment t1 inner join tbl_appointment t2 on t1.date = t2.appointment_date where t2. appointment_date = '$tod_day' and t2.status = 1"); // echo "select * from tbl_appointment where appointment_date='$tod_day' and status in (0,1,2,3,4)"; $get_num_stats = mysqli_num_rows($get_stats); $get_tot_app = get_tot_app($tod_day, $conn); $timing = calc_timing($tod_day, $conn); ?> = '$MALA_CU_DAY_AR_KAR' and date='$tod_day' ) and status='0'"); // // $num_rows = mysql_num_rows($objitem); $objitem = mysql_query("select * from tbl_doctor_appointment where date='$tod_day'"); $num_rows = mysql_num_rows($objitem); $get_stats = mysqli_query($conn, "select * from tbl_doctor_appointment t1 inner join tbl_appointment t2 on t1.date = t2.appointment_date where t2. appointment_date = '$tod_day' and t2.status = 1"); // echo "select * from tbl_appointment where appointment_date='$tod_day' and status in (0,1,2,3,4)"; $get_num_stats = mysqli_num_rows($get_stats); $get_tot_app = get_tot_app($tod_day, $conn); $timing = calc_timing($tod_day, $conn); ?> = '$MALA_CU_DAY_AR_KAR' and date='$tod_day' ) and status='0'"); // // $num_rows = mysql_num_rows($objitem); $objitem = mysql_query("select * from tbl_doctor_appointment where date='$tod_day'"); $num_rows = mysql_num_rows($objitem); $get_stats = mysqli_query($conn, "select * from tbl_doctor_appointment t1 inner join tbl_appointment t2 on t1.date = t2.appointment_date where t2. appointment_date = '$tod_day' and t2.status = 1"); // echo "select * from tbl_appointment where appointment_date='$tod_day' and status in (0,1,2,3,4)"; $get_num_stats = mysqli_num_rows($get_stats); $get_tot_app = get_tot_app($tod_day, $conn); $timing = calc_timing($tod_day, $conn); ?> = '$MALA_CU_DAY_AR_KAR' and date='$tod_day' ) and status='0'"); // // $num_rows = mysql_num_rows($objitem); $objitem = mysql_query("select * from tbl_doctor_appointment where date='$tod_day'"); $num_rows = mysql_num_rows($objitem); $get_stats = mysqli_query($conn, "select * from tbl_doctor_appointment t1 inner join tbl_appointment t2 on t1.date = t2.appointment_date where t2. appointment_date = '$tod_day' and t2.status = 1"); // echo "select * from tbl_appointment where appointment_date='$tod_day' and status in (0,1,2,3,4)"; $get_num_stats = mysqli_num_rows($get_stats); $get_tot_app = get_tot_app($tod_day, $conn); $timing = calc_timing($tod_day, $conn); ?> = '$MALA_CU_DAY_AR_KAR' and date='$tod_day' ) and status='0'"); // // $num_rows = mysql_num_rows($objitem); $objitem = mysql_query("select * from tbl_doctor_appointment where date='$tod_day'"); $num_rows = mysql_num_rows($objitem); $get_stats = mysqli_query($conn, "select * from tbl_doctor_appointment t1 inner join tbl_appointment t2 on t1.date = t2.appointment_date where t2. appointment_date = '$tod_day' and t2.status = 1"); // echo "select * from tbl_appointment where appointment_date='$tod_day' and status in (0,1,2,3,4)"; $get_num_stats = mysqli_num_rows($get_stats); $get_tot_app = get_tot_app($tod_day, $conn); $timing = calc_timing($tod_day, $conn); ?> = '$MALA_CU_DAY_AR_KAR' and date='$tod_day' ) and status='0'"); // // $num_rows = mysql_num_rows($objitem); $objitem = mysql_query("select * from tbl_doctor_appointment where date='$tod_day'"); $num_rows = mysql_num_rows($objitem); $get_stats = mysqli_query($conn, "select * from tbl_doctor_appointment t1 inner join tbl_appointment t2 on t1.date = t2.appointment_date where t2. appointment_date = '$tod_day' and t2.status = 1"); // echo "select * from tbl_appointment where appointment_date='$tod_day' and status in (0,1,2,3,4)"; $get_num_stats = mysqli_num_rows($get_stats); $get_tot_app = get_tot_app($tod_day, $conn); $timing = calc_timing($tod_day, $conn); ?> = '$MALA_CU_DAY_AR_KAR' and date='$tod_day' ) and status='0'"); // // $num_rows = mysql_num_rows($objitem); $objitem = mysql_query("select * from tbl_doctor_appointment where date='$tod_day'"); $num_rows = mysql_num_rows($objitem); $get_stats = mysqli_query($conn, "select * from tbl_doctor_appointment t1 inner join tbl_appointment t2 on t1.date = t2.appointment_date where t2. appointment_date = '$tod_day' and t2.status = 1"); // echo "select * from tbl_appointment where appointment_date='$tod_day' and status in (0,1,2,3,4)"; $get_num_stats = mysqli_num_rows($get_stats); $get_tot_app = get_tot_app($tod_day, $conn); $timing = calc_timing($tod_day, $conn); ?> = '$MALA_CU_DAY_AR_KAR' and date='$tod_day' ) and status='0'"); // // $num_rows = mysql_num_rows($objitem); $objitem = mysql_query("select * from tbl_doctor_appointment where date='$tod_day'"); $num_rows = mysql_num_rows($objitem); $get_stats = mysqli_query($conn, "select * from tbl_doctor_appointment t1 inner join tbl_appointment t2 on t1.date = t2.appointment_date where t2. appointment_date = '$tod_day' and t2.status = 1"); // echo "select * from tbl_appointment where appointment_date='$tod_day' and status in (0,1,2,3,4)"; $get_num_stats = mysqli_num_rows($get_stats); $get_tot_app = get_tot_app($tod_day, $conn); $timing = calc_timing($tod_day, $conn); ?> = '$MALA_CU_DAY_AR_KAR' and date='$tod_day' ) and status='0'"); // // $num_rows = mysql_num_rows($objitem); $objitem = mysql_query("select * from tbl_doctor_appointment where date='$tod_day'"); $num_rows = mysql_num_rows($objitem); $get_stats = mysqli_query($conn, "select * from tbl_doctor_appointment t1 inner join tbl_appointment t2 on t1.date = t2.appointment_date where t2. appointment_date = '$tod_day' and t2.status = 1"); // echo "select * from tbl_appointment where appointment_date='$tod_day' and status in (0,1,2,3,4)"; $get_num_stats = mysqli_num_rows($get_stats); $get_tot_app = get_tot_app($tod_day, $conn); $timing = calc_timing($tod_day, $conn); ?> = '$MALA_CU_DAY_AR_KAR' and date='$tod_day' ) and status='0'"); // // // $num_rows = mysql_num_rows($objitem); $objitem = mysql_query("select * from tbl_doctor_appointment where date='$tod_day'"); $num_rows = mysql_num_rows($objitem); $get_stats = mysqli_query($conn, "select * from tbl_doctor_appointment t1 inner join tbl_appointment t2 on t1.date = t2.appointment_date where t2. appointment_date = '$tod_day' and t2.status = 1"); // echo "select * from tbl_appointment where appointment_date='$tod_day' and status in (0,1,2,3,4)"; $get_num_stats = mysqli_num_rows($get_stats); $get_tot_app = get_tot_app($tod_day, $conn); $timing = calc_timing($tod_day, $conn); ?> = '$MALA_CU_DAY_AR_KAR' and date='$tod_day' ) and status='0'"); // // $num_rows = mysql_num_rows($objitem); $objitem = mysql_query("select * from tbl_doctor_appointment where date='$tod_day'"); $num_rows = mysql_num_rows($objitem); $get_stats = mysqli_query($conn, "select * from tbl_doctor_appointment t1 inner join tbl_appointment t2 on t1.date = t2.appointment_date where t2. appointment_date = '$tod_day' and t2.status = 1"); // echo "select * from tbl_appointment where appointment_date='$tod_day' and status in (0,1,2,3,4)"; $get_num_stats = mysqli_num_rows($get_stats); $get_tot_app = get_tot_app($tod_day, $conn); $timing = calc_timing($tod_day, $conn); ?> = '$MALA_CU_DAY_AR_KAR' and date='$tod_day' ) and status='0'"); // // $num_rows = mysql_num_rows($objitem); $objitem = mysql_query("select * from tbl_doctor_appointment where date='$tod_day'"); $num_rows = mysql_num_rows($objitem); $get_stats = mysqli_query($conn, "select * from tbl_doctor_appointment t1 inner join tbl_appointment t2 on t1.date = t2.appointment_date where t2. appointment_date = '$tod_day' and t2.status = 1"); // echo "select * from tbl_appointment where appointment_date='$tod_day' and status in (0,1,2,3,4)"; $get_num_stats = mysqli_num_rows($get_stats); $get_tot_app = get_tot_app($tod_day, $conn); $timing = calc_timing($tod_day, $conn); ?> = '$MALA_CU_DAY_AR_KAR' and date='$tod_day' ) and status='0'"); // // $num_rows = mysql_num_rows($objitem); $objitem = mysql_query("select * from tbl_doctor_appointment where date='$tod_day'"); $num_rows = mysql_num_rows($objitem); $get_stats = mysqli_query($conn, "select * from tbl_doctor_appointment t1 inner join tbl_appointment t2 on t1.date = t2.appointment_date where t2. appointment_date = '$tod_day' and t2.status = 1"); // echo "select * from tbl_appointment where appointment_date='$tod_day' and status in (0,1,2,3,4)"; $get_num_stats = mysqli_num_rows($get_stats); $get_tot_app = get_tot_app($tod_day, $conn); $timing = calc_timing($tod_day, $conn); ?> = '$MALA_CU_DAY_AR_KAR' and date='$tod_day' ) and status='0'"); // // $num_rows = mysql_num_rows($objitem); $objitem = mysql_query("select * from tbl_doctor_appointment where date='$tod_day'"); $num_rows = mysql_num_rows($objitem); $get_stats = mysqli_query($conn, "select * from tbl_doctor_appointment t1 inner join tbl_appointment t2 on t1.date = t2.appointment_date where t2. appointment_date = '$tod_day' and t2.status = 1"); // echo "select * from tbl_appointment where appointment_date='$tod_day' and status in (0,1,2,3,4)"; $get_num_stats = mysqli_num_rows($get_stats); $get_tot_app = get_tot_app($tod_day, $conn); $timing = calc_timing($tod_day, $conn); ?> = '$MALA_CU_DAY_AR_KAR' and date='$tod_day' ) and status='0'"); // $num_rows = mysql_num_rows($objitem); $objitem = mysql_query("select * from tbl_doctor_appointment where date='$tod_day'"); $num_rows = mysql_num_rows($objitem); $get_stats = mysqli_query($conn, "select * from tbl_doctor_appointment t1 inner join tbl_appointment t2 on t1.date = t2.appointment_date where t2. appointment_date = '$tod_day' and t2.status = 1"); // echo "select * from tbl_appointment where appointment_date='$tod_day' and status in (0,1,2,3,4)"; $get_num_stats = mysqli_num_rows($get_stats); $get_tot_app = get_tot_app($tod_day, $conn); $timing = calc_timing($tod_day, $conn); ?> = '$MALA_CU_DAY_AR_KAR' and date='$tod_day' and status='0'"); // "SELECT id from tbl_doctor_appointment where date >= ' and date='$MALA_CU_DAY_AR_KAR' and status='0'"; // $num_rows = mysql_num_rows($objitem); $objitem = mysql_query("select * from tbl_doctor_appointment where date='$tod_day'"); $num_rows = mysql_num_rows($objitem); $get_stats = mysqli_query($conn, "select * from tbl_doctor_appointment t1 inner join tbl_appointment t2 on t1.date = t2.appointment_date where t2. appointment_date = '$tod_day' and t2.status = 1"); // echo "select * from tbl_appointment where appointment_date='$tod_day' and status in (0,1,2,3,4)"; $get_num_stats = mysqli_num_rows($get_stats); $get_tot_app = get_tot_app($tod_day, $conn); $timing = calc_timing($tod_day, $conn); ?>
Mon Tue Wed Thu Fri Sat Sun
Monday Tuesday Wednesday Thursday Friday Saturday Sunday
0 && $day<=$maxDays) { $num_padded = sprintf("%02d", ($day+1)); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); if($day==1) { $st="st"; } if($day==2) { $st="nd"; } if($day==3) { $st="rd"; } if($day>3 && $day<=30) { $st="th"; } if($day==31) { $st="st"; } ?> 0 && $day<=$maxDays) { $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); if($day==1) { $st="st"; } if($day==2) { $st="nd"; } if($day==3) { $st="rd"; } if($day>3 && $day<=30) { $st="th"; } if($day==31) { $st="st"; } ?> 0 && $day<=$maxDays) { $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); if($day==1) { $st="st"; } if($day==2) { $st="nd"; } if($day==3) { $st="rd"; } if($day>3 && $day<=30) { $st="th"; } if($day==31) { $st="st"; } ?> 0 && $day<=$maxDays) { $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); if($day==1) { $st="st"; } if($day==2) { $st="nd"; } if($day==3) { $st="rd"; } if($day>3 && $day<=30) { $st="th"; } if($day==31) { $st="st"; } ?> 0 && $day<=$maxDays) { $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); if($day==1) { $st="st"; } if($day==2) { $st="nd"; } if($day==3) { $st="rd"; } if($day>3 && $day<=30) { $st="th"; } if($day==31) { $st="st"; } ?> 0 && $day<=$maxDays) { $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); if($day==1) { $st="st"; } if($day==2) { $st="nd"; } if($day==3) { $st="rd"; } if($day>3 && $day<=30) { $st="th"; } if($day==31) { $st="st"; } ?> 0 && $day<=$maxDays) { $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); if($day==1) { $st="st"; } if($day==2) { $st="nd"; } if($day==3) { $st="rd"; } if($day>3 && $day<=30) { $st="th"; } if($day==31) { $st="st"; } ?>
0 && $day<=$maxDays) { $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); if($day==1) { $st="st"; } if($day==2) { $st="nd"; } if($day==3) { $st="rd"; } if($day>3 && $day<=30) { $st="th"; } if($day==31) { $st="st"; } ?> 0 && $day<=$maxDays) { $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); if($day==1) { $st="st"; } if($day==2) { $st="nd"; } if($day==3) { $st="rd"; } if($day>3 && $day<=30) { $st="th"; } if($day==31) { $st="st"; } ?> 0 && $day<=$maxDays) { $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); if($day==1) { $st="st"; } if($day==2) { $st="nd"; } if($day==3) { $st="rd"; } if($day>3 && $day<=30) { $st="th"; } if($day==31) { $st="st"; } ?> 0 && $day<=$maxDays) { $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); if($day==1) { $st="st"; } if($day==2) { $st="nd"; } if($day==3) { $st="rd"; } if($day>3 && $day<=30) { $st="th"; } if($day==31) { $st="st"; } ?> 0 && $day<=$maxDays) { $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); if($day==1) { $st="st"; } if($day==2) { $st="nd"; } if($day==3) { $st="rd"; } if($day>3 && $day<=30) { $st="th"; } if($day==31) { $st="st"; } ?> 0 && $day<=$maxDays) { $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); if($day==1) { $st="st"; } if($day==2) { $st="nd"; } if($day==3) { $st="rd"; } if($day>3 && $day<=30) { $st="th"; } if($day==31) { $st="st"; } ?> 0 && $day<=$maxDays) { $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); if($day==1) { $st="st"; } if($day==2) { $st="nd"; } if($day==3) { $st="rd"; } if($day>3 && $day<=30) { $st="th"; } if($day==31) { $st="st"; } ?>
0 && $day<=$maxDays) { $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); if($day==1) { $st="st"; } if($day==2) { $st="nd"; } if($day==3) { $st="rd"; } if($day>3 && $day<=30) { $st="th"; } if($day==31) { $st="st"; } ?> 0 && $day<=$maxDays) { $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); if($day==1) { $st="st"; } if($day==2) { $st="nd"; } if($day==3) { $st="rd"; } if($day>3 && $day<=30) { $st="th"; } if($day==31) { $st="st"; } ?> 0 && $day<=$maxDays) { $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); if($day==1) { $st="st"; } if($day==2) { $st="nd"; } if($day==3) { $st="rd"; } if($day>3 && $day<=30) { $st="th"; } if($day==31) { $st="st"; } ?> 0 && $day<=$maxDays) { $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); if($day==1) { $st="st"; } if($day==2) { $st="nd"; } if($day==3) { $st="rd"; } if($day>3 && $day<=30) { $st="th"; } if($day==31) { $st="st"; } ?> 0 && $day<=$maxDays) { $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); if($day==1) { $st="st"; } if($day==2) { $st="nd"; } if($day==3) { $st="rd"; } if($day>3 && $day<=30) { $st="th"; } if($day==31) { $st="st"; } ?> 0 && $day<=$maxDays) { $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); if($day==1) { $st="st"; } if($day==2) { $st="nd"; } if($day==3) { $st="rd"; } if($day>3 && $day<=30) { $st="th"; } if($day==31) { $st="st"; } ?> 0 && $day<=$maxDays) { $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); if($day==1) { $st="st"; } if($day==2) { $st="nd"; } if($day==3) { $st="rd"; } if($day>3 && $day<=30) { $st="th"; } if($day==31) { $st="st"; } ?>
0 && $day<=$maxDays) { $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); if($day==1) { $st="st"; } if($day==2) { $st="nd"; } if($day==3) { $st="rd"; } if($day>3 && $day<=30) { $st="th"; } if($day==31) { $st="st"; } ?> 0 && $day<=$maxDays) { $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); if($day==1) { $st="st"; } if($day==2) { $st="nd"; } if($day==3) { $st="rd"; } if($day>3 && $day<=30) { $st="th"; } if($day==31) { $st="st"; } ?> 0 && $day<=$maxDays) { $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); if($day==1) { $st="st"; } if($day==2) { $st="nd"; } if($day==3) { $st="rd"; } if($day>3 && $day<=30) { $st="th"; } if($day==31) { $st="st"; } ?> 0 && $day<=$maxDays) { $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); if($day==1) { $st="st"; } if($day==2) { $st="nd"; } if($day==3) { $st="rd"; } if($day>3 && $day<=30) { $st="th"; } if($day==31) { $st="st"; } ?> 0 && $day<=$maxDays) { $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); if($day==1) { $st="st"; } if($day==2) { $st="nd"; } if($day==3) { $st="rd"; } if($day>3 && $day<=30) { $st="th"; } if($day==31) { $st="st"; } ?> 0 && $day<=$maxDays) { $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); if($day==1) { $st="st"; } if($day==2) { $st="nd"; } if($day==3) { $st="rd"; } if($day>3 && $day<=30) { $st="th"; } if($day==31) { $st="st"; } ?> 0 && $day<=$maxDays) { $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); if($day==1) { $st="st"; } if($day==2) { $st="nd"; } if($day==3) { $st="rd"; } if($day>3 && $day<=30) { $st="th"; } if($day==31) { $st="st"; } ?>
0 && $day<=$maxDays) { $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); if($day==1) { $st="st"; } if($day==2) { $st="nd"; } if($day==3) { $st="rd"; } if($day>3 && $day<=30) { $st="th"; } if($day==31) { $st="st"; } ?> 0 && $day<=$maxDays) { $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); if($day==1) { $st="st"; } if($day==2) { $st="nd"; } if($day==3) { $st="rd"; } if($day>3 && $day<=30) { $st="th"; } if($day==31) { $st="st"; } ?> 0 && $day<=$maxDays) { $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); if($day==1) { $st="st"; } if($day==2) { $st="nd"; } if($day==3) { $st="rd"; } if($day>3 && $day<=30) { $st="th"; } if($day==31) { $st="st"; } ?> 0 && $day<=$maxDays) { $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); if($day==1) { $st="st"; } if($day==2) { $st="nd"; } if($day==3) { $st="rd"; } if($day>3 && $day<=30) { $st="th"; } if($day==31) { $st="st"; } ?> 0 && $day<=$maxDays) { $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); if($day==1) { $st="st"; } if($day==2) { $st="nd"; } if($day==3) { $st="rd"; } if($day>3 && $day<=30) { $st="th"; } if($day==31) { $st="st"; } ?> 0 && $day<=$maxDays) { $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); if($day==1) { $st="st"; } if($day==2) { $st="nd"; } if($day==3) { $st="rd"; } if($day>3 && $day<=30) { $st="th"; } if($day==31) { $st="st"; } ?> 0 && $day<=$maxDays) { $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); if($day==1) { $st="st"; } if($day==2) { $st="nd"; } if($day==3) { $st="rd"; } if($day>3 && $day<=30) { $st="th"; } if($day==31) { $st="st"; } ?>
0 && $day<=$maxDays) { $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); if($day==1) { $st="st"; } if($day==2) { $st="nd"; } if($day==3) { $st="rd"; } if($day>3 && $day<=30) { $st="th"; } if($day==31) { $st="st"; } ?> 0 && $day<=$maxDays) { $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); if($day==1) { $st="st"; } if($day==2) { $st="nd"; } if($day==3) { $st="rd"; } if($day>3 && $day<=30) { $st="th"; } if($day==31) { $st="st"; } ?> 0 && $day<=$maxDays) { $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); if($day==1) { $st="st"; } if($day==2) { $st="nd"; } if($day==3) { $st="rd"; } if($day>3 && $day<=30) { $st="th"; } if($day==31) { $st="st"; } ?> 0 && $day<=$maxDays) { $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); if($day==1) { $st="st"; } if($day==2) { $st="nd"; } if($day==3) { $st="rd"; } if($day>3 && $day<=30) { $st="th"; } if($day==31) { $st="st"; } ?> 0 && $day<=$maxDays) { $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); if($day==1) { $st="st"; } if($day==2) { $st="nd"; } if($day==3) { $st="rd"; } if($day>3 && $day<=30) { $st="th"; } if($day==31) { $st="st"; } ?> 0 && $day<=$maxDays) { $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); if($day==1) { $st="st"; } if($day==2) { $st="nd"; } if($day==3) { $st="rd"; } if($day>3 && $day<=30) { $st="th"; } if($day==31) { $st="st"; } ?> 0 && $day<=$maxDays) { $num_padded = sprintf("%02d", $day); $tod_day = $year.'-'.$month.'-'.$num_padded; $n_t_d=strtotime($tod_day); if($day==1) { $st="st"; } if($day==2) { $st="nd"; } if($day==3) { $st="rd"; } if($day>3 && $day<=30) { $st="th"; } if($day==31) { $st="st"; } ?>
' . $js_code . ''; } echo $js_code; } function get_tot_app($date, $conn){ $Query = "SELECT * from tbl_doctor_appointment where date= '$date' order by date asc"; $get_app = mysqli_query($conn, $Query); while ($row_job_move_free_job = mysqli_fetch_array($get_app, MYSQLI_ASSOC)){ $new_date=$row_job_move_free_job['date']; $idss=$row_job_move_free_job['id']; //$dob=date('Y-m-d', strtotime($dob)); $appointment_date=date('Y-m-d', strtotime($new_date)); $new_ap_date=date('l', strtotime($appointment_date)); $new_date_m=date('M', strtotime($appointment_date)); $new_date_m_da=date('d', strtotime($appointment_date)); $new_id=$row_job_move_free_job['id']; $from_hour=$row_job_move_free_job['from_hour']; $from_hour_1 = sprintf("%02d", $from_hour); $from_min=$row_job_move_free_job['from_min']; $from_min_1 = sprintf("%02d", $from_min); $from_sta=$row_job_move_free_job['from_sta']; $to_hour=$row_job_move_free_job['to_hour']; $to_hour_1 = sprintf("%02d", $to_hour); $to_min=$row_job_move_free_job['to_min']; $to_min_1 = sprintf("%02d", $to_min); $to_sta=$row_job_move_free_job['to_sta']; $new_date=$row_job_move_free_job['date']; $time=strtotime($new_date); $month=date("F",$time); $year=date("Y",$time); $new_date_1=date('D', strtotime($new_date)); $new_date_m=date('M', strtotime($new_date)); $new_date_m_mas=date('d', strtotime($new_date)); $selectedTime = ''.$from_hour_1.':'.$from_min_1.' '.$from_sta.''; $selectedTime2 = ''.$to_hour_1.':'.$to_min_1.' '.$to_sta.''; $endTime = strtotime("+20 minutes", strtotime($selectedTime)); /*echo $newtime1=date('h:i a', $selectedTime); $newtime2=date('h:i a', $selectedTime2);*/ $loginTime = strtotime($selectedTime); $checkTime = strtotime($selectedTime2); $diff = $checkTime - $loginTime; //increase the time to +20 and also change the below newdiff $newdif=round($diff/1200); $new_time_ma=$selectedTime = ''.$from_hour_1.':'.$from_min_1.' '.$from_sta.''; $new_time_ma_1=strtotime($new_time_ma); return $newdif+1; } } function calc_timing($date, $conn){ $new_man_1 = mysql_query("SELECT * from tbl_doctor_appointment where date='$date' order by id asc "); $num_rows_man = mysql_num_rows($new_man_1); $row_job_man= mysql_fetch_array($new_man_1); //mas_mal $Query_job_move_free_job = mysql_query("SELECT * from tbl_doctor_appointment where date='$date' order by id asc "); $num_rows_mal = mysql_num_rows($Query_job_move_free_job); if($num_rows_mal>0) { $si=0; $totalSecondsDiff=0; $date_pagal2=""; while($row_job_move_free_job = mysql_fetch_array($Query_job_move_free_job)) { $totalSecondsDiff=0; $date_pagal2=""; ?>