Gecko [ 43.229.15.234 ]

Name	Size	Permission
111ajaxview.php	1.24 KB	-rw-r--r--
222report_indproduct_sale.php	4.05 KB	-rw-r--r--
ajaxapplicant.php	4.72 KB	-rw-r--r--
ajaxselection.php	2.88 KB	-rw-r--r--
applicant_callingpage.php	419 B	-rw-r--r--
applicant_editor.php	5.83 KB	-rw-r--r--
applicantselection.php	3.7 KB	-rw-r--r--
applicantselection_editor.php	2.9 KB	-rw-r--r--
applicantselection_list.php	6.14 KB	-rw-r--r--

Code Editor : applicantselection.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
					$stmt = $conn->prepare("SELECT id FROM applicantlist WHERE trevent_id = ? ORDER BY id");
					$stmt->bind_param("i",$_REQUEST["trevent_id"]);
					$stmt->execute();

//Result
					$result = $stmt->get_result();
					
					//Data Retriving
					while($row = $result->fetch_assoc()) {
						$apid   = $row["id"];	
						
							if  (!isset($_POST['slflag'.$apid])){
							
								$slflag=0;						
							}
							else{
								$slflag=$_POST['slflag'.$apid];
							}
							$applicantlist_id=$_POST['applicantlist_id'.$apid];

$stmt = $conn->prepare("INSERT INTO applicantselection (trevent_id,applicantlist_id,slflag) VALUES (?,?,?)"); 
						$stmt->bind_param("iii", $_REQUEST["trevent_id"],												
												 $applicantlist_id,
												 $slflag
												);
						$stmt->execute();
						
					}

$stmt->close();
				}
				else
				{
					
					$stmt = $conn->prepare("UPDATE applicantselection SET 
														   trevent_id = ?, applicantlist_id = ?, slflag = ? 	 WHERE id = ? ");
					$stmt->bind_param("iiii", $_REQUEST["trevent_id"],
			                                $_REQUEST["applicantlist_id"],
			                                $_REQUEST["slflag"],
			                                $_REQUEST["id"]);
					$stmt->execute();
					$stmt->close();
				}
				
				Header("Location: ../applicantselection/applicantselection.php?cmd=list");				   
				break;    
		case "edit":      
				$Id               = $_REQUEST["id"];
				if( !empty($Id ))
				{
					// prepare and bind
					$stmt = $conn->prepare("SELECT * FROM applicantselection 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"];
						$trevent_id = $row["trevent_id"];
						$applicantlist_id = $row["applicantlist_id"];
						$slflag = $row["slflag"];
						
					}					
					$stmt->close();	
			    }
						   
				include("../applicantselection/applicantselection_editor.php");						  
				break;

case "aplist": 
			$Id               = $_REQUEST["id"];				
							
			if($Id)
			{
				//$db->delete($info);
			}
			include("../applicantselection/applicant_editor.php");						   
			break; 		
						   
         case "delete": 
				$Id               = $_REQUEST["id"];				
								
				if($Id)
				{
					//$db->delete($info);
				}
				include("../applicantselection/applicantselection_list.php");						   
				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("../applicantselection/applicantselection_list.php");
				break; 
        case "search_applicantselection":
				$_REQUEST["page"] = 1;  
				$_SESSION["search"]="yes";
				$_SESSION["field_value"] = $_REQUEST["field_value"];
				include("../applicantselection/applicantselection_list.php");
				break;  								   
						
	     default :    
		       include("../applicantselection/applicantselection_editor.php");		         
	   }

${this.title}

Code Editor : applicantselection.php