WampServer

Hi everyone,

I am new to this forum and just started to learn how to use phyMyAdmin to create database. I have installed WAMP sever in my computer and the sever runs well(the icon is green).
I have a simple(maybe silly) question. In most web sites, the popular window like below will be open when clicking "Buy","Add to Cart" or "Purchase" button.
[www-ssl.futureshop.ca],

My question is that if I want to a database, how many columns do I need? what contents should be the columns.
Any advice is appreciated.But please be in details if possible. in above example, should I use two columns, one column is for phone name and another for price?

Henry0918

i doubt they have two columns,

it all depends how many tables your going to use

an example would be 7 Tables and the column structues below

Table Name	 	Description
tbl_category	 	Storing all product categories
tbl_product	 	The products
tbl_cart                When the shopper decided to put an item into the shopping cart
tbl_order	  	This is where the orders are saved
tbl_order_item          The items ordered
tbl_user	        Store all shop admin user account
tbl_shop_config	        Contain the shop configuration like name, address, phone number, email, etc

PK is Primary Key
FK is Foreign Key

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]



Edited 2 time(s). Last edit at 09/16/2012 07:49PM by stevenmartin99.

Thanks Steven for your help. I am still confused.
There is another example:

[www.skcshopping.com]


Can you please explain how to create database in phpMyAdmin.?

Thanks a lot.

i think you have no idea how to do this, its way to advanced for a beginner.


maybe you should use a cms that has a shopping cart

check google > [www.google.ie]

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

Henry, I would suggest doing some research online for PHP/MySQL tutorials. There are many that are free and well worth pursuing. There are also many that are not free, but are still worth checking out.

Creating shopping carts is not something a novice should dive into. No offense meant here, but you need to learn how to crawl before you start trying to run the 4 minute mile.