duanshangying5102 2018-07-22 18:10
浏览 30

使用ajax使用单个函数显示两个不同div中的两个表的结果

$(".search").click(function() {
       a=  $(".input").val();
        $.post("search_input.php", {search:a}, function(resp) {
        if (resp!= 'incorrect') {
       $('#first').html(resp);
         }
       else{
     $('#first').html('no result found');
     }
   })

})
<input type="text" class="input">
<button class="search">Search</button>
<div id="first"></div>
<div id="second"></div>

At search_input.php, I tried searching two different tables with search.

$result1 = mysqli_query($this->con, "SELECT * from names_tb WHERE name LIKE '%$search%'");
$result2 = mysqli_query($this->con, "SELECT * from places_tb WHERE location LIKE '%$search%'");

My major issue is this, how can I display the result of result1 in the first div and the result for result2 in the second div using php? I tried using echo

$first=mysqli_num_rows($result1);
        if ($first>0) {

while ($b=$result1->fetch_array()) {

            $name=$b['name'];
            $age= $b['age'];
         }
} else{
            echo "incorrect";
        }
 $second=mysqli_num_rows($result2);
        if ($second>0) {

while ($c=$result2->fetch_array()) {

            $location=$b['location'];
            $state= $b['state'];
         }
} else{
            echo "incorrect";
        }   

But the problem with this is that, it will only display one of the results in the first div leaving the second div empty. Again, my main issue is to display result1 in the first div and result2 in the second div, how can I do this?

</div>
  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 2024-五一综合模拟赛
    • ¥15 下图接收小电路,谁知道原理
    • ¥15 装 pytorch 的时候出了好多问题,遇到这种情况怎么处理?
    • ¥20 IOS游览器某宝手机网页版自动立即购买JavaScript脚本
    • ¥15 手机接入宽带网线,如何释放宽带全部速度
    • ¥30 关于#r语言#的问题:如何对R语言中mfgarch包中构建的garch-midas模型进行样本内长期波动率预测和样本外长期波动率预测
    • ¥15 ETLCloud 处理json多层级问题
    • ¥15 matlab中使用gurobi时报错
    • ¥15 这个主板怎么能扩出一两个sata口
    • ¥15 不是,这到底错哪儿了😭