· 8 years ago · Jul 30, 2018, 10:28 PM
1Not putting variable in MySQL table
2$chars = "abcdefghijkmnopqrstuvwxyz023456789";
3srand((double)microtime()*1000000);
4$i = 0;
5$actc = '' ;
6while ($i <= 11) {
7$num = rand() % 33;
8$tmpc = substr($chars, $num, 1);
9$actc = $actc . $tmpc;
10$i++;
11}
12 mysql_query("INSERT INTO users (username, pass, email, ip, actc)
13 VALUES ('".$nl."', '".$pw."', '".$email."', '".$_SERVER['REMOTE_ADDR']."', '".$actc."')") or die(mysql_error());
14
15CREATE TABLE IF NOT EXISTS `users` (
16 `id` int(11) NOT NULL auto_increment,
17 `username` varchar(255) NOT NULL,
18 `pass` varchar(60) NOT NULL,
19 `email` varchar(255) NOT NULL,
20 `ip` varchar(20) NOT NULL,
21 `actc` int(11) NOT NULL,
22 PRIMARY KEY (`id`)
23) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4531 ;
24
25CREATE TABLE IF NOT EXISTS `users` (
26 [...]
27 `actc` varchar(11) NOT NULL,
28 PRIMARY KEY (`id`)
29);
30
31CREATE TABLE IF NOT EXISTS `users` (
32 `id` int(11) NOT NULL auto_increment,
33 `username` varchar(255) NOT NULL,
34 `pass` varchar(60) NOT NULL,
35 `email` varchar(255) NOT NULL,
36 `ip` varchar(20) NOT NULL,
37 **`actc` varchar(11) NOT NULL,**
38 PRIMARY KEY (`id`)
39) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4531 ;