Gecko [ 43.229.15.234 ]

Name	Size	Permission
salaccounts.php	5.54 KB	-rw-r--r--
salaccounts_editor.php	8.07 KB	-rw-r--r--
salaccounts_list.php	8.31 KB	-rw-r--r--
view.php	2.81 KB	-rw-r--r--

Code Editor : salaccounts.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 salaccounts (GovtId,
																	houserent,
																	 medical,
																	 srantibinodon,

education,
																	 spicial,
																	 preson,
																	 respon,

wash,
																	 haor,
																	 mauntain,
																	 mobile,

tifin,
																	 convayance,
																	 userinfo_id,
																	 salbasic,

finyear_id
																	 
																	 ) 
																	 VALUES
																	 (?,?,?,?,
																	  ?,?,?,?,
																	  ?,?,?,?,
																	  ?,?,?,?,
																	  ?)"); 
                    $stmt->bind_param("siiiiiiiiiiiiiiii", $_SESSION["pimsid"],
											englishnum($_REQUEST["houserent"]),
											englishnum($_REQUEST["medical"]),
			                                englishnum($_REQUEST["srantibinodon"]),

englishnum($_REQUEST["education"]),
											englishnum($_REQUEST["spicial"]),
											englishnum($_REQUEST["preson"]),
			                                englishnum($_REQUEST["respon"]),

englishnum($_REQUEST["wash"]),
											englishnum($_REQUEST["haor"]),
											englishnum($_REQUEST["mauntain"]),
											englishnum($_REQUEST["mobile"]),
											englishnum($_REQUEST["tifin"]),
											englishnum($_REQUEST["convayance"]),
										
											$_SESSION["user_id"],
											englishnum($_REQUEST["salbasic"]),
											englishnum($_REQUEST["finyear_id"])
											
			                                );
					$stmt->execute();
					$stmt->close();
				}
				else
				{
					//Data Update
					$stmt = $conn->prepare("UPDATE salaccounts SET 
													houserent= ?, 
													medical = ?,
													srantibinodon = ?,
													education = ?, 
													spicial= ?, 
													preson = ?,
													respon = ?,

wash= ?, 
													haor = ?,
													mauntain = ?,
													mobile = ?, 
													tifin= ?, 
													convayance = ?,
													salbasic = ?,
													finyear_id = ?
													
											WHERE id = ?");
					$stmt->bind_param("iiiiiiiiiiiiiiii", 
											englishnum($_REQUEST["houserent"]),
											englishnum($_REQUEST["medical"]),
											englishnum($_REQUEST["srantibinodon"]),

englishnum($_REQUEST["education"]),
											englishnum($_REQUEST["spicial"]),
											englishnum($_REQUEST["preson"]),
											englishnum($_REQUEST["respon"]),

englishnum($_REQUEST["wash"]),
											englishnum($_REQUEST["haor"]),
											englishnum($_REQUEST["mauntain"]),
											englishnum($_REQUEST["mobile"]),

englishnum($_REQUEST["tifin"]),
											englishnum($_REQUEST["convayance"]),
											englishnum($_REQUEST["salbasic"]),
											englishnum($_REQUEST["finyear_id"]),

$_REQUEST["id"]);
					$stmt->execute();
					$stmt->close();
				}
				
				Header("Location: ../salaccounts/salaccounts.php?cmd=list");				   
				break;    
		case "edit":      
				$Id               = $_REQUEST["id"];
				if( !empty($Id ))
				{
					// prepare and bind
					$stmt = $conn->prepare("SELECT * FROM salaccounts 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"];
						$houserent = $row["houserent"];
						$medical = $row["medical"];
						$srantibinodon = $row["srantibinodon"];
						$education = $row["education"];
						$spicial = $row["spicial"];
						$preson = $row["preson"];
						$respon = $row["respon"];

$wash = $row["wash"];
						$haor = $row["haor"];
						$mauntain = $row["mauntain"];
						$mobile = $row["mobile"];
						$tifin = $row["tifin"];
						$convayance = $row["convayance"];

$salbasic = $row["salbasic"];
						$finyear_id = $row["finyear_id"];										
						
					}					
					$stmt->close();	
			    }
						   
				include("../salaccounts/salaccounts_editor.php");						  
				break;
						   
         case "delete": 
				$Id               = $_REQUEST["id"];				
								
				if($Id)
				{
					//$db->delete($info);
				}
				include("../salaccounts/salaccounts_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("../salaccounts/salaccounts_list.php");
				break; 
        case "search_salaccounts":
				$_REQUEST["page"] = 1;  
				$_SESSION["search"]="yes";
				$_SESSION["field_value"] = $_REQUEST["field_value"];
				include("../salaccounts/salaccounts_list.php");
				break;  								   
						
	     default :    
		       include("../salaccounts/salaccounts_editor.php");		         
	   }

${this.title}

Code Editor : salaccounts.php