Shopping Cart Database

[Webitry]

I seek to educate myself on e-commerce Shopping Carts before I move up to the mainstream versions. I found this plaincart tutorial at

http://www.phpwebcommerce.com/php-mysql ... torial.php

and I seek to get an understanding of it as it presents a good learning environment. I have installed it in WAMP on my local machine but I get the following message when I run it.

Message = Cannot select database. Unknown database 'plaincart.sql'. Yet the plaincart.sql is within the library files.

Any clues or pointers to get me started with this thing.

Thanking You.

[jorgepinho]

Hi,

Probably that is a script to create the DB, not the DB itself

If it is mySQL, you have to install mysql

--
Jorge
Live Help on Skype: lets.talk.about.help
(languages: english, portuguese)

[Webitry]

Hi,

Thanks for your comments. I need to think about this a bit. The plaincart.sql lists the tables that forms the database! Being a bit new to PHP and mySql I am not getting the meaning of 'not the DB itself' Could you please elabourate a bit more please.

Your next sentence seems to tax my learning ability.... I thought that I had mysql installed! Again, forgive me for asking you to expand here again.

Have a good evening.

[jorgepinho]

Hi,

Ah! ok... you have WAMP!

Mysql is a server... this server has many databases (DB). You can create a DB by hand... table by table, field by field... or you can run a script.

The .sql file that you have is a script, it has commands that will create all the tables for you. So you have to run that script on Mysql environment.

Go to Mysql install folder and run mysql.exe, it will open a command line tool that allows you to control all the Mysql server. Or, you can install "mysql workbench", its a front-end to mysql server.

After the script runs sucessfully, you have a working DB!

You will need to put somewhere on PHP some config to connect to mysql (host, username and password and DB)

--
Jorge
Live Help on Skype: lets.talk.about.help
(languages: english, portuguese)