-
- $.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