mysql urldecode_url里面的数据解码

有时在url里面会遇到以下类似的数据

https://api.XXXXX.com/track/?data=eyJldmVudCI6ICIkd2ViX2V2ZW50IiwicHJvcGVydGllcyI6IHsiJG9zIjogIldpbmRvd3MiLCIkYnJvd3NlciI6ICJDaHJvbWUiLCIkY3VycmVudF91cmwiOiAiaHR0cHM6Ly93ZWIuaXRpZ2VyLmNvbS9xdW90ZS9LTy9jaGFydCIsIiRicm93c2VyX3ZlcnNpb24iOiA2NiwiJHNjcmVlbl9oZWlnaHQiOiAxMDgwLCIkc2NyZWVuX3dpZHRoIjogMTkyMCwibXBfbGliIjogIndlYiIsIiRsaWJfdmVyc2lvbiI6ICIyLjEzLjAiLCJkaXN0aW5jdF9pZCI6IDM0Nzk1Mjg5NzIyMTU3NDUsIiRpbml0aWFsX3JlZmVycmVyIjogImh0dHBzOi8vd3d3Lml0aWdlci5jb20vZG93bmxvYWQiLCIkaW5pdGlhbF9yZWZlcnJpbmdfZG9tYWluIjogInd3dy5pdGlnZXIuY29tIiwiJGV2ZW50X3R5cGUiOiAiY2hhbmdlIiwiJGNlX3ZlcnNpb24iOiAxLCIkaG9zdCI6ICJ3ZWIuaXRpZ2VyLmNvbSIsIiRwYXRobmFtZSI6ICIvcXVvdGUvS08vY2hhcnQiLCIkZWxlbWVudHMiOiBbCiAgICB7ImNsYXNzZXMiOiBbCiAgICAiIgpdLCJ0YWdfbmFtZSI6ICJpbnB1dCIsImF0dHJfX3R5cGUiOiAicGFzc3dvcmQiLCJhdHRyX19yZXF1aXJlZCI6ICJyZXF1aXJlZCIsImF0dHJfX2F1dG9mb2N1cyI6ICJhdXRvZm9jdXMiLCJhdHRyX19tYXhsZW5ndGgiOiAiNiIsIm50aF9jaGlsZCI6IDEsIm50aF9vZl90eXBlIjogMX0sCiAgICB7ImNsYXNzZXMiOiBbCiAgICAicGFzc3dvcmQiCl0sInRhZ19uYW1lIjogInNlY3Rpb24iLCJhdHRyX19jbGFzcyI6ICJwYXNzd29yZCIsIm50aF9jaGlsZCI6IDIsIm50aF9vZl90eXBlIjogMX0sCiAgICB7ImNsYXNzZXMiOiBbCiAgICAiIgpdLCJ0YWdfbmFtZSI6ICJtYWluIiwibnRoX2NoaWxkIjogMSwibnRoX29mX3R5cGUiOiAxfSwKICAgIHsiY2xhc3NlcyI6IFsKICAgICJ0cmFkZS1wYXNzd29yZCIKXSwidGFnX25hbWUiOiAiZGl2IiwiYXR0cl9fY2xhc3MiOiAidHJhZGUtcGFzc3dvcmQiLCJudGhfY2hpbGQiOiAxLCJudGhfb2ZfdHlwZSI6IDF9LAogICAgeyJjbGFzc2VzIjogWwogICAgIiIKXSwidGFnX25hbWUiOiAiZGl2IiwiYXR0cl9faWQiOiAibW9kYWxfd3JhcHBlciIsIm50aF9jaGlsZCI6IDcsIm50aF9vZl90eXBlIjogN30sCiAgICB7ImNsYXNzZXMiOiBbCiAgICAiYXBwIiwKICAgICJzdG9jay1jb2xvci0tcmVkLXVwIiwKICAgICJibGluay1hY3RpdmUtdHJ1ZSIKXSwidGFnX25hbWUiOiAiZGl2IiwiYXR0cl9fY2xhc3MiOiAiYXBwIHN0b2NrLWNvbG9yLS1yZWQtdXAgYmxpbmstYWN0aXZlLXRydWUiLCJudGhfY2hpbGQiOiA2LCJudGhfb2ZfdHlwZSI6IDV9LAogICAgeyJjbGFzc2VzIjogWwogICAgInRoZW1lLWRhcmsiCl0sInRhZ19uYW1lIjogImJvZHkiLCJhdHRyX19jbGFzcyI6ICJ0aGVtZS1kYXJrIiwiYXR0cl9fc3R5bGUiOiAiIiwibnRoX2NoaWxkIjogMiwibnRoX29mX3R5cGUiOiAxfQpdLCIkZWxfdGV4dCI6ICLigKLigKLigKLigKLigKLigKIiLCJ0b2tlbiI6ICJmZWNiZThlNzAxZTlmMmU4M2YyOGU1M2E2MjYzYWJlZiIsIiRfX2MiOiAwfX0%3D&ip=1&_=1526864479314

