Question

为什么pdostatement：execute：sqlstate

Answer 1

不知道你之前是怎么写的sql
我的sql语句之前是这样写的：INSERT INTO tablename SET a = ':a',b = ':b',c = ':c',d = :d,e = :e
然后我的出现了Warning: PDOStatement::execute(): SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens报错
然后改成：INSERT INTO tablename SET a = :a,b = :b,c = :c,d = :d,e = :e
正常插入数据 ，大概是参数化语句中不需要把字符串类型的参数加上引号吧，也确实感觉有点多此一举。
你可以试试

Answer 2

不知道你之前是怎么写的sql
我的sql语句之前是这样写的：INSERT INTO tablename SET a = ':a',b = ':b',c = ':c',d = :d,e = :e
然后我的出现了Warning: PDOStatement::execute(): SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens报错
然后改成：INSERT INTO tablename SET a = :a,b = :b,c = :c,d = :d,e = :e
正常插入数据 ，大概是参数化语句中不需要把字符串类型的参数加上引号吧，也确实感觉有点多此一举。
你可以试试