您现在的位置是:PDO fetch 模式各种参数的输出结果
PDO fetch 模式各种参数的输出结果
PDO::FETCH_ASSOC 关联数组形式。
PDO::FETCH_NUM 数字索引数组形式。
PDO::FETCH_BOTH 两者数组形式都有,这是默认的。
PDO::FETCH_OBJ 按照对象的形式,类似于以前的mysql_fetch_object()函数。
PDO::FETCH_BOUND 以布尔值的形式返回结果,同时将获取的列值赋给bindParam()方法中指定的变量。
PDO::FETCH_LAZY 以关联数组、数字索引数组和对象3种形式返回结果。
<?php $dbAdapter = new PDO("mysql:host=localhost;dbname=test", "root", "1234"); $dbAdapter->exec("SET NAMES 'utf8';"); $data = $dbAdapter->query(" SELECT id, name, method FROM category ")->fetchAll(PDO::FETCH_ASSOC); //var_dump($data); /* array( array( 'id' => '1', 'name' => 'HBO', 'method' => 'service', ), array( 'id' => '2', 'name' => '本周新片', 'method' => 'movie', ), array( 'id' => '3', 'name' => '热映中', 'method' => 'movie', ), ) */ $data = $dbAdapter->query(" SELECT name, method FROM category ")->fetchAll(PDO::FETCH_COLUMN); //var_dump($data); /* array( 'HBO', '本周新片', '热映中', ) */ $data = $dbAdapter->query(" SELECT id, name, method FROM category ")->fetchAll(PDO::FETCH_UNIQUE | PDO::FETCH_ASSOC); //var_dump($data); /* array( '1' => array( 'name' => 'HBO', 'method' => 'service', ), '2' => array( 'name' => '本周新片', 'method' => 'movie', ), '3' => array( 'name' => '热映中', 'method' => 'movie', ), ) */ $data = $dbAdapter->query(" SELECT method, id, name FROM category ")->fetchAll(PDO::FETCH_UNIQUE | PDO::FETCH_ASSOC); //var_dump($data); /* array( 'service' => array( 'id' => '1', 'name' => 'HBO', ), 'movie' => array( 'id' => '3', 'name' => '热映中', ), ) */ $data = $dbAdapter->query(" SELECT id, name, method FROM category ")->fetchAll(PDO::FETCH_UNIQUE | PDO::FETCH_COLUMN); //var_dump($data); /* array( '1' => 'HBO', '2' => '本周新片', '3' => '热映中', ) */ $data = $dbAdapter->query(" SELECT method, name, id FROM category ")->fetchAll(PDO::FETCH_UNIQUE | PDO::FETCH_COLUMN); //var_dump($data); /* array( 'service' => 'HBO', 'movie' => '热映中', ) */ $data = $dbAdapter->query(" SELECT method, id, name FROM category ")->fetchAll( PDO::FETCH_ASSOC | PDO::FETCH_GROUP); //var_dump($data); /* array( 'service' => array( array( 'id' => '1' 'name' => 'HBO' ), ) 'movie' => array( array( 'id' => '2' 'name' => '本周新片' ), array( 'id' => '3' 'name' => '热映中' ), ) ) */ $data = $dbAdapter->query(" SELECT method, name, id FROM category ")->fetchAll(PDO::FETCH_GROUP | PDO::FETCH_COLUMN); //var_dump($data); /* array( 'service' => array( 'HBO' ), 'movie' => array( '本周新片' '热映中' ), ) */ $data = $dbAdapter->query(" SELECT id, name, method FROM category ")->fetchAll(PDO::FETCH_OBJ); //var_dump($data); /* array( stdClass{ public $id = '1'; public $name = 'HBO'; public $method = 'service'; }, stdClass{ public $id = '2'; public $name = '本周新片'; public $method = 'movie'; }, stdClass{ public $id = '3'; public $name = '热映中'; public $method = 'movie'; }, ) */ class Category_1 {} $data = $dbAdapter->query(" SELECT id, name, method FROM category ")->fetchAll(PDO::FETCH_CLASS | PDO::FETCH_PROPS_LATE, "Category_1"); //var_dump($data); /* array( Category_1{ public $id = '1'; public $name = 'HBO'; public $method = 'service'; }, Category_1{ public $id = '2'; public $name = '本周新片'; public $method = 'movie'; }, Category_1{ public $id = '3'; public $name = '热映中'; public $method = 'movie'; }, ), */ class Category_2 { public $name; public $method; public function __construct() {} public function __set($name, $value ){} } $data = $dbAdapter->query(" SELECT id, name, method FROM category ")->fetchAll(PDO::FETCH_CLASS | PDO::FETCH_PROPS_LATE, "Category_2"); //var_dump($data); /* array( Category_2{ public $name = 'HBO'; public $method = 'service'; }, Category_2{ public $name = '本周新片'; public $method = 'movie'; }, Category_2{ public $name = '热映中'; public $method = 'movie'; }, ) */
站长简介
姓名:喻理
微信:yuli0927
邮箱:yuli0927@126.com
不懂业务的运维工程师不是一个好程序员。
微信:yuli0927
邮箱:yuli0927@126.com
不懂业务的运维工程师不是一个好程序员。
分类
最新文章
热门文章
- 微信支付退款结果通知解密
- Linux修改密码提示passwd /usr/share/cracklib/pw_dict: error reading header
- 到ICANN投诉三五互联获取域名转移密码成功
- {"errcode":45047,"errmsg":"out of response count limit hint]"}
- 微信html弹出点击右上角分享到朋友圈
- CentOS使用chkconfig提示systemctl enable xxxx.service
- PHP将B转换为KB、MB、GB
- Apache禁用TRACE Method和添加X-frame-options响应头
- mysqld_safe Number of processes running now
- 构建微信公众号被动回复image图片消息xml