phpeveryday.com

We still use same database from previous practice. The database name is "zend". Now, create table for store members information. The table name is "users". You can use this query:

CREATE TABLE `users` (
  `id` int(11) NOT NULL auto_increment,
  `username` varchar(50) NOT NULL,
  `password` varchar(255) NOT NULL,
  `real_name` varchar(50) NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `username` (`username`)
);

Now, try to insert sample member data for example:

INSERT INTO `users` 
(`id`, `username`, `password`, `real_name`) 
VALUES 
(1, 'admin', '21232f297a57a5a743894a0e4a801fc3', 'Administrator');

Above, we insert a member with user name "admin". Actually, his password is admin. But, for security reason, we use MD5(), so that why, password is stored at database is 21232f297a57a5a743894a0e4a801fc3.

INSERT INTO `zend`.`users` (`id` ,`username` ,`password` ,`real_name`)
VALUES (NULL , 'admin', MD5( 'admin' ) , 'Administrator');

This is screenshot if we use phpMyAdmin.