大概率是base64编码+url编码，反向操作即可解码

先进行url解码，再进行base64解码

url解码

eyJldmVudCI6ICIkd2ViX2V2ZW50IiwicHJvcGVydGllcyI6IHsiJG9zIjogIldpbmRvd3MiLCIkYnJvd3NlciI6ICJDaHJvbWUiLCIkY3VycmVudF91cmwiOiAiaHR0cHM6Ly93ZWIuaXRpZ2VyLmNvbS9xdW90ZS9LTy9jaGFydCIsIiRicm93c2VyX3ZlcnNpb24iOiA2NiwiJHNjcmVlbl9oZWlnaHQiOiAxMDgwLCIkc2NyZWVuX3dpZHRoIjogMTkyMCwibXBfbGliIjogIndlYiIsIiRsaWJfdmVyc2lvbiI6ICIyLjEzLjAiLCJkaXN0aW5jdF9pZCI6IDM0Nzk1Mjg5NzIyMTU3NDUsIiRpbml0aWFsX3JlZmVycmVyIjogImh0dHBzOi8vd3d3Lml0aWdlci5jb20vZG93bmxvYWQiLCIkaW5pdGlhbF9yZWZlcnJpbmdfZG9tYWluIjogInd3dy5pdGlnZXIuY29tIiwiJGV2ZW50X3R5cGUiOiAiY2hhbmdlIiwiJGNlX3ZlcnNpb24iOiAxLCIkaG9zdCI6ICJ3ZWIuaXRpZ2VyLmNvbSIsIiRwYXRobmFtZSI6ICIvcXVvdGUvS08vY2hhcnQiLCIkZWxlbWVudHMiOiBbCiAgICB7ImNsYXNzZXMiOiBbCiAgICAiIgpdLCJ0YWdfbmFtZSI6ICJpbnB1dCIsImF0dHJfX3R5cGUiOiAicGFzc3dvcmQiLCJhdHRyX19yZXF1aXJlZCI6ICJyZXF1aXJlZCIsImF0dHJfX2F1dG9mb2N1cyI6ICJhdXRvZm9jdXMiLCJhdHRyX19tYXhsZW5ndGgiOiAiNiIsIm50aF9jaGlsZCI6IDEsIm50aF9vZl90eXBlIjogMX0sCiAgICB7ImNsYXNzZXMiOiBbCiAgICAicGFzc3dvcmQiCl0sInRhZ19uYW1lIjogInNlY3Rpb24iLCJhdHRyX19jbGFzcyI6ICJwYXNzd29yZCIsIm50aF9jaGlsZCI6IDIsIm50aF9vZl90eXBlIjogMX0sCiAgICB7ImNsYXNzZXMiOiBbCiAgICAiIgpdLCJ0YWdfbmFtZSI6ICJtYWluIiwibnRoX2NoaWxkIjogMSwibnRoX29mX3R5cGUiOiAxfSwKICAgIHsiY2xhc3NlcyI6IFsKICAgICJ0cmFkZS1wYXNzd29yZCIKXSwidGFnX25hbWUiOiAiZGl2IiwiYXR0cl9fY2xhc3MiOiAidHJhZGUtcGFzc3dvcmQiLCJudGhfY2hpbGQiOiAxLCJudGhfb2ZfdHlwZSI6IDF9LAogICAgeyJjbGFzc2VzIjogWwogICAgIiIKXSwidGFnX25hbWUiOiAiZGl2IiwiYXR0cl9faWQiOiAibW9kYWxfd3JhcHBlciIsIm50aF9jaGlsZCI6IDcsIm50aF9vZl90eXBlIjogN30sCiAgICB7ImNsYXNzZXMiOiBbCiAgICAiYXBwIiwKICAgICJzdG9jay1jb2xvci0tcmVkLXVwIiwKICAgICJibGluay1hY3RpdmUtdHJ1ZSIKXSwidGFnX25hbWUiOiAiZGl2IiwiYXR0cl9fY2xhc3MiOiAiYXBwIHN0b2NrLWNvbG9yLS1yZWQtdXAgYmxpbmstYWN0aXZlLXRydWUiLCJudGhfY2hpbGQiOiA2LCJudGhfb2ZfdHlwZSI6IDV9LAogICAgeyJjbGFzc2VzIjogWwogICAgInRoZW1lLWRhcmsiCl0sInRhZ19uYW1lIjogImJvZHkiLCJhdHRyX19jbGFzcyI6ICJ0aGVtZS1kYXJrIiwiYXR0cl9fc3R5bGUiOiAiIiwibnRoX2NoaWxkIjogMiwibnRoX29mX3R5cGUiOiAxfQpdLCIkZWxfdGV4dCI6ICLigKLigKLigKLigKLigKLigKIiLCJ0b2tlbiI6ICJmZWNiZThlNzAxZTlmMmU4M2YyOGU1M2E2MjYzYWJlZiIsIiRfX2MiOiAwfX0=

