CODEWITHSUNDEEP
phpsqlarrayssymfonydoctrine
JCG-59
JCG-59

Reputation: 1

Transform a complex array from a dql query to a simple one returning just selected entries

I have written a dql query:

$emails = $manager->createQuery('SELECT (u.email) as email FROM App\Entity\User u')->getResult();

That returns:

Array

I would like to transform it in a simple array who'll list directly the emails like:

$emails = ["email1", "email2", "email3", "email4" ...];

Does anyone could help me with that?.

Upvotes: 0

Views: 37

Answers (1)

u_mulder
u_mulder

Reputation: 54831

$emails = $manager->createQuery('SELECT (u.email) as email FROM App\Entity\User u')->getResult();
$emails = array_column($emails, 'email');

Upvotes: 2

Related Questions