时间:2021-07-01 10:21:17 帮助过:42人阅读
本文实例讲述了Symfony2实现从数据库获取数据的方法。分享给大家供大家参考,具体如下:
假设有一张表:test, 字段:name,color;
有2条记录:
Tom blue
Lily red
示例1:
- $conn = $this->getDoctrine()->getConnection();
- $data = $conn->fetchcolumn("SELECT name, color FROM 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
- )
- )
希望本文所述对大家基于Symfony框架的PHP程序设计有所帮助。