How can PHP developers efficiently retrieve and display images from a MySQL database without corruption?

When retrieving and displaying images from a MySQL database in PHP, it's important to store the images as BLOB data type in the database and use appropriate headers to prevent corruption. To efficiently retrieve and display images, you can use the following PHP code snippet that fetches the image data from the database, sets the appropriate content type header, and outputs the image data. 

<?php
// Connect to MySQL database
$connection = mysqli_connect("localhost", "username", "password", "database");

// Retrieve image data from database
$query = "SELECT image_data FROM images WHERE id = 1";
$result = mysqli_query($connection, $query);
$imageData = mysqli_fetch_assoc($result)['image_data'];

// Set appropriate content type header
header("Content-type: image/jpeg");

// Output image data
echo $imageData;
?>

Keywords

PHP MySQL image retrieval display corruption prevention

Related Questions