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 => Test {#382
+id: 1
+name: "foo"
+creationDate: DateTime @1405849049 {#368
: 2014-07-20 11:37:29.0 Europe/Berlin (+02:00)
}
}
"modulo" => "1"
]
1 => array:2 [
0 => Test {#404
+id: 3
+name: "bar"
+creationDate: DateTime @1406093238 {#364
: 2014-07-23 07:27:18.0 Europe/Berlin (+02:00)
}
}
"modulo" => "1"
]
2 => array:2 [
0 => Test {#399
+id: 2
+name: "test"
+creationDate: DateTime @1405845622 {#401
: 2014-07-20 10:40:22.0 Europe/Berlin (+02:00)
}
}
"modulo" => "0"
]
]
array:3 [
0 => Test {#382
+id: 1
+name: "foo"
+creationDate: DateTime @1405849049 {#368
: 2014-07-20 11:37:29.0 Europe/Berlin (+02:00)
}
}
1 => Test {#404
+id: 3
+name: "bar"
+creationDate: DateTime @1406093238 {#364
: 2014-07-23 07:27:18.0 Europe/Berlin (+02:00)
}
}
2 => Test {#399
+id: 2
+name: "test"
+creationDate: DateTime @1405845622 {#401
: 2014-07-20 10:40:22.0 Europe/Berlin (+02:00)
}
}
]
More Snippets
Used Versions
PHP 7.2, Zend 3.0, Symfony 4.0, Laravel 5.6, PHPUnit 6.5, Doctrine 2.8