Display images from database

[niths]

hi all,
i need to display the images that are saved in the back end. so can any one help me please....

$sql="select * from images";
     mysql_error();  
     $result=mysql_query($sql);

after this wat should be done to display the result obtained images.

[jrock2004]

Well more information is needed? Are the images stored in the database themselves or do you have a field in the db that just points to the file location and filename?

[rbrt13]

Hello

I have tackled this problem before, so I can tell you what to do.
Assuming that the images are stored in a database:

<?php
$con = mysql_connect ( $server, $uname, $pass );
if ( !$con )
  die ( mysql_error() );
mysql_select_db ( "images" );
$query = "SELECT * FROM 'images' WHERE 'name' = " . $_GET["name"];
$q = mysql_query ( $query );
if ( !$q )
  die ( mysql_error() );
$row = mysql_fetch_array ( $q );
header ( "Content-type: " . $row["mime"] );
echo $row["data"];
mysql_close ( $con );
?>

If the images are simply referenced in a database, then use a loop to extract the names and generate an <img> tag for each of them.

Hope this helps

[khalil88]

hi everybody
and how about if images are not stored

[vibhaJ]

Images must be stored some where to get it display.
It may be 3 case:
- you can save image in folder
- in database
- you can directly use external link like http://www.abc.jpf as a image src.