alert('Unable to update data!');");
echo "";
}
mysqli_close($conn);
echo "";
echo "";
}
// Check if file already exists
if (file_exists($target_file)) {
echo "Sorry, file already exists.";
$uploadOk = 0;
}
// Check file size
if ($_FILES["image"]["size"] > 500000) {
echo "Sorry, your file is too large.";
$uploadOk = 0;
}
// Allow certain file formats
if($imageFileType != "jpg" && $imageFileType != "png" && $imageFileType != "jpeg"
&& $imageFileType != "gif" ) {
echo "Sorry, only JPG, JPEG, PNG & GIF files are allowed.";
$uploadOk = 0;
}
// Check if $uploadOk is set to 0 by an error
if ($uploadOk == 0) {
echo "Sorry, your file was not uploaded.";
// if everything is ok, try to upload file
} else {
if (move_uploaded_file($_FILES["image"]["tmp_name"], $target_file)) {
echo "The file ". basename( $_FILES["image"]["name"]). " has been uploaded.";
} else {
echo "Sorry, there was an error uploading your file.";
}
}
$uid = $_POST['uid'];
$itemdesc = $_POST['itemdesc'];
$itemcat = $_POST['itemcat'];
$itemstock = $_POST['itemstock'];
$itemprice = $_POST['itemprice'];
$sql="Update item SET Item_Desc = '$itemdesc', Item_Category = '$itemcat', Item_Image = '$target_file', Item_Stock = '$itemstock', Item_Price = '$itemprice' Where Item_Name = '$uid'";
mysqli_query($conn,$sql);
if(mysqli_affected_rows($conn)<=0)
{
die("");
echo "";
}
mysqli_close($conn);
echo "";
echo "";
?>