Does MySQL BLOB only accept images?
I have been looking online trying to be able to upload larger file sizes of different formats, but I only come across image tutorials.
I have the code below, which fails on the if statement and returns the echo when I upload different file types larger than 10 megs. (the column is LONGBLOB).
<?php
ini_set('error_reporting', E_ALL);
ini_set('display_errors', 'On'); //On or Off
session_start();
require_once('connect.php');
if(isset($_POST['submit'])){
$file = rand(1000,100000)."-".$_FILES['file']['name'];
$notes = mysqli_real_escape_string($connection,$_POST['notes']);
$file_loc = $_FILES['file']['tmp_name'];
$file_size = $_FILES['file']['size'];
$file_type = $_FILES['file']['type'];
$email = mysqli_real_escape_string($connection, $_SESSION['email']);
$folder="uploads/";
move_uploaded_file($file_loc,$folder.$file);
$sql = "INSERT INTO `supportcontent` (`scontentdata`, `scontentnotes`, `suseremail`, `stype`,`ssize`)
VALUES( '$file','$notes','$email','$file_type ','$file_size')";
$current_id = mysqli_query($connection, $sql)
or die("<b>Error:</b> Problem on Image Insert<br/>" . mysqli_error($connection));
if (isset($current_id)) {
header("Location: landingpage.php?upload=success");
}
}
else{
echo 'file is 0';
}
?>
Does MySQL BLOB only accept images?
No, you can store anything you want in it. What's failing when you try to upload a file over 10MB is not the SQL, but the PHP code. Either:
the files size limit. Check the value of the upload_max_filesize and post_max_size settings in the php.ini file.
or the operation timing out. This is more likely to be the culprit especially if you've never changed the default values in your php.ini file. The default timeout in PHP is 30 seconds, so your file must be uploaded in less than 30 seconds. You can change it in the php.ini file using the max_execution_time setting, or it is better to change it in you code using the set_time_limit() function.
Example, to set the timeout to 2 minutes:
set_time_limit(120);
You can check the value of max_allowed_packet size and check if this is set to greater than 10MB to handle your case.