= '".dmyE2ymdT($_REQUEST['dateStart'])."' AND history_absent_tb.Date_finish <= '".dmyE2ymdT($_REQUEST['dateFinish'])."' "; $query = " SELECT *, prefixName as First_name FROM history_absent_tb LEFT JOIN personal_tb ON history_absent_tb.Teacher_code = personal_tb.Teacher_code LEFT JOIN prefix ON personal_tb.First_name = prefix.prefixId WHERE history_absent_tb.Date_start >= '".dmyE2ymdT($_REQUEST['dateStart'])."' AND history_absent_tb.Date_finish <= '".dmyE2ymdT($_REQUEST['dateFinish'])."' "; $result = $dbObj->execQuery($query); ?>
¢éÍÁÙÅ¡ÒÃÅÒ µÑé§áµèÇѹ·Õè =($_REQUEST['dateStart'])?dmyE2dmyT($_REQUEST['dateStart']):dmyE2dmyT(date("d/m/Y"));?> ¶Ö§Çѹ·Õè =($_REQUEST['dateFinish'])?dmyE2dmyT($_REQUEST['dateFinish']):dmyE2dmyT(date("d/m/Y"));?> | ||||
No | ª×èÍ | àÃ×èͧ | ÃÐËÇèÒ§Çѹ·Õè | ¨Ó¹Ç¹Çѹ·ÕèÅÒ |
=$no;?> | execQuery($query); $rs2 = $dbObj->fetchArray($result2); $dbObj->freeresult($result1); echo " $rs2[Absent_type] "; ?> | - | execQuery($query); // $rs3 = $dbObj->fetchArray($result3); // $dbObj->freeresult($result3); echo " $rs[Absent_times] "; ?> |