pdostatement-rowcount.md

title	description	author	ms.author	ms.date	ms.service	ms.subservice	ms.topic
PDOStatement::rowCount	API reference for the PDOStatement::rowCount function in the Microsoft PDO_SQLSRV Driver for PHP for SQL Server.	David-Engel	davidengel	08/10/2020	sql	connectivity	reference

PDOStatement::rowCount

[!INCLUDEDriver_PHP_Download]

Returns the number of rows added, deleted, or changed by the last statement.

Syntax

  
int PDOStatement::rowCount ();  

Return Value

The number of rows added, deleted, or changed.

Remarks

If the last SQL statement executed by the associated PDOStatement was a SELECT statement, a PDO::CURSOR_FWDONLY cursor returns -1. A PDO::CURSOR_SCROLLABLE cursor returns the number of rows in the result set.

Support for PDO was added in version 2.0 of the [!INCLUDEssDriverPHP].

Example

This example shows two uses of rowCount. The first use returns the number of rows that were added to the table. The second use shows that rowCount can return the number of rows in a result set when you specify a scrollable cursor.

<?php  
$database = "Test";  
$server = "(local)";  
$conn = new PDO( "sqlsrv:server=$server ; Database = $database", "", "");  
  
$col1 = 'a';  
$col2 = 'b';  
  
$query = "insert into Table2(col1, col2) values(?, ?)";  
$stmt = $conn->prepare( $query );  
$stmt->execute( array( $col1, $col2 ) );  
print $stmt->rowCount();  
  
echo "\n\n";  
  
$con = null;  
$database = "AdventureWorks";  
$conn = new PDO( "sqlsrv:server=$server ; Database = $database", "", "");  
  
$query = "select * from Person.ContactType";  
$stmt = $conn->prepare( $query, array(PDO::ATTR_CURSOR => PDO::CURSOR_SCROLL));  
$stmt->execute();  
print $stmt->rowCount();  
?>  

See Also

PDOStatement Class

PDO