squireless

Back Back Up Advanced Editor

<?php
session_start();
include("../database.php");

$user_id=NULL;

$user_id=session_id();

$title=$_POST['title'];
$price=$_POST['price'];
$size=$_POST['size'];
$size_id=$_POST['edit_id'];
$p_id=$_POST['p_id'];
$check_file=$_POST['check_file'];
$getqunatity = $_POST['quantity'];

if ($check_file==1){

$query				= "SELECT * from sizes where id='$size_id'";
    $product_image		= db::getRecord($query);

$data      = $product_image['image_name'];
    $dir       = "../product/images/";
    $dirHandle = opendir($dir);
    while ($file      = readdir($dirHandle)) {
        if ($file == $data) {
            unlink($dir . '/' . $file);
        }
    }
    closedir($dirHandle);

$file          = rand(1000, 100000) . "-" .  $_FILES['filenew']['name'];
    $file_loc      = $_FILES['filenew']['tmp_name'];
    $file_size     = $_FILES['filenew']['size'];
    $file_type     = $_FILES['filenew']['type'];
    $folder        = "../product/images/";
    $new_size      = $file_size / 1024;
    $new_file_name = strtolower($file);
    $final_file    = str_replace(' ', '-', $new_file_name);

if (move_uploaded_file($file_loc, $folder . $final_file)) {

// $query ="UPDATE sizes SET title='$title',size='$size',price='$price',image_name='$final_file',image_type='$file_type' where id='$size_id'";
         $query ="UPDATE sizes SET title='$title',size='$size',price='$price',image_name='$final_file',image_type='$file_type', quantity='$getqunatity' where id='$size_id'";
        $update   = db::query($query);
        echo "<script>location='../product/edit_size.php?id=$p_id'</script>";
    }

echo "<script>location='../product/edit_size.php?id=$p_id'</script>";
}else{

// $query ="UPDATE sizes SET title='$title',size='$size',price='$price' where id='$size_id'";
     $query ="UPDATE sizes SET title='$title',size='$size',price='$price',quantity='$getqunatity' where id='$size_id'";
    $update   = db::query($query);
    echo "<script>location='../product/edit_size.php?id=$p_id'</script>";
}

echo "<script>location='../product/edit_size.php?id=$p_id'</script>";
?>