note 107906 deleted from pdostatement.rowcount by danbrown
| From: | danbrown@php.net | Date: | Thu, 10 May 2012 18:10:37 +0000 |
| Subject: | note 107906 deleted from pdostatement.rowcount by danbrown | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-187730@lists.php.net to get a copy of this message | ||
Note Submitter: nuggez at gmail dot com
----
<?php
$sql = 'SELECT * FROM users WHERE point< :point';
$sth = $this->db->prepare($sql);
/* Bindparam to point */
$sth->execute(Array(':point' => 20));
$data = $sth->fetchAll();
/* Get the number of rows that match the SELECT statement */
$count = sizeof($data); /* or count($data) */
/* Print how many records found */
echo $count.' record found';
/* List data */
if ($count > 0) {
foreach ($data as $value) {
echo $value['Name'].'<br />';
}
}
}
?>