What is the recommended method for displaying an image stored in a database in PHP?

When displaying an image stored in a database in PHP, the recommended method is to create a separate PHP file that retrieves the image data from the database and outputs it with the appropriate content type header. This separate PHP file can then be included in the src attribute of an img tag in the HTML file where you want to display the image. 

<?php
// Connect to database and retrieve image data
$pdo = new PDO('mysql:host=localhost;dbname=test', 'username', 'password');
$stmt = $pdo->prepare('SELECT image_data FROM images WHERE id = :id');
$stmt->bindParam(':id', $_GET['id']);
$stmt->execute();
$imageData = $stmt->fetchColumn();

// Output image data with appropriate content type header
header('Content-type: image/jpeg');
echo $imageData;
?>
```

In your HTML file, you can display the image like this:

```html
<img src="display_image.php?id=1" alt="Image">

Keywords

PHP database image display method

Related Questions