display multiple image from database in php

[gaurav13477]

i fetch single image . how i fetch multiple image. please send the code.
img1.php

<?php
$con=mysql_connect('localhost','root','');
$d=mysql_select_db("test");
$q1="select * from cat ";
$r1=mysql_query($q1);
while($r=mysql_fetch_array($r1))
{
header("Content-type: image/jpeg");
print $r['image'];
}
?>

img2.php

<?php
$con1=mysql_connect('localhost','root','');
$d1=mysql_select_db("test");
$q2="select * from cat";
$r2=mysql_query($q2);
//$r3=mysql_fetch_array($r2);
?>
<table border="1">
<tr>
    <td>id</td>
    <td>name</td>
    <td>image</td>
    </tr>
<?php
while($r3=mysql_fetch_array($r2))
{
?>
<tr>
<td><?php echo $r3['id']; ?></td>
<td><?php echo $r3['name']; ?></td>
<td><img src="img4.php" height="100" width="100" /></td>
</tr>
<?php
}
?>
</table>

[vivekgs2007]

hello,
use mysql_fetch assoc();
and using "for" loop, or "if n while" u can retrieve all the images on single click

[Atli]

When you have PHP set the mime-type via the header function to that of an image, that requests becomes an image. Thus, you can not print more than a single image per request.

Which means that to print multiple images per page, you need to make multiple requests to the PHP script, each one representing a single image (just like you would with normal images). Usually you have two scripts, one that prints the HTML of the page, fetches the image meta-data and adds <img> tags, each one calling a second PHP script while passing it the ID of an image.

The second PHP script then just fetches and prints the data of that single image.

please send the code.

Not going to happen. We are happy to guide you through problems you may face while writing your own code, but we will not simply write it for you and hand it over.

[gaurav13477]

In which program i use for loop and mysql_fetch_assoc .

[gaurav13477]

PLEASE use my code then u send my answer .

[Atli]

@gaurav13477
We are not going to write this for you, mate. We are here to help you write the code, not to do it for you.

Try it yourself and let us know what exactly you are having problems with.
Remember to include the details we need to figure out what you are doing. Like: error messages, excepted output, actual output, code examples.

[gaurav13477]

How i fetch multiple image from database here is my coding. i fetch single image.
where i get mistake. and which line.

img1.php

    <?php
    $con=mysql_connect('localhost','root','');
    $d=mysql_select_db("test");
    $q1="select * from cat ";
    $r1=mysql_query($q1);
    while($r=mysql_fetch_array($r1))
    {
    header("Content-type: image/jpeg");
    print $r['image'];
   }
   ?>

img2.php

  <?php
    $con1=mysql_connect('localhost','root','');
    $d1=mysql_select_db("test");
    $q2="select * from cat";
    $r2=mysql_query($q2);
    //$r3=mysql_fetch_array($r2);
    ?>
    <table border="1">
    <tr>
       <td>id</td>
       <td>name</td>
       <td>image</td>
      </tr>
  <?php
   while($r3=mysql_fetch_array($r2))
   {
   ?>
   <tr>
   <td><?php echo $r3['id']; ?></td>
   <td><?php echo $r3['name']; ?></td>
   <td><img src="img4.php" height="100" width="100" /></td>
   </tr>
   <?php
   }
   ?>
   </table>

[vivekgs2007]

tell me exactly wt u need....y u used this header("Content-type: image/jpeg");

[gaurav13477]

I get onle single image but in my database there are many other image.
I used for and mysql_fetch_assoc also but i can't get solve my problem

[vivekgs2007]

<?php
$con=mysql_connect('localhost','root','');
$d=mysql_select_db("test");
$q1=mysql_query("select * from cat ");
$r1 = mysql_num_rows($q1);
if($r1>0)
{
while($r=mysql_fetch_assoc($q1))
{
 
echo $r['image'];
}
}
?>
 

use table td tr

[gaurav13477]

I get output http://localhost/binary/pic3.php.
Instead of image

[vivekgs2007]

<img src="folder_image/<?php echo $r['image']; ?>" height="100" width="100" />

[gaurav13477]

I think u can't get my question.
http://localhost/binary/pic3.php

[vivekgs2007]

ok what exactly u need...tell me clearly

[Atli]

The problem with the code above, the one you labeled "img1.php", is that you are printing all the images in the database, instead of just one.

When you set the content-type header to an image, the PHP code becomes an image and you need to print the data belonging to that image, and only that image.

Your code fetches all the images from the database and prints every one of them. The browser is only expecting data for one image, so when it gets all of your images, it can not render it correctly and just displays an error icon or the file name.

You should only be fetching and printing a single image, not all of them.

[gaurav13477]

I used two file to display image.In second file to fetch image
<img src="img1.php" height="100" width="100"> In this i get single image.
And your answer is <img src="imq/. $row['img']" > where i write this code.
And where i make folder img.
i want to fetch mutiple image from database. but from my code get single
code . I send code also to u .