Images in database

norwid

I am new to php. How do I store images in db with text description, links, etc.? I am planning on building a search engine and have that info displayed in search results together with images, text, links, for every result. Any help will be appreciated.

philosophology

I'm guessing you would put it in a table... a field for the pointer to the image file, a field for the description, etc.

dougal85

Store the filename in the database - not the actual file.

chetan1

U should put image in databse.

leatherback

chetan1 wrote:
U should put image in databse.

didnt you just ask how to do it yourself here?

Common view is that in most cases it is most efficient to store the path to a file, instead of the actual image data in the database.

norwid

No I didn't post anything elsewhere. Read the manual, browsed the forums, this is the first time I asked. Received 0 answers, but again you can't expect much from some wanabes.

NogDog

norwid wrote:
No I didn't post anything elsewhere. Read the manual, browsed the forums, this is the first time I asked. Received 0 answers, but again you can't expect much from some wanabes.

Leatherback was responding to Chetan1's post, not yours.

bardell38

okay so what if i did this, i would store the photos in a separate folder and the database contained

ID
PHOTOURL
VIEWS

now, lets just say liek 10 people keep uploading photos at the same time, it would all be placed in order and store them in the databse and teh folder and should not be a problem. but in order to make sure that the image gets put immediately in the slideshow, is it possible that each image that gets displayed for a certain amount of time would have to connect to the database

i understand that javascript makes teh slideshow but when you are calling the images in the beginning is it possible to replace that with MYSQL so that every image means connecting to the database and getting the link to the site just from there based on the id number? how would you mix the javascript in with the MYSQL?

leatherback

You might want to store the ID of the person uploading the file too. That way this person could be allowed to modify/delete the photo if he accidentally uploaded a pic of his granny, instead of his holiday snaps.

The system woul work:
=> PhP calls upon the database to give a certain set of photo records, which the database happily provides
=> PhP takes these, and generates a valid javascript statement (Probably a js array) and the rest of the page
=> The browser receives the valid HTML and JS, and starts running the slideshow.