1、$rsm
~~~
$rsm = new ResultSetMapping();
# $rsm->addScalarResult($columnName, $alias, type="string");
$rsm->addScalarResult('name', 'name');
$rsm->addScalarResult('password', 'password');
~~~
2、$sql
~~~
$sql = "SELECT t.name t.password FROM table t where t.id < 100 GROUP BY t.role";
~~~
3、$query
~~~
$query = $em->createNativeQuery($sql, $rsm);
~~~
4、$qr
~~~
$qr = $query->getResult();
~~~
- 安裝
- 配置
- web服務器
- DependencyInjection
- Serializer
- Ajax
- Annotation
- Controller
- Entity
- Components【組件】
- HttpFoundation【HTTP處理】
- Routing【路由處理】
- Form【表單處理】
- Validator【驗證處理】
- ClassLoader【類加載】
- Templating【模板】
- Security【處理安全問題】
- Translation【語言翻譯】
- Bundles【功能包】
- Doctrine
- entityManager
- entityRespository
- createQueryBuilder
- createNativeQuery
- find
- DoctrineBundle
- doctrine_config
- DoctrineFixturesBundle
- KnpMenuBundle
- KnpPaginatorBundle
- FOSUserBundle
- FOSRestBundle
- FOSCommentBundle
- FOSElasticaBundle
- SonataCoreBundle
- SonataBlockBundle
- SonataMediaBundle
- SonataAdminBundle
- DoctrineORMAdminBundle
- Sonata
- Install_Sonata
- Config_Sonata
- BlockService
- Custom_BlockService
- Custom_Admin
- Problems