Mysql where id is 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')

Related Posts:

  1. Difference between “as $key => $value” and “as $value” in PHP foreach
  2. How to log in to phpMyAdmin with WAMP, what is the username and password?
  3. Array to String PHP?
  4. Should I use mysqli_real_escape string() or mysql_real_escape_string() for form data?
  5. Fatal error: Call to undefined function mysql_connect()
  6. “Notice: Undefined variable”, “Notice: Undefined index”, and “Notice: Undefined offset” using PHP
  7. PDOException SQLSTATE[HY000] [2002] No such file or directory
  8. http://localhost:80 is not working on running Apache server through UniServer ZeroXIII
  9. PDOException SQLSTATE[HY000] [2002] No such file or directory
  10. Mysql query- How to use contains?
  11. mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in
  12. Invalid column count in CSV input on line 1 Error
  13. Invalid column count in CSV input on line 1 Error
  14. Convert a PHP object to an associative array
  15. How to echo or print an array in PHP?
  16. $wpdb->update or $wpdb->insert results in slashes being added in front of quotes
  17. PDO with INSERT INTO through prepared statements
  18. phpMyAdmin: secret passphrase?
  19. PDO bindParam() with prepared statement isn’t working
  20. Forbidden :You don’t have permission to access /phpmyadmin on this server
  21. Deleting an element from an array in PHP
  22. How to insert an item at the beginning of an array in PHP?
  23. Creating a search form in PHP to search a database?
  24. How can I do ‘insert if not exists’ in MySQL?
  25. Fatal error: Call to a member function bind_param() on boolean [duplicate]
  26. what is a good method to sanitize the whole $_POST array in php?
  27. Sort array of objects by object fields
  28. MySqli Commands out of sync; you can’t run this command now
  29. Trying to get property of non-object in
  30. Fix Access denied for user ‘root’@’localhost’ for phpMyAdmin
  31. Getting connection failed: php_network_getaddresses: getaddrinfo failed: Name or service not known
  32. Commands out of sync; you can’t run this command now
  33. Lost connection to MySQL server at ‘reading initial communication packet’, system error: 0
  34. In_array not working
  35. PHP with MySQL 8.0+ error: The server requested authentication method unknown to the client
  36. SQLSTATE[HY093]: Invalid parameter number: parameter was not defined
  37. PHP multidimensional array search by value
  38. How can I do ‘insert if not exists’ in MySQL?
  39. Fatal error: Cannot use object of type mysqli_result
  40. Object of class DateTime could not be converted to string
  41. What does it mean to escape a string?
  42. Convert from MySQL datetime to another format with PHP
  43. MAMP “Apache couldn’t be started because port is in use.” AND “Can’t connect to local MySQL server through /tmp/mysql.sock
  44. mysqli::query(): Couldn’t fetch mysqli
  45. Unexpected Exception: SQLSTATE[HY000] [1045] Access denied for user ****@’localhost’ (using password: YES)
  46. php foreach with multidimensional array
  47. Convert php array to Javascript
  48. Uncaught Error: Call to undefined function mysql_escape_string()
  49. Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in
  50. Call to a member function on null?
  51. SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens on line 102
  52. PHP reindex array?
  53. Warning: mysqli_query() expects parameter 1 to be mysqli, resource given
  54. MySQL query to get column names?
  55. What does MYSQLI_NUM mean and do?
  56. php – How do I fix this illegal offset type error
  57. ERROR: SQLSTATE[HY000] [2002] No connection could be made because the target machine actively refused it
  58. What is the advantage of using try {} catch {} versus if {} else {}
  59. How to convert array to SimpleXML
  60. select * from table where column = value ^ column2= value
  61. Deprecated: mysql_query() [duplicate]
  62. Array of PHP Objects
  63. Is there a function to make a copy of a PHP array to another?
  64. How to Sort a Multi-dimensional Array by Value
  65. PHP array printing using a loop
  66. Fastest way to implode an associative array with keys
  67. No query results for model [App\Products] Laravel
  68. Fatal error: Call to a member function query() on null
  69. mysqlworkbench giving version error on exporting database
  70. How to make DROP INDEX IF EXISTS for mysql?
  71. What is the meaning of sprintf(): Too few arguments
  72. PHP array delete by value (not key)
  73. Having a problem getting mysqli_query to execute
  74. CodeIgniter: Unable to connect to your database server using the provided settings Error Message
  75. Can I store images in MySQL 
  76. MySQL Daemon Failed to Start – centos 6
  77. PHP Multiple Checkbox Array
  78. How to insert TIMESTAMP into my MySQL table?
  79. How to remove index.php from WordPress site URL
  80. Display array values in PHP
  81. Reset PHP Array Index
  82. PHP Like thing similar to MySQL Like, for if statement?
  83. How get value from URL
  84. How to push both value and key into PHP array
  85. How to use Memcached with PHP7?
  86. Remove empty array elements
  87. select count(*) from table of mysql in php
  88. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ””)’ at line 2
  89. count() parameter must be an array or an object that implements countable in laravel
  90. Resize image in PHP
  91. How to create cron job using PHP?
  92. Imploding an associative array in PHP
  93. NotFoundHttpException in RouteCollection.php line 161: in laravel 5
  94. Easy way to password-protect php page
  95. Authenticating in PHP using LDAP through Active Directory
  96. What is /var/www/html? [closed]
  97. Show MySQL errors that occur when I excute $wpdb->insert()
  98. Large Woocommerce Site (83,000 items), What Can I Do? [closed]
  99. WordPress WP_Query without query GET parameters
  100. Query the links Database

Leave a Comment