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

[Jim S.]

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?

[Bart Van der Donck]

> 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

[Bart Van der Donck]

> 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

[Bart Van der Donck]

> 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