php PDO操作oracle，如何返回sql语句所影响的记录行数?

Question

rowCount() 方法试过好像没用；
下面这个方法也没用$sql = "SELECT COUNT(*) FROM folks";if ($STH = $DBH->query($sql)) { # check the row count if ($STH->fetchColumn() > 0) { # issue a real select here, because there's data! } else { echo "No rows matched the query."; }}

Answer 1

$sql = "select * from folks";$rs = $pdo->prepare($sql);//$rs->exec();$rs->execute();$num = $rs->rowCount();if（$num）{#}else{#}

Answer 2

$sql = "select count(*) from folks";$rs = $pdo->prepare($sql);$rs->execute();$num = $rs->fetchColumn();echo $num;