How To Edit Phpmyadmin

[enigmabunny]

hi ive been having difficulty installing contributions, and think its because ive not been editing the phpmyadmin side of things, and to be honest, i havent a clue what it is. ive managed to log into phpmyadmin. but havnt a clue what to do. here is an example of something that i need to be doing:

 

Step 7.

Run this statment in phpMyAdmin (or your fav database program)

 

 

CREATE TABLE `visitor` (

`email` VARCHAR( 255 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL ,

PRIMARY KEY ( `email` )

) ENGINE = MYISAM ;

 

its all gibberish to me at the moment. sorry guys.

 

Eddie

[awarner20]

hi ive been having difficulty installing contributions, and think its because ive not been editing the phpmyadmin side of things, and to be honest, i havent a clue what it is. ive managed to log into phpmyadmin. but havnt a clue what to do. here is an example of something that i need to be doing:

 

Step 7.

Run this statment in phpMyAdmin (or your fav database program)

CREATE TABLE `visitor` (

`email` VARCHAR( 255 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL ,

PRIMARY KEY ( `email` )

) ENGINE = MYISAM ;

 

its all gibberish to me at the moment. sorry guys.

 

Eddie

 

 

Hi Eddie,

 

phpMyAdmin is a database manager. Your store has a database. This database is where your product information is stored, names, prices, descriptions, etc. The osC code requests information from the database and then writes that to your webpages.

 

You can also insert information to your database, like when a customer enters their address, this gets inserted into your database.

 

I would recommend doing a little research online into databases and what they're used for and also SQL. You should be able to understand the basics fairly quickly. There is also the phpMyAdmin online help.

 

Hope this helps to lift the fog a bit.

 

Adam