Counting lines reached PDO

Question

I’m doing a query and need to count the number of returned lines, I’m not usually used to doing this in PDO, follow my code below.

$sqlCODCEL = $conn->prepare("SELECT * FROM tbl_CELULAS WHERE TXT_CODIG_SECUR = :codCEL");
$sqlCODCEL->bindParam(":codCEL", $lbl_CODCELULA);
$linha = $sqlCODCEL->fetchAll();
$count = count_chars($linha);

error_log($count);

Answer 1

Use the method rowCount() it returns the lines affected by a DML(Insert, update delete) in some databases also returns the rows of a select, in mysql it works correctly.

$linhas =$sqlCODCEL->rowCount();

Related:

How to get the number of rows of a select with SQL Server.

Answer 2

In order for you to get back the amount of affected lines, you have to use rowCount();.
Probably, $linhasafetadas = $sqlCODCEL->rowCount() will solve your problem.

---

An example:

<?php
/* Delete all rows from the FRUIT table */
$del = $dbh->prepare('DELETE FROM fruit');
$del->execute();

/* Return number of rows that were deleted */
print("Return number of rows that were deleted:\n");
$count = $del->rowCount();
print("Deleted $count rows.\n");
?>

Return:

Return number of Rows that Were Deleted: Deleted 9 Rows.

Source: php.net