json编码的数据到数据表


json encoded data to datatables

我使用"服务器端"版本的数据表获得了这个json编码的数据。但是,我如何将这个值放入数据表中,以便以表格格式列出我的数据呢?

{"sEcho":0,"iTotalRecords":"40","iTotalDisplayRecords":"40","aaData":[["test@test.com","5656565","656565"],["test@test.com","5656565","656565"],["test@test.com","5656565","656565"],["test@test.com","Greater Noida","201308"],["test@test.com","Greater Noida","201308"],["test@test.com","Greater Noida","201308"],["test@test.com","656","56"],["test@test.com","656","56"],["test@test.com","656","56"],["test@test.com","Lucknow","226005"],["test@test.com","Lucknow","226005"],["test@test.com","Lucknow","226005"],["test@test.com","Greater Noida","201308"],["test@test.com","Greater Noida","201308"],["test@test.com","Greater Noida","201308"],["test@test.com","Lucknow","226005"],["test@test.com","Lucknow","226005"],["test@test.com","Lucknow","226005"],["test@test.com","Lucknow","226005"],["test@test.com","Lucknow","226005"],["test@test.com","Lucknow","226005"],["test@test.com","Lucknow","226005"],["test@test.com","56565","56565"],["test@test.com","Greater Noida","201308"],["test@test.com","Greater Noida","201308"],["rahul_mishra@gmail.com","Greater Noida","201308"],["rahul_mishra@gmail.com","Greater Noida","201308"],["rahul_mishra@gmail.com","Lucknow","226005"],["rahul_mishra@gmail.com","Lucknow","226005"],["rahul_mishra@gmail.com","ko","koko"],["rahul_mishra@gmail.com","ko","koko"],["rahul_mishra@gmail.com","Greater Noida","201308"],["test@test.com","Lucknow","226005"],["znet@gmail.com","o","ok"],["znet@gmail.com","TA","TA"],["znet@gmail.com","Lucknow","226012"],["znet@gmail.com","Lucknow","226012"],["znet@gmail.com","Lucknow","226012"],["test@test.com","o","ok"],["test@test.com","o","ok"]]}

您需要通过AJAX加载它。看看jQueryDataTables站点上的示例。

http://www.datatables.net/examples/server_side/object_data.html

您将有一个服务器端脚本来输出您发布的数据。您将拥有一些JS,它对服务器端脚本进行AJAX调用。这将处理将数据放入表中的操作。

$obj = json_decode($json); 

将使用您的数据创建一个对象

您也可以创建一个数组,但使用true作为第二个参数

$array= json_decode($json, true);