Eloquent ORM laravel 5 Get Array of ids

Question

I m using Eloquent ORM laravel 5 1  i want to return an array of ids greater than 0  My model called test   I have tried     test test  select  id  - gt where  id     gt    0 - gt get  - gt toarray      It return    Array    0    gt  Array    id    gt  1    1    gt  Array    id    gt  2       But i want result to be in simple array like    Array   1 2

User · Answer

The correct answer to that is the method lists  it s very simple like this    test test  select  id  - gt where  id     gt    0 - gt lists  id      Regards

User · Answer

You could use lists       test  where  id     gt    0 - gt lists  id  - gt toArray      NOTE   Better if you define your models in Studly Case format  e g Test     You could also use get      test  where  id     gt    0 - gt get  id        UPDATE   For versions    5 2   The lists   method was deprecated in the new versions  gt   5 2  now you could use pluck   method instead    test  where  id     gt    0 - gt pluck  id  - gt toArray      NOTE  If you need a string  for example in a blade  you can use function without the toArray   part  like   test  where  id     gt    0 - gt pluck  id

User · Answer

You may also use all   method to get array of selected attributes    test test  select  id  - gt where  id     gt    0 - gt all      Regards

User · Answer

Although you have marked the Answer  This is a much simpler approach  App User  pluck  id  - gt toArray

User · Answer

You can use all   method instead of toArray   method  see more  laravel documentation    test  where  id     gt    0 - gt pluck  id  - gt all      returns array   If you need a string  you can use without toArray   attachment   test  where  id     gt    0 - gt pluck  id      returns string

User · Answer

read about the lists   method   test test  select  id  - gt where  id     gt    0 - gt lists  id  - gt toArray

User · Answer

From a Collection  another way you could do it would be    collection- gt pluck  id  - gt toArray     This will return an indexed array  perfectly usable by laravel in a whereIn   query  for instance

User · Answer

Just an extra info  if you are using DB   DB  table  test  - gt where  id     gt    0 - gt pluck  id  - gt toArray      And if using Eloquent model   test  where  id     gt    0 - gt lists  id  - gt toArray

[php] Eloquent ORM laravel 5 Get Array of ids

Examples related to php

Examples related to laravel

Examples related to laravel-5

Examples related to eloquent

Examples related to model