Ok, so I’m moving project from non framework PHP to Symfony2, and it goes very nice, except of Doctrine, I’m sure it’s me. I’ve been using MySQL for last 8 years and DQL vs SQL to me feels like i.e. taking snowboard for the first time, after skiing for 30 years. What I do after 30 min. of trying. I’m going back to rental place and I switch to skis. Below one can find skis.
\n<\/p>\n
\r\nuse Doctrine\\ORM\\EntityRepository;\r\n\r\nclass ProductRepository extends EntityRepository\r\n{\r\n\r\n$stmt = $this->getEntityManager()\r\n->getConnection()\r\n->prepare('select * from product where 1');\r\n$stmt->execute();\r\n$result = $stmt->fetchAll();\r\n\r\nreturn $this->render('Test1Bundle:Default:index.html.twig', array('name' => 'Showig '. print_r($result,true)));\r\n}\r\n<\/pre>\nOr if you do not want to use class try this.<\/p>\n
\r\n$stmt = $this->getDoctrine()->getEntityManager()\r\n ->getConnection()\r\n ->prepare('select * from product where 1');\r\n$stmt->execute();\r\n$result = $stmt->fetchAll();\r\n<\/pre>\nOr this<\/p>\n
\r\n$rsm = new ResultSetMapping;\r\n $rsm->addScalarResult('optionname', 'option');\r\n $rsm->addScalarResult('answers', 'count');\r\n\r\n return $this->_em->createNativeQuery('\r\n SELECT\r\n qo.title as optionname,\r\n COUNT(qap.answer_id) as answers\r\n FROM\r\n quiz_answer_option qap\r\n INNER JOIN quizoption qo ON qo.id = qap.option_id\r\n INNER JOIN quizquestion qq ON qq.id = qo.quizquestion_id\r\n WHERE\r\n qq.active\r\n AND qq.id = :quizquestionid\r\n GROUP BY qap.option_id\r\n ORDER BY qo.number asc\r\n ', $rsm)\r\n ->setParameter('quizquestionid', $quizquestion->getId())\r\n ->getResult();\r\n<\/pre>\n