How to use Get paramter with where In condition



I want to understand how i can use WHERE IN condition with $_GET parameter.

As in above screen shot there is a possibility to define our own GET param with condition operators such as ( = , > < )… But i need condition WHERE IN

As in above screen i am trying to put ( in ) . But it isn’t working.
Can u tell me anything ?



Can anyone answer this ?


it’s hard to tell what exactly isn’t working without any kind of reproducible demo or logs.
First thing, you may want to enable connector logging:

$scheduler = new schedulerConnector($res, $dbtype);

log.txt will contain the exact sql queries connector generates, so you’ll be able to see sql created from your configuration.

Working code might look like the following:

$scheduler = new schedulerConnector($res, $dbtype);

function custom_filter($filter_by){
    $filter_by->add("event_id", $_GET["ids"], "IN");

And request from the client:

scheduler.load("events.php?ids=(66, 67, 68)");

Here are complete examples with “LIKE” and “IN” operators: