为什么忽略MYSQLI_CLIENT_FOUND_ROWS？

Question

我使用mysqli将我的php代码连接到mysql，并使用MYSQLI_CLIENT_FOUND_ROWS选项来确保我的UPDATE语句将返回非零值，即使它们试图用已经持有的相同值更新记录。

$mysqli->real_connect(
            $this->DB_HOST,
            $this->DB_USERNAME,
            $this->DB_PASSWORD,
            $this->DB_DATABASE,
            3306,
            null,
            MYSQLI_CLIENT_FOUND_ROWS
    );

我现在安装了一个不起作用的新机器: php53 53，MySQL5.1.44- mysql发行版

在第一个框中，语句的'affected_rows‘是1，在第二个框中是0。

非工作箱的软件信息：

Apache/2.2.14 (Unix) DAV/2 mod_ssl/2.2.14 OpenSSL/0.9.8l PHP/5.3.1 mod_perl/2.0.4 Perl/v5.10.1

phpinfo for the non working box (我希望这里有足够的细节)：mysql

MySQL Support   enabled
Active Persistent Links 0
Active Links    0
Client API version  5.1.44
MYSQL_MODULE_TYPE   external
MYSQL_SOCKET    /Applications/XAMPP/xamppfiles/var/mysql/mysql.sock
MYSQL_INCLUDE   -I/Applications/XAMPP/xamppfiles/include/mysql
MYSQL_LIBS  -L/Applications/XAMPP/xamppfiles/lib/mysql -lmysqlclient
Directive   Local Value Master Value
mysql.allow_local_infile    On  On
mysql.allow_persistent  On  On
mysql.connect_timeout   60  60
mysql.default_host  no value    no value
mysql.default_password  no value    no value
mysql.default_port  no value    no value
mysql.default_socket    /tmp/mysql.sock /tmp/mysql.sock
mysql.default_user  no value    no value
mysql.max_links Unlimited   Unlimited
mysql.max_persistent    Unlimited   Unlimited
mysql.trace_mode    Off Off
mysqli

MysqlI Support  enabled
Client API library version  5.1.44
Active Persistent Links 0
Inactive Persistent Links   0
Active Links    0
Client API header version   5.1.44
MYSQLI_SOCKET   /Applications/XAMPP/xamppfiles/var/mysql/mysql.sock
Directive   Local Value Master Value
mysqli.allow_local_infile   On  On
mysqli.allow_persistent On  On
mysqli.default_host no value    no value
mysqli.default_port 3306    3306
mysqli.default_pw   no value    no value
mysqli.default_socket   /Applications/XAMPP/xamppfiles/var/mysql/mysql.sock /Applications/XAMPP/xamppfiles/var/mysql/mysql.sock
mysqli.default_user no value    no value
mysqli.max_links    Unlimited   Unlimited
mysqli.max_persistent   Unlimited   Unlimited
mysqli.reconnect    Off Off

working的php信息：

mysql
MySQL Support   enabled
Active Persistent Links 0
Active Links    0
Client API version  5.1.54
MYSQL_MODULE_TYPE   no value
MYSQL_SOCKET    /usr/local/zend/mysql/tmp/mysql.sock
MYSQL_INCLUDE   no value
MYSQL_LIBS  no value

Directive   Local Value Master Value
mysql.allow_local_infile    On  On
mysql.allow_persistent  On  On
mysql.connect_timeout   60  60
mysql.default_host  no value    no value
mysql.default_password  no value    no value
mysql.default_port  no value    no value
mysql.default_socket    /usr/local/zend/mysql/tmp/mysql.sock    /usr/local/zend/mysql/tmp/mysql.sock
mysql.default_user  zend    zend
mysql.max_links Unlimited   Unlimited
mysql.max_persistent    Unlimited   Unlimited
mysql.trace_mode    Off Off

mysqli

MysqlI Support  enabled
Client API library version  5.1.54
Active Persistent Links 0
Inactive Persistent Links   0
Active Links    0
Client API header version   5.1.54
MYSQLI_SOCKET   /usr/local/zend/mysql/tmp/mysql.sock

Directive   Local Value Master Value
mysqli.allow_local_infile   On  On
mysqli.allow_persistent On  On
mysqli.default_host no value    no value
mysqli.default_port 3306    3306
mysqli.default_pw   no value    no value
mysqli.default_socket   /usr/local/zend/mysql/tmp/mysql.sock    /usr/local/zend/mysql/tmp/mysql.sock
mysqli.default_user zend    zend
mysqli.max_links    Unlimited   Unlimited
mysqli.max_persistent   Unlimited   Unlimited
mysqli.reconnect    Off Off

你知道为什么吗？我在这里撞到头了.这不太可能是两个mysql之间的小版本号差异导致的……

Answer 1

当使用启用了mysqlnd的php而不是mysql原生客户端时，它工作得很好。但由于种种原因，我无法重新构建PHP。我最终通过macports (port install php53 php53-mysql)安装了一个新的PHP来解决这个问题。

Answer 2

而不是

MYSQLI_CLIENT_FOUND_ROWS

尝试使用整数

2

如下所示：

$mysqli->real_connect(
        $this->DB_HOST,
        $this->DB_USERNAME,
        $this->DB_PASSWORD,
        $this->DB_DATABASE,
        3306,
        null,
        2
);

它为我解决了问题...