注册数据不工作mysql

Question

With below code, I am getting no error but it stuck at register page and didn't put data in database

 $sql="INSERT INTO `user`(`id`, `first_name`, `last_name`, `email`, `gender`, `date`, `password`, `hash`, `active`) VALUES ([NULL],[$first_name],[$last_name],[$email],[$ty],[$date],[$password],[$hash],[0]);";

And

$sql = "INSERT INTO `user` (`id`, `first_name`, `last_name`, `email`, `gender`, `date`, `password`, `hash`, `active`)  //VALUES (NULL, '$first_name', '$last_name', '$email', '$ty', '$date', '$password', '$hash', '0');

the above was working fine.

Answer 1

you can not use this [] , second query is right :-

$sql = "INSERT INTO `user` (`id`, `first_name`, `last_name`, `email`, `gender`, `date`, `password`, `hash`, `active`)  //VALUES (NULL, '$first_name', '$last_name', '$email', '$ty', '$date', '$password', '$hash', '0');