Gecko [ 43.229.15.234 ]

Name	Size	Permission
docfile	[ DIR ]	drwxr-xr-x
archaive.php	4 KB	-rw-r--r--
archaive_editor.php	3.67 KB	-rw-r--r--
archaive_list.php	5.62 KB	-rw-r--r--

Code Editor : archaive.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":

// prepare and bind for Maximum Number
			$stmt = $conn->prepare("SELECT IFNULL(max(id),0)+1 AS id FROM archaive");
			$stmt->execute();

//Result
			$result = $stmt->get_result();	
			$numrows=$result->num_rows;
			
			while($row = $result->fetch_assoc()){ $max = $row["id"];}	
			  
   
			//Photo File   
			if(strlen($_FILES['docfile']['name'])>0 && $_FILES['docfile']['size']>0)
			{
				
				if(!file_exists("docfile"))
				{ 
				   mkdir("docfile",0755);	
				}
				if(empty($_REQUEST['id']))
				{
				  $file=$max."_".str_replace(" ","_",strtolower(trim($_FILES['docfile']['name'])));
				}
				else
				{
				  $file=trim($_REQUEST['id'])."_".str_replace(" ","_",strtolower(trim($_FILES['docfile']['name'])));
				}
				$filePath="docfile/".$file;
				move_uploaded_file($_FILES['docfile']['tmp_name'],$filePath);
			   $docfile="docfile/".trim($file);
			 }

if(empty($_REQUEST["id"]))
				{
					//Data Insert					
					$stmt = $conn->prepare("INSERT INTO archaive (archaivetype_id,remarks,archivedate,docfile) VALUES (?,?,?,?)"); 
                    $stmt->bind_param("isss", $_REQUEST["archaivetype_id"],			                               
			                                $_REQUEST["remarks"],
											date("Y-m-d", strtotime(str_replace('/','-',englishnum($_REQUEST['archivedate'])))),											
			                               $docfile
										  
			                                );
					$stmt->execute();
					$stmt->close();					
					
				}
				
				else
				{
					//Data Update
					$stmt = $conn->prepare("UPDATE archaive SET 
														   archaivetype_id = ?,  remarks = ?, archivedate = ?, docfile = ? 	 WHERE id = ?");
					$stmt->bind_param("isssi", $_REQUEST["archaivetype_id"],			                               
			                                   $_REQUEST["remarks"],
			                                  date("Y-m-d", strtotime(str_replace('/','-',englishnum($_REQUEST['archivedate'])))),											
			                                  $docfile,
			                                $_REQUEST["id"]);
					$stmt->execute();
					$stmt->close();
				}
				
				Header("Location: ../archaive/archaive.php?cmd=list");				   
				break;    
		case "edit":      
				$Id               = $_REQUEST["id"];
				if( !empty($Id ))
				{
					// prepare and bind
					$stmt = $conn->prepare("SELECT * FROM archaive 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"];
						$archaivetype_id = $row["archaivetype_id"];						
						$remarks = $row["remarks"];
						$archivedate=str_replace('01/01/1970','',date("d/m/Y", strtotime(str_replace('-','/',$row['archivedate']))));						
						$docfile = $row["docfile"];
						
					}					
					$stmt->close();	
			    }
						   
				include("../archaive/archaive_editor.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("../archaive/archaive_list.php");
				break; 
        case "search_archaive":
				$_REQUEST["page"] = 1;  
				$_SESSION["search"]="yes";
				$_SESSION["field_value"] = $_REQUEST["field_value"];
				include("../archaive/archaive_list.php");
				break;  								   
						
	     default :    
		       include("../archaive/archaive_editor.php");		         
	   }

${this.title}

Code Editor : archaive.php