在PHP中使用PDO类获取num_rows时出现问题

问题描述

我刚刚更改了数据库连接.我还不习惯PDO类或OOP.无论如何，我这样连接到数据库:

I have just changed my database connection. I am not used to the PDO class or OOP yet. Anyway, I connect to the db like this:

        $dsn = "mysql:host=" . DB_HOST . ";dbname=" . DB_NAME;
        try
        {
            $this->db = new PDO($dsn, DB_USER, DB_PASS);
        }
        catch ( Exception $e )
        {
            die ( $e->getMessage() );
        }

我正在尝试从此查询中获取行数:

I am trying to get number of rows from this query:

    $ip = $this->ip();
    $sql = "SELECT `id` FROM `login_failed`
            WHERE `ip` = :ip AND `time` BETWEEN NOW( ) - INTERVAL 120 MINUTE AND NOW( )
            LIMIT 3";
    try
    {
        $stmt = $this->db->prepare($sql);
        $stmt->bindParam(':ip', $ip, PDO::PARAM_STR);
        $result = $stmt->execute(); // $result = true
        $n = $stmt->num_rows ; // n = NULL?
        $stmt->closeCursor();
    }
    catch (Exception $e)
    {
        die ($e->getMessage() );
    }

在phpmyadmin中，我得到一个结果，所以我的查询是正确的，但是由于某些原因，$n是NULL.如何使用PDO

In phpmyadmin I get a result so my query is correct, but $n is NULL for some reason.. How do I get number of rows with PDO

推荐答案

$stmt的类型为 PDOStatement .该类没有num_rows属性.

您可能正在寻找 rowCount ，但是该状态的文档:

You might be looking for rowCount instead, but the documentation for that states:

如果是这样的话，如果要实际SELECT所有数据，则可以通过遍历结果集来可靠地确定返回了多少行(或者只需调用 fetchAll 并计算数组中的项目).如果您不需要数据而只需要一个数字，请改用SELECT COUNT.

The long and the short if it is that, if you want to actually SELECT all that data, you can reliably determine how many rows were returned by iterating over the result set (or just call fetchAll and count the items in the array). If you don't need the data but just a number, use SELECT COUNT instead.

因此，要在不更改查询的情况下对行进行计数:

So, to count the rows without changing the query:

$result = $stmt->execute();
$rows = $stmt->fetchAll(); // assuming $result == true
$n = count($rows);

这篇关于在PHP中使用PDO类获取num_rows时出现问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！