How can I know how many rows are affected when the mysql-php PDO object performs preprocessing?

Normal mode, with $pdo->exec ($SQL); Can return the number of affected rows;

How do I know how to affect the number of rows if I insert delete data into a preprocessed object?
$stmt = $pdo->prepare ($SQL);
$stmt->execute ();

Reply content:

Normal mode, with $pdo->exec ($SQL); Can return the number of affected rows;

How do I know how to affect the number of rows if I insert delete data into a preprocessed object?
$stmt = $pdo->prepare ($SQL);
$stmt->execute ();

$stmt=$pdo->prepare($SQL);$stmt->execute();$count = $stmt->rowCount();//删除行数

Pdostatement::rowcount () returns the number of rows affected by the previous delete, INSERT, or UPDATE statement executed by the corresponding Pdostatement object.
If the previous SQL statement executed by the related pdostatement is a SELECT statement, some data may return the number of rows returned by this statement. However, this approach does not guarantee that all data is valid and should not be relied upon for portable applications.

