php读取mysql数据库并转成json格式返回

php读取mysql数据库并转成json格式返回

想要实现一个读取数据库数据后，然后以json格式返回数据，做成api形式跟其它网站进行数据互通，就有了以下的尝试。

<?php
//定义json标准页头
header('Content-Type: application/json');
error_reporting(E_ALL || ~E_NOTICE);
$link = mysql_connect("localhost","xxxxUser","xxxxPassword");
if (!$link) {
    echo "fail";
}
mysql_select_db("xxxdb");
//查询数据库
//$result = mysql_query("select * from t_user");
//格式化查询语句，这样更加安全些
$query = sprintf("SELECT  title,url FROM link order by id desc  LIMIT 10;");
$result = mysql_query($query);
class Link {
    public $title;
    public $url;
    //public $create_time;
}
$data = array();
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
    $link = new Link();
    $link->title = $row["title"];
    $link->url = $row["url"];
    $data[] = $link;
}
$json = json_encode($data,JSON_UNESCAPED_UNICODE);
echo "{" . '"link"' . ":" . $json . "}";

演示地址http://blogger.csroad.cn/api2.php