Display images from a database into a PHP page

Question

Im wondering what can I do to make images from a database on Php display on my page. This is what I have

images .php

$query = "SELECT * FROM images ORDER BY name ASC ";

            $result = $db->query($query);
            $num_result = $result->num_rows;

            echo "<h1> Images</h1>";

            for ($i = 0; $i < $num_result; $i++){

                $row = $result->fetch_assoc();
                $name = $row['name'];
                $URL = $row['imageURL'];


                $array = array($URL);
            }

foreach ($array as $image){
        echo '<tr>';
        echo '<td><img class="coupons" src="'.$image.'"/></td>';
        echo '<td></td>';
        echo '</tr>';
        echo '<tr>';

          }

This is just printing only one image and I have 10 in my database, what can I do or change to print all of the images from the database? Thanks

Marcin Nabiałek · Accepted Answer · 2014-05-05 16:40:43Z

1

You should change

$array = array($URL);

into

$array[] = $URL;

And add before line:

for ($i = 0; $i < $num_result; $i++){

add line:

$array = array();

edited May 5, 2014 at 16:40

answered May 5, 2014 at 16:32

Marcin Nabiałek

112k43 gold badges271 silver badges299 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Jonathan Kuhn Over a year ago

don't forget to assign your array before the for loop unless you like errors.

Marcin Nabiałek Over a year ago

True, I've added info to answer

Programmer4000 Over a year ago

this worked great! thanks a lot and yeh added the $array = array(); at the top

Krish R · Accepted Answer · 2014-05-05 16:33:58Z

1

Try this,

$array = array();//initialize here 
for ($i = 0; $i < $num_result; $i++){
            $row = $result->fetch_assoc();
            $name = $row['name'];
            $URL = $row['imageURL'];
            $array[] = $URL;
    }

You can rewrite your code as,

    while ($row = $result->fetch_assoc()){
        $name = $row['name'];
        $URL = $row['imageURL'];    
        echo '<tr>';
        echo '<td><img class="coupons" src="'.$URL.'"/></td>';
        echo '<td></td>';
        echo '</tr>';
        echo '<tr>';
    }

answered May 5, 2014 at 16:33

Krish R

22.7k7 gold badges54 silver badges60 bronze badges

Comments

Ian · Accepted Answer · 2014-05-05 16:36:50Z

1

$query = "SELECT * FROM images ORDER BY name ASC ";

$result = $db->query($query);
$num_result = $result->num_rows;

$array = array();

echo "<h1> Images</h1>";

for ($i = 0; $i < $num_result; $i++){

    $row = $result->fetch_assoc();
    $name = $row['name'];
    $URL = $row['imageURL'];


    $array[] = URL;
}

foreach ($array as $image){
    echo '<tr>';
    echo '<td><img class="coupons" src="'.$image.'"/></td>';
    echo '<td></td>';
    echo '</tr>';
}

You also had a trailing <tr> which may cause styling issues

answered May 5, 2014 at 16:36

Ian

3,7064 gold badges32 silver badges50 bronze badges

Collectives™ on Stack Overflow

Display images from a database into a PHP page

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related