5.0.0 - 普通 - 未处理
// 鉴权 使用 ？号占位符时 占位参数 会影响下一条SQL语句
$sql = 'SELECT a.`title`, a.`rules` FROM authgroup a INNER JOIN authgroupaccess g ON a.`id` = g.`group` WHERE g.`status` = 2 AND g.`account` = ? AND a.`status` = 2 AND a.`id` = ? limit 1';
$data = Db::query($sql, ['admin', 1]);
// 查询日志表的SQL语句前带有上一次查询的参数
// "'1'admin'ELECT * FROM `log` ORDER BY `id` DESC LIMIT 0,15"
// 鉴权 使用 键值对绑定参数时 则不会影响下一条SQL 语句
$sql = 'SELECT a.`title`, a.`rules` FROM authgroup a INNER JOIN authgroupaccess g ON a.`id` = g.`group` WHERE g.`status` = 2 AND g.`account` = :account AND a.`status` = 2 AND a.`id` = :aid limit 1';
$data = Db::query($sql, ['account' => 'admin', 'aid' => 1]);
// 查询日志表
// "SELECT * FROM `log` ORDER BY `id` DESC LIMIT 0,15" 