Shopping Cart Database

Installation and configuration iussues

Moderators: macek, egami, gesf

Webitry
New php-forum User
New php-forum User
Posts: 2
Joined: Wed Jul 06, 2011 7:39 am

Shopping Cart Database

Postby Webitry » Wed Jul 06, 2011 7:56 am

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. :help: :(

Thanking You.

jorgepinho
New php-forum User
New php-forum User
Posts: 101
Joined: Tue Jul 05, 2011 5:41 am
Location: Portugal
Contact:

Re: Shopping Cart Database

Postby jorgepinho » Wed Jul 06, 2011 10:06 am

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
New php-forum User
New php-forum User
Posts: 2
Joined: Wed Jul 06, 2011 7:39 am

Re: Shopping Cart Database

Postby Webitry » Wed Jul 06, 2011 11:53 am

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
New php-forum User
New php-forum User
Posts: 101
Joined: Tue Jul 05, 2011 5:41 am
Location: Portugal
Contact:

Re: Shopping Cart Database

Postby jorgepinho » Wed Jul 06, 2011 1:53 pm

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)


Return to “MySQL Installation”

Who is online

Users browsing this forum: No registered users and 1 guest

cron