469,625 Members | 1,080 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,625 developers. It's quick & easy.

lots of data with pictures, how to put it in website database?

Hi guys,
i have lots of data for products (with different categories) and pictures
that i would need it entered into a database on the website. How would i go
about doing so?

i was thinking about an excel sheet with each category as a sheet but i have
no idea what to do about the pictures that will go with each product, (since
i would not want the pictures in the mysql database.)

any ideas?
Jul 19 '05 #1
3 1872
> i have lots of data for products (with different categories) and pictures
that i would need it entered into a database on the website. How would i go
about doing so?

i was thinking about an excel sheet with each category as a sheet but i have
no idea what to do about the pictures that will go with each product, (since
i would not want the pictures in the mysql database.)

any ideas?


The typical solution is to upload your images to a directory in your
website and then store their URL's in MySQL. That way you 'll avoid
considerable overhead and you will use far less memory.
I mostly work by giving the pictures names like [ProductID].jpg. So
you wouldn't need to store anything at all. It is the application that
talks to MySQL that then decides which photo belongs to which product.

Bart
Jul 19 '05 #2
> i have lots of data for products (with different categories) and pictures
that i would need it entered into a database on the website. How would i go
about doing so?

i was thinking about an excel sheet with each category as a sheet but i have
no idea what to do about the pictures that will go with each product, (since
i would not want the pictures in the mysql database.)

any ideas?


The typical solution is to upload your images to a directory in your
website and then store their URL's in MySQL. That way you 'll avoid
considerable overhead and you will use far less memory.
I mostly work by giving the pictures names like [ProductID].jpg. So
you wouldn't need to store anything at all. It is the application that
talks to MySQL that then decides which photo belongs to which product.

Bart
Jul 19 '05 #3
> i have lots of data for products (with different categories) and pictures
that i would need it entered into a database on the website. How would i go
about doing so?

i was thinking about an excel sheet with each category as a sheet but i have
no idea what to do about the pictures that will go with each product, (since
i would not want the pictures in the mysql database.)

any ideas?


The typical solution is to upload your images to a directory in your
website and then store their URL's in MySQL. That way you 'll avoid
considerable overhead and you will use far less memory.
I mostly work by giving the pictures names like [ProductID].jpg. So
you wouldn't need to store anything at all. It is the application that
talks to MySQL that then decides which photo belongs to which product.

Bart
Jul 19 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

9 posts views Thread by google_nospam | last post: by
10 posts views Thread by Dave Moore | last post: by
reply views Thread by JakeC | last post: by
5 posts views Thread by Simon | last post: by
3 posts views Thread by John | last post: by
1 post views Thread by FeelLikeANut | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.