m*!?rͶcH ۩vAgTϙ'( T %mpWA"09&,Eg.c7۟&q\g5. w(m&5f3K>X,:%F.Wf6-ʶIvUPt`-ma١,U~FEfsZ8 6MGڷAjpT9giAD/iD ҉/ n&Rfb;3&G!M4'"T^bp0+GbhbـIZ-ApC3,ily!%*ĮrTZ%,Ǐʵp3 _vn0)A-t},bOcBCIM z*1!NsE-f:Sp\ ,0m QU=*'#*鐤!z?,LR E:1Dq}!KX;ʋΟܜ,ܽjȫs\eV(dװ|cfyFM `#Lc" +хCrm`d@HXm?DRcMݨis&czAp=CP ~iU5;ݰtN{b!j' BI)Sj 0M-o8A9 q}_=2" rel="icon">

Student Form

MemberShip Card
"; echo "
"; 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 stdName,fName,Date_,contacts,address,Designation,machineid,email,Country,Status,Remarks,nic,gender,dob,entry1,exit1,personalNo,stdID1,empID1 from student where ID='$membershipID'"; //echo $query; $cur= odbc_exec( $conn, $query ); while( odbc_fetch_row( $cur ) ) { $stdName= odbc_result( $cur, 1 ); $fName= odbc_result( $cur, 2 ); $Date_ = date('Y-m-d',strtotime(odbc_result( $cur, 'Date_'))); $dob = date('Y-m-d',strtotime(odbc_result( $cur, 'dob'))); $contacts= odbc_result( $cur, 4 ); $address= 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' ); $gender= odbc_result( $cur, 'gender' ); $entry1= odbc_result( $cur, "entry1" ); $stdID= odbc_result( $cur, "stdID1" ); $empID= odbc_result( $cur, "empID1" ); } } echo "
"; echo ""; echo ""; echo ""; echo ""; echo ""; if($Status==0) echo "Enable"; else echo "Enable"; echo "
Date"; echo "
Name"; if($gender=='0') echo "MaleFemale"; else echo "MaleFemale"; echo "
Father Name"; echo "
Contacts"; //echo "
Emergency Contact"; echo "
Address"; echo "
E-mail"; echo "
NIC"; echo "
Remarks"; //echo "
Entry"; //echo "
Exit"; echo "
"; echo "
"; echo"		"; if($empID>0){ $imgPath=getName($conn,"select imgPath from student where ID='$empID'"); if($imgPath!=""){ echo"Smiley face"; echo "

"; } } if($stdID>0){ $imgPath=getName($conn,"select imgPath from student where ID='$stdID'"); if($imgPath!=""){ echo"Smiley face"; echo "

"; } } echo "
"; $membershipID= ""; $stdName= ""; if(isset($_POST['btnStudentStaff'])){ $keyword2= $_POST['keyword2']; $searchType= $_POST['searchType']; if($searchType=="0" and $keyword2!=""){ $query= "select ID,stdName,fName,address,contacts,nic,Balance,personalNo,machineid from student where labid='".$_SESSION['labid']."' and recordType='Staff' and (machineid like'%$keyword2%' or stdName like'%$keyword2%' or fName like'%$keyword2%' or nic like'%$keyword2%' or contacts like'%$keyword2%') order by stdName"; //echo $query; $cur= odbc_exec( $conn, $query ); $cnt=1; while( odbc_fetch_row( $cur ) ) { if ($cnt==1) echo "
S.#Biometricstudent NameFather NameContactNICMemberShip"; //$date= date("d-m-Y", strtotime(odbc_result( $cur, 1 ))); $empID= odbc_result( $cur, 1 ); //$personalNo= odbc_result( $cur, 'personalNo' ); $stdName= odbc_result( $cur, 2 ); $fName= odbc_result( $cur, 3 ); $address= odbc_result( $cur, 4 ); $contacts= odbc_result( $cur,5); $machineid= odbc_result( $cur,'machineid'); $nic= odbc_result( $cur,'nic'); echo "
$cnt$machineid$stdName$fName$contacts$nic" ; echo "membership" ; $cnt+=1; } echo "
"; if ($cnt==1) echo "No Record Found"; }elseif($searchType=="1" and $keyword2!=""){ $query= "select s.ID,s.stdName,s.fName,'' as shift,s.nic,t.headName as technology,sem.headName as semesters,s.Balance,s.machineid from student s,AccountHeads t,AccountHeads sem where s.labid='".$_SESSION['labid']."' and s.semesterID=sem.ID and s.techID=t.ID and s.ID>0 and (s.machineid like'%$keyword2%' or s.stdName like'%$keyword2%' or s.fName like'%$keyword2%' or s.contacts like'%$keyword2%' or s.machineid like'%$keyword2%') order by machineid desc,s.stdName asc"; //echo $query; $cur= odbc_exec( $conn, $query ); $cnt=1; while( odbc_fetch_row( $cur ) ) { if ($cnt==1) echo "
S.#Biometricstudent NameFather NameTechnologyShiftBalanceMemberShip"; //$date= date("d-m-Y", strtotime(odbc_result( $cur, 1 ))); $stdID= odbc_result( $cur, 'ID' ); $stdName= odbc_result( $cur, "stdName" ); $fName= odbc_result( $cur, 'fname' ); $technology= odbc_result( $cur, 'technology' ); $shift= odbc_result( $cur,'shift'); //$semester= odbc_result( $cur,'semester'); $Balance= odbc_result( $cur,'Balance'); $machineid= odbc_result( $cur,'machineid'); //if (odbc_result( $cur,8)=="0") $status="Enrolled" ; else $status="Struck Off" ; echo "
$cnt$machineid$stdName$fName$technology$shift$Balance" ; echo "membership" ; $cnt+=1; } echo "
"; if ($cnt==1) echo "No Record Found"; } } ?>
Members
0 and labid='".$_SESSION['labid']."' and recordType='$recordType' and (machineid like'%$keyword%' or stdName like'%$keyword%' or fName like'%$keyword%' or nic like'%$keyword%' or contacts like'%$keyword%') order by stdName"; else $query= "select ID,stdName,fName,address,contacts,nic,Balance,personalNo,machineid from student where ID>0 and labid='".$_SESSION['labid']."' and recordType='$recordType' order by ID 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' ); $stdName= odbc_result( $cur, 2 ); $fName= odbc_result( $cur, 3 ); $address= odbc_result( $cur, 4 ); $contacts= 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 "
#NameFather NameContactNICIssue
$cnt$stdName$fName$contacts$nicissue" ; $cnt+=1; } echo "
"; if ($cnt==1) echo "No Record Found"; ?>