How to select fields according to input array in eloquent - laravel 9

Question

$arr = array('field1', 'field2', 'field3');

From User Inputs I get array containing Field names. I have to fetch data from multiple table joins so, The goal is to select respective fields from tables according to table input from array.

    $update_co_column = Co_Total_Ia::
                      ->select(current($arr), next($arr), next($arr))
                     //->join('All Joins here')
                       ->where("user_key", "=", session()->get("user_id"))
                       ->where("student_details.deleted_at", "=", null);

I tried using PHP array methods, curret(arr) and next(arr). It is working, but just as an temporary solution. Problems in current solution -

Don't know exact how many fields to fetch
Need to fetch extra useless field all times.

RG Servers · Accepted Answer · 2023-01-12 07:10:40Z

2

You can do it like this:

$fields = ['field1', 'field2', 'field3'];

Model::select($fields)->get();

results:

SELECT
  `field1`,
  `field2`,
  `field3`
FROM
  `model`

answered Jan 12, 2023 at 7:10

RG Servers

1,7952 gold badges15 silver badges30 bronze badges

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

Collectives™ on Stack Overflow

How to select fields according to input array in eloquent - laravel 9

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related