mysql query json_MySQL Query to Json

/******************by garcon1986*********************/

$connect = mysql_connect("localhost","root","") or die(mysql_error());

mysql_select_db("crm1_7");

$query = "select id,firstname,lastname from user";

//$query = "select * from user";

$results = mysql_query($query) or die(mysql_error());

//以下代码的array显示方式是Array ( [0] => 1 [id] => 1 [1] => piman

[firstname] => piman [2] => piman [lastname] => piman )

/*while($row = mysql_fetch_array($results)){

//print_r() 使array以Array ( [0] => 1 [id] => 1 [1] => piman

[firstname] => piman [2] => piman [lastname] => piman ) 形式显示

print_r($row);

//json_encode() 以json形式显示

echo json_encode($row);

}

*/

//以下代码array的显示方式是{"id":"1","firstname":"piman","lastname":"piman"}

/*while($row = mysql_fetch_array($results, MYSQL_ASSOC)){

echo json_encode($row);

}*/

//或者{"id":"1","firstname":"piman","lastname":"piman"}

while($row = mysql_fetch_assoc($results)){

echo json_encode($row);

}

?>

例子2：

$conn = mysql_connect("localhost","charles","charles");

mysql_select_db("crm1204", $conn);

$query = "select * from entreprise";

$result = mysql_query($query);

$response = "[";

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

$response .= "{'nom':'".$row['nom']."', 'entreprise_id':'".$row['entreprise_id']."'}";

}

$response .= "]";

echo $response;

?>

结果：

[{'nom':'e1', 'entreprise_id':'1'}{'nom':'e2', 'entreprise_id':'2'}]

分享到：

2010-10-13 04:12

浏览 628

评论