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