Gecko [ 43.229.15.234 ]

Name	Size	Permission
ExpectedLastSal	[ DIR ]	drwxr-xr-x
FringerTham	[ DIR ]	drwxr-xr-x
SignetureSample	[ DIR ]	drwxr-xr-x
delcrearation	[ DIR ]	drwxr-xr-x
photo	[ DIR ]	drwxr-xr-x
ajaxviewgrade.php	544 B	-rw-r--r--
general.php	26.11 KB	-rw-r--r--
general_allemp.php	13.46 KB	-rw-r--r--
general_editor.php	47.52 KB	-rw-r--r--
general_list.php	11.51 KB	-rw-r--r--
general_report.php	23.71 KB	-rw-r--r--
pdsreport.php	72.99 KB	-rw-r--r--

Code Editor : general.php

<?php
       session_start();
       include("../common/config.php");
	   include("../common/functions.php");
	   
	  if(empty($_SESSION["username"])) 
	   {
	     Header("Location: ../login/login.php");
	    }

$cmd = $_REQUEST['cmd'];
	   switch($cmd)
	   {
	     
		  case 'add': 
		   
			if(!empty($_REQUEST["id"])){
					// prepare and bind for Maximum Number
					$stmt = $conn->prepare("SELECT * FROM general WHERE id = ?");
					$stmt->bind_param("i",$_REQUEST["id"]);
					$stmt->execute();

//Result
					$result = $stmt->get_result();						
					while($row = $result->fetch_assoc()){
						$photo = $row["photo"];
						$FringerTham = $row["FringerTham"];
						$SignetureSample = $row["SignetureSample"];
						$delcrearation = $row["delcrearation"];
						$ExpectedLastSal = $row["ExpectedLastSal"];					
					}
			}

// prepare and bind for Maximum Number
			$stmt = $conn->prepare("SELECT IFNULL(max(id),0)+1 AS id FROM general");
			$stmt->execute();

//Result
			$result = $stmt->get_result();	
			$numrows=$result->num_rows;
			
			while($row = $result->fetch_assoc()){ $max = $row["id"];}	
			  
   
			//Photo File   
			if(strlen($_FILES['photo']['name'])>0 && $_FILES['photo']['size']>0)
			{
				
				if(!file_exists("photo"))
				{ 
				   mkdir("photo",0755);	
				}
				if(empty($_REQUEST['id']))
				{
				  $file=$max."_".str_replace(" ","_",strtolower(trim($_FILES['photo']['name'])));
				}
				else
				{
				  $file=trim($_REQUEST['id'])."_".str_replace(" ","_",strtolower(trim($_FILES['photo']['name'])));
				}
				$filePath="photo/".$file;
				move_uploaded_file($_FILES['photo']['tmp_name'],$filePath);
			   $photo="photo/".trim($file);
			 }

//Finger Print    
			if(strlen($_FILES['FringerTham']['name'])>0 && $_FILES['FringerTham']['size']>0)
			{
				
				if(!file_exists("FringerTham"))
				{ 
				   mkdir("FringerTham",0755);	
				}
				if(empty($_REQUEST['id']))
				{
				  $file=$max."_".str_replace(" ","_",strtolower(trim($_FILES['FringerTham']['name'])));
				}
				else
				{
				  $file=trim($_REQUEST['id'])."_".str_replace(" ","_",strtolower(trim($_FILES['FringerTham']['name'])));
				}
				$filePath="FringerTham/".$file;
				move_uploaded_file($_FILES['FringerTham']['tmp_name'],$filePath);
			   $FringerTham="FringerTham/".trim($file);
			 }

//Signataure   
			if(strlen($_FILES['SignetureSample']['name'])>0 && $_FILES['SignetureSample']['size']>0)
			{
				
				if(!file_exists("SignetureSample"))
				{ 
				   mkdir("SignetureSample",0755);	
				}
				if(empty($_REQUEST['id']))
				{
				  $file=$max."_".str_replace(" ","_",strtolower(trim($_FILES['SignetureSample']['name'])));
				}
				else
				{
				  $file=trim($_REQUEST['id'])."_".str_replace(" ","_",strtolower(trim($_FILES['SignetureSample']['name'])));
				}
				$filePath="SignetureSample/".$file;
				move_uploaded_file($_FILES['SignetureSample']['tmp_name'],$filePath);
			   $SignetureSample="SignetureSample/".trim($file);
			 }

//delcrearation   
			if(strlen($_FILES['delcrearation']['name'])>0 && $_FILES['delcrearation']['size']>0)
			{
				
				if(!file_exists("delcrearation"))
				{ 
				   mkdir("delcrearation",0755);	
				}
				if(empty($_REQUEST['id']))
				{
				  $file=$max."_".str_replace(" ","_",strtolower(trim($_FILES['delcrearation']['name'])));
				}
				else
				{
				  $file=trim($_REQUEST['id'])."_".str_replace(" ","_",strtolower(trim($_FILES['delcrearation']['name'])));
				}
				$filePath="delcrearation/".$file;
				move_uploaded_file($_FILES['delcrearation']['tmp_name'],$filePath);
			   $delcrearation="delcrearation/".trim($file);
			 }

//ExpectedLastSal   
			if(strlen($_FILES['ExpectedLastSal']['name'])>0 && $_FILES['ExpectedLastSal']['size']>0)
			{
				
				if(!file_exists("ExpectedLastSal"))
				{ 
				mkdir("ExpectedLastSal",0755);	
				}
				if(empty($_REQUEST['id']))
				{
				$file=$max."_".str_replace(" ","_",strtolower(trim($_FILES['ExpectedLastSal']['name'])));
				}
				else
				{
				$file=trim($_REQUEST['id'])."_".str_replace(" ","_",strtolower(trim($_FILES['ExpectedLastSal']['name'])));
				}
				$filePath="ExpectedLastSal/".$file;
				move_uploaded_file($_FILES['ExpectedLastSal']['tmp_name'],$filePath);
		 	$ExpectedLastSal="ExpectedLastSal/".trim($file);
			}

if (strlen($max)==1)
			{
				$GovtId="00000".$max;
			}
			if (strlen($max)==2)
			{
				$GovtId="0000".$max;
			}
			if (strlen($max)==3)
			{
				$GovtId="000".$max;
			}
			if (strlen($max)==4)
			{
				$GovtId="00".$max;
			}
			if (strlen($max)==5)
			{
				$GovtId="0".$max;
			}

if(empty($_SESSION["pimsid"]))
			{
				$_SESSION["pimsid"]=$GovtId;
			}

if(empty($_REQUEST['id']))
				{
					
					$stmt = $conn->prepare("INSERT INTO general ( 
														photo,
														GovtId,		
														NameB,		
														NameE,		
														FatherB,
														
														FatherE,		
														MotherB,		
														MotherE,		
														NationalID,		
														PassportNo,
														
														PassIssueDate,		
														PassLastDate,		
														dob,		
														BirthCertificateNo,		
														PersonalEmail,	
														
														OfficialEmail,		
														district_id,		
														designation_id,		
														office_id,		
														CaderName,
														
														CaderDate,		
														BatchNo,		
														FredomFighter_id,		
														FredomChildGrand_id,		
														triballist_id,		
														
														sex_id,		
														MaritualStatus_id,		
														religion_id,		
														profsubject_id,		
														grade_id,
														
														CurrScale_id,		
														SalBasic,															
														ProjectName,		
														emptype_id,		
														FirstJoinDate,		
														
														EedJoinDate,		
														EedCDJoinDate,		
														CLJoinDate,		
														PLJoindate,		
														RegularDate,		
														
														PermanentDate,		
														GovtResident_id,																	
														LprDesignation_id,		
														AnutoshikClass,															
														Teliphone_id,
														
														ElectricityBill_id,		
														Vhechilefair_id,		
														HouseRent_id,		
														delcrearation,		
														ExpectedLastSal,

VheInfo_id,		
														FringerTham,															
														SignetureSample,														
														emptypenow_id,
														entrydate,

districtoffice_id,
														status_id,		
														userinfo_id,
														meritno																										
														) 
														VALUES 
														(?,
														?,														
														?,
														?,
														?,
														
														?,
														?,
														?,
														?,
														?,
														
														?,
														?,
														?,
														?,
														?,
														
														?,
														?,
														?,
														?,
														?,
														
														?,
														?,
														?,
														?,
														?,
														
														?,
														?,
														?,
														?,
														?,
														
														?,
														?,
														?,
														?,
														?,
														
														?,
														?,
														?,
														?,
														?,

?,
														?,
														?,
														?,
														?,

?,
														?,
														?,
														?,
														?,														
													
													    ?,
														?,
														?,
														?,
														?,
														
														?,
														?,
														?,
														?
														)");
					//$stmt->bind_param("sssss  sssss  sssss siiis  ssiii iiiii idsis sssss siisi iiiss issis iiii", 
					  $stmt->bind_param("ssssssssssssssssiiisssiiiiiiiiidsisssssssiisiiiississisiiii", 
														$photo,
														$GovtId,
														$_REQUEST['NameB'],
														$_REQUEST['NameE'],
														$_REQUEST['FatherB'],

$_REQUEST['FatherE'],
														$_REQUEST['MotherB'],
														$_REQUEST['MotherE'],
														$_REQUEST['NationalID'],
														$_REQUEST['PassportNo'],
														
														date("Y-m-d", strtotime(str_replace('/','-',englishnum($_REQUEST['PassIssueDate'])))),
														date("Y-m-d", strtotime(str_replace('/','-',englishnum($_REQUEST['PassLastDate'])))),
														date("Y-m-d", strtotime(str_replace('/','-',englishnum($_REQUEST['dob'])))),
														$_REQUEST['BirthCertificateNo'],
														$_REQUEST['PersonalEmail'],
														
														$_REQUEST['OfficialEmail'],
														$_REQUEST['district_id'],
														$_REQUEST['designation_id'],
														$_REQUEST['office_id'],
														$_REQUEST['CaderName'],
														
														date("Y-m-d", strtotime(str_replace('/','-',englishnum($_REQUEST['CaderDate'])))),													
														$_REQUEST['BatchNo'],
														$_REQUEST['FredomFighter_id'],
														$_REQUEST['FredomChildGrand_id'],
														$_REQUEST['triballist_id'],
														
														
														$_REQUEST['sex_id'],
														$_REQUEST['MaritualStatus_id'],
														$_REQUEST['religion_id'],
														$_REQUEST['profsubject_id'],
														$_REQUEST['grade_id'],
														
														$_REQUEST['CurrScale_id'],
														englishnum($_REQUEST['SalBasic']),													
														$_REQUEST['ProjectName'],
														$_REQUEST['emptype_id'],
														date("Y-m-d", strtotime(str_replace('/','-',englishnum($_REQUEST['FirstJoinDate'])))),
														
														date("Y-m-d", strtotime(str_replace('/','-',englishnum($_REQUEST['EedJoinDate'])))),
														date("Y-m-d", strtotime(str_replace('/','-',englishnum($_REQUEST['EedCDJoinDate'])))),
														date("Y-m-d", strtotime(str_replace('/','-',englishnum($_REQUEST['CLJoinDate'])))),
														date("Y-m-d", strtotime(str_replace('/','-',englishnum($_REQUEST['PLJoindate'])))),
														date("Y-m-d", strtotime(str_replace('/','-',englishnum($_REQUEST['RegularDate'])))),
														
														date("Y-m-d", strtotime(str_replace('/','-',englishnum($_REQUEST['PermanentDate'])))),
														$_REQUEST['GovtResident_id'],														
														$_REQUEST['LprDesignation_id'],
														$_REQUEST['AnutoshikClass'],
														$_REQUEST['Teliphone_id'],
														
														$_REQUEST['ElectricityBill_id'],
														$_REQUEST['Vhechilefair_id'],
														$_REQUEST['HouseRent_id'],
														$delcrearation,
														$ExpectedLastSal,
														
														$_REQUEST['VheInfo_id'],
														$FringerTham,														
														$SignetureSample,														
														$_REQUEST["emptypenow_id"],
														date("Y-m-d"),
														
														$_REQUEST["districtoffice_id"],
														$_REQUEST["status_id"],														
														$_SESSION["user_id"],
														englishnum($_REQUEST["meritno"])										
									  );
					$stmt->execute();
					$stmt->close();
				}
				else
				{
					
					$stmt = $conn->prepare("UPDATE general SET 	photo = ?,															
																NameB = ?,
																NameE = ?,
																FatherB = ?,
																FatherE = ?,
																MotherB = ?,
																MotherE = ?,
																NationalID = ?,
																PassportNo = ?,
																PassIssueDate = ?,
																PassLastDate = ?,
																dob = ?,
																BirthCertificateNo = ?,
																PersonalEmail = ?,
																OfficialEmail = ?,
																district_id = ?,
																designation_id = ?,
																office_id = ?,
																CaderName = ?,
																CaderDate = ?,
																BatchNo = ?,
																FredomFighter_id = ?,
																FredomChildGrand_id = ?,
																triballist_id = ?,
																sex_id = ?,
																MaritualStatus_id = ?,
																religion_id = ?,
																profsubject_id = ?,
																grade_id = ?,
																CurrScale_id = ?,
																SalBasic = ?,															
																ProjectName = ?,
																emptype_id = ?,
																FirstJoinDate = ?,
																EedJoinDate = ?,
																EedCDJoinDate = ?,
																CLJoinDate = ?,
																PLJoindate = ?,
																RegularDate = ?,
																PermanentDate = ?,
																GovtResident_id = ?,
																
																LprDesignation_id = ?,
																AnutoshikClass = ?,																
																Teliphone_id = ?,
																ElectricityBill_id = ?,
																Vhechilefair_id = ?,
																HouseRent_id = ?,
																delcrearation = ?,
																ExpectedLastSal = ?,
																VheInfo_id = ?,
																FringerTham = ?,																
																SignetureSample = ?,
																emptypenow_id = ?,
																districtoffice_id = ?,
																status_id = ?,
																meritno = ?
															 WHERE id = ?");
					$stmt->bind_param("sssssssssssssssiiisssiiiiiiiiidsisssssssiisiiiississiiiii", 
					$photo,				
					$_REQUEST['NameB'],
					$_REQUEST['NameE'],
					$_REQUEST['FatherB'],
					$_REQUEST['FatherE'],
					$_REQUEST['MotherB'],
					$_REQUEST['MotherE'],
					$_REQUEST['NationalID'],
					$_REQUEST['PassportNo'],
					date("Y-m-d", strtotime(str_replace('/','-',englishnum($_REQUEST['PassIssueDate'])))),
					date("Y-m-d", strtotime(str_replace('/','-',englishnum($_REQUEST['PassLastDate'])))),
					date("Y-m-d", strtotime(str_replace('/','-',englishnum($_REQUEST['dob'])))),
					$_REQUEST['BirthCertificateNo'],
					$_REQUEST['PersonalEmail'],
					$_REQUEST['OfficialEmail'],
					$_REQUEST['district_id'],
					$_REQUEST['designation_id'],
					$_REQUEST['office_id'],
					$_REQUEST['CaderName'],
					date("Y-m-d", strtotime(str_replace('/','-',englishnum($_REQUEST['CaderDate'])))),					
					$_REQUEST['BatchNo'],
					$_REQUEST['FredomFighter_id'],
					$_REQUEST['FredomChildGrand_id'],
					$_REQUEST['triballist_id'],
					$_REQUEST['sex_id'],
					$_REQUEST['MaritualStatus_id'],
					$_REQUEST['religion_id'],
					$_REQUEST['profsubject_id'],
					$_REQUEST['grade_id'],
					$_REQUEST['CurrScale_id'],
					englishnum($_REQUEST['SalBasic']),					
					$_REQUEST['ProjectName'],
					$_REQUEST['emptype_id'],
					date("Y-m-d", strtotime(str_replace('/','-',englishnum($_REQUEST['FirstJoinDate'])))),
					date("Y-m-d", strtotime(str_replace('/','-',englishnum($_REQUEST['EedJoinDate'])))),
					date("Y-m-d", strtotime(str_replace('/','-',englishnum($_REQUEST['EedCDJoinDate'])))),
					date("Y-m-d", strtotime(str_replace('/','-',englishnum($_REQUEST['CLJoinDate'])))),
					date("Y-m-d", strtotime(str_replace('/','-',englishnum($_REQUEST['PLJoindate'])))),
					date("Y-m-d", strtotime(str_replace('/','-',englishnum($_REQUEST['RegularDate'])))),
					date("Y-m-d", strtotime(str_replace('/','-',englishnum($_REQUEST['PermanentDate'])))),
					$_REQUEST['GovtResident_id'],
				
					$_REQUEST['LprDesignation_id'],
					$_REQUEST['AnutoshikClass'],				
					$_REQUEST['Teliphone_id'],
					$_REQUEST['ElectricityBill_id'],
					$_REQUEST['Vhechilefair_id'],
					$_REQUEST['HouseRent_id'],
					$delcrearation,
					$ExpectedLastSal,
					$_REQUEST['VheInfo_id'],
					$FringerTham,				
					$SignetureSample,
					$_REQUEST['emptypenow_id'],
					$_REQUEST['districtoffice_id'],		
					$_REQUEST['status_id'],
					englishnum($_REQUEST['meritno']),										
					$_REQUEST['id']);
					
					
					$stmt->execute();
					$stmt->close();
				}
				
				Header("Location: ../general/general.php?cmd=list");		   
				break;    
		case "edit":      
				
			    $Id               = $_REQUEST['id'];
				if( !empty($Id ))
				{
					// prepare and bind
					$stmt = $conn->prepare("SELECT * FROM general WHERE id = ?");
					$stmt->bind_param("i",$_REQUEST["id"]);
					$stmt->execute();
					
					//Result
					$result = $stmt->get_result();
					
					//Data Retriving
					while($row = $result->fetch_assoc()) {
						$id = $row['id'];
						$photo = $row['photo'];					
						$NameB = $row['NameB'];
						$NameE = $row['NameE'];
						$FatherB = $row['FatherB'];
						$FatherE = $row['FatherE'];
						$MotherB = $row['MotherB'];
						$MotherE = $row['MotherE'];
						$NationalID = $row['NationalID'];
						$PassportNo = $row['PassportNo'];
						$PassIssueDate=ddateremove($row['PassIssueDate']);						
						$PassLastDate=ddateremove($row['PassLastDate']);						
						$dob=ddateremove($row['dob']);					
						$BirthCertificateNo = $row['BirthCertificateNo'];
						$PersonalEmail = $row['PersonalEmail'];
						$OfficialEmail = $row['OfficialEmail'];
						$district_id = $row['district_id'];
						$designation_id = $row['designation_id'];
						$office_id = $row['office_id'];
						$CaderName = $row['CaderName'];
						$CaderDate=($row['CaderDate']);					
						$BatchNo = $row['BatchNo'];
						$FredomFighter_id = $row['FredomFighter_id'];
						$FredomChildGrand_id = $row['FredomChildGrand_id'];
						$triballist_id = $row['triballist_id'];
						$sex_id = $row['sex_id'];
						$MaritualStatus_id = $row['MaritualStatus_id'];
						$religion_id = $row['religion_id'];
						$profsubject_id = $row['profsubject_id'];
						$grade_id = $row['grade_id'];
						$CurrScale_id = $row['CurrScale_id'];
						$SalBasic = $row['SalBasic'];					
						$ProjectName = $row['ProjectName'];
						$emptype_id = $row['emptype_id'];
						$FirstJoinDate=ddateremove($row['FirstJoinDate']);						
						$EedJoinDate=ddateremove($row['EedJoinDate']);						
						$EedCDJoinDate=ddateremove($row['EedCDJoinDate']);						
						$CLJoinDate=ddateremove($row['CLJoinDate']);						
						$PLJoindate=ddateremove($row['PLJoindate']);					
						$RegularDate=ddateremove($row['RegularDate']);						
						$PermanentDate=ddateremove($row['PermanentDate']);						
						$GovtResident_id = $row['GovtResident_id'];
						
						$LprDesignation_id = $row['LprDesignation_id'];
						$AnutoshikClass = $row['AnutoshikClass'];						
						$Teliphone_id = $row['Teliphone_id'];
						$ElectricityBill_id = $row['ElectricityBill_id'];
						$Vhechilefair_id = $row['Vhechilefair_id'];
						$HouseRent_id = $row['HouseRent_id'];
						$delcrearation = $row['delcrearation'];
						$ExpectedLastSal = $row['ExpectedLastSal'];
						$VheInfo_id = $row['VheInfo_id'];
						$FringerTham = $row['FringerTham'];						
						$SignetureSample = $row['SignetureSample'];
						$emptypenow_id = $row['emptypenow_id'];

$entrydate = $row['entrydate'];
						$districtoffice_id = $row['districtoffice_id'];
						$status_id = $row['status_id'];
						$meritno = $row['meritno'];
								  
					}					
					$stmt->close();

}
						   
				include("../general/general_editor.php");						  
				break;
						   
         case 'delete': 
				$Id               = $_REQUEST['id'];
				
	        	if($Id)
				{	
				    
				    //Delete backup
					$stmt25 = $conn->prepare("INSERT INTO delgeneral(GovtId,		
										NameB,		
										NameE,		
										FatherB,
										FatherE,		
										MotherB,		
										dob,		
										PersonalEmail,	
										OfficialEmail,		
										district_id,		
										designation_id,		
										office_id,	
										userinfo_id)
					SELECT                  GovtId,		
										NameB,		
										NameE,		
										FatherB,
										FatherE,		
										MotherB,		
										dob,		
										PersonalEmail,	
										OfficialEmail,		
										district_id,		
										designation_id,		
										office_id,
										userinfo_id 
					FROM general
					WHERE userinfo_id=?");
					$stmt25->bind_param("i",$Id);											
					$stmt25->execute();

//1
                    $stmt1 = $conn->prepare("DELETE FROM general WHERE userinfo_id=?");
                    $stmt1->bind_param("i",$Id);											
					$stmt1->execute();

//2
                    $stmt2 = $conn->prepare("DELETE FROM spouse WHERE userinfo_id=?");
                    $stmt2->bind_param("i",$Id);											
					$stmt2->execute();

//3
                    $stmt3 = $conn->prepare("DELETE FROM empaddress WHERE userinfo_id=?");
                    $stmt3->bind_param("i",$Id);											
					$stmt3->execute();

//4
                    $stmt4 = $conn->prepare("DELETE FROM childinfo WHERE userinfo_id=?");
                    $stmt4->bind_param("i",$Id);											
					$stmt4->execute();

//5
                    $stmt5 = $conn->prepare("DELETE FROM emplanguage WHERE userinfo_id=?");
                    $stmt5->bind_param("i",$Id);											
					$stmt5->execute();

//6
                    $stmt6 = $conn->prepare("DELETE FROM educational WHERE userinfo_id=?");
                    $stmt6->bind_param("i",$Id);											
					$stmt6->execute();

//7
                    $stmt7 = $conn->prepare("DELETE FROM apqualification WHERE userinfo_id=?");
                    $stmt7->bind_param("i",$Id);											
					$stmt7->execute();

//8
                    $stmt8 = $conn->prepare("DELETE FROM publication WHERE userinfo_id=?");
                    $stmt8->bind_param("i",$Id);											
					$stmt8->execute();

//9
                    $stmt9 = $conn->prepare("DELETE FROM haward WHERE userinfo_id=?");
                    $stmt9->bind_param("i",$Id);											
					$stmt9->execute();

//10
                    $stmt10 = $conn->prepare("DELETE FROM salaccounts WHERE userinfo_id=?");
                    $stmt10->bind_param("i",$Id);											
					$stmt10->execute();

//11
                    $stmt11 = $conn->prepare("DELETE FROM postingrecord WHERE userinfo_id=?");
                    $stmt11->bind_param("i",$Id);											
					$stmt11->execute();

//12
                    $stmt12 = $conn->prepare("DELETE FROM promotion WHERE userinfo_id=?");
                    $stmt12->bind_param("i",$Id);											
					$stmt12->execute();

//13
                    $stmt13 = $conn->prepare("DELETE FROM empleave WHERE userinfo_id=?");
                    $stmt13->bind_param("i",$Id);											
					$stmt13->execute();

//14
                    $stmt14 = $conn->prepare("DELETE FROM frtravel WHERE userinfo_id=?");
                    $stmt14->bind_param("i",$Id);											
					$stmt14->execute();

//15
                    $stmt15 = $conn->prepare("DELETE FROM placeinspaction WHERE userinfo_id=?");
                    $stmt15->bind_param("i",$Id);											
					$stmt15->execute();

//16
                    $stmt16 = $conn->prepare("DELETE FROM localtraining WHERE userinfo_id=?");
                    $stmt16->bind_param("i",$Id);											
					$stmt16->execute();

//17
                    $stmt17 = $conn->prepare("DELETE FROM foreigntraining WHERE userinfo_id=?");
                    $stmt17->bind_param("i",$Id);											
					$stmt17->execute();

//18
                    $stmt18 = $conn->prepare("DELETE FROM empvch WHERE userinfo_id=?");
                    $stmt18->bind_param("i",$Id);											
					$stmt18->execute();

//19
                    $stmt19 = $conn->prepare("DELETE FROM servicehistry WHERE userinfo_id=?");
                    $stmt19->bind_param("i",$Id);											
					$stmt19->execute();

//20
                    $stmt20 = $conn->prepare("DELETE FROM general WHERE userinfo_id=?");
                    $stmt20->bind_param("i",$Id);											
					$stmt20->execute();

//21
                    $stmt21 = $conn->prepare("DELETE FROM auditobj WHERE userinfo_id=?");
                    $stmt21->bind_param("i",$Id);											
					$stmt21->execute();

//22
                    $stmt22 = $conn->prepare("DELETE FROM acrinfo WHERE userinfo_id=?");
                    $stmt22->bind_param("i",$Id);											
					$stmt22->execute();

//23
                    $stmt23 = $conn->prepare("DELETE FROM diciplinary WHERE userinfo_id=?");
                    $stmt23->bind_param("i",$Id);											
					$stmt23->execute();

//24
                    $stmt24 = $conn->prepare("DELETE FROM userinfo WHERE id=?");
                    $stmt24->bind_param("i",$Id);											
					$stmt24->execute();

//$stmt->close();
				}
				Header("Location: ../general/general.php?cmd=allemp");		   				
				break; 						   
         case "list" :    	 
			  if(!empty($_REQUEST['page'])&&$_SESSION["search"]=="yes")
				{
				  $_SESSION["search"]="yes";
				}
				else
				{
				   $_SESSION["search"]="no";
				   unset($_SESSION["search"]);
				   unset($_SESSION["field_value"]); 
				}
				include("../general/general_list.php");
				break; 
		case "allemp" :    	 
			if(!empty($_REQUEST['page'])&&$_SESSION["search"]=="yes")
				{
				$_SESSION["search"]="yes";
				}
				else
				{
					$_SESSION["search"]="no";
					unset($_SESSION["search"]);
					unset($_SESSION["field_value"]); 
				}
				include("../general/general_allemp.php");
				break; 
		case "search_allemp":
			$_REQUEST['page'] = 1;  
			$_SESSION["search"]="yes";
			$_SESSION["field_value"] = $_REQUEST['field_value'];				
			include("../general/general_allemp.php");
			break;  
        case "search_general":
				$_REQUEST['page'] = 1;  
				$_SESSION["search"]="yes";
				$_SESSION["field_value"] = $_REQUEST['field_value'];				
				include("../general/general_list.php");
				break;  								   
						
	     default :    
		       include("../general/general_editor.php");		         
	   }

${this.title}

Code Editor : general.php