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

foreach ($_REQUEST as $key => $value) {
    $$key = $value;
}

$target_path_val = "../cat_images/Enewsletter/";
$prefix = time();
$target_path = $target_path_val . basename($prefix . $_FILES['image']['name']);
$target_path1 = $target_path_val . basename($prefix . $_FILES['upload_file']['name']);


$title = $_POST['title'];
$status  =  $_POST['status'];   
$date = date("Y-m-d H:i:s");

//           EDIT code
if ($_REQUEST['mode'] == "Edit") {  
       
    $Image_Data="select * from tbl_news_letter where id = '" .$_POST['id']. "'"; 
    $query=  mysql_query($Image_Data); 
    $rows = mysql_fetch_assoc($query);

    if ($_FILES['image']['name'] != "") {
        
        $image_path = @unlink("../cat_images/Enewsletter/".$rows['image']);
        if (move_uploaded_file($_FILES['image']['tmp_name'], $target_path)) {
            chmod($target_path, 0777);
            $upload_image = basename($prefix . $_FILES['image']['name']);
        }
    } else {
        $upload_image = $rows['image'];
    }
    
    
    if ($_FILES['upload_file']['name'] != "") {
        
        $image_path1 = @unlink("../cat_images/Enewsletter/".$rows['upload_file']);
        if (move_uploaded_file($_FILES['upload_file']['tmp_name'], $target_path1)) {
            chmod($target_path1, 0777);
            $upload_file = basename($prefix . $_FILES['upload_file']['name']);
        }
    } else {
        $upload_file = $rows['upload_file'];
    }
    
    $sql = "update tbl_news_letter set title = '" . $title . "',image = '" . $upload_image . "',upload_file = '" . $upload_file . "',status = '" . $status . "'   where id = '" . $_POST['id'] . "'";

}   
else { 
    
    
    if ($_FILES['upload_file']['name'] != "") {
        if (move_uploaded_file($_FILES['upload_file']['tmp_name'], $target_path1)) {
            chmod($target_path1, 0777);
            $upload_file = basename($prefix . $_FILES['upload_file']['name']);
        }else{
            echo 'not done';die;
        }
    }
    
    
    if ($_FILES['image']['name'] != "") {
   
        if (move_uploaded_file($_FILES['image']['tmp_name'], $target_path)) {
            chmod($target_path, 0777);
            $upload_image = basename($prefix . $_FILES['image']['name']);
        }else{
            echo 'not done';die;
        }
    }
    
  
    
    $sql = "insert into tbl_news_letter (title,image,upload_file,status) VALUES ('$title','$upload_image', '$upload_file','$status')";
     
}

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

<script>
    document.location = "newsletter_list.php?page=listhomeBanner";
</script>