Make a bank GET from an Laravel Array

Question

I have a select where I do a search from an informed id, No Postman do a POST by sending an array to as in the example below

[
{  
      "id":"1"
},
{  
      "id":"2"
}
]

In the repository I search for these id to get all the information about them.

how I would look in my repository at the time of doing the search and bring the information of the currently informed ids I do a simple search with a get();

Repository:

Public function listarId($id)
    {
    return $this->produto = DB::table('produtos')
    ->where('id', $id)
    ->get();  
     }

and send as a parameter in the Postman one id at a time

  {  
  "id":"2"
  }

in my controller it is as follows, I send request with the variable $id, and return to select that I did in Repository.

   public function lista(Request $request) 
    {      

        $id = $request->input('id');

        return $this->produtosRepository->listarId($id);
    }

and I want to be able to send an array with several ids

Answer 1

You instead of using Where(); you could use wherein();

For example:

 return $this->produto = DB::table('produtos')
->where('id_admin', $array_id)
->get();

Where is this $array_id would be an array of id’s.

OBS.: wherein necessarily needs to receive an array one-dimensional for example [1,2,3]

With this he will make a query similar to :

Select * from produtos where id_admin in (1,2);

I hope I’ve helped.