Gecko [ 43.229.15.234 ]

Name	Size	Permission
userinfo.php	3.3 KB	-rw-r--r--
userinfo_editor.php	3.8 KB	-rw-r--r--
userinfo_list.php	4.01 KB	-rw-r--r--

Code Editor : userinfo.php

<?php
       session_start();
       include("../common/functions.php");
	   include("../common/config.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 userinfo (uname,upassword,dumpass,office_id,designation,mobileno) VALUES (?,?,?,?,?,?)");
					$stmt->bind_param("sssis", trim($_REQUEST['uname']),md5(trim($_REQUEST["upassword"])),
											  trim($_REQUEST['upassword']), $_REQUEST['office_id'],$_REQUEST['designation'],$_REQUEST['mobileno']);
                    $stmt->execute();
                    $stmt->close();
                }
                else
                {
					                  
                    $stmt = $conn->prepare("UPDATE userinfo SET uname = ?, upassword = ?,dumpass = ?, office_id = ?,
																designation = ?, mobileno = ? WHERE id = ?");
					$stmt->bind_param("sssissi", trim($_REQUEST['uname']),md5(trim($_REQUEST["upassword"])),trim($_REQUEST['upassword']), 
												$_REQUEST['office_id'], $_REQUEST['designation'],$_REQUEST['mobileno'],base64_decode($_REQUEST['id']));
                    $stmt->execute();
					$stmt->close();
				
				}
				
				Header("Location: ../usernormal/userinfo.php?cmd=list");				   
				break;    
		case "edit":

if(!empty($_REQUEST["id"]))
            {
                // prepare and bind
                $stmt = $conn->prepare("SELECT * FROM userinfo WHERE id = ?");
                $stmt->bind_param("i",base64_decode($_REQUEST["id"]));
                $stmt->execute();

//Result
                $result = $stmt->get_result();

//Data Retriving
                while($row = $result->fetch_assoc()) {
                    $Id   = $row['id'];
                    $uname =  $row["uname"];
                    $upassword =  $row["dumpass"];
					$userrole_id =  $row["userrole_id"];
					$office_id =  $row["office_id"];
					$designation =  $row["designation"];
					$mobileno =  $row["mobileno"];
                }
                $stmt->close();
            }

include("../usernormal/userinfo_editor.php");						  
				break;
						   
         case "delete":
             /*
				$Id               = $_REQUEST["id"];
				
				$info["table"]    = "caseclass";
				$info["where"]    = "id=".$Id;
				
				if($Id)
				{
					$db->delete($info);
				}
				*/
				include("../usernormal/userinfo_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("../usernormal/userinfo_list.php");
				break; 
        case "search_userinfo":
				$_REQUEST["page"] = 1;  
				$_SESSION["search"]="yes";
				$_SESSION["field_value"] = $_REQUEST["field_value"];
				include("../usernormal/userinfo_list.php");
				break;  								   
						
	     default :    
		       include("../usernormal/userinfo_editor.php");		         
	   }

${this.title}

Code Editor : userinfo.php