How can PHP be used to download Blob data from MySQL as a file?

To download Blob data from MySQL as a file using PHP, you can retrieve the Blob data from the database, set the appropriate headers to specify the file type and name, and then output the Blob data to the browser. This can be achieved by using the header() function to set the content type and disposition, and then using the readfile() function to output the Blob data. 

<?php
// Connect to MySQL database
$conn = new mysqli('localhost', 'username', 'password', 'database');

// Retrieve Blob data from MySQL
$sql = "SELECT blob_data, file_name FROM table_name WHERE id = ?";
$stmt = $conn->prepare($sql);
$stmt->bind_param('i', $id);
$stmt->execute();
$stmt->bind_result($blob_data, $file_name);
$stmt->fetch();

// Set headers for file download
header('Content-Type: application/octet-stream');
header('Content-Disposition: attachment; filename="' . $file_name . '"');

// Output Blob data to browser
echo $blob_data;
?>

Keywords

PHP MySQL Blob data file download fopen

Related Questions