mysql represent images

Anon

I wish to create a database that will include information about 16000 files and i wish to add to a table this information.
filename and where it is
keywords
title of cdrom (where can i found them)
category and subcategory and other relational category.like for example i could do the query like selecting woman and then i could select young or orld woman for example,
and when i do the query like book i wish to know if i can see the result with the images that has book in the keyword and another option that this image can be clicked and see the rest of the images of that cd and can be selected directly by filename or by full cd.
Anyone know that if mysql can do this? is too dificult to doing these by myself or not?.

Thanks in advance.

maranza

woooooooaaaahhh good luck! you'll need it :-)
As for you mysql-images question, i'd say yes you can.
All you have to do is have a img field in your table, a LONGBLOB type. Then you must do an upload script (this is the hardest part) wich gets the file data, addslashes it, and stick it into your img field.
Then you must create a file wich functions as img.
For example, you create the file as showimg.php.
Then you add in this file
header("Content-type: $row->imagetype");
$row->imagetype is the row fetched, the imagetype column (image/gif won't work if your img is a jpeg, you should find the mime type in the uploading script and store it the db in the imagetype field)
and then

echo "$row->img";

So, except for the file extension, this file looks like an image. You can display it on your browser like normal img <img src="showimg.php?id=6">
Understood?

elklabone

OR you could load all of your images into a directory on your webserver using a systematic naming method such as img006.jpg and then simply refer to that image url in your database..

Anon

i prefer the solution of mark hall but how can i do this fast with about 19000 images i have on the web site?.
And also i wish to add keywords to these images and category like colecction,sports,travel,etc and i wish to do this with php and mysql,can these be done?.
And the last thing for example you search for book and then a few images of books is been showing how can i select any of these images and get more details of these image and i could select to view all the rest of the images of that cd?.
And what about shopping cart?.

Thanks in advance.