一、返回格式为:
[ {"id":"1","address":"iana"}, {"id":"2","address":"美国"}]
php代码:
<?php header('content-type:application/json'); //此声明非常重要 try { $conn = new pdo("mysql:host=localhost;dbname=orig", 'admin', 'admin'); $conn -> setattribute(pdo::attr_errmode, pdo::errmode_exception); $conn->exec("set names utf8"); //设置编码 } catch(pdoexception $e) { echo "conn_error:<br/>" . $e -> getmessage(); } $sql = "select id,address from ip_segments limit 2;"; $result = $conn->query($sql)->fetchall(pdo::fetch_assoc); echo json_encode($result,json_unescaped_unicode); //json_unescaped_unicode防止中文乱码 ?>
二、返回格式为:
{ "total":2, "rows":[ {"id":"1","address":"iana"}, {"id":"2","address":"美国"} ]}
php代码:
<?php header('content-type:application/json'); try { $conn = new pdo("mysql:host=localhost;dbname=orig", 'admin', 'admin'); $conn -> setattribute(pdo::attr_errmode, pdo::errmode_exception); $conn->exec("set names utf8"); } catch(pdoexception $e) { echo "conn_error:<br/>" . $e -> getmessage(); } $sql = "select id,address from ip_segments limit 2;"; $result = $conn->query($sql)->fetchall(pdo::fetch_assoc); $json['total'] = count($result); $json['rows'] = $result; echo json_encode($json,json_unescaped_unicode); ?>
相关文章推荐:
php如何来创建一个软连接(代码)
php中的性能优化利器:php生成器的详解
以上就是php如何来实现返回json数据(代码)的详细内容。
