fork download
copy 
  1. <?php
  2. $arr = array(
  3.     array(1,3),
  4.     array(8,7),
  5.     array(9,9)
  6. );
  7.  
  8. function wherify($val) {
  9.     return "(`x` = ".$val[0]." AND `y` = ".$val[1].")";
  10. }
  11.  
  12. $criteria = implode(" OR ", array_map("wherify", $arr));
  13. $query = "SELECT * FROM `table` WHERE $criteria";
  14.  
  15. echo $query;
Success #stdin #stdout 0.02s 13064KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
SELECT * FROM `table` WHERE (`x` = 1 AND `y` = 3) OR (`x` = 8 AND `y` = 7) OR (`x` = 9 AND `y` = 9)
https://ideone.com/JWuicc
language:
PHP (php 7.3.5)
created:
11 years ago
visibility:
public

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!