Laravel | Query with select

Question

I have a query and use ->pluck and i see my result

[22]

$ferias = feria::where('id_funcionario', '=', $userid)->pluck('n_ferias_disponiveis');

I can see my result without [] ? For exemple use de select 'n_ferias_disponiveis', but how do you use select in the above query?

if you are looking for id and n_ferias_disponiveis then ->pluck('n_ferias_disponiveis','id_funcionario'); .Also note only two columns can select in pluck query not mroe than tht — John Lobo
– John Lobo, Commented Mar 13, 2022 at 9:21

gguney · Accepted Answer · 2022-03-13 09:10:09Z

1

$ferias = Feria::select('id_funcionario')->where('id_funcionario', '=', $userid)->get();

Pluck is collection function you should first get then you can use pluck method like:

$ferias = Feria::select('id_funcionario')->where('id_funcionario', '=', $userid)->get()->pluck('id_funcionario');

answered Mar 13, 2022 at 9:10

gguney

2,6711 gold badge17 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1