如何在PHP中单击鼠标从html表中检索行 - How to retrieve row from a html table on mouse click in PHP?

How to retrieve row from a html table on mouse click in PHP?

本文关键字：html 检索单击 PHP 鼠标 | 更新日期: 2023-09-27

我使用PHP在HTML表中显示一些记录。我试图使它，当我点击一行，我可以存储itemID(已点击)在一个变量。出于某种原因，当我单击我想要的行时，JavaScript中的警告不工作，也不会发生。我是不是漏掉了什么微不足道的东西?

<?php
    $con=mysqli_connect("localhost","root","mypassword","myDB");
    // Check connection
    if (mysqli_connect_errno())
    {
    echo "Failed to connect to MySQL: " . mysqli_connect_error();
    }
    echo "<font color = 'darkgreen'> Connected to database. </font> <br>";
    $result = mysqli_query($con,"SELECT * FROM Inventory");
    echo "<table border='1'>
    <tr>
    <th>Item ID</th>
    <th>Item Name</th>
    </tr>";
    while($row = mysqli_fetch_array($result))
    {
    echo "<tr>";
    echo "<td>" . $row['itemID'] . "</td>";
    echo "<td>" . $row['itemName'] . "</td>";
    echo "</tr>";
    }
    echo "</table>";
    mysqli_close($con);
    ?>
    <script type="text/javascript">
    $("tr.table").click(function() {
        var tableData = $(this).children("td").map(function() {
            return $(this).text();
        }).get();
        alert("Your data is: " + $.trim(tableData[0]) + " , " + $.trim(tableData[1]));
    });
    </script>

<?php
    $con=mysqli_connect("localhost","root","mypassword","myDB");
    // Check connection
    if (mysqli_connect_errno())
    {
    echo "Failed to connect to MySQL: " . mysqli_connect_error();
    }
    echo "<h3 style='color: darkgreen;'> Connected to database. </h3> <br />";
    $result = mysqli_query($con,"SELECT * FROM Inventory");
    echo "<table border='1'>
    <tr>
    <th>Item ID</th>
    <th>Item Name</th>
    </tr>";
    while($row = mysqli_fetch_array($result))
    {
    echo "<tr>";
    echo "<td class='item-id'>" . $row['itemID'] . "</td>";
    echo "<td class='item-name'>" . $row['itemName'] . "</td>";
    echo "</tr>";
    }
    echo "</table>";
    mysqli_close($con);
    ?>
    <script src="https://code.jquery.com/jquery-1.12.4.min.js" integrity="sha256-ZosEbRLbNQzLpnKIkEdrPv7lOy9C27hHQ+Xp8a4MxAQ=" crossorigin="anonymous"></script>
    <script type="text/javascript">
    $("tr").click(function() {
        var id = $(this).find('.item-id').text();
        var name = $(this).find('.item-name').text();
        alert("Your data is: " + $.trim(id) + " , " + $.trim(name));
    });
    </script>

echo "<tr onclick='showAlert($row['itemID'],$row['itemName']);'>";

请在您的表中写入并创建Java脚本函数来显示警报

<script>
     function showAlert(TxtItemid,txtItemName){
      alert("Your data is: " + TxtItemid + " , " + txtItemName));
     }
</script>

这是一种提醒方式。请试穿一下。这对你有用。