Skip to content

Instantly share code, notes, and snippets.

@hirak
Created March 26, 2012 16:44
Show Gist options
  • Save hirak/2206420 to your computer and use it in GitHub Desktop.
Save hirak/2206420 to your computer and use it in GitHub Desktop.
PDOで1xNのデータをDBから取得するなら ref: http://qiita.com/items/856c4bac914451bc0c75
<?php
$pdo = new PDO('...');
$stmt = $pdo->query('SELECT txt FROM Hoge');
var_dump($stmt->fetchAll(PDO::FETCH_NUM));
//[ [txt1], [txt2], [txt3], ... ]
<?php
$stmt = $pdo->query('SELECT txt FROM Hoge');
var_dump($stmt->fetchAll(PDO::FETCH_COLUMN, 0));
//[ txt1, txt2, txt3, ... ]
//こうしてもOK
$stmt = $pdo->query('SELECT txt FROM Hoge');
$stmt->setFetchMode(PDO::FETCH_COLUMN, 0);
var_dump($stmt->fetchAll());
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment