linking images from a mysql database.

[networktm]

In the mysql/php tutorials (which are great) only text/numeric entries are covered (id's , the jokes, names etc.). But what if you want to get an article from the database which includes an image? Is it possible to to get both the text and (the link to) the image from the database?

[TWTCommish]

networktm: I believe plain HTML can be entered into an SQL table...so you could just stick the image code in there and try to pull it out of the database...



------------------
Chris Bowyer
MyCoding.com: Join our mailing list for launch notification!
"I'm not an insomniac, I'm a web designer."

[jwynia]

Well, if you have a standard image directory and put the filename in the db, it's pretty simple to put it in.

<img src="path/to/<?php printf($filename); ?>">

Of course it assumes that you pulled the filename from the db and assigned it to $filename.

[qslack]

jwynia's way is the best but images and other binary data can be stored in DBs too. Just use BLOB to store the data. Like...

CREATE TABLE images (
//stuff...
IMAGEDATA BLOB,
);

[Kevin Yank]

Hopefully I'll have time to cover storing binary data in a MySQL database and displaying it as an image in an HTML page. If I don't, I'll be sure to post a link to the information somewhere on the Net.


------------------
-Kevin Yank.
http://www.SitePoint.com/
Helping Small Business Grow Online!

[networktm]

Thank you all for helping me.