Json生成SQL语句

{
  "cart_act": "buy",
  "cart_type": "fixed",
  "cart_atime": "1643439481",
  "product_id": "32",
  "product_guid": "0",
  "product_name": "健舒佳 牙线棒）",
  "product_rule": "默认",
  "product_logo": "4c49cb66ffebdbb2.jpg",
  "product_money": "4990.0",
  "product_num": "1",
  "user_id": "2"
}

生成Insert语句

//处理设置语句
protected function _setinsert($set)
{
	//仅针对insert插入多条数据
	echo  json_encode($set) . '<br>'; 
	$key_arr = $val_arr = array();  
	foreach ($set as $k => $v) {  
		$key_arr[] = str_ireplace('`', '', $k);
		$val_arr[] = "'{$v}'";
	}
	$val_str[] = "(" . implode($val_arr, ', ') . ")";
	$key_str = "(" . implode($key_arr, ', ') . ")";
	$sqlset = "{$key_str}  values ".implode($val_str, ', ');
	return $sqlset;
}