mysql - 查询构建器不显示变量？

Question

我运行这段代码:

$id = 1;
$email = 'email@gmail.com';

$user = DB::table('users')->where([
  ['id', '=', $id],
  ['email', '=', $email]
])->toSql();
dd($user);

但是查询生成器打印是:

select * from `users` where (`id` = ? and `email` = ?)

为什么不打印是:

select * from `users` where (`id` = 1 and `email` = email@gmail.com)

Answer 1

查询生成器插入字符代替值来保护你免受sql注入(inject)，然后他自己会根据需要为你设置值，你会得到最终的结果，并且你显示在屏幕只是查看查询查询