<?php $userIds = [1, 2, 3, 4, 5, 8, 2, 39, 298]; $userIdKeys = array_map(function ($index) { return ":userId_{$index}"; }, range(0, count($userIds) - 1)); $userIds = array_combine($userIdKeys, $userIds); $userIdKeyString = implode(', ', $userIdKeys); $sql = "SELECT * FROM user WHERE userId IN ({$userIdKeyString});"; var_dump($sql, $userIds);
You have javascript disabled. You will not be able to edit any code.