|
STEP 1: Create SQL Tables to insert registration dates - PHP Login script free
SQL tables are used to store login data: usually the user name, password, date added and user IP.
You can store much more data about the user depending on which contains the registration form.
The code for SQL tables.
CREATE TABLE IF NOT EXISTS `usr__s_` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(34) NOT NULL,
`password` varchar(15) NOT NULL,
`mail` varchar(30) NOT NULL,
`date` varchar(12) NOT NULL,
`ip` varchar(20) NOT NULL,
PRIMARY KEY (`id_`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
|
top