PHP/MySQLi - looping through an array to build dynamic WHERE clause

you only bind the (search) param once. where you apply the loop is on the execute/fetch stage.