mysql to json_MYSQL转换JSON

http://51strive.com/

在线 Mysql 转换 json串

在线 Mysql 转换 json串

2016.5.16 修复xmpphp-0.1rc2-r77支持php7

xmpphp-0.1rc2-r77 for php7

Mysql 输出格式：

mysql> select * from demo_test;

+-----+--------------+------+------+------+

| c1 | c2 | c3 | c4 | c5 |

+-----+--------------+------+------+------+

| a11 | 123456789 | 10 | 1 | 0 |

| AA | HELLO, HELLO | 8 | 0 | 0 |

+-----+--------------+------+------+------+

注：拷贝表格部分

Json串：

null

var _hmt = _hmt || [];

(function() {

var hm = document.createElement("script");

hm.src = "//hm.baidu.com/hm.js?e8bbc4c2aa86f142f8c62acd306e2497";

var s = document.getElementsByTagName("script")[0];

s.parentNode.insertBefore(hm, s);

})();

function checkValid()

{

var tex = document.getElementById("strData");

if(tex.value.length > 16384)

{

alert("输入不超过16384个字符！已经超出"+Number(tex.value.length-16384));

return false;

}

return true;

}