phpeveryday.com

Create a database, for example "test". Then create table. This is the query:

CREATE TABLE `books` (
`id` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`title` VARCHAR( 255 ) NOT NULL ,
`author` VARCHAR( 60 ) NOT NULL
) ENGINE = MYISAM ;

Next, try to insert sample data, such as:

INSERT INTO `test`.`books` (
`id` ,
`title` ,
`author`
)
VALUES (
NULL , 'PHP Undercover', 'Wiwit Siswoutomo'
), (
NULL , 'PHP Enterprise', 'Wiwit Siswoutomo'
);

Ok, next post we will try how to connect database use PHP ADOdb as data access tier.