PHP PDO fetch 模式各種參數(shù)的輸出結(jié)果一覽，pdofetch_PHP教程
Jul 13, 2016 am 10:09 AM
PHP PDO fetch 模式各種參數(shù)的輸出結(jié)果一覽，pdofetch
PDO 的 fetch 模式功能實在是太方便了，但每次要產(chǎn)生想要的結(jié)果都要試太麻煩了，這里列出可能的組合。
$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';??
?? },??
)??
*/??
? AI ??
Undress AI Tool
??? ???? ??
Undresser.AI Undress
???? ?? ??? ??? ?? AI ?? ?
AI Clothes Remover
???? ?? ???? ??? AI ?????.
Clothoff.io
AI ? ???
Video Face Swap
??? ??? AI ?? ?? ??? ???? ?? ???? ??? ?? ????!
?? ??
??? ??
???++7.3.1
???? ?? ?? ?? ???
SublimeText3 ??? ??
??? ??, ???? ?? ????.
???? 13.0.1 ???
??? PHP ?? ?? ??
???? CS6
??? ? ?? ??
SublimeText3 Mac ??
? ??? ?? ?? ?????(SublimeText3)
PHP? AI ??? ?? ?? PHP ?? ?? ?? ??? ??? ?????.
Jul 25, 2025 pm 08:45 PM
??? ?? ??? ??? ?? JavaScript? MediareCorder API? ?? PHP ???? ???? ?????. 2. PHP? ???? ?? ??? ???? STTAPI (? : Google ?? Baidu ?? ??)? ???? ???? ?????. 3. PHP? ???? AI ??? (? : OpenAigpt)? ????. 4. ?? ?? PHP? TTSAPI (? : Baidu ?? Google ?? ??)? ???? ??? ?? ??? ?????. 5. PHP? ?? ??? ??? ??? ??? ?? ?? ??? ?????. ?? ????? PHP? ?? ???? ?? ?? ?? ??? ??? ?????.
PHP? ???? ?? ?? ??? ???? ?? PHP ?? ????? ?? ??
Jul 25, 2025 pm 08:51 PM
PHP?? ?? ?? ??? ???? ?? ??? ? ???? ?? ??? ???? ?? ??? ???? ???? ????. 1. ?? ?? ??? ?? ??? URL ? ?? ??? ????. 2. UrlenCode? ???? ?? ??? ???????. 3. ? ???? ????? ?? ?? ??? ? ?? ??? ?????. 4. ???? ???? ?? ? ? ??? ??? ??? ??? ?????. 5. ??? ?? ??? ????? ?? ????? OG ??? ???? ?????. 6. XSS ??? ???? ?? ??? ??? ?????. ? ???? ??? ??? ???? ??? ?? ?? ??? ??? ???? ??? ?? ??? ?????.
PHP? ???? AI? ???? ??? ?? ?? PHP ?? ?? ? ???? ?????.
Jul 25, 2025 pm 08:57 PM
AI? ??? ??? ?? ?? ? ?? ???? ????? ?? ??? ??????. 1. Baidu, Tencent API ?? ?? ?? NLP ?????? ?? ??? AI ?? ?? API? ??????. 2. PHP? ? ?? guzzle? ?? API? ???? ?? ??? ??????. 3. ?? ????? ?? ?? ??? ???? ???? ???? ??? ??? ? ????. 4. ?? ?? ? ?? ???? ?? PHP-L ? PHP_CODESNIFFER? ??????. 5. ???? ????? ???? ?? ?? ??? ?????? ??? ??????. AIAPI? ??? ? ???, ?? ??, ?? ? PHP ?? ??? ??? ???. ?? ???? PSR ??? ???, ??? ????? ????, ?? ??? ???, ????? ??? ????, X? ???????.
PHP? PHP ?? ?? ? ?? ??? ??? ?????? ??? ??? ???? ????.
Jul 25, 2025 pm 08:27 PM
1. ?? ???? ??? ??? ?????? ?? ?? ??? ??, ??? ?? ???? ??? (? : ?? ???, ? ? ??), ?? ??? ?? ???? ???? ? ?? ?? ??? ??? ?? ??? ????????. 2. ?? ??? ??? ?? ? ??? ???? ?? ?? ?? ???? ?? ? ?? AUDIT ?? ??? ??? ? ????? ????? ??? ???????. 3. ?? ?? ??? ?? ??? ???????. Recaptchav3 ???? ??, ??? ?? ?? ?? ?? ??, IP ? ?? ??? ??? ??? ?? ???? ??? ?? ??? ????? ??? ???? ????? ??? ?????.
PHP? ???? AI? ???? ???? ???? ??. PHP? ???? ?? ??? ?????
Jul 25, 2025 pm 07:21 PM
PHP? AI ??? ??? ?? ????? ??? API? ?? ?????. ??? ??? ????? ? ??? ???? ?????. API ??? ?? ?? ??? ???? ??? ??? ???? ???? ? ????. 2. ?? ?? ???? guzzle ?? curl? ???? HTTP ??? ???, JSON ??? ??? ? ???, API ? ?? ??, ??? ? ?? ??? ???? ??, ??? ?? ?? ? ? ?? ????, ??? ?? ? ?????? ?????. 3. ???? ???? ?? ???? API ??, ?? ? ??? ?? ??, ??? ?? ??, ?? ?? ? ??? ??? ??? ?????. ?? ??? ??? ??? ? ??? ???? Propt ?? ? ?? ?? ??, ??? ?? ? ?? ????, ?? ?? ?? ???? ? ??? ?? ? ???? ????? ?????.
PHP? ?? ?? ?? ? ?? ?? PHP ?? ??? ? ?? ????? ??
Jul 25, 2025 pm 08:30 PM
PHP? ?????? ????? ?? ?? ?? ???? ???? ?? ???? ???? ?? ?? ???? ?????. 2. ?? ??? ???? ???? ?? ??? ?? ? ??? ??? ???? ?? API/Webhook ??? ??? ?? ???? ??? ??? ??? ??? ?????. 3. ?? ????? ?? ??, ??/???? ????, ???? ??, ???? ? ??? ?????? ????? ?? ??? ???? ???? ?? Dingtalk, SMS ?? ??? ???? ??? ?????? ???? ?? ? ??? ??? ????? ?? ??? ???? ???????.
?? ?? ?? : ?? ?? ?????? PHP? ??
Jul 27, 2025 am 04:31 AM
PhpisstillRelevantinmodernenterpriseenvironments.1. Modernphp (7.xand8.x)? ??? ??, ??? ??, jitcompilation ? modernsyntax, mateitsuilableforlarge-scalepplications
PHP ?? AI ?? ?? ? ??? PHP ?? ??? ?? ?? ???
Jul 25, 2025 pm 07:06 PM
??? AI ?? ?? ???? ???? PHPSDK? ??????. 2. PHP? ???? FFMPEG? ???? ???? API ?? ?? (? : WAV)?? ?????. 3. ??? ???? ????? ????? API ???? ??? ??????. 4. NLP ??? ???? JSON ??? ???? ???? ?????. 5. ?? ??? ???? ???? ?? ?? ?? ?? ?? ??? ?????. ?? ????? ?? ?? ? ??? ???? ?? ??? ???, ??? ?? ? ??? ???????.
