Skip to content

Instantly share code, notes, and snippets.

@AJLoveChina

AJLoveChina/demo.php

Created November 6, 2015 02:02
Show Gist options
  • Save AJLoveChina/62eff078601225c94726 to your computer and use it in GitHub Desktop.
Save AJLoveChina/62eff078601225c94726 to your computer and use it in GitHub Desktop.
Download ZIP
Store XML data in JSON
Raw
demo.php
// 我有一个数据表, 其中有一个字段是 XML数据, 我现在要把数据读出来并存储到 JSON格式的数据结构中返回给浏览器
// 我使用的PHP原生函数 json_encode, 但是json格式依然有错误, 主要是因为 xml中有许多特殊字符
// 怎么办 ?
// 用base64_encode 编码xml数据后再存储到 json 结构中. 形如下面这样
// 客户端解析 w_desc 字段时, 先base64解码一下就好了.
/*
[{
"w_val": "abampere",
"w_desc": "PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iVVRGLTgiPz4KPHlvZGFvZGljdD4KICA8cmV0dXJuLXBocmFzZT48IVtDREFUQVthYmFtcGVyZV1dPjwvcmV0dXJuLXBocmFzZT4KICAgICAgICAgICAgICAgIDxsYW5nPmVuZzwvbGFuZz4KICAgICAgICAgICAgICAgCSAgCiAgICAgICAgICAgICAgICA8ZGljdGNuLXNwZWFjaD48IVtDREFUQVthYmFtcGVyZV1dPjwvZGljdGNuLXNwZWFjaD4KICAgICAgIDxzcGVlY2g+PCFbQ0RBVEFbYWJhbXBlcmVdXT48L3NwZWVjaD4KICAgICAgIDx1ay1zcGVlY2g+PCFbQ0RBVEFbYWJhbXBlcmVdXT48L3VrLXNwZWVjaD4KICAgICAgIDx1cy1zcGVlY2g+PCFbQ0RBVEFbYWJhbXBlcmVdXT48L3VzLXNwZWVjaD4KICAgICAgICAgICAgICAJPHBob25ldGljLXN5bWJvbD7DpmInw6ZtcM61yZk8L3Bob25ldGljLXN5bWJvbD4KICAgICAgICAgICAgICAgICAgICAgIDx1ay1waG9uZXRpYy1zeW1ib2w+w6ZiJ8OmbXDOtcmZPC91ay1waG9uZXRpYy1zeW1ib2w+CiAgICAgICAgICAgICAgICAgICAgICA8dXMtcGhvbmV0aWMtc3ltYm9sPsOmYifDpm1wzrXJmTwvdXMtcGhvbmV0aWMtc3ltYm9sPgogICAgICAgICAgICAgICAgIDxjdXN0b20tdHJhbnNsYXRpb24+CiAgICAgIDx0eXBlPmVjPC90eXBlPgogICAgICAgICAgICAgPHRyYW5zbGF0aW9uPjxjb250ZW50PjwhW0NEQVRBW24uIOe7neWvueWuieWfue+8iOeUteejgeWItueUtea1geW8uuW6puWNleS9je+8iV1dPjwvY29udGVudD48L3RyYW5zbGF0aW9uPgogICAgICAgICAgIDwvY3VzdG9tLXRyYW5zbGF0aW9uPgogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIDx5b2Rhby13ZWItZGljdD4KICAgICAgICAgICAgICAgICAgICAgICAgICAgIDx3ZWItdHJhbnNsYXRpb24gc2FtZT0idHJ1ZSI+CiAgICAgICAgICAgICAgICA8a2V5PjwhW0NEQVRBW0FiYW1wZXJlXV0+PC9rZXk+CiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIDx0cmFucz4KCQkgIDx2YWx1ZT48IVtDREFUQVvnu53lr7nlronln7ldXT4KCQkgIDwvdmFsdWU+CgkJICAJCSAgCQkgIDwvdHJhbnM+CiAgICAgICAgICAgICAgICAgICAgICAgICAgICA8dHJhbnM+CgkJICA8dmFsdWU+PCFbQ0RBVEFb57ud5a+55a6J5Z+5XV0+CgkJICA8L3ZhbHVlPgoJCSAgCQkgIAkJICA8L3RyYW5zPgogICAgICAgICAgICAgICAgICAgICAgICAgICAgPHRyYW5zPgoJCSAgPHZhbHVlPjwhW0NEQVRBW+eUteejgeWuiV1dPgoJCSAgPC92YWx1ZT4KCQkgIAkJICAJCSAgPC90cmFucz4KICAgICAgICAgICAgICAgIDwvd2ViLXRyYW5zbGF0aW9uPgogICAgICAgICAgICAgICAgICAgICAgPHdlYi10cmFuc2xhdGlvbj4KICAgICAgICAgICAgICAgIDxrZXk+PCFbQ0RBVEFbYWJhbXBlcmUgQ0dTXV0+PC9rZXk+CiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIDx0cmFucz4KCQkgIDx2YWx1ZT48IVtDREFUQVvnlLXno4HliLblronln7ldXT4KCQkgIDwvdmFsdWU+CgkJICAJCSAgCQkgIDwvdHJhbnM+CiAgICAgICAgICAgICAgICA8L3dlYi10cmFuc2xhdGlvbj4KICAgICAgICAgICAgICAgICAgICAgIDx3ZWItdHJhbnNsYXRpb24+CiAgICAgICAgICAgICAgICA8a2V5PjwhW0NEQVRBW2FiYW1wZXJlIHBlciBzcXVhcmUgY2VudGltZXRlciAoYUEvY20gMildXT48L2tleT4KICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgPHRyYW5zPgoJCSAgPHZhbHVlPjwhW0NEQVRBW+eUteejgeWuiS/ljpjnsbNdXT4KCQkgIDwvdmFsdWU+CgkJICAJCSAgCQkgIDwvdHJhbnM+CiAgICAgICAgICAgICAgICA8L3dlYi10cmFuc2xhdGlvbj4KICAgICAgICAgICAgPC95b2Rhby13ZWItZGljdD4KICAgIAogICAgICAgICAgPHNleHA+MDwvc2V4cD4KCjwveW9kYW9kaWN0Pgo="
}]
*/
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment