Search for list of ids in mysql via php

Question

Does anyone know how to get multiple elements from a database using an array that contains all the search id?? PHP/Mysql

static function list($ids){
    $wa = "";
    foreach ($ids as $key => $value) {
      $wa .= " e_produto.id = {$value} OR";
    }
    $wa = substr($wa,0,-2);
    $wa = ($wa!="")?"OR $wa":"";
    ////------------
    $myid = User::id();
    $query = "SELECT * FROM tabela WHERE $wa;";
    $retorno = DB::dbQuery($query,$carrinhoArr);

    return $retorno;
  }

It’s the provisioning solution I got. But there is a "more correct way"?

Answer 1

You can use this way at the time of consultation.

$ids = array('1', '2', '3');
$query = "SELECT * FROM users WHERE id IN (" . implode(', ', $ids) . ")";

// Saída
SELECT * FROM users WHERE id IN (1, 2, 3)

Answer 2

I finally found the answer!

SELECT column_name(s)
FROM table_name
WHERE column_name IN (value1, value2, ...); 

https://www.w3schools.com/sql/sql_in.asp?fbclid=IwAR2M8oAroid908S65C9wgiI4nob921uOYeVcbJd6cUBRsCq-HIr8CRfjs0E