Community Learn Tools Library Leisure
search
English
Home > Database > Mysql Tutorial > How to Display MySQL Database Images in an HTML Image Tag Using PHP?

How to Display MySQL Database Images in an HTML Image Tag Using PHP?

DDD
Release： 2024-12-14 02:49:10
Original
645 people have browsed it

How to Display MySQL Database Images in an HTML Image Tag Using PHP?

Retrieving Images from MySQL Database and Displaying in an HTML Image Tag

Question:

In PHP, you've created a MySQL database with a table that includes a BLOB column for storing JPEG images. You've also written a PHP script, catalog.php, to retrieve the image from the database and display it in an HTML image tag. However, you're experiencing issues accessing the $result variable in your catalog.php script.

Answer:

Directly accessing the $result variable in HTML is not possible. To display the image in the HTML tag, you need to create a separate PHP script to fetch the image data from the database and return it as an image.

Updated catalog.php:

<body>
<img src="getImage.php?id=1" width="175" height="200" />
</body>
Copy after login

New PHP Script: getImage.php:

<?php

$link = mysqli_connect("localhost", "root", "", "dvddb");
$sql = "SELECT dvdimage FROM dvd WHERE>
Copy after login

How it Works:

  • The catalog.php script calls the getImage.php script with the id of the image you want to display.
  • getImage.php connects to the database, executes the SQL query to retrieve the image data, and stores it in the $image variable.
  • getImage.php sets the Content-type header to "image/jpeg" and echoes the $image variable, which sends the image data to the browser.
  • The browser receives the image data and displays it in the HTML image tag specified in catalog.php.

The above is the detailed content of How to Display MySQL Database Images in an HTML Image Tag Using PHP?. For more information, please follow other related articles on the PHP Chinese website!

source：php.cn
Previous article：How Can I Optimize MySQL Queries Using ORDER BY RAND()? Next article：How to Work Around MySQL's Subquery LIMIT Restriction with IN Operator?
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
function_exists() cannot determine the custom function Function test () {return true;} if (function_exists ('test')) {echo "test is function...
From 2024-04-29 11:01:01
0
3
2183
How to display the mobile version of Google Chrome Hello teacher, how can I change Google Chrome into a mobile version?
From 2024-04-23 00:22:19
0
11
2330
The child window operates the parent window, but the output does not respond. The first two sentences are executable, but the last sentence cannot be implemented.
From 2024-04-19 15:37:47
0
1
1960
There is no output in the parent window document.onclick = function(){ window.opener.document.write('I am the output of the child ...
From 2024-04-18 23:52:34
0
1
1845
Where is the courseware about CSS mind mapping? Courseware
From 2024-04-16 10:10:18
0
0
1897
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template