如何在db中以二进制格式保存文件？

Question

I need to save files in binary format in my database rather than saving files in directory and inserting file name in the database. Like i get the file by print_r($_FILES) and what is next now??

Answer 1

Table entity data type should be blob

  CREATE TABLE `media`( `id` INT NOT NULL AUTO_INCREMENT, `content` BLOB, PRIMARY KEY (`id`) );

For Example :

    $uploaddir = '/var/www/uploads/';
    $uploadfile = $uploaddir . basename($_FILES['userfile']['name']);

    if(move_uploaded_file($_FILES['userfile']['tmp_name'], $uploadfile)) {

      $fileContent = file_get_contents($uploadfile);
      $query = "INSERT INTO `media` (content) VALUES ("$fileContent");
    }