how to download blob based file from MySQL database in PHP?

by

This is the most common problem faced while dealing with the blob file. From your example, I can see that you are saving “fileType” as the extensions of the files (i.e ‘jpg’ for images, ‘pdf’ for pdf files etc.), you are uploading. But instead of that you can can save file type as the MIME content type.

Suppose if you upload a jpeg image – the MIME type will be stored in the “fileType” as the “image/jpeg”. Similarly for pdf it will be stored as “application/pdf”. I designed code like this to download the blob file from the database. I am going to assume that the files are already uploaded into the database table you created.

Database table “uploads”

| fileID | fileName | fileType | fileSize |fileData | userID |

download.php

<?php
$connection =  mysqli_connect("localhost","root"," ",your_database)
               or die('Database Connection Failed');
mysqli_set_charset($connection,'utf-8');

$id = 1;

// Use a prepared statement in production to avoid SQL injection;
// we can get away with this here because we're the only ones who
// are going to use this script.
$query = "SELECT * " ."FROM uploads WHERE userID = '$id'";
$result = mysqli_query($connection,$query) 
       or die('Error, query failed');
list($id, $file, $type, $size,$content) = mysqli_fetch_array($result);
header("Content-length: $size");
header("Content-type: $type");
header("Content-Disposition: attachment; filename=$file");
ob_clean();
flush();
echo $content;
mysqli_close($connection);
exit;

?>

You can find the complete code of blob-upload here.

More Related Contents:

  1. How can I store and retrieve images from a MySQL database using PHP?
  2. Insert Blobs in MySql databases with php
  3. I need my PHP page to show my BLOB image from mysql database
  4. displaying an image stored in a mysql blob
  5. Php : Convert a blob into an image file
  6. How to display an BLOB image stored in MySql database?
  7. php:Store image into Mysql blob, Good or bad?
  8. PHP/PDO/MySQL: inserting into MEDIUMBLOB stores bad data
  9. using the browser prompt to download a file
  10. How can I insert large files in MySQL db using PHP?
  11. Laravel – only a zero is saved to the database
  12. I am seeing this error on submitting form Error: query was empty [closed]
  13. Reference: What is a perfect code sample using the MySQL extension? [closed]
  14. Convert from MySQL datetime to another format with PHP
  15. Correct way to use LIKE ‘%{$var}%’ with prepared statements?
  16. Passing an array to a query using a WHERE clause
  17. Whether to use “SET NAMES”
  18. Escaping single quote in PHP when inserting into MySQL [duplicate]
  19. How can I get enum possible values in a MySQL database?
  20. Mechanisms for tracking DB schema changes [closed]
  21. Inserting data using mysqli
  22. Import file size limit in PHPMyAdmin
  23. PDO Connection Test
  24. How to convert these strange characters? (ë, Ã, ì, ù, Ã)
  25. PDO error: SQLSTATE[HY000]: General error: 2031
  26. php warning mysql_fetch_assoc
  27. Check if row exists in the database before inserting
  28. MySQL Table does not exist error, but it does exist
  29. SQLSTATE[HY000] [1698] Access denied for user ‘root’@’localhost’
  30. Which MySQL datatype to use for an IP address? [duplicate]

Leave a Comment