Display Images from MySQL DB using PHP

Expand Post »

Hi There Everyone.

Could anyone assist me in the correct method of displaying images from my mysql db. I want to display multiple images on my page.

This is the code I have. I got this from a post from DaniWeb. Hope I did the code tags correctly.

php Syntax (Toggle Plain Text)
<?php
 
require 'library/config.php';
require 'library/opendb.php';
?>
<?php
header('Content-type: image/JPG');
 
@mysql_connect($dbhost, $dbuser, $dbpass) or die("Can not connect to database: ".mysql_error());
@mysql_select_db($dbstore) or die("Can not select the database: ".mysql_error());
 
$query = mysql_query("SELECT id, type, content FROM upload");
while($row = mysql_fetch_array($query)){
print $row['content'];
}
?>
<?php

require 'library/config.php';
require 'library/opendb.php';
?>
<?php
header('Content-type: image/JPG');

@mysql_connect($dbhost, $dbuser, $dbpass) or die("Can not connect to database: ".mysql_error());
@mysql_select_db($dbstore) or die("Can not select the database: ".mysql_error());

$query = mysql_query("SELECT id, type, content FROM upload");
while($row = mysql_fetch_array($query)){
print $row['content'];
}
?>

Thanks allot.

Similar Threads

display images from mysql using php in PHP
Displaying images as a gallery in PHP/MySQL in PHP
How to display many images? in PHP
How to display image from mysql in PHP
Making mysql links clickable in php in PHP

LRNPHP

Reputation Points: 10

Solved Threads: 1

Junior Poster in Training

Offline

57 posts
since Jul 2010

Permalink

Jul 12th, 2010

Re: Display Images from MySQL DB using PHP

What data type did you use for 'content?' Is it blob?
I think it would be better if you don't save the image itself on the database. Instead save just the file name and path where it was uploaded. When you have the path you can then show the images by doing <img src = '<?php echo $content ?>'>

Shinehah

Reputation Points: 14

Solved Threads: 5

Newbie Poster

Offline

23 posts
since May 2010

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: problems with preg_replace on elements in an array

Next Thread in PHP Forum Timeline: aptana, mysql-server, php

DaniWeb Message

Cancel Changes

User Name
Password