Hi all,
Of the below $content and $fileType are not inserted into the database.
Why is this?
Thanks.
/* Declare variables... */
// $fileName is original file name
$fileName = $_FILES['images']['name'];
// $tmpName is where file went on server
$tmpName = $_FILES['images']['tmp_name'];
// $fileSize is size in bytes
$fileSize = $_FILES['images']['size'];
// $fileType is mime type e.g. image/gif
$fileType = $_FILE['images']['type'];
// $fileError is any error encountered
$fileError = $_FILE['images']['error'];
/* End Declaring Variables */
// Error Checking
if ($userfile_error > 0)
{
echo 'Error: ';
switch ($fileError)
{
case 1: echo 'File exceeded upload_max_filesize';
break;
case 2: echo 'File exceeded max_file_size';
break;
case 3: echo 'File only partially uploaded';
break;
case 4: echo 'No file uploaded';
break;
}
exit;
}
// if no error perform query
if ($fileError == 0)
{
// read file contents
$fp = fopen($value[tmp_name], 'rb');
$content = fread($fp, $fileSize);
$content = addslashes($content);
fclose($fp);
}
// put the file into folder
$uploaddir = 'uploads/images/';
$uploadfile = $uploaddir . basename($fileName);
if (move_uploaded_file($tmpName, $uploadfile))
{
echo '<p>File Successfully Uploaded!</p><br />';
// insert data into database
$query = "INSERT INTO simple_tbl values(NULL, '".$fileName."', '".$fileType."', '".$fileSize."', '".$content."', NOW())";
//$result = mysql_query($query) or die("Query Error:", mysql_error());
echo $query;
}
