douchongzhang9267
douchongzhang9267
2018-06-03 07:15

MySQL BLOB只接受图像吗?

已采纳

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';
        }   
?>
  • 点赞
  • 写回答
  • 关注问题
  • 收藏
  • 复制链接分享
  • 邀请回答

2条回答

  • duanchen1937 duanchen1937 3年前

    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:

    1. the files size limit. Check the value of the upload_max_filesize and post_max_size settings in the php.ini file.

    2. 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);
    
    点赞 评论 复制链接分享
  • dongzi8191 dongzi8191 3年前

    You can check the value of max_allowed_packet size and check if this is set to greater than 10MB to handle your case.

    点赞 评论 复制链接分享