rendered paste body//Move the temporary file to the final location ($fullPath)
if(move_uploaded_file($_FILES['imagePath']['tmp_name'], $fullPath))
{
// if file movement is successful print message
echo "The file $filename has been uploaded";
// Change file permissions so all can read and write to the file
chmod($fullPath, 0666);
// Create query for adding details to database
$request = "INSERT INTO `catalogue` (`prodCode`, `prodName`, `imagePath`, `prodDesc`, `colour`, `numHoles`, `size` )
VALUES ( '$prodCode', '$prodName', '$fullPath', '$prodDesc', '$colour', '$numHoles', '$size')";
// Run query and check if successful
if ($result = mysql_query($request))
{
print "Button added successfully.";
}
else
{
print "Error adding button - Please report following error.";
echo mysql_error($request);
// echo's to check variable data
echo "Product Code" . $prodCode . "\n";
echo "Product Name" . $prodName . "\n";
echo "Image Path" . $fullPath . "\n";
echo "Product Desc" . $prodDesc . "\n";
echo "Num Holes" . $numHoles . "\n";
echo "size" . $size . "\n";
}
}
else // if moving file failed
{
echo "There was an error uploading the file, please try again!";
echo "fullPath is $fullPath";
}