php 数据库记录生成json,关于使用php链接sql数据库生成json数据

//connection information

$host = "localhost";

$user = "root";

$password = "";

$database = "tagcloud";

//make connection

$server = mysql_connect($host, $user, $password);

$connection = mysql_select_db($database, $server);

//query the database

$query = mysql_query("SELECT * FROM tags");

//start json object

$json = "({ tags:[";

//loop through and return results

for ($x = 0; $x < mysql_num_rows($query); $x++) {

$row = mysql_fetch_assoc($query);

//continue json object

$json .= "{tag:'" . $row["tag"] . "',freq:'" . $row["frequency"] . "'}";

//add comma if not last row, closing brackets if is

if ($x < mysql_num_rows($query) -1)

$json .= ",";

else

$json .= "]})";

}

//return JSON with GET for JSONP callback

$response = $_GET["callback"] . $json;

echo $response;

//close connection

mysql_close($server);

?>