Question

Views

I am planning to run mongodb query from php platform text area as picture below where I want to write query like

 array('Chat_time' => array('$gt' => $start, '$lte' => $end))

and execute like

$m = new MongoClient();
$db = $m->Forensic;
$coll= $db->mobile_
$user_code = $coll->find($_POST['txt_area']));

but cannot execute becuause I think when I convert query to string it cannot understand => as a command.

what would be the best way pass this command as a string and php will understand.

over 4 years ago · Santiago Trujillo

Answer question

Answer 1 · 2022-05-25T15:04:31.390Z

you should write json to your text area. like:

{
    "Chat_time": {
        "$gt" => "xxx",
        "$lte" => "yyy"
    }
}

in php

// json string to array using json_decode
$query = json_decode($_POST['txt_area'], true);
$user_code = $coll->find($query);