javascript - MySql 表的 Ajax 搜索以从结果中创建 href 链接

Question

我目前有一个可以工作并返回结果的 Ajax 搜索功能。但是，我无法让搜索结果成为 href 链接，因此它将搜索找到的“payroll_number”添加到 url 中，例如成为 Candidatecard.php?pr=1388。其中 1388 是工资单号

    <a href="candidatecard.php?pr='.$Result['payroll_number'].'">

我的网页代码：

    <h2>Payroll <span>Number Search</span></h2>
                
                <!-- Search box. -->
    <input type="text" id="search" placeholder="Payroll Number Search" />
    <b>Eg: </b><i>5100, 6237, 7259. </i>

    <!-- Suggestions will be displayed in below div. -->




     <?php
     echo "<a href='candidatecard.php?pr=$pn'>Search $pn</a>";
     ?>

     <div id="display"></div>

我的js代码

    //Getting value from "ajax.php".
    function fill(Value) {
    //Assigning value to "search" div in "search.php" file.
    $('#search').val(Value);
    //Hiding "display" div in "search.php" file.
    $('#display').hide();
    }
    $(document).ready(function() {
    //On pressing a key on "Search box" in "search.php" file. This function will be called.
    $("#search").keyup(function() {
    //Assigning search box value to javascript variable payroll_numberd as "payroll_number".
    var payroll_number = $('#search').val();
    //Validating, if "payroll_number" is empty.
    if (payroll_number == "") {
       //Assigning empty value to "display" div in "search.php" file.
       $("#display").html("");
    }
    //If payroll_number is not empty.
   else {
       //AJAX is called.
       $.ajax({
           //AJAX type is "Post".
           type: "POST",
           //Data will be sent to "ajax.php".
           url: "ajax.php",
           //Data, that will be sent to "ajax.php".
           data: {
               //Assigning value of "payroll_number" into "search" variable.
               search: payroll_number
           },
           //If result found, this funtion will be called.
           success: function(html) {
               //Assigning result to "display" div in "search.php" file.
               $("#display").html(html).show();
           }
           });
           }
           });
           });

我的阿贾克斯代码：

    <?php
    //Including Database configuration file.
    include "Include/db.php";
    //Getting value of "search" variable from "script.js".
    if (isset($_POST['search'])) {
    //Search box value assigning to $payroll_number variable.
     $payroll_number = $_POST['search'];
   //Search query.
    $Query = "SELECT payroll_number FROM candidatedetails WHERE payroll_number LIKE 
  '%$payroll_number%' LIMIT 10";
   //Query execution
   $ExecQuery = MySQLi_query($con, $Query);
   //Creating unordered list to display result.
   echo '
   <ul>
   ';
   //Fetching result from database.
   while ($Result = MySQLi_fetch_array($ExecQuery)) {
   ?>
   <!-- Creating unordered list items.
    Calling javascript function named as "fill" found in "script.js" file.
    By passing fetched result as parameter. -->
    <li onclick='fill("<?php echo $Result['payroll_number']; ?>")'>
    <a>
     <!-- Assigning searched result in "Search box" in "search.php" file. -->
    <?php echo $Result['payroll_number'];?>
    </li></a>
    <!-- Assign searchbox result to pn variable.-->
    <?php$pn = $Result['payroll_number'];?>
    <!-- Closing parenthesis. -->
    <?php
    }}
    ?>
   </ul>

标签： javascriptphpajax