base64解码

{"event": "$web_event","properties": {"$os": "Windows","$browser": "Chrome","$current_url": "https://web.XXXXXXX.com/XXXXXXXX","$browser_version": 66,"$screen_height": 1080,"$screen_width": 1920,"mp_lib": "web","$lib_version": "2.13.0","distinct_id": 3479528972215745,"$initial_referrer": "https://www.XXXXXXXX.com/download","$initial_referring_domain": "www.XXXXXXXX.com","$event_type": "change","$ce_version": 1,"$host": "web.XXXXXXX.com","$pathname": "XXXXXXX","$elements": [

{"classes": [

""

],"tag_name": "input","attr__type": "XXXXXXX","attr__required": "required","attr__autofocus": "autofocus","attr__maxlength": "6","nth_child": 1,"nth_of_type": 1},

{"classes": [

"XXXXXXXX"

],"tag_name": "section","attr__class": "password","nth_child": 2,"nth_of_type": 1},

{"classes": [

""

],"tag_name": "main","nth_child": 1,"nth_of_type": 1},

{"classes": [

"XXXXXXX"

],"tag_name": "div","attr__class": "XXXXXXXX","nth_child": 1,"nth_of_type": 1},

{"classes": [

""

],"tag_name": "div","attr__id": "modal_wrapper","nth_child": 7,"nth_of_type": 7},

{"classes": [

"app",

"stock-color--red-up",

"blink-active-true"

],"tag_name": "div","attr__class": "app stock-color--red-up blink-active-true","nth_child": 6,"nth_of_type": 5},

{"classes": [

"theme-dark"

],"tag_name": "body","attr__class": "theme-dark","attr__style": "","nth_child": 2,"nth_of_type": 1}

],"$el_text": "XXXXXXXXX","token": "XXXXXXXX","$__c": 0}}

最后格式化一下

{

"event": "$web_event",

"properties": {

"$os": "Windows",

"$browser": "Chrome",

"$current_url": "https://web.XXXX.com/XXXXXXt",

"$browser_version": 66,

"$screen_height": 1080,

"$screen_width": 1920,

"mp_lib": "web",

"$lib_version": "2.13.0",

"distinct_id": 3479528972215745,

"$initial_referrer": "https://www.XXXXX.com/download",

"$initial_referring_domain": "www.XXXXXXX.com",

"$event_type": "change",

"$ce_version": 1,

"$host": "web.XXXXXXX.com",

"$pathname": "/XXXXXXX",

"$elements": [

{

"classes": [

""

],

"tag_name": "input",

"attr__type": "XXXXXX",

"attr__required": "required",

"attr__autofocus": "autofocus",

"attr__maxlength": "6",

"nth_child": 1,

"nth_of_type": 1

},

{

"classes": [

"XXXXXXX"

],

"tag_name": "section",

"attr__class": "XXXXXX",

"nth_child": 2,

"nth_of_type": 1

},

{

"classes": [

""

],

"tag_name": "main",

"nth_child": 1,

"nth_of_type": 1

},

{

"classes": [

"XXXXXXXX"

],

"tag_name": "div",

"attr__class": "XXXXXXXX",

"nth_child": 1,

"nth_of_type": 1

},

{

"classes": [

""

],

"tag_name": "div",

"attr__id": "modal_wrapper",

"nth_child": 7,

"nth_of_type": 7

},

{

"classes": [

"app",

"stock-color--red-up",

"blink-active-true"

],

"tag_name": "div",

"attr__class": "app stock-color--red-up blink-active-true",

"nth_child": 6,

"nth_of_type": 5

},

{

"classes": [

"theme-dark"

],

"tag_name": "body",

"attr__class": "theme-dark",

"attr__style": "",

"nth_child": 2,

"nth_of_type": 1

}

],

"$el_text": "XXXXXXXX",

"token": "XXXXXXXXXXXX",

"$__c": 0

}

}