PHP编程：PHP PDO fetch 模式各种参数的输出结果一览
发布时间：2020-12-13 02:19:53 所属栏目：PHP教程 来源：网络整理
导读：《PHP PDO fetch 模式各种参数的输出结果一览》要点： 本文介绍了PHP PDO fetch 模式各种参数的输出结果一览，希望对您有用。如果有疑问，可以联系我们。 PHP编程 PDO 的 fetch 模式功能实在是太便利了,但每次要产生想要的结果都要试太麻烦了,这里列出可能的
|
《PHP PDO fetch 模式各种参数的输出结果一览》要点： PHP编程PDO 的 fetch 模式功能实在是太便利了,但每次要产生想要的结果都要试太麻烦了,这里列出可能的组合.
代码如下:
<必修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' => '热映中',?? )?? */??? ??? ??? ??? $data = $dbAdapter->query("?? ?? SELECT name,method FROM category?? ")->fetchAll(PDO::FETCH_COLUMN);??? ??? //var_dump($data);??? /*?? array(?? ?? 'HBO',?? ?? '本周新片',?? ?? '热映中',?? )?? */??? ??? ??? ??? $data = $dbAdapter->query("?? ?? SELECT id,method FROM category?? ")->fetchAll(PDO::FETCH_UNIQUE | PDO::FETCH_ASSOC);??? ??? //var_dump($data);??? /*?? array(?? ?? '1' => array(?? ?????? 'name' => 'HBO',?? ?? '2' => array(?? ?????? 'name' => '本周新片',?? ?? '3' => array(?? ?????? 'name' => '热映中',?? )?? */??? ??? ??? ??? $data = $dbAdapter->query("?? ?? SELECT method,id,name FROM category?? ")->fetchAll(PDO::FETCH_UNIQUE | PDO::FETCH_ASSOC);??? ??? //var_dump($data);??? /*?? array(?? ?? 'service' => array(?? ?????? 'id' => '1',?? ?? 'movie' => array(?? ?????? 'id' => '3',method FROM category?? ")->fetchAll(PDO::FETCH_UNIQUE | PDO::FETCH_COLUMN);??? ??? //var_dump($data);??? /*?? array(?? ?? '1' => 'HBO',?? ?? '2' => '本周新片',?? ?? '3' => '热映中',id FROM category?? ")->fetchAll(PDO::FETCH_UNIQUE | PDO::FETCH_COLUMN);??? ??? //var_dump($data);??? /*?? array(?? ?? 'service' => 'HBO',?? ?? 'movie' => '热映中',?? )?? */??? ??? ??? ??? ??? $data = $dbAdapter->query("?? ?? SELECT method,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,id FROM category?? ")->fetchAll(PDO::FETCH_GROUP | PDO::FETCH_COLUMN);??? ??? //var_dump($data);??? /*?? array(?? ?? 'service' => array(?? ?????? 'HBO'?? ?? ),?? ?? 'movie' => array(?? ?????? '本周新片'?? ?????? '热映中'?? ?? ),?? )?? */??? ??? ??? ??? ??? ??? $data = $dbAdapter->query("?? ?? SELECT id,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,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,"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';?? ?? },?? )?? */?? 欢迎参与《PHP PDO fetch 模式各种参数的输出结果一览》讨论，分享您的想法，编程之家 52php.cn为您提供专业教程。 （编辑：李大同） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |