MySQL

Can't get images to display in database

Please support our MySQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Oct 2008

Posts: 8

Reputation: twmprys is an unknown quantity at this point

Solved Threads: 0

twmprys

Offline

Newbie Poster

Can't get images to display in database

Oct 12th, 2008

Yes, I know this is a common one, but I've inserted images in a database and can't for the life of me get them to display. And before anyone suggests I shouldn't do it, they are only small pictures and a maximum of four. I am currently using two pages to display the pictures. This is the main page:

 Help with Code Tags 
 mysql Syntax (Toggle Plain Text) 
<?
mysql_connect("localhost", "username", "password") OR die(mysql_error());
mysql_select_db("debname") OR die(mysql_error());
$result=mysql_query("SELECT * FROM newyddion") OR die("Can't Perform Query");
While($row=mysql_fetch_object($result)) {
echo "<IMG SRC=\"picupload3.php3?id=$row->id\">";
}
?>
<?
mysql_connect("localhost", "username", "password") or die(mysql_error());
mysql_select_db("debname") or die(mysql_error());
$result=mysql_query("SELECT * FROM newyddion") or die("Can't Perform Query");
While($row=mysql_fetch_object($result)) {
echo "<IMG SRC=\"picupload3.php3?id=$row->id\">";
}
?>

And this is the supporting page (i.e. picupload3.php3):

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
<?php
ini_set("register_globals",1);
mysql_connect("localhost", "username", "password") or die(mysql_error());
mysql_select_db("debname") or die(mysql_error());
$result=mysql_query("SELECT pic1 FROM newyddion WHERE id=$id") or die("Can't perform Query");
$row=mysql_fetch_object($result);
Header( "Content-type: image/jpg");
echo $row->pic1;
?>
<?php
ini_set("register_globals",1);
mysql_connect("localhost", "username", "password") or die(mysql_error());
mysql_select_db("debname") or die(mysql_error());
$result=mysql_query("SELECT pic1 FROM newyddion WHERE id=$id") or die("Can't perform Query");
$row=mysql_fetch_object($result);
Header( "Content-type: image/jpg");
echo $row->pic1;
?>