So, your jQuery might be something like.....
复制代码 代码如下:
$.ajax({
url: "query.php",
data: {id:10},
datatype: json
success: function(results) {
if (results.msg == "success") {
for (var i in data) {
$("#content").append(
"id = " + results.data[i].id + ", description = " + results.data[i].description + ", msrp = " + results.data[i].msrp
);
}
} else {
$("#content").append(results.msg);
}
}
});

And your php....
复制代码 代码如下:
if (isset($_GET["id"])) {
$sql = "SELECT id, description, msrp FROM tbl WHERE id = "{$_GET["id"]}"";
$return = array();
if ($result = mysql_query($sql)) {
if (mysql_num_rows($result)) {
$return["msg"] = "success";
while ($row = mysql_fetch_assoc($result)) {
$return["data"][] = $row;
}
} else {
$return["msg"] = "No results found";
} else {
$return["msg"] = "Query failed";
}
header("Content-type: application/json");
echo json_encode($result);
}