FOUND_ROWS（）保持返回0 [英] FOUND_ROWS() keeps returning 0

问题描述

$result = $db_con->query("SELECT SQL_CALC_FOUND_ROWS * FROM users LIMIT 0,10");

$count_result = $db_con->query("SELECT FOUND_ROWS() as totalcount");
$row = $count_result->fetch_assoc();
$total = $row['totalcount'];

$ total保持返回0，即使$ result包含其中的所有用户行。 >

$total keeps returning 0 even though the $result contains all the user rows in it.

ini_set("mysql.trace_mode", "0");

我通过在这里搜索类似的Q找到了此设置，但它没有解决我的问题。

I found out about this setting via searching a similar Q on here, but it did not resolve my issue.

当我在MySQL客户端中使用2个select语句时，它总是输出正确的计数。只是不能看出如何让它的工作在我的PHP页面。

When I use the 2 select statements in my MySQL client it always outputs the right count. Just can't seem to figure out how to get it working on my php page.

PHP版本：5.2.5 build 6
MySQL版本：5.1。 30

PHP Version: 5.2.5 build 6 MySQL Version: 5.1.30

注意：我在这里提供的代码没有在我的实际项目中使用，但是，它证明了我遇到的问题，无法检索总计数。这个代码，从我读过的关于found_rows（），应该工作，但不是。

Note: The code I provided here is not being used on my actual project, however, it does exemplify the problem I am having with not being able to retrieve the total count. This code, from what I've read about found_rows(), should work but it doesn't.

推荐答案

net我发现有人可能是同样的问题。他说的是可能发生的竞争条件： php .net 。基本上，他通过暂时锁定表来以减慢事情为代价来解决这个问题。

On php.net I found someone with maybe the same problem. He is speaking of a race condition that could occur: php.net. Basically he solves this problem by temporary locking the table at the cost of slowing things down.

这篇关于FOUND_ROWS（）保持返回0的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！