how to show images from a database

[sonill]

hey i m new in php and wanted to know how to show a image from a database to a web page, i know how to connect to a database, i just wanted query for displaying images, my database name is : spice_db and table name is tbpictures with two fields: a) ID & b) pic. i hope some one can help.

[trq]

Is the actual image stored in the database or just the path to the image file?

[sonill]

the images actually exists in the database, i just want to  some query on how to call them from database and use it in web page.

[xcoderx]

post table structure

[sonill]

table structure

table name: tbpictures

dtabase name: spice_db

 

2 rows,

a) pictureID - int - 11 - auto increment not null

b) pictures - varchar - 100 not null

primary key: pictureID

 

[xcoderx]

the pics are stored in dir or by image url? ???

[xcoderx]

i found someting u can use according to ur needs

 

//connect to mysql with your variables here...
//execute your sql query(s), store result in $result

//make a table to hold images and data
$output = "<table width=\"300\">";

//fetch each row of data
while($row = mysql_fetch_array($result))
{
//do something with each row of data
//refer to columns holding data as $row['columnName'];

//for example...


//fill table with data...be sure to refer to the column/field names in your database table!

$output .= ("
<tr>
	<td><img src =\" ". $row['imageURL'] . "\"></td>
	<td>". $row['imageTitle'] . "</td>
</tr>		
")


}

//close table tag
$output .= "</table>";

//display output
echo $output;

[xcoderx]

or maybe something like this?

 

$sql = "SELECT pictures FROM tbpictures ORDER BY pictureID DESC LIMIT 1";
$reslut = @mysql_query($sql) or die("Query failed");

if($row = mysql_fetch_assoc($reslut)) {    

  echo $row['pictures'];
}
else {
   echo "error fetching picture!";
}