Create a Log In Page via PHP Script (1)

STEP 1. Create database "dp_ips" by MySQL
STEP 2. Create table "tb_ips_user"
----------------------------------------------
copy the script below into the Run SQL query / queries on database db_ips.
----------------------------------------------



1. SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

2. --
3. -- Database: `db_ips`
4. --

5. -- --------------------------------------------------------

6. --
7. -- Table structure for table `tb_ips_user`
8. --


9. CREATE TABLE IF NOT EXISTS `tb_ips_user` (
10. `id` int(11) NOT NULL AUTO_INCREMENT,
11. `iduser` varchar(8) NOT NULL,
12. `iuser` varchar(100) NOT NULL,
13. `ipass` varchar(255) NOT NULL,
14. `ileve` varchar(1) NOT NULL,
15. `ilogin` varchar(1) NOT NULL,
16. `iactive` varchar(1) NOT NULL,
17. PRIMARY KEY (`id`),
18. UNIQUE KEY `iduser` (`iduser`)
19. ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

20. --
21. -- Dumping data for table `tb_ips_user`
22. --

23. INSERT INTO `tb_ips_user` (`id`, `iduser`, `iuser`, `ipass`, `ileve`, `ilogin`, `iactive`) VALUES
24. (1, 'erich marco', '1f6cffef2701681ecc52768c1d3504a4', '81dc9bdb52d04dc20036dbd8313ed055', '2', '0', '1'),
25. (2, 'junifer lang', 'ae2b1fca515949e5d54fb22b8ed95575', '81dc9bdb52d04dc20036dbd8313ed055', '1', '0', '1');