<?php
include_once("session.php");
include_once("settings.php");


foreach ($_REQUEST as $key => $value) {
    $$key = $value;
}
$Catgory_Description = addslashes($Catgory_Description);
$target_path = "../cat_images/catBg/";
$prefix = time();
$target_path = $target_path . basename($prefix . $_FILES['image']['name']);




$name = $_POST['Brand_Name'];
$category = $_POST['Categoryname'];
$feedback = $_POST['Feedback_Name'];


//           EDIT code

if ($_REQUEST['mode'] == "Edit") {  
    
    
    
    
 $Image_Data="select * from tblnewcategory where category_id = '" .$_POST['id']. "'"; 
 $query=  mysql_query($Image_Data); 
 $rows = mysql_fetch_assoc($query);
    
 
 
    if ($_FILES['image']['name'] != "") {
        if (move_uploaded_file($_FILES['image']['tmp_name'], $target_path)) {
            chmod($target_path, 0777);
            //echo "The file ". basename( $_FILES['file']['name']). " has been uploaded";
            $upload_image = basename($prefix . $_FILES['image']['name']);
        }
    } else {

        $upload_image = $rows['image'];
    }
    
    
    $sql = "update tblnewcategory set brand_name = '" . $name . "',category_name = '" . $category . "',feedback = '" . $feedback . "',image = '" . $upload_image . "' where category_id = '" . $_POST['id'] . "'";

    }
    
    
    
else {

    if ($_FILES['image']['name'] != "") {
        if (move_uploaded_file($_FILES['image']['tmp_name'], $target_path)) {
            chmod($target_path, 0777);
            //echo "The file ". basename( $_FILES['file']['name']). " has been uploaded";
            $upload_image = basename($prefix . $_FILES['image']['name']);
        }
    }





    $sql = "insert into tblnewcategory (brand_name,category_name,feedback,image) VALUES ('$name','$category', '$feedback','$upload_image')";
    //echo $sql; die;
}

$result = mysql_query($sql) 
        or die(mysql_error());
?>

<script>
    document.location = "category_Newlist.php?page=listNewcategory";
</script>