Page 1 of 1

MySQL Questions...NEED HELP

Posted: Wed May 12, 2004 10:03 am
by pernks
How could I display images shared into mysql.......thanks for your help..

Posted: Wed May 12, 2004 10:25 am
by PrObLeM
pull the information (ie the url to the image) from the db and display it with html...

Code: Select all

echo'<img src="' . $url . '">';

Re: MySQL Questions...NEED HELP

Posted: Wed May 12, 2004 10:30 am
by pernks
OK I TRY IT

Posted: Wed May 12, 2004 5:37 pm
by pickle
Using blob (Binary Large OBject), you can store the image itself in MySQL. To be honest though, I'm not sure how to do it. I have also heard of a way to 64bit encode an image, and store it in a field of type 'text'. I'd try blob though.

Posted: Wed May 12, 2004 6:31 pm
by Weirdan
pickle wrote:To be honest though, I'm not sure how to do it.
Using load_file() mysql function perhaps ;)