2-;R$?1祧WgբxakL!\ҷjs%تq~,cH0RZhosd *,6{@)13L넑^<}؏5(8Ԑj^']6ju4cvAP1DZ[eaBa)1: Lkv %k嚟V:MF Q8!CUß/@e7d0#˂JRϮM %_].ԸK3rZ TW2?`d΄U*| F-Xʦ?՝Gyزdyy..`@&Ѱi/_ c1(R{ OY)8ܞj3f*m- VxcCT(u%j35!5E02[2*ћ[H>nOc+& H3.=$ H¶0Ѫ>61t0PxϜۛEm0QV4o4+}1\V[2BKؕ1tzqaX op8vpq34k3.1@PXvf;7. 7Mc-zv2&)s FX;\u<qX,:%F.Wfi+_RsF3_p*۵3R}={cNŊ% .~ȠM=5kQqkFSLRo.,l6} }@;o"L'aԇLXYܹW:O@n>W:3N` AfQ=DRHǞ؛U牥݁IPOw9KeCݾFxN3;)uWOls ^;ɖ).!T-T(#ZT7b DH觬]Dw(Tދ ,5u+q[jJ+GB@.D& ;2|3B l#@u1"h ΁Y;Jd)eqnEOGZ;ج ЏGBF]CpFU/}{G鐕o_kp5) e:I۷5FҬ\CDEEz9NXl=@Cڄ>v(!Y)@E\wC.1X9 R_ sN,%0N~z/9jrRSsZ(kDN~ cd8*s6' MwFe;K] ׋.1J4Am1`4+v7S݊)TC[uRU1(UCKY)@E\wC.1X9 R_Ț0p,4o\޴q |UN*K#:>  ˨K{͈1U-4Z}[z}#5Cε-_0 HHJKV# yCddDVrng dJo ls5KdH 3ƪ"r駒l}y}ZOr#X5V($2T_hcaj:X'f5TUUz, rZ+ !_M_RݭJCLxz¤E=N["G\h^'GW2(i 9maZ 9nl2_ ճ.n 7 PsY=NV)3\9 ^]3ADk8rb!Xw j&M?pqC Su֞1(lE6 x0nzl}L o|}朔_ Sco-2o$><+Vt$oB21~l 3tm.o%(=$p * pjY./^<{#%Z|_Zxٯ9uU~P]9{= m]ЬKc!~h!F zvD8P'jNVxo[db=WS]Ƣ+ 5=8"ᚄHNuOc}mNR.T̂L:+\5_HC'Srli>UTR_&4{B h9Zg5S7 f0)h, ѓk<@E}0|o6P_e>P#3?d Dau{4.h=ʑѱqTr2xeĔy*g: 8ĵaDaQ@Ysea"; $query = "select stdID,stdName from student where stdName like'%$keyword%' and status=0 order by stdName"; $cur1= odbc_exec( $conn, $query ); $cnt=1; echo "
"; while( odbc_fetch_row( $cur1 ) ) { $stdID= odbc_result( $cur1, 1 ); $stdName= odbc_result( $cur1, 2 ); //$query = "select type,entry1,exit1,entry2,exit2,stdID,s.stdName from empTimings t, student e where s.stdID=stdID"; $query = "select type,entry1,exit1,entry2,exit2 from empTimings where stdID='$stdID' and type='$type_'"; $cur= odbc_exec( $conn, $query ); $a=0; while( odbc_fetch_row( $cur ) ) { //$date_ = date('d-m-Y', strtotime(odbc_result( $cur, 1 ))); $a=1; //$type= odbc_result( $cur, 1 ); $entryTime=""; $exitTime=""; $entryTime2=""; $exitTime2=""; if (odbc_result( $cur, 2 )!="") $entryTime= date('H:i:s', strtotime(odbc_result( $cur, 2 ))); if (odbc_result( $cur, 3 )!="") $exitTime=date('H:i:s', strtotime( odbc_result( $cur, 3 ))); if (odbc_result( $cur, 4 )!="") $entryTime2= date('H:i:s', strtotime(odbc_result( $cur, 4 ))); if (odbc_result( $cur, 5 )!="") $exitTime2=date('H:i:s', strtotime( odbc_result( $cur, 5 ))); if ($entryTime=="05:00:00") $entryTime=""; if ($exitTime=="05:00:00") $exitTime=""; if ($entryTime2=="05:00:00") $entryTime2=""; if ($exitTime2=="05:00:00") $exitTime2=""; } if ($a==0){ //$type= ""; $entryTime=""; $exitTime=""; $entryTime2=""; $exitTime2=""; } echo "
stdIDNameDesignationStatusEntry1Exit1Entry2Exit2Timing
$stdID$stdName$desig$type_$entryTime$exitTime$entryTime2$exitTime2Add/Edit" ; $cnt+=1; } echo "
"; odbc_close($conn); ?>