-
- $.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);
- }
- }
- });
复制代码
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);
- }
复制代码
|