dongliao8069 2019-01-16 17:35 采纳率: 0%
浏览 172
已采纳

如何使用ajax和jquery从我的数据库中检索记录?

I'm trying to retrieve records from my db using a button without the page refreshing. I'm not familiar with ajax and i've been having a hard time getting it to work. Here's what I have so far. any help would be appreciated, thank you

<h3>Avaiable assignments</h3><br>
<script>
 $(document).ready(function () {
$('#button1').click(function (e) {
    e.preventDefault();
    $.ajax({
        type: "GET",
        url: "getItem.php",
        dataType: "html",
        success: function (msg) {
            if (msg.success) {
            $("#responsecontainer").html(msg);
        } else {
            alert("error");
        }
    }
    });
  });
});
<br>
 <input name="button1" type="submit" id="button1" 
value="Picked" />

my getItem.php

<?php
include("connect.php");
$q = intval($_GET['q']);


if (!$con) {
    die('Could not connect: ' . mysqli_error($con));
}

mysqli_select_db($con,"items");
$sql="SELECT * FROM items WHERE LIMIT 1 OFFSET 1";
$result = mysqli_query($con,$sql);


while($row = mysqli_fetch_array($result))
{
echo $row['items'];
}

mysqli_close($con);
?>
  • 写回答

1条回答 默认 最新

  • duanca3415 2019-01-16 17:47
    关注

    Your best bet is to start in the Network tab of the browser's developer tools. There, you can see the outgoing request and what it comes back with.

    Bring up your form in the browser and fire off the click event. Then, find the request to 'getItem.php' and look at its response. If it's not what you expect, set getItem.php to echo 'hello' and die; if the network tab does not show 'hello' in the response, that means you're not hitting the endpoint. If you see 'hello', congratulations, you're close!

    In terms of your actual endpoint, I see you are repeatedly echoing the results of your query. This is not the most useful way to do this. Instead, json_encode the entire results set, echo that, and kill the script. This will return all your table rows as a JSON array which can then be read by javascript back on the client side.. I hope any of this helps!

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 调用函数时,无关变量的改变引起函数值的改变
  • ¥15 xy坐标转化为经纬度坐标
  • ¥15 一般三角模糊数的上界值和下届值取中值的多少比较合理?
  • ¥15 关于#python#的问题,请各位专家解答!
  • ¥20 Hbase启动失败,无法启动HMaster
  • ¥15 sqpingboot在父模块已经引入了mybatisplus 在子组件不写版本号还是报错
  • ¥20 Lumerical FDTD solutions 中模型的相对阻抗,有效介电常数和有效磁导率的实部和虚部的数据如何获得?
  • ¥100 sql reporting service 远程smtp服务器配置支持
  • ¥15 ppyoloe_r带角度目标检测,loss_cls没法收敛
  • ¥15 淘宝交易指数如何解读,其关联的数据指标是什么