新版本的pdo会有这个问题:
general error: 2014 cannot execute queries while other unbuffered queries are active. consider using pdostatement::fetchall(). alternatively, if your code is only ever going to run against mysql, you may enable query buffering by setting the pdo::mysql_attr_use_buffered_query attribute.' in。。。
意思是要么使用fetchall(),要么使用mysql_attr_use_buffered_query这个属性,前者不想那样用,因为担心占用内存,后者发现没效果。
<span>$this</span>->db->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, <span>true</span>);
参考博客:
http://www.flashj.cn/wp/pdo-transaction-err-in-php.html
PHP怎么学习?PHP怎么入门?PHP在哪学?PHP怎么学才快?不用担心,这里为大家提供了PHP速学教程(入门到精通),有需要的小伙伴保存下载就能学习啦!
Copyright 2014-2025 https://www.php.cn/ All Rights Reserved | php.cn | 湘ICP备2023035733号