Gecko [ 43.229.15.234 ]

Name	Size	Permission
ministrylist.php	2.41 KB	-rw-r--r--
ministrylist_editor.php	1.63 KB	-rw-r--r--
ministrylist_list.php	4.86 KB	-rw-r--r--

Code Editor : ministrylist.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']))
				{
					
					$stmt = $conn->prepare("INSERT INTO ministrylist (mname) VALUES (?)");
					$stmt->bind_param("s", $_REQUEST['mname']);
					$stmt->execute();
					$stmt->close();
				}
				else
				{
					$stmt = $conn->prepare("UPDATE ministrylist SET mname = ? WHERE id = ?");
					$stmt->bind_param("si", $_REQUEST['mname'], $_REQUEST['id']);
					$stmt->execute();
					$stmt->close();
				}
				
				Header("Location: ../ministrylist/ministrylist.php?cmd=list");				   
				break;    
		case "edit":      
				$Id               = $_REQUEST['id'];
				if( !empty($Id ))
				{
					// prepare and bind
					$stmt = $conn->prepare("SELECT * FROM ministrylist 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'];
						$mname =$row['mname'];				  
					}					
					$stmt->close();

}
						   
				include("../ministrylist/ministrylist_editor.php");						  
				break;
						   
         case 'delete': 
				$Id               = $_REQUEST['id'];
				
				$info['table']    = "ministrylist";
				$info['where']    = "id='$Id'";
				
				if($Id)
				{
					//$db->delete($info);
				}
				include("../ministrylist/ministrylist_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("../ministrylist/ministrylist_list.php");
				break; 
        case "search_ministrylist":
				$_REQUEST['page'] = 1;  
				$_SESSION["search"]="yes";
				$_SESSION["field_value"] = $_REQUEST['field_value'];
				include("../ministrylist/ministrylist_list.php");
				break;  								   
						
	     default :    
		       include("../ministrylist/ministrylist_editor.php");		         
	   }

${this.title}

Code Editor : ministrylist.php