pdo获取总记录数,如何获取得到所查询的数据的条数?
- <?php
- $dsn='mysql:dbname=zidiu;charset=utf8';
- $pdo=new PDO($dsn,'root','admin123456');
- $stmt=$pdo->query('select * from products');
- ?>
- <html>
- <head>
- <title>分页功能</title>
- </head>
- <body>
- <?php
- $pagesize=10;
- echo $stmt->rowCount();
- ?>
- </body>
- </html>
复制代码
|
|