View Full Version : Databases
01-12-2005, 11:33 AM
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.
01-12-2005, 01:25 PM
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?
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.
Remember that the sripts should be an "Include" which keeps your SQL log in details secret.
01-12-2005, 01:45 PM
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.
01-12-2005, 02:04 PM
Have a look at this.
01-13-2005, 02:11 AM
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..
vBulletin® v3.8.5, Copyright ©2000-2013, Jelsoft Enterprises Ltd.