N1DRWQCh

1$email = $mysqli->real_escape_string($_POST['email']);
2$password = $mysqli->real_escape_string($_POST['password']);
3$username =$mysqli->real_escape_string($_POST['username']);
4$salt     = sha1(md5($password)) . 'AAAAAAAA';
5$password = md5($password . $salt);
6
7$query = "INSERT INTO user_table (email, password, username) VALUES(?, ?, ?)";
8$insert_statement->bind_param('sss', $email, $password, $username);
9
10$insert_statement = $mysqli->prepare($query);
11if($insert_statement->execute()){
12print 'Success! ID of last inserted record is : ' .$insert_statement->insert_id .'<br />'; 
13}else{
14die('Error : ('. $mysqli->errno .') '. $mysqli->error);
15    }
16	
17CREATE TABLE IF NOT EXISTS `user_table` (
18  `id` int(5) NOT NULL AUTO_INCREMENT PRIMARY KEY,
19  `email` varchar(255) NOT NULL,
20  `password` varchar(255) NOT NULL,
21  `username` varchar(300) NOT NULL
22) ENGINE=InnoDB  DEFAULT CHARSET=latin1;