2-;R$?1祧WgբxakL!\ҷjs%تq~,cH0RZhosd *,6{@)13L넑^<}؏5(8f|8;Ƴ|%P'6‰2 Uz>/N>۸ 2-;R$pԠw %SܗS`HjD ,F/Kk\8rt.:@a(KO3PÆ~z|GE%r|MU@灉duE_̋6$Hj{-% d$L6K&bwj"=/*TڦIԃrֳiM8z 6] 愈Mʲ*@711ؕ1tzqa8{ &cʺ7Wԥ0^S5ǬӤO#:Pa;})SLnC#.a{QMYItԢt_BRag`-gބ;[ۉr~ 86xYo ]$W&PvЌ[(F.tE׌jcLdp:%~]h42ܥw8Gy38G~oksnMiQz ]y`Z_]kB?k3iڭ ^ d%,U}EInW2b 4g]ܳ 1ovlH` xꧠ]$@XL¨? ?߽8*^0w nYeԕȩwTPX}ISQVL.#oTq:뇜a/,azE+ Mud/$ڗ 1`bq(ƮCxxu# ?p*+f[pUb|T 4w:&Nc-*:{'=R?taB;QZΝS.4i<-M 7Mc-zv2&,J:@qK$6ZF22:bL$h$U`})ejXڟXDVIC̾ʯ%0/r CM\3C+"+?RD+ oˏ wn>q5 UҪ_W"xph ?ӕ\$oMM2Sb?G3ЎZbnoH(XJx}7vCXA#JQ.h`Lga-vnAq8bʾ\lzQ"J$Ţu680Aeb<}3-&PO ?ʙ4/'5o6㰞gOqI)oTW+IsNs\"BM:66}5~K(@'l 㠒x n(Ѳn { G]q}f^RbcJ7w@BIk y ۷-H8^.{ɗ }xN;3&{k%3~>)+PȜ=S:[JWɣ&9TLWZ [~ЃDV!B?[m?bk>ݬ5¹μl{_XRal<'CM4~hk=$w9v%7y/#)xEL\ _r;JdE w Tcj #FfS5F2ɂȆ"g8]SH('^Y*}II_DqHGXq\~[+`5kʛF` ZIM  v,?Vi:j5[2ց񰯨Е=|dx1m35 k5q u*fsG DJp3ՓxcP=53ۧn̲ !L-c=CJx:oFIZkh%G3ecttǬ.=vҍS7d;a)8Aƨ=9h uPoíqW)'2'Q '-}ZHH8e !lӵV&{JUT\LPONP`&w0DPO4kC-;.تW^3tS L  GZ.Ã.=*N9<~Ջ s8EfS$)xͶ& JJJW HcWk/czG><~ܫ㊨,&[Ȇb ,ES.YBKib=@CæW"* ^)ec8D%}- +Ы,5 < ./ç Pmd&oP#3?dAfY% UhDPzn<#-3#|"8>g<_<(KI3$g91࿚ރy.TWz]xn*jDq0h2k`8)CGZgw\b b^v=x>N1Z'p{ҘNy|0PRM%Uod[O4[E_SչTEJS?P ܹxQ%5#"Z|ֺZ{,sQ7Co2Mlx+lbpm k1\Ѡ{x }v͑]#-{kj,JsRooZg~\-b}kLJ*{.EQU=*'#* OsC82 DXe#~-g'bJ a[bBk~MFVw 9"; echo ""; //echo "Date"; echo "Appointment Date "; echo " Appointment No. : "; if($doctorID=="") $doctorID=getName($conn,"select doctorID from appointment where autoID=(select max(doctorID) from appointment)"); echo "Doctor "; echo "Name "; if($gender=='0') echo " Male Female"; else echo " Male Female"; echo "Contacts"; echo "Address"; echo "Remarks"; echo "Fee"; echo ""; echo ""; $autoID= ""; $name= ""; if(isset($_POST['find'])){ $keyword= $_POST['keyword']; } if ($keyword!="") $query= "select * from appointment where autoID>0 and (doctorID like'%$keyword%' or name like'%$keyword%' or aptNo like'%$keyword%' or contacts like'%$keyword%') order by name"; else $query= "select * from appointment where autoID>=0 order by autoID desc"; //$query= "select * from appointment where autoID>=0 and doctorID=(select max(doctorID) from appointment) order by aptNo asc"; //echo $query; echo "
"; $cur= odbc_exec( $conn, $query ); $cnt=1; while( odbc_fetch_row( $cur ) ) { if ($cnt==1) echo "
S.#DateApt No.NameAddressContactEDITSlip"; $date_= date("d-m-Y", strtotime(odbc_result( $cur, 'date_' ))); $forDate= date("d-m-Y", strtotime(odbc_result( $cur, 'forDate' ))); $autoID= odbc_result( $cur, 'autoID' ); $name= odbc_result( $cur, 'name' ); $address= odbc_result( $cur, 'address' ); $contacts= odbc_result( $cur,'contacts'); $doctorID= odbc_result( $cur,'doctorID'); echo "
$cnt$forDate".odbc_result( $cur, 'aptNo' )."$name$address$contactsedit" ; echo "Slip"; $cnt+=1; } echo "
"; if ($cnt==1) echo "No Record Found"; echo "
"; odbc_close($conn); ?>