Setup The Example Database

You must open class.DbTest.php and set the username, password, etc. to reflect your host settings.

Here is the SQL to create the table. After creating the table and updating class.DbTest.php, visit Value Objects (VOs). This will add rows to the user table while explaining what it's doing.

CREATE TABLE IF NOT EXISTS `user` (
  `user_id` int(5) unsigned NOT NULL AUTO_INCREMENT,
  `username` varchar(40) NOT NULL,
  `pwd` varchar(40) NOT NULL,
  PRIMARY KEY (`user_id`),
  KEY `username` (`username`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=21 ;