1#@!#!123s

https 1#@!#!123s
: / home2 / affluencebiotech / www / absolutoffice.com / admin / category /
Filename : add_category.php
back
<?php 
require_once '../config/db.php';
require_once '../config/database.class.php';
require_once '../config/functions.php';
$d = new database($db_config);


if(isset($_POST)){
	$post  =$_POST;
    $category = str_replace("'","\'", $post['category']);
   $name = '';
    $tmp_name = '';
    $file_url = '';
  
    
    if(empty($post['id']) && empty($_FILES['image']['name']))
    {
        //If file not selected displaying a message to choose a file while insert new products-------
        echo getResponse('error','Please choose a file');
        die;
    }
    else if(!empty($_FILES['image']['name']))
    {
        $name = $_FILES['image']['name'];
        $tmp_name = $_FILES['image']['tmp_name'];
        //Getting temporary file name stored in php tmp folder 
 
        //Path to store files on server
        $path = '../uploads/';
        if(!empty($name))
        {
            //Moving file to temporary location to upload path 
            move_uploaded_file($tmp_name,$path.$name);
            move_uploaded_file($tmp_name2,$path.$name2);
            //Displaying success message 
            //echo "Upload successfully";
        }
        $file_url = $path.$name;
       
    }
    
   
 
	if($post['id']==''){
    $query = "INSERT INTO category(`category`,`image`) VALUES('$category','$file_url')";
        $executeQuery = $d->insertQuery($query);
        if($executeQuery){
            ?>
             <script>
 alert('Data saved successfully!');
	 document.location.href = "../category.php"
   
    </script>
    <?php 
        // 	echo getResponse('success','Data saved successfully');
        }else{
             ?>
             <script>
 alert('Something went wrong, please try later!');
	 document.location.href = "../category.php"
   
    </script>
    <?php 
        // 	echo getResponse('error','Something went wrong, please try later!');
        }
	}else{
$id = $post['id'];
		$query = "UPDATE category SET category='".$category."'";
		 if(!empty($name))
        {
            $query .= " , image='".$file_url."' ";
        }
        
         $query .= " WHERE id=$id";
        $executeQuery = $d->updateQuery($query);
        
        if($executeQuery){
              ?>
             <script>
 alert('Data Updated Successfully!');
	 document.location.href = "../category.php"
   
    </script>
    <?php 
        // 	echo getResponse('success','Data updated successfully');
        }else{
              ?>
             <script>
 alert('Something went wrong, please try later!');
	 document.location.href = "../category.php"
   
    </script>
    <?php 
        // 	echo getResponse('error','Something went wrong, please try later!');
        }

	}
}


?>