3v4l.org

run code in 300+ PHP versions simultaneously
<?php //select * from tbl_product where id IN(select product_id from tbl_vehicleproductequipments where (equipmentvalue_id = 1 OR equipmentvalue_id = 2 OR equipmentvalue_id = 3 OR equipmentvalue_id = 4) AND (equipmentvalue_id = 5 OR equipmentvalue_id = 6 OR equipmentvalue_id = 7) $arr = array( array(1, 2, 3, 4), array(5, 6, 7) ); echo $sql = 'select product_id from tbl_vehicleproductequipments where (equipmentvalue_id = '.implode("OR equipmentvalue_id = ", $arr[0]).') AND (equipmentvalue_id = '.implode("OR equipmentvalue_id = ", $arr[1]).")";
Output for 5.5.0 - 5.5.35, 5.6.0 - 5.6.28, 7.0.0 - 7.0.20, 7.1.0 - 7.1.20, 7.2.6 - 7.2.33, 7.3.16 - 7.3.33, 7.4.0 - 7.4.33, 8.0.0 - 8.0.30, 8.1.0 - 8.1.28, 8.2.0 - 8.2.18, 8.3.0 - 8.3.7
select product_id from tbl_vehicleproductequipments where (equipmentvalue_id = 1OR equipmentvalue_id = 2OR equipmentvalue_id = 3OR equipmentvalue_id = 4) AND (equipmentvalue_id = 5OR equipmentvalue_id = 6OR equipmentvalue_id = 7)

preferences:
214.77 ms | 404 KiB | 213 Q