Setting up Database

I am having trouble setting up a database. I am a beginner and I am really grinding my teeth with this. Any help would be appreciated. I have watched the tutorials, but I still can't grasp what to do. Can anyone point me in the right direction? Thanks

Please provide some more details.

What step are you having difficulty with.

are you trying to use the MySQL eCommerce database:
ecommerce-database/

The learning resources page has a tutorial for "How to import a MySQL (.SQL) file to your database":
resources.php

are you getting stuck trying to follow this tutorial?

if so, What step?

I wasn't aware of the MySQL eCommerce database, but I know I was missing something like that. I will give this a try tonight and will post back with more detailed info/questions.

Where do I go to add my products to the database?

You would need to use a MySQL GUI Tool such as PHPMyAdmin, Sequel Pro or Sequel Yog to edit the data base directly.

or use a tool like data assist to create back end admin pages to insert products through your website.

Can you give me a a little breakdown of what the following fields from the WebAssist Free eCommerce MySQL database represent and examples?

productoptions

ProductID -

OptionID -

OptionGroupID -

OptionPriceIncrement -

Are any of these fields for putting sizes for products?

Also how would I be able to add the right weight if the larger sizes weigh more then the smaller sizes, would I just leave the weight column empty when I add a product?

Ok so I believe I got the above question figured out......but now I am stuck on getting the thumb to show in cart. I have uploaded the pic to my MySQL database. How do sync the pic to my products databse? The pics are in a database called pix as you can see in the screenshots below.

the images should not be stored in the database using the blob data type.

In your products table, create a column for the productImage

in that column, store the image file name:

myProduct.jpg

the files should be stored in a folder on your site, for instance:

productImages/myProduct.jpg


the productImage column in the products recordset will return the file name. in your img tag, you can use the data from the recordset:

<img src="productImages/<?php echo $row_RecordsetName['productImage'] ?>" />

Does that work for the product thumb as well?

yes, you would have a another column for the thumbnail as well, and use the same technique.