(PHP 5 >= 5.1.0, PECL pdo >= 0.1.0)
PDOStatement->rowCount — ﾄｾｶ皃ﾎ SQL ･ｹ･ﾆ｡ｼ･ﾈ･皈ﾈ､ﾋ､隍ﾃ､ﾆｺ隆ﾑ､ｷ､ｿｹﾔｿﾖ､ｹ
PDOStatement::rowCount() ､ﾏ ﾁ�ｹ､� PDOStatement ･ｪ･ﾖ･ｸ･ｧ･ｯ･ﾈ､ﾋ､隍ﾃ､ﾆｼﾂｹﾔ､ｵ､�ｿ ﾄｾｶ皃ﾎ DELETE, INSERT, UPDATE ﾊｸ､ﾋ､隍ﾃ､ﾆｺ隆ﾑ､ｷ､ｿｹﾔｿﾖ､ｷ､ﾞ､ｹ｡｣
ｴﾘﾏ｢､ｹ､� PDOStatement ､ﾋ､隍ﾃ､ﾆｼﾂｹﾔ､ｵ､�ｿﾄｾｶ皃ﾎ SQL ･ｹ･ﾆ｡ｼ･ﾈ･皈ﾈ､ｬ SELECT ﾊｸ､ﾎｾ�遑｢､､､ｯ､ﾄ､ｫ､ﾎ･ﾇ｡ｼ･ｿ･ﾙ｡ｼ･ｹ､ﾏﾊｸ､ﾋ､隍ﾃ､ﾆﾊﾖ､ｵ､�ｿ ｹﾔｿﾖ､ｹ､ｫ､篥ﾎ､�ﾞ､ｻ､｣､ｷ､ｫ､ｷ､ﾊ､ｬ､鬘｢ ､ｳ､ﾎｿｶ､�､､ﾏﾁｴ､ﾆ､ﾎ･ﾇ｡ｼ･ｿ･ﾙ｡ｼ･ｹ､ﾇﾊﾝｾﾚ､ｵ､�ﾆ､､､ﾞ､ｻ､｣ ､ｵ､ﾞ､ｶ､ﾞ､ﾊｾ�熙ﾇｻﾈﾍﾑ､ｹ､�｢･ﾗ･�ｱ｡ｼ･ｷ･逾ﾇ､ﾏ｡｢ ､ｳ､�ﾋﾍ熙ﾃ､ﾆ､ﾏ､､､ｱ､ﾞ､ｻ､｣
ｹﾔ､ﾎｿﾖ､ｷ､ﾞ､ｹ｡｣
ﾎ�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.
ﾎ�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