Convert Filter Builder json data into php-sql where query

Job ID: 33901907

Budget: $15 – $16 USD

Hello

I am using the DataGrid Filter Builder (http://www.jeasyui.com/extension/filterbuilder.php), which posts filter rules to the server.

E.g.

{"op":"and","children":[{"field":"department","op":"equal","value":"000002"},{"field":"department","op":"equal","value":"000001"},{"op":"and","value":"","children":[{"field":"department","op":"equal","value":"000026"},{"op":"and","value":"","children":[{"field":"department","op":"equal","value":"000025"}]}]}]}

I need to parse the posted data in PHP file and use it in WHERE clause of sql query.
Related categories: PHP XML SQL Software Architecture MySQL