Wduw{Aó*19ôKam*t}:V꯰CQLucG?Κn"҃j!ິ>s΂J1j\[;$8YJ&1vnZ29r7W\G0 n,|c&3D|pMF2AG@ʦ1i?^##Am2]o U0\񨭍h2KhmX+bhe>L`YV)Me-.⣎OkǥfCA젏r*H~hݞ+A[,$С4g}3gn5:sbH4;>Tc8Pv+!YG˔n\GNэhx@R~'=&`kD *3VuJ)P'ӛ&/`G"ps=eR{0# Z*I]Wgep/9y&Y4dAdGV\DE.CFUQŧ{'k;\By@E1{h4w6m1yh$o**-MR [8ufrR Ʊ5A=6JBG,.I^~5("_Zqm $ٹ;X:|~Ջ s8e6RIUطd .Hm'sG5Dl]z3lkdf??#b&m2#iwcD6uP\CIWҁ?~F;^~HEDD[,rU NԺf8n Г.}i5G)1 9EVj$߹J`y8‚(EQ/+*N)'uQ})^yWY8ZEnG%pļ |$H{-zn?6:wtkr~@qaaRSe3FUaeig!31 Ǧ 5Y01\Zo|;Vtֈ)D?4" kp3F495)xSoٕN-UgB>.(d=9B>ebї\-vD\c}8? 04_À%؇BqQp׺L}{] Uյ<0O;`u"q;" keTH{s؊F d",I2(uP * 7Mc-zv2&,J:@qK$6$! xT~hytm>-B{ꏅW87cm$d &UjPն(4 ^Ԅd\{2 ڍEU~ { O¦ӆ Uյ<0O;`uB) t8ϚBxk_u VT 1)nYDH0c=Mk o͡ŕ_`YkXǁwy`l&;1 6Ap?=dZp3iڭ ^ d%,U} Zxx¸"vKKyt1'q|5XL0" /ƚ鄤I3sûQET mXx@.tlR_FL' )קHCF9w0n#Qcxی@ $10 5%a&W:F2$˾hF* -gL}{] Uյ<0O;`ume `L@KE K^S.sy:Hws3bLMQ|z$X)/ skztuJ7Fp3ؖUي &yxnNֻsIP]V)f)DZ{( ̥un| ]Un"80|vv hFc+m/#gTCmB],{y(fS׿8MK(X 4mng])t&Un,-f;0jD!C`z͗aC-?qSP a4{8@qԥ0^S5ǬӤO#sUI<{cI#rA%4YIC-Py^Q+,{ʸy^F-PCo6L7AG?SI5rX7.|n4}mBvHg޲|xraeuЈa:P08|8?eF["e]c 7 7|_S8'蠛+h@nD)zL()399DYS@gBOzZxT <;sރ')I7mJ* 7Φ:-`LHhb.Mϧn[@ȧlJMVK; tyKS &|2KQIW79aJPmlvm;=!0!ybrpCA o/J;̺=v͂7ooN4 qlW8N|{;YfmthO8#KGCƶ1 m Ba&u KJ${\̐fۉ2~5\"8MK(X 4m(\‰NvxR g2hh=Q4sDFvQ(;^-vSi~g޻tcZhɶ`/F/S))^n2{kk*ItmP!,[2y{,BØGZx ZoJiF}Q!'eVgo0b,\%WpZA(/=UmZR*=T$9`f$Nvsqr9{OQ  jdG cz)Cn*֫>u/>gjjw z``kݻf!MOIFu.~֠--yZB >q>z!ϴXJj _ǃUG/ OlW%2޿  =hrh+dD@zL^tjջjMẙs N"-?4齭dGp幀I(\%WpZA(2 K 1hJSک9(ɯ թێ9][\I[-KJi45uQ:AQyd5wC+*&x:Ԟ'4VM \:~Uj(&JbRꗣR/ {aOi^. F_m?2t"sg4ʖ[+̞xyhH^q#lUcn|&+seA,ȎK%xCr|v=Mn M}}bHX?Əbk]:v VxQ}me($_FILES["fileToUpload"]["name"]); $target_file = $_SESSION['photosFolder']."/".$picname; if(move_uploaded_file($temp_name, $target_file)){ //$oldImg=getName($conn,"select img from kpDatatbl where autoID='$autoID' and labid='".$_SESSION['labid']."' and recordType='$recordType'"); if ($oldImg!="") unlink($_SESSION['photosFolder']."/$oldImg"); $query="update kpDatatbl set img='$picname' where autoID='$autoID' and labid='".$_SESSION['labid']."' and recordType='$recordType' "; $cur= odbc_exec( $conn, $query ); } */ //exit(); echo ""; } if (isset($_GET['dob'])) $dob = $_GET['dob']; if (isset($_GET['ID'])) $dob = $_GET['ID']; if (isset($_GET['delinvno'])){ //$cur=odbc_exec($conn,"delete from kpDatatbl where autoID='".$_GET['delinvno']."' and labid='".$_SESSION['labid']."' and recordType='$recordType' "); $cur=odbc_exec($conn,"delete from kpDatatbl where autoID='".$_GET['delinvno']."' "); echo ""; } if (isset($_GET['editinvno'])){ //$dob = $_GET['dob']; $query="select * from kpDatatbl where autoID='".$_GET['editinvno']."' and labid='".$_SESSION['labid']."' and recordType='$recordType' "; $cur=odbc_exec($conn,$query); while( odbc_fetch_row( $cur ) ) { $from=$date_= date("Y-m-d", strtotime(odbc_result( $cur, 'date_' ))); $dob= date("Y-m-d", strtotime(odbc_result( $cur, 'dob' ))); $dob=odbc_result($cur,'dob'); $autoID=odbc_result($cur,'autoID'); $pName=odbc_result($cur,'pName'); $address=odbc_result($cur,'address'); $district=odbc_result($cur,'district'); $hospitalName=odbc_result($cur,'hospitalName'); $ageStatus=odbc_result($cur,'ageStatus'); $mrno=odbc_result($cur,'mrno'); $age=odbc_result($cur,'age'); } } ?> HOME
From Date
To Date
Hospital
Address
Department


Import Data"; $query= "select autoID,date_,dob,pName,mrno,address,hospitalName,department,DATEDIFF(day, dob,date_) AS days from kpDatatbl where (date_ between '$from' and '$to')"; if($address!="") $query.=" and address='$address' "; if($hospitalName!="") $query.=" and hospitalName='$hospitalName' "; if($department!="") $query.=" and department='$department' "; $query.=" order by date_ asc,autoID asc"; //echo $query; $cur= odbc_exec( $conn, $query ); $cnt=1; while( odbc_fetch_row( $cur ) ) { //if ($cnt==1) echo "
#DateMR No.Patient NameDOBAddressHospitalDepartment"; if ($cnt==1) echo "
#DateMR No.Patient NameDOBAddressHospitalDepartment"; $date2= date("d.m.y", strtotime(odbc_result( $cur, 'date_' ))); $autoID=odbc_result($cur,'autoID'); echo "
".$cnt++."$date2"; echo "".odbc_result($cur,'mrno'); echo "".odbc_result($cur,'pName').""; echo "".date("d.m.y", strtotime(odbc_result( $cur, 'dob' ))); //echo "".toAge((odbc_result( $cur, 'date_' )),odbc_result($cur,'dob')); //echo "".odbc_result( $cur, 'days' ); echo "".odbc_result( $cur, 'address' ); //echo "".odbc_result( $cur, 'district' );//factory weight echo "".odbc_result( $cur, 'hospitalName' ); echo "".odbc_result( $cur, 'department'); //echo "" ; //echo "" ; } echo "
"; ?>