-
- $.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);
- }
复制代码
|
本網站聲明
本文內容由網友自願投稿,版權歸原作者所有。本站不承擔相應的法律責任。如發現涉嫌抄襲或侵權的內容,請聯絡admin@php.cn
作者最新文章
-
2024-10-22 09:46:29
-
2024-10-13 13:53:41
-
2024-10-12 12:15:51
-
2024-10-11 22:47:31
-
2024-10-11 19:36:51
-
2024-10-11 15:50:41
-
2024-10-11 15:07:41
-
2024-10-11 14:21:21
-
2024-10-11 12:59:11
-
2024-10-11 12:17:31