CODEWITHSUNDEEP
phpmysql
Caio Kawasaki
Caio Kawasaki

Reputation: 1

Load Images from mysql table

I wrote the code below, I can load each image of a column within a individual div, someone could help me adapt the code so that it opens all images within the same div?

<?php

mysql_connect("localhost","root","");
mysql_select_db("bravo");
$res=mysql_query("select * from coisas");

while ($row=mysql_fetch_array($res)) {

    echo "<div>";?> <img src="<?php echo $row["imagem"]; ?>"> <?php echo "</div>";

}
?>

Upvotes: 0

Views: 163

Answers (5)

kkatusic
kkatusic

Reputation: 94

<?php

mysql_connect("localhost","root","");
mysql_select_db("bravo");

$res = mysql_query("select * from coisas");

while ($row=mysql_fetch_array($res)):
?>
    <div><img src="<?php echo $row["imagem"]; ?>"></div>;

<?php endwhile; ?>

Upvotes: 0

user2696691
user2696691

Reputation: 91

echo "<div>";
while ($row=mysql_fetch_array($res)) {
    ?> <img src="<?php echo $row["imagem"]; ?>">

<?php 
}
echo "</div>"; ?>

Upvotes: 0

EliteTech
EliteTech

Reputation: 386

Try this 

<?php

mysql_connect("localhost","root","");
mysql_select_db("bravo");
$res=mysql_query("select * from coisas");
echo "<div>";
while ($row=mysql_fetch_array($res)) {

    echo "<img src=".$row["imagem"].">";

}
echo "</div>";
?>

Upvotes: 1

pulsar
pulsar

Reputation: 987

<?php

    mysql_connect("localhost","root","");
    mysql_select_db("bravo");
    $res=mysql_query("select * from coisas");

?>
<div>
<?php
    while ($row=mysql_fetch_array($res)) {

    echo "<img src=\"{$row['imagem']}\">";

    }
?>
</div>

Upvotes: 0

lovelyramos
lovelyramos

Reputation: 9559

<?php

mysql_connect("localhost","root","");
mysql_select_db("bravo");
$res=mysql_query("select * from coisas");

echo "<div>";
while ($row=mysql_fetch_array($res)) { ?>

 <img src="<?php echo $row["imagem"]; ?>"> 
<?php 
}
echo "</div>";
?>

Upvotes: 0

Related Questions