I have a file upload script I am using, it is uploading the file perfectly. The only issue I am having is it is not INSERT the info into the DB. Any help would be greatly appreciated.
<?php
if (($_FILES["file"]["type"] == "image/gif")
|| ($_FILES["file"]["type"] == "image/jpg")
&& ($_FILES["file"]["size"] < 120000))
{
if ($_FILES["file"]["error"] > 0)
{
echo "Return Code: " . $_FILES["file"]["error"] . "<br />";
}
else
{
if (file_exists("upload/" . $_FILES["file"]["name"]))
{
echo $_FILES["file"]["name"] . " already exists. ";
}
else
{
require ( "dbconnex.inc.php" );
$sql = "INSERT INTO files(file_date, file_name, file_type, file_size) VALUES(NOW()," . $_FILES["file"]["name"] . "," . $_FILES["file"]["type"] . "," . ($_FILES["file"]["size"] / 1024) . ")";
header ( "Location: thanks/" );
move_uploaded_file($_FILES["file"]["tmp_name"],
"upload/" . $_FILES["file"]["name"]);
echo "Stored in: " . "upload/" . $_FILES["file"]["name"];
}
}
}
else
{
echo "Invalid file";
}
?>
