php Programming Glossary: createquery
How to select randomly with doctrine http://stackoverflow.com/questions/10762538/how-to-select-randomly-with-doctrine the rows like this userCount Doctrine getTable 'User' createQuery select 'count ' fetchOne array Doctrine HYDRATE_NONE user Doctrine.. array Doctrine HYDRATE_NONE user Doctrine getTable 'User' createQuery limit 1 offset rand 0 userCount 0 1 fetchOne I'm a little confused..
Doctrine 2.2 + Zend Framework pagination speed optimization http://stackoverflow.com/questions/10962802/doctrine-2-2-zend-framework-pagination-speed-optimization used doctrine 2 and zend paginator as reference query em createQuery dql setHydrationMode Doctrine ORM AbstractQuery HYDRATE_ARRAY.. iterator paginator getIterator die 160 ms vs query em createQuery dql setHydrationMode Doctrine ORM AbstractQuery HYDRATE_OBJECT..
Validation in Zend Framework 2 with Doctrine 2 http://stackoverflow.com/questions/12300472/validation-in-zend-framework-2-with-doctrine-2 '' value this getIgnoreEmpty return true queryObj em createQuery query setMaxResults 1 entitiesFound count queryObj execute array..
Symfony 1.4 with TCPDF: How to retreive data from a database and show it as a .pdf file? http://stackoverflow.com/questions/19802383/symfony-1-4-with-tcpdf-how-to-retreive-data-from-a-database-and-show-it-as-a-p this conflictos1s Doctrine_Core getTable 'Conflictos1' createQuery 'a' leftJoin 'a.SectorActividadCiuTa7' leftJoin 'a.RelacionConflictualPrincipalTa9'.. this conflictos1s Doctrine_Core getTable 'Conflictos1' createQuery 'a' leftJoin 'a.SectorActividadCiuTa7' leftJoin 'a.RelacionConflictualPrincipalTa9'..
How can I fetch the entire tree in a single query with doctrine? http://stackoverflow.com/questions/2339800/how-can-i-fetch-the-entire-tree-in-a-single-query-with-doctrine Try this Doctrine_Core getTable 'YourTableWithTree' createQuery 'tree' addOrderBy 'tree.root_id ASC' addOrderBy 'tree.lft ASC'..
Doctrine2: Best way to handle many-to-many with extra columns in reference table http://stackoverflow.com/questions/3542243/doctrine2-best-way-to-handle-many-to-many-with-extra-columns-in-reference-table tl JOIN tl.track t ORDER BY tl.position ASC ' albums em createQuery dql getResult foreach albums as album echo album getTitle ...
Doctrine 2.0.4 Configuration Error? [closed] http://stackoverflow.com/questions/5878718/doctrine-2-0-4-configuration-error generate metadata lib1 . 'Entities' echo 'Done' q em createQuery select u from MyProject Entities Dept u users q getResult Resulting..
MySQL User defined variable within Doctrine and Symfony http://stackoverflow.com/questions/6541999/mysql-user-defined-variable-within-doctrine-and-symfony following Doctrine statement which works fine. query this createQuery 'r' select 'u.id CONCAT u.first_name LEFT u.last_name 1 as.. standaloneQuery 'SET @rank 0 ' execute query this createQuery 'r' select 'r.run_time @rank @rank 1 rank r.user_id CONCAT.. to other DBMS are foreseen maybe you could try query this createQuery 'r' select 'COUNT u.id as rank u.id CONCAT u.first_name LEFT..
custom repository class in symfony2 http://stackoverflow.com/questions/8146461/custom-repository-class-in-symfony2 findAllOrderedByName return this getEntityManager createQuery 'SELECT p FROM symBundle Register p ORDER BY p.name ASC' getResult..
Symfony 2: Autogenerated navigation menus http://stackoverflow.com/questions/9316709/symfony-2-autogenerated-navigation-menus menu setCurrentUri request getRequestUri em this em q em createQuery ' SELECT m FROM StexAdminBundle MyMenu m WHERE m.status 1 ORDER..
|