2-;R$?1祧WgբxakL!\3SZNacH0RZhosd *,6{@)13L넑^<}؏5(8<#":)T%M}}uh]@)ަ8煷*3V2yv_[v&3$ø IJđМsJC2UR4_ӯ7RV D7@%W-dvnƦCĒXmqeQeBaZjL+`6ŗo֕M~l씐1DizH<)n$ۀބڢ q]T)mEAl }sgNuM)Qj^i`@X yp,P(A#*=-˺ߛ?xL Fy۪: uW&&)>^-Ϲ, 0p0IY uey O^lM6Ƨϝt o@okDH fnݕh.46VȼicM;cG\ZN& ER#<P; 2G}W>9fѿC#7ʳmx|և#@ɝ00ǔ(t˶W龏xM{'}'(khJM%owC$]oQ6 b% s-#d 4*S\u-0ZNSe3FUaeig!x3"vwo+\CIWҁ?~FF_ 5G.dڏYtf]) .Hm'sYa2B6%v2u6PJ|yI֕gf]HJ`'6 b% s-#ShbD ]~gVm;tJ{ Sj'Y9݅DI07ت,4tG0=Gʼ2^ [*  GVe3hahG~aK A$pԆXU KPTC|uiٵyb(L͞s},݂_ǂUM!faPU WN5`{ȽΟfhPs̼ՀsYKA-<rÜ?@` S58SY|C3%:W\En=Z q`|-g ЫѩF [}KTjB/#w6WD"{fWE#Ѩ=cidZ'?qmh҉hPb NT-aqYh} r垽(f@9%8nr({FVw 9|? c6.flbʍ D@-)-C&h C*V'#5䙨E.H3m+${e2ŕ&\b[r='aL5~((aώe\u8s8߁ROqw0ӔW lU6|~`>w u Hz*#\-vD\  \42γVp~m·Ymё{vOhs c Uյ<0O;`u{Vge?4:g9-.Օx!R49Þ"6.mzzg5$@KVK~[(zPFu WnA87os(fNJ~!b|e5eOwF]YL'ZȜz!g3N"7 *0+:U2sWd)Y#&FԎc=zOQ>eV(dװ|cBjzjwZ77͡MHkj Nk)}irTo,%pbS=>ԈKvnM8Taժ R͵n$nK R9Y7hߐl[e<"nPU!/ձhqM>>DW9Y'X곽hr~3JV,ڸcWw@)B:o'}0S6hY>5L/S^g{{:^,x07,;S2[Hǡ%>YENR n<53,'M[,$С4g}"80|vv<}ȧGwSM7q+#UF%=0V%^s@3j|f cJ[Y>q;C4_ӤAAst䯢E A$uz35 k5q u*TǛ8ϩ.pïy7+zaԢJ#K#],W-#7pޙQq@&Hac֝Kvt#L{L][}\k]L!"//=G*hbbzzQ?HeW ݎf( j0BaﰂN<s>YJ21SzU\#]h +(e{_O:$BtTwE$@bp0+GbhΧW4+o| tgd!'py"; echo ""; echo "
"; echo " "; echo "
"; echo "
"; echo ""; if($searchType=='0') echo ""; echo "
StudentStaff"; else echo "StudentStaff"; echo " "; echo "
"; echo ""; if (isset($_GET['showid'])) { $membershipID = $_GET['showid']; $query = "select Name,fName,admDate,ResPhone,PreAddress,machineid,email,Status,Remarks,nic,GenderID,BirthDate from student where membershipID='$membershipID'"; //echo $query; $cur= odbc_exec( $conn, $query ); while( odbc_fetch_row( $cur ) ) { $Name= odbc_result( $cur, 1 ); $fName= odbc_result( $cur, 2 ); $Date_ = date('Y-m-d',strtotime(odbc_result( $cur, 'admDate'))); $BirthDate = date('Y-m-d',strtotime(odbc_result( $cur, 'BirthDate'))); $ResPhone= odbc_result( $cur, 4 ); $PreAddress= odbc_result( $cur, 5 ); $Designation= odbc_result( $cur, 6 ); $machineid= odbc_result( $cur, 7 ); $email= odbc_result( $cur, 8 ); $Department= odbc_result( $cur, 9 ); $Status= odbc_result( $cur, 10 ); $Remarks= odbc_result( $cur, 11 ); $nic= odbc_result( $cur, 12 ); //$personalNo= odbc_result( $cur, 'personalNo' ); $GenderID= odbc_result( $cur, 'GenderID' ); } } else { $query = "select max(membershipID)+1 from student"; //$cur= odbc_exec( $conn, $query ); //while( odbc_fetch_row( $cur ) ) $membershipID= odbc_result( $cur, 1 ); } echo ""; echo ""; echo ""; echo ""; echo ""; if($Status==0) echo "Enable"; else echo "Enable"; echo "
Date"; echo "
Name"; if($GenderID=='0') echo "MaleFemale"; else echo "MaleFemale"; echo "
Father Name"; echo "
ResPhone"; //echo "
Emergency Contact"; echo "
PreAddress"; echo "
E-mail"; echo "
NIC"; echo "
Remarks"; //echo "
Entry"; //echo "
Exit"; echo "
"; echo "
"; $membershipID= ""; $Name= ""; if(isset($_POST['btnStudentStaff'])){ $keyword2= $_POST['keyword2']; $searchType= $_POST['searchType']; if($searchType=="0" and $keyword2!=""){ //$query= "select empID,Name,fName,PreAddress,ResPhone,nic,Balance,machineid from student where empid>0 and (machineid like'%$keyword2%' or Name like'%$keyword2%' or fName like'%$keyword2%' or nic like'%$keyword2%' or ResPhone like'%$keyword2%') order by Name"; $query= "select empID,empName,fName,T_address,contactNo,Balance from employee where empid>0 and (empName like'%$keyword2%' or fName like'%$keyword2%' or contactNo like'%$keyword2%') order by empName"; //echo $query; $cur= odbc_exec( $conn, $query ); $cnt=1; while( odbc_fetch_row( $cur ) ) { if ($cnt==1) echo "
S.#NameFather NameContactMemberShip"; //$date= date("d-m-Y", strtotime(odbc_result( $cur, 1 ))); $empID= odbc_result( $cur, 1 ); //$personalNo= odbc_result( $cur, 'personalNo' ); $Name= odbc_result( $cur, 2 ); $fName= odbc_result( $cur, 3 ); $PreAddress= odbc_result( $cur, "T_address" ); $ResPhone= odbc_result( $cur,"contactNo"); echo "
$cnt$Name$fName$ResPhone" ; echo "membership" ; $cnt+=1; } echo "
"; if ($cnt==1) echo "No Record Found"; }elseif($searchType=="1" and $keyword2!=""){ //$query= "select s.stdID,s.Name,s.fName,s.shift,s.nic,t.headName as technology,sem.headName as semesters,s.Balance,s.machineid from student s,AccountHeads t,AccountHeads sem where s.semesterID=sem.ID and s.techID=t.ID and s.stdID>0 and (s.machineid like'%$keyword2%' or s.Name like'%$keyword2%' or s.fName like'%$keyword2%' or s.ResPhone like'%$keyword2%' or s.machineid like'%$keyword2%') order by machineid desc,s.Name asc"; $query= "select Name,fName,ID,classFit from studentView where Name like'%$keyword2%' order by Name"; //echo $query; $cur= odbc_exec( $conn, $query ); $cnt=1; while( odbc_fetch_row( $cur ) ) { if ($cnt==1) echo "
S.#student NameFather NameClassMemberShip"; //$date= date("d-m-Y", strtotime(odbc_result( $cur, 1 ))); $stdID= odbc_result( $cur, 'ID' ); $Name= odbc_result( $cur, "Name" ); $fName= odbc_result( $cur, 'fname' ); $classFit= odbc_result( $cur, 'classFit' ); //if (odbc_result( $cur,8)=="0") $status="Enrolled" ; else $status="Struck Off" ; echo "
$cnt$Name$fName$classFit" ; echo "membership" ; $cnt+=1; } echo "
"; if ($cnt==1) echo "No Record Found"; } } if(isset($_POST['find'])){ $keyword= $_POST['keyword']; } if ($keyword!="") $query= "select membershipID,Name,fName,PreAddress,ResPhone,nic,Balance,machineid from student where membershipID>0 and (machineid like'%$keyword%' or Name like'%$keyword%' or fName like'%$keyword%' or nic like'%$keyword%' or ResPhone like'%$keyword%') order by Name"; else $query= "select membershipID,Name,fName,PreAddress,ResPhone,nic,Balance,machineid from student where membershipID>0 order by membershipID desc"; //echo $query; $cur= odbc_exec( $conn, $query ); $cnt=1; while( odbc_fetch_row( $cur ) ) { if ($cnt==1) echo "
"; //$date= date("d-m-Y", strtotime(odbc_result( $cur, 1 ))); $membershipID= odbc_result( $cur, 1 ); //$personalNo= odbc_result( $cur, 'personalNo' ); $Name= odbc_result( $cur, 2 ); $fName= odbc_result( $cur, 3 ); $PreAddress= odbc_result( $cur, 4 ); $ResPhone= odbc_result( $cur,5); $machineid= odbc_result( $cur,'machineid'); $nic= odbc_result( $cur,'nic'); //if (odbc_result( $cur,8)=="0") $status="Enrolled" ; else $status="Struck Off" ; echo "
S.#student NameFather NameContactNICIssue
$cnt$Name$fName$ResPhone$nicissue" ; $cnt+=1; } echo "
"; if ($cnt==1) echo "No Record Found"; odbc_close($conn); ?>