public static function buildMySQLValuesArr($json) { $json['USER_CRASH_DATE'] = self::convertRFCDateToMySQLTimestamp($json['USER_CRASH_DATE']); $json['USER_APP_START_DATE'] = self::convertRFCDateToMySQLTimestamp($json['USER_APP_START_DATE']); $values = array(); foreach ($json as $k => $v) { $k = strtolower($k); if (in_array(strtoupper($k), self::$mSerializedFields)) { $values[$k] = base64_encode(serialize($v)); } else { // report_id is translate to report_key if (strcmp($k, 'report_id') == 0) { $values['report_key'] = DBHelper::escapeString($v); } else { $values[$k] = DBHelper::escapeString($v); } } } return $values; }
public static function buildMySQLValuesArr($json) { $json['USER_CRASH_DATE'] = self::convertRFCDateToMySQLTimestamp($json['USER_CRASH_DATE']); $json['USER_APP_START_DATE'] = self::convertRFCDateToMySQLTimestamp($json['USER_APP_START_DATE']); $values = array(); //error_log("JSON => ");error_log(print_r($json, true)); //error_log("BUILD => ");error_log(print_r($json['build'], true)); //error_log("BUILD_CONFIG => ");error_log(print_r($json['build_config'], true)); foreach ($json as $k => $v) { $k = strtolower($k); // my fix if ($k == "build_config") { continue; } if (in_array(strtoupper($k), self::$mSerializedFields)) { $values[$k] = base64_encode(serialize($v)); } else { // report_id is translate to report_key //error_log($k . "=> ");error_log(print_r($v, true)); if (strcmp($k, 'report_id') == 0) { $values['report_key'] = DBHelper::escapeString($v); } else { $values[$k] = DBHelper::escapeString($v); } } } return $values; }