python result转json row_header_从数据库中取出的resultset数据集怎么转成json格式？ 新手请教...

$sql = "SELECT iso,name,printable_name,iso3,numcode FROM country $where $sort $limit";

$result = runSQL($sql);

$total = countRec("iso","country $where");

header("Expires: Mon, 26 Jul 1997 05:00:00 GMT" );

header("Last-Modified: " . gmdate( "D, d M Y H:i:s" ) . "GMT" );

header("Cache-Control: no-cache, must-revalidate" );

header("Pragma: no-cache" );

header("Content-type: text/x-json");

$json = "";

$json .= "{\n";

$json .= "page: $page,\n";

$json .= "total: $total,\n";

$json .= "rows: [";

$rc = false;

while ($row = mysql_fetch_array($result)) {

if ($rc) $json .= ",";

$json .= "\n{";

$json .= "id:'".$row['iso']."',";

$json .= "cell:['".$row['iso']."'";

$json .= ",'".addslashes($row['name'])."'";

$json .= ",'".addslashes($row['printable_name'])."'";

$json .= ",'".addslashes($row['iso3'])."'";

$json .= ",'".$row['numcode']."']";

$json .= "}";

$rc = true;

}

$json .= "]\n";

$json .= "}";

echo $json;

类似的一般的php输出，不复杂的话，直接改成相应的jsp即可。

2008年9月12日 13:44