DQL syntax to hide irrelevant values for the result
<?php
use PHPSnippets\Db\Entity\Test;
$getResult = function($dql) use ($entityManager) {
return $entityManager->createQuery($dql)
->setMaxResults(5)
->getResult();
};
// Regular DQL Query
$dql = 'SELECT t, MOD(t.id, 2) as modulo FROM '.Test::class.' t
ORDER BY modulo DESC';
dump($getResult($dql));
// DQL Query with HIDDEN for modulo alias
$dql = 'SELECT t, MOD(t.id, 2) as HIDDEN modulo FROM '.Test::class.' t
ORDER BY modulo DESC';
dump($getResult($dql));
Result
^ array:3 [
0 => array:2 [
0 => PHPSnippets\Db\Entity\Test {#1425
+id: 1
+name: "foo"
+creationDate: DateTime @1405849049 {#1419
: 2014-07-20 11:37:29.0 Europe/Berlin (+02:00)
}
+subTests: Doctrine\ORM\PersistentCollection {#1432
#collection: Doctrine\Common\Collections\ArrayCollection {#1436
-elements: []
}
#initialized: false
-snapshot: []
-owner: PHPSnippets\Db\Entity\Test {#1425}
-association: array:15 [ …15]
-em: Doctrine\ORM\EntityManager {#1322 …11}
-backRefFieldName: "test"
-typeClass: Doctrine\ORM\Mapping\ClassMetadata {#1428 …}
-isDirty: false
}
}
"modulo" => 1
]
1 => array:2 [
0 => PHPSnippets\Db\Entity\Test {#1438
+id: 3
+name: "bar"
+creationDate: DateTime @1406093238 {#1437
: 2014-07-23 07:27:18.0 Europe/Berlin (+02:00)
}
+subTests: Doctrine\ORM\PersistentCollection {#1439
#collection: Doctrine\Common\Collections\ArrayCollection {#1440
-elements: []
}
#initialized: false
-snapshot: []
-owner: PHPSnippets\Db\Entity\Test {#1438}
-association: array:15 [ …15]
-em: Doctrine\ORM\EntityManager {#1322 …11}
-backRefFieldName: "test"
-typeClass: Doctrine\ORM\Mapping\ClassMetadata {#1428 …}
-isDirty: false
}
}
"modulo" => 1
]
2 => array:2 [
0 => PHPSnippets\Db\Entity\Test {#1442
+id: 2
+name: "test"
+creationDate: DateTime @1405845622 {#1441
: 2014-07-20 10:40:22.0 Europe/Berlin (+02:00)
}
+subTests: Doctrine\ORM\PersistentCollection {#1443
#collection: Doctrine\Common\Collections\ArrayCollection {#1444
-elements: []
}
#initialized: false
-snapshot: []
-owner: PHPSnippets\Db\Entity\Test {#1442}
-association: array:15 [ …15]
-em: Doctrine\ORM\EntityManager {#1322 …11}
-backRefFieldName: "test"
-typeClass: Doctrine\ORM\Mapping\ClassMetadata {#1428 …}
-isDirty: false
}
}
"modulo" => 0
]
]
^ array:3 [
0 => PHPSnippets\Db\Entity\Test {#1425
+id: 1
+name: "foo"
+creationDate: DateTime @1405849049 {#1419
: 2014-07-20 11:37:29.0 Europe/Berlin (+02:00)
}
+subTests: Doctrine\ORM\PersistentCollection {#1432
#collection: Doctrine\Common\Collections\ArrayCollection {#1436
-elements: []
}
#initialized: false
-snapshot: []
-owner: PHPSnippets\Db\Entity\Test {#1425}
-association: array:15 [ …15]
-em: Doctrine\ORM\EntityManager {#1322 …11}
-backRefFieldName: "test"
-typeClass: Doctrine\ORM\Mapping\ClassMetadata {#1428 …}
-isDirty: false
}
}
1 => PHPSnippets\Db\Entity\Test {#1438
+id: 3
+name: "bar"
+creationDate: DateTime @1406093238 {#1437
: 2014-07-23 07:27:18.0 Europe/Berlin (+02:00)
}
+subTests: Doctrine\ORM\PersistentCollection {#1439
#collection: Doctrine\Common\Collections\ArrayCollection {#1440
-elements: []
}
#initialized: false
-snapshot: []
-owner: PHPSnippets\Db\Entity\Test {#1438}
-association: array:15 [ …15]
-em: Doctrine\ORM\EntityManager {#1322 …11}
-backRefFieldName: "test"
-typeClass: Doctrine\ORM\Mapping\ClassMetadata {#1428 …}
-isDirty: false
}
}
2 => PHPSnippets\Db\Entity\Test {#1442
+id: 2
+name: "test"
+creationDate: DateTime @1405845622 {#1441
: 2014-07-20 10:40:22.0 Europe/Berlin (+02:00)
}
+subTests: Doctrine\ORM\PersistentCollection {#1443
#collection: Doctrine\Common\Collections\ArrayCollection {#1444
-elements: []
}
#initialized: false
-snapshot: []
-owner: PHPSnippets\Db\Entity\Test {#1442}
-association: array:15 [ …15]
-em: Doctrine\ORM\EntityManager {#1322 …11}
-backRefFieldName: "test"
-typeClass: Doctrine\ORM\Mapping\ClassMetadata {#1428 …}
-isDirty: false
}
}
]
More Snippets
Used Versions
PHP 8.2, Laminas MVC 3.2, Symfony 5.2, Laravel 8.28, PHPUnit 9.5, Doctrine ORM 2.8