(PHP 5 >= 5.1.0, PHP 7, PECL pdo >= 0.1.0)
PDOStatement::rowCount — 锟斤拷锟斤拷锟斤拷锟斤拷一锟斤拷 SQL 锟斤拷锟接帮拷锟斤拷锟斤拷锟斤拷
PDOStatement::rowCount() 锟斤拷锟斤拷锟斤拷一锟斤拷锟缴讹拷应锟斤拷 PDOStatement 锟斤拷锟斤拷执锟斤拷DELETE锟斤拷 INSERT锟斤拷锟斤拷 UPDATE 锟斤拷锟斤拷锟接帮拷锟斤拷锟斤拷锟斤拷锟斤拷
锟斤拷锟斤拷锟揭伙拷锟斤拷锟斤拷锟斤拷 PDOStatement 执锟叫碉拷 SQL 锟斤拷锟斤拷锟揭伙拷锟� SELECT 锟斤拷洌拷锟叫╋拷锟斤拷菘锟斤拷芊锟斤拷锟斤拷纱锟斤拷锟戒返锟截碉拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟街凤拷式锟斤拷锟杰憋拷证锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷效锟斤拷锟揭讹拷锟节匡拷锟斤拷植锟斤拷应锟矫诧拷应锟斤拷锟斤拷锟节此凤拷式锟斤拷
锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷
Example #1 锟斤拷锟斤拷删锟斤拷锟斤拷锟斤拷锟斤拷
PDOStatement::rowCount() 锟斤拷锟斤拷锟斤拷 DELETE锟斤拷INSERT锟斤拷 锟斤拷 UPDATE 锟斤拷锟接帮拷锟斤拷锟斤拷锟斤拷锟斤拷
<?php
/* 锟斤拷 FRUIT 锟斤拷锟捷憋拷锟斤拷删锟斤拷锟斤拷锟斤拷锟斤拷 */
$del = $dbh->prepare('DELETE FROM fruit');
$del->execute();
/* 锟斤拷锟截憋拷删锟斤拷锟斤拷锟斤拷锟斤拷 */
print("Return number of rows that were deleted:\n");
$count = $del->rowCount();
print("Deleted $count rows.\n");
?>
锟斤拷锟斤拷锟斤拷锟教伙拷锟斤拷锟斤拷锟�
Return number of rows that were deleted: Deleted 9 rows.
Example #2 锟斤拷锟斤拷锟斤拷一锟斤拷 SELECT 锟斤拷浞碉拷氐锟斤拷锟斤拷锟�
锟斤拷锟节达拷锟斤拷锟斤拷锟斤拷菘猓�PDOStatement::rowCount() 锟斤拷锟杰凤拷锟斤拷锟斤拷一锟斤拷 SELECT 锟斤拷锟接帮拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷姆锟斤拷锟斤拷牵锟绞癸拷锟� PDO::query() 锟斤拷锟斤拷锟斤拷一锟斤拷锟斤拷原锟斤拷锟斤拷锟叫碉拷SELECT锟斤拷锟斤拷锟斤拷锟酵拷锟斤拷锟斤拷锟斤拷式锟斤拷 SELECT COUNT(*) 锟斤拷洌伙拷锟斤拷锟� PDOStatement::fetchColumn() 锟斤拷取锟矫凤拷锟截碉拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷应锟矫筹拷锟斤拷锟斤拷锟斤拷锟饺分达拷小锟�
<?php
$sql = "SELECT COUNT(*) FROM fruit WHERE calories > 100";
if ($res = $conn->query($sql)) {
/* 锟斤拷锟斤拷锟斤拷 SELECT 锟斤拷锟斤拷锟斤拷锟斤拷 */
if ($res->fetchColumn() > 0) {
/* 锟斤拷锟斤拷一锟斤拷锟斤拷锟斤拷锟斤拷 SELECT 锟斤拷洳拷锟斤拷锟斤拷锟斤拷氐慕锟斤拷 */
$sql = "SELECT name FROM fruit WHERE calories > 100";
foreach ($conn->query($sql) as $row) {
print "Name: " . $row['NAME'] . "\n";
}
}
/* 没锟斤拷匹锟斤拷锟斤拷锟� -- 执锟斤拷锟斤拷锟斤拷 */
else {
print "No rows matched the query.";
}
}
$res = null;
$conn = null;
?>
锟斤拷锟斤拷锟斤拷锟教伙拷锟斤拷锟斤拷锟�
apple banana orange pear