PDO 출력 및 그룹핑

  $insert = $dbh->prepare("INSERT INTO fruit(name, colour) VALUES (?, ?)");

$insert->execute(array('apple', 'red'));

$insert->execute(array('pear', 'green'));

$insert->execute(array('watermelon', 'green'));

$sth = $dbh->prepare("SELECT name, colour FROM fruit");

$sth->execute();

/* Group values by the first column */

var_dump($sth->fetchAll(PDO::FETCH_COLUMN|PDO::FETCH_GROUP));

PDO::FETCH_GROUP: 그룹 지어서 데이타 출력

array(3) 

{ 

["watermelon"]=> 

array(1) { 

[0]=> string(5) "green" 

} 

["pear"]=> 

array(2) { 

[0]=> string(5) "green" 

[1]=> string(6) "yellow" 

} 

["apple"]=> 

array(2) { 

[0]=> string(3) "red" 

[1]=> string(5) "green" 

} 

}