Gecko [ 43.229.15.234 ]

Name	Size	Permission
ajaxselection.php	6.05 KB	-rw-r--r--
applicantlist.php	4.83 KB	-rw-r--r--
applicantlist_editor.php	8.62 KB	-rw-r--r--
applicantlist_list.php	7.01 KB	-rw-r--r--
applicantlist_manual.php	4.64 KB	-rw-r--r--
applicantlist_manual_editor.ph...	8.52 KB	-rw-r--r--
applicantlist_manual_list.php	6.67 KB	-rw-r--r--

Code Editor : applicantlist.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"]))
				{
					//Data Insert
					$stmt = $conn->prepare("INSERT INTO applicantlist (GovtId,trevent_id,district_id,
																	  apname,nidcard,designation_id,
																	  office_id,address,mobileno,
																	  email,comment,srlno)
										    VALUES (?,?,?,?,?,?,?,?,?,?,?,?)"); 
                    $stmt->bind_param("siissiissssi", englishnum($_REQUEST["GovtId"]),
			                                $_REQUEST["trevent_id"],
			                                $_REQUEST["district_id"],
			                                $_REQUEST["apname"],
											englishnum($_REQUEST["nidcard"]),
			                                $_REQUEST["designation_id"],
			                                $_REQUEST["office_id"],
			                                $_REQUEST["address"],
			                                $_REQUEST["mobileno"],
			                                $_REQUEST["email"],
			                                $_REQUEST["comment"],
											englishnum($_REQUEST["srlno"])
			                                );
					$stmt->execute();
					$_SESSION["trevent_id"] =  $_REQUEST["trevent_id"];

$stmt->close();
				}
				else
				{
					//Data Update
					$stmt = $conn->prepare("UPDATE applicantlist SET 
														   GovtId = ?, trevent_id = ?, district_id = ?, 
														   apname = ?,
														   nidcard = ?, designation_id = ?,
														   office_id = ?, address = ?, mobileno = ?,
														   email = ?, comment = ?,
														   srlno=?
										 	 WHERE id = ?");
					$stmt->bind_param("siissiissssii", englishnum($_REQUEST["GovtId"]),
			                                $_REQUEST["trevent_id"],
			                                $_REQUEST["district_id"],
			                                $_REQUEST["apname"],
											englishnum($_REQUEST["nidcard"]),
			                                $_REQUEST["designation_id"],
			                                $_REQUEST["office_id"],
			                                $_REQUEST["address"],
			                                $_REQUEST["mobileno"],
			                                $_REQUEST["email"],
			                                $_REQUEST["comment"],
											englishnum($_REQUEST["srlno"]),
			                                $_REQUEST["id"]);
					$stmt->execute();
					$stmt->close();
				}
				
				Header("Location: ../applicantlist/applicantlist.php?cmd=edit");				   
				break;    
		case "edit":      
				$Id               = $_REQUEST["id"];
				if( !empty($Id ))
				{
					// prepare and bind
					$stmt = $conn->prepare("SELECT * FROM applicantlist 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"];
						$GovtId = $row["GovtId"];
						$trevent_id = $row["trevent_id"];
						$district_id = $row["district_id"];
						$apname = $row["apname"];
						$designation_id = $row["designation_id"];
						$office_id = $row["office_id"];
						$address = $row["address"];
						$mobileno = $row["mobileno"];
						$email = $row["email"];
						$comment = $row["comment"];
						$nidcard = $row["nidcard"];
						$srlno = $row["srlno"];
						
					}					
					$stmt->close();	
			    }
						   
				include("../applicantlist/applicantlist_editor.php");						  
				break;
						   
         case "delete": 
				$Id               = $_REQUEST["id"];				
								
				if($Id)
				{
					//1
                    $stmt1 = $conn->prepare("DELETE FROM applicantlist WHERE id=?");
                    $stmt1->bind_param("i",$Id);											
					$stmt1->execute();
				}
				Header("Location: ../applicantlist/applicantlist.php?cmd=edit");				   
				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("../applicantlist/applicantlist_list.php");
				break; 
        case "search_applicantlist":
				$_REQUEST["page"] = 1;  
				$_SESSION["search"]="yes";
				$_SESSION["field_value"] = $_REQUEST["field_value"];
				include("../applicantlist/applicantlist_list.php");
				break;  								   
						
	     default :    
		       include("../applicantlist/applicantlist_editor.php");		         
	   }

${this.title}

Code Editor : applicantlist.php