doumeng3345 2011-08-28 00:55
浏览 53


I have a for statement that runs a few mysql querys but they wont always be the same number of querys like this:

    $results[$i] = mysql_query("[ACTUAL MYSQL QUERY]");

As you can see I put the result into an array, and I want to make sure all of the queries were successful using an if statement. How would I do that, I was thinking eval() but that doesn't seem reliable.

  • 写回答

2条回答 默认 最新

  • drvpvmz16241016 2011-08-28 00:59

    You can use array_filter to check the whole $result list at once, because mysql_query will return false for failed queries.

    if (count($results) == count(array_filter($results))) {
        // all succeeded

    (I believe you might however run into problems if you keep too many concurrent query handles open; they consume some memory. So maybe you should rather do an immediate mysql_fetch_assoc in your loop, or just keep a boolean, then free the result handles.)

    本回答被题主选为最佳回答 , 对您是否有帮助呢?



  • ¥20 keepalive配置业务服务双机单活的方法。业务服务一定是要双机单活的方式
  • ¥50 关于多次提交POST数据后,无法获取到POST数据参数的问题
  • ¥15 win10,这种情况怎么办
  • ¥15 如何在配置使用Prettier的VSCode中通过Better Align插件来对齐等式?(相关搜索:格式化)
  • ¥100 在连接内网VPN时,如何同时保持互联网连接
  • ¥15 MATLAB中使用parfor,矩阵Removal的有效索引在parfor循环中受限制
  • ¥20 Win 10 LTSC 1809版本如何无损提升到20H1版本
  • ¥50 win10 LTSC 虚拟键盘不弹出
  • ¥30 微信小程序请求失败,网页能正常带锁访问
  • ¥15 Matlab求解微分方程,如何用fish2d进行预优?