How to display through php an image stored in a folder considering that my image's link is stored in MySQL database

Question

As good practice, I'm only storing my image's link in my database, the questios are:

How should I store my image's link? (let's say it's on c:)

c://image.jpg?

Which peace of PHP code should I use to display that image? I'm only displaying the path, what should I do to display the image?

Can I use this:

$query = "SELECT ImageURL from WhateverTable";

$result = mysql_query($query) or die(mysql_error());

$Image = mysql_fetch_row($result);

echo "<img src='$Image[0]' alt='This is an image'>";

Thank you all lads

the images should be somewhere visible to a browser. then use the img tag above. — Alex Gittemeier, Feb 24 '13 at 20:34

score 3 · Accepted Answer · answered Feb 24 '13 at 20:45

3

You only want to store the relative path, not the absolute path, as linking to something like

 <img src="/var/www/vhosts/website.com/images/file.jpg">

would return a 404 on any real website. store your files in the database via a relative path (/images/file.jpg) or by only the filename if they are all in the same directory.

alternatively, you can learn MongoDB and it allows you to actually store files in the database itself.

answered Feb 24 '13 at 20:45

skrilled

5,350
2
26
48

1

That is exactly what worked for me, storing inside "image". It is awesome to see that image mate! thanks a lot for your help skrilled – Alan Feb 24 '13 at 21:50

score 2 · Answer 2 · answered Feb 24 '13 at 21:42

I would strongly suggest that you use PDO instead.
Use relative URLs to your image folder in case you need to move them one day.

Here is an example.

// relative to your public webroot
$publicImageUrl = '/images/in/here';

// Pull up some record, maybe of a product 
$select = 'SELECT imageFilename FROM products WHERE id = 2332';
$results = mysql_query($select);
if(!$results) {
    // issue with query. deal with it here
} else {
    if( mysql_num_rows($result) ) {
        // record not found. deal with it here
    }

    $row = mysql_fetch_array($result);

    $imageSrc = $publicImageUrl  . '/' . $row['imageFilename'];
}

And then your HTML would be as follows

<img src="<?php echo $imageSrc; ?>" />

Thanks Adam, this approach seems to be a good practice mate, I'll try to apply it, I'm first trying to understand everythig. I will look and see other PDO examples...Thanks a lot! — Alan, Feb 24 '13 at 22:07

score 0 · Answer 3 · answered Feb 24 '13 at 20:43

0

use PDO for php <-> mysql connection
post mysql query output

answered Feb 24 '13 at 20:43

Eugen

1,356
12
15

How to display through php an image stored in a folder considering that my image's link is stored in MySQL database

3 Answers3

Linked