Trouble having mongodb code to php having $and $not and mongoregex operator

Question

i am having difficulty to convert mongodb shell command to php. In shell i am using

db.files.find({"username":"username",
$and:[
{'filetype': {$not : /image/}},
{'filetype':{$not:/application/}},
{'filetype':{$not:/video/}}
]

})

As you can see i am having diffculty to convert it to php. I tried few way on stack overflow but got empty result. Can anyone help on this code.

pozs · Accepted Answer · 2013-04-01 21:24:20Z

1

It should be

$db->files->find(array(
  'username' => 'username',
  '$and' => array(
    array('filetype' => array('$not' => new MongoRegex('/image/'))),
    array('filetype' => array('$not' => new MongoRegex('/application/'))),
    array('filetype' => array('$not' => new MongoRegex('/video/'))),
  ),
));

BTW you could use this tiny script, to convert JSON representations to PHP:

var_export(json_decode($jsonAsString, true));

answered Apr 1, 2013 at 21:24

pozs

36.6k5 gold badges61 silver badges66 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Abhishek Sharma Over a year ago

Thanks for your awesome answer. Btw how var_export(json_decode($jsonAsString, true)); How this helps to convert most of mongoshell command to php.

pozs Over a year ago

If you have your where in json (f.ex. '{"username":"username"}') this script would show to you how it would be in php: var_export(json_decode('{"username":"username"}', true)) => array('username' => 'username')

Collectives™ on Stack Overflow

Trouble having mongodb code to php having $and $not and mongoregex operator

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related