Databases

[gntombel]

Can anyone please help me with a code snippet to extract a picture from mysql database and show on on the web using php. It's just that I'm new to databases so whenever I add an image to the database it's stored as a blob(I don't know what this means) so I don't know how to access it.

Another question is if there is an easier way to load images to mysql database.

[motorwatchercounter]

Hi Gntombel,

Are you still trying to get this to work?

2 bits of information. Have you tried some of the free photo viewer software already written and some free?

http://php.resourceindex.com/Complete_Scripts/Images_and_Graphs/Image_Indexing/

If you want to teach yourself some basic stuff have a look at this easy tutorial. Not for pictures but once you can do this you can create add to and view whatever is in the database.

http://www.freewebmasterhelp.com/tutorials/phpmysql/1

Remember that the sripts should be an "Include" which keeps your SQL log in details secret.

:lol:

[gntombel]

Yes I appreciate your input. I will try and study the tutorial. I'm not sure if you did get the last part of my question which is to load thousands of images into mysql database.

[motorwatchercounter]

Have a look at this.

http://www.weberdev.com/ViewArticle-3.html

[Nomad]

Either get a webhost who runs MySQL/PHP/phpMyAdmin or install in that order (You will also need Apache if you want to work from a local server- *Important* - Install this first -I made that mistake ;) ) installed first).

You can then go on a hunt to places like www.hotscripts.com and look in the php developement section.

This will be a far easier option for you in the short term and looking at your site that php software I mentioned in my pm would be perfect for you, though as I said it does need slight modification to remove the time out function.

Best and easiest way I know anyway..

:)