CODEWITHSUNDEEP
phphtmlmysqlimageimageview
Taha Kirmani
Taha Kirmani

Reputation: 1274

How to Displaying an image with path stored in Database?

I have stored images path in database and images in project folder. Now i am trying to view all IMAGES with their PRODUCTS in my HTML template. I have written the following code and its given me an empty images box in the output and when i open that image box in the new tab, it opens the following URL.

 http://localhost/cms/1

Kindly tell me the way of referring images in 'img src ' tag.

enter image description here

include 'connect.php';

$image_query = "select * from product_images";
$image_query_run = mysql_query($image_query);
$image_query_fetch = mysql_fetch_array($image_query_run);


if (!$query=mysql_query ("select product_id,name from products")) {
    echo mysql_error();

} else {
    while ($query_array = mysql_fetch_array($query)) {
        echo '</br><pre>';

        $product_id = $query_array['product_id'];

        echo "<a href='single_product.php?product_id=$product_id' >";
        print_r ($query_array['name']);
        echo "</a>";

        echo "&lt;img src=". $image_query_fetch
        ['images'] ." alt=\"\" /&gt;";

        echo '</pre>';
    }
}

} else {
    echo "You need to Log in to visit this Page";

}

Upvotes: 0

Views: 21847

Answers (2)

Malaiyandi Murugan
Malaiyandi Murugan

Reputation: 393

Add your local image path before source

example

echo "<img src='http://localhost/cms/1/". $image_query_fetch['images'] .'" alt=\"\" />";

*Use PHP *

<?php echo "http://" . $_SERVER['HTTP_HOST'] . $_SERVER['REQUEST_URI']; ?>

Upvotes: 2

Lars Juel Jensen
Lars Juel Jensen

Reputation: 1683

You can use the HTML base tag to set a base URL that relative URLs will be resolved from. See -> http://www.w3schools.com/tags/tag_base.asp

Upvotes: 1

Related Questions