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 "");
// 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.";
}
}
$itemname=$_POST['itemname'];
$itemdesc=$_POST['itemdesc'];
$itemcat=$_POST['itemcat'];
$itemstock=$_POST['itemstock'];
$itemprice=$_POST['itemprice'];
$sql = "INSERT INTO item (Item_Name, Item_Desc, Item_Category, Item_Image, Item_Stock, Item_Price) VALUES
('$itemname','$itemdesc','$itemcat','$target_file','$itemstock','$itemprice');";
mysqli_query($conn, $sql);
//echo $sql
if (mysqli_affected_rows($conn) <= 0)
{
echo "");
}
echo "";
?>