我正在尝试使用php将json编码的字符串解码为SQL语句。
假设我有这样一个json编码的字符串=〉

$j = '{"groupOp":"AND","rules":[{"field":"id","op":"cn","data":"A"},{"field":"i_name","op":"cn","data":"B"}]}';

我想构建SQL WHERE子句（jqGrid中filterToolbar搜索所需），类似于this =〉“WHERE id LIKE %A% AND i_name LIKE %B%“等。
我做了这个=〉

$d = json_decode($j);

$filterArray = get_object_vars($d); // makes array

foreach($filterArray as $m_arr_name => $m_arr_key){
    // here I can't made up my mind how to continue build SQL statement which I've mentioned above 
}

你知道怎么做吗？