提示SQLSTATE[HY093]: Invalid parameter number: parameter was not defined

问题描述

代码如下

$sql = "select * from user where age>:age LIMIT :num";$map = ['age'=>16 , 'nmu'=>2];$res = Db::query($sql,$map);var_dump($res);

错误提示：SQLSTATE[HY093]: Invalid parameter number: parameter was not defined

错误信息：[10501]SQLSTATE[HY093]: Invalid parameter number: parameter was not defined[D:wwwroottp6.comvendortopthinkthink-ormsrcdbPDOConnection.php:722]

问题解答

已经解决，看了后面的教程，老师说是参数未定义，传参错误，然后仔细检查了下，原来是 num写错了