Images and mysql

[haymandan]

Hi all,

I was wondering If anyone knows how to insert images into MySQL and how to retrieve and display the images... VIA php.
Thanks

[rob::db]

Use a blob field, although I'd just prefer to leave them on the disc...


haymandan wrote:

> Hi all,
>
> I was wondering If anyone knows how to insert images into MySQL and
> how to retrieve and display the images... VIA php. Thanks

[tecknowjnkie]

rob:db is correct.

Typically, you'll want to save the path in the db only. You can still have
all the info about the file, title, alt text, and what not but simply have a
table set named path and inside have for example: /img/your-image.jpg .

[haymandan]

Thanks, got it working now but without using blob. I couldn't figure out what
to enter in the text field to get it to pen up the image file but I have it
now. this how I entered it to beable to access the image.

<img src="http://bucklehaven.com/images/2269.jpg">
Thanks