miércoles, 24 de agosto de 2022

MYSQL search value in array

 $string="1,2,3,4,5";

$array=array_map('intval', explode(',', $string));
$array = implode("','",$array);



$query=mysqli_query($conn, "SELECT name FROM users WHERE id IN ('".$array."')");

NB: the syntax is:

SELECT * FROM table WHERE column IN('value1','value2','value3')



https://stackoverflow.com/questions/20203063/mysql-where-id-is-in-array

No hay comentarios:

Publicar un comentario