This work has to be done in a client, since you have to manage external
files. If the files are all uniquely named, then you could use filename as a
key.
In my case, I was linking the images to a product in another table. I used
three tables:
prod_table:
==
prod_num /* an auto-increment key */
... /* other product specific information */
image_table:
===
image_num /* an auto-increment key */
original_image_name /* a key varchar field */
... /* other information about uploaded images, such as file type (.jpg,
.gif) */
prod_image_index:
prod_num /* a key, holds the product number from prod_table */
image_num /* a key, holds the image number from image_table */
Then I name each image the same as its image_num, regardless of its original
name. That avoids any collisions, and allows two images with the same
original name to coexist. When someone uploads an image that goes with a
specific product, I add a record to image_table and prod_image_index and
store the file. If a product is deleted, I can easily find and delete the
related image files when I delete the entries in prod_image_index.
If someone wants to see the images for a particular product, I find them in
prod_image_index. I follow the image_num back to image_table to get the
original file name for the user's convenience. I can then display the image
file (/imgs/1234, say) along with its original_file_name.
If the user then chooses to delete an image, then I delete the file
(/imgs/1234), the corresponding record in image_table, and the corresponding
records in prod_image_index.
I hope that helps.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
-Original Message-
From: Shain Lee [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 16, 2006 5:52 AM
To: MySql
Subject: Contents storing in mysql
Hi ,
I wanted to store images , musics, videos ..etc in mysql
database.storing contents as content type BLOB , i don't
have any issues with that setup.
But , now i need to store that contents in folders and
should be kept the contents path with referrence of
contents file name .
for eample , if i have a image called sky.jpg . and that
image stored in the /usr/local/wallpapers/sky.jpg.
In my database , i have defined fields like , filename ,
filesize, imagepath, contenttype.
How can i do that ?
can you give me any help ful links ?
Thanx in advance,
Shaine.
-
All New Yahoo! Mail - Tired of [EMAIL PROTECTED]@! come-ons? Let our
SpamGuard protect you.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]