假设有一张表:test,字段:name,color
有两条记录:Tom blue
Lily red
1
$conn=$this->getDoctrine()->getConnection();
$data=$conn->fetchcolumn("SELECT name,color FORM test");
echo '<pre>';print_r($data);
结果为:Tom
2
$conn=$this->getDoctrine()->getConnection();
$data=$conn->fetchArray("SELECT name,color FROM test");
echo '<pre>';print_r($data);
结果为:
Array
{
[0]=>Tom
[1]=>blue
}
3
$conn=$this->getDoctrine()->getConnection();
$data=$conn->fetchAssoc("SELECT name,color FROM test");
echo '<pre>';print_r($data);
结果为
Array
(
[name]=>Tom
[color]=>blue
)
4
$conn=$this->getDoctrine()->getConnection();
$data=$conn->fetchAll("SELECT name,color FROM test");
echo '<pre>';print_r($data);
结果为
Array
(
[0]=>Array
(
[name]=>Tom
[color]=>blue
)
[1]=>Array
(
[name]=>Lily
[color]=>red
)
)