Question

php sql语句与变量到底怎么拼接？

如图，php sql语句与变量如何拼接

Answer 1

要考虑到字符串本身是要用引号括住的，所以要这样：
$sql = "insert into users (slug,email,`password`,nickname) values ('".$slug."','".$email."','".$password."','".$nickname."')";
或者
$sql = "insert into users (slug,email,`password`,nickname) values ('$slug','$email','$password','$nickname')";