Convert Filter Builder json data into php-sql where query
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.
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.