Doctrine就是一種對象關系映射(ORM)同時也是一種數據庫抽象層(DBAL),使用ORM和DBAL能讓我們很輕易的操作數據庫。
我們生成了 entity 所以以前我認為entity跟symfony有關,現在看是錯的:
$repository = $this->getDoctrine()
->getRepository('AppBundle:Product');
$query = $repository->createQueryBuilder('p')
->where('p.price > :price')
->setParameter('price', '19.99')
->orderBy('p.price', 'ASC')
->getQuery();
$products = $query->getResult();
$configs = $query->getArrayResult();
$repository = $this->getDoctrine()
->getRepository('AppBundle:Worker');
$list= $repository->createQueryBuilder('p')
->where('p.username = :user and p.password=:pss')
->setParameter('user', $user)
->setParameter('pass', md5($pass))
->getQuery();
$list = $list->getSingleResult();