File "update_size.php"

Full Path: /home/magicrsz/public_html/admin/update_size.php
File size: 2.12 KB
MIME-type: text/x-php
Charset: utf-8

<?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>";
?>