php - 在 HTML 行中使用来自 mysql 的数据

Question

我有一个网页，我正在其中从 mysql 数据库中提取数据，并且我希望能够选中复选框并更改表中的信息。我显示信息的方式如下:

<?php
    $get_tickets = mysql_query("SELECT * FROM assignment 
                                JOIN technician 
                                ON assignment.TechID = technician.TechID
                                JOIN employee
                                ON assignment.EID = employee.EID
                                JOIN ticket
                                ON assignment.TickID = ticket.TickID
                                WHERE assignment.TechID = '$current_id'");

    echo "<table border='1' width=\"100%\" style=\"margin: 0px;\">";
    echo "<tr><td>Ticket Number</td>";
    echo "<td>First Name</td>";
    echo "<td>Last Name</td>";
    echo "<td>Phone</td>";
    echo "<td>Device</td>";
    echo "<td>Location</td>";
    echo "<td>Problem</td>";
    echo "<td>Time Stamp</td>";
    echo "<td>Completed</td>";
    echo '<td><form><input type="checkbox"/></form></td></tr>';

    while($row2 = mysql_fetch_array($get_tickets))
    {
        $count = 1;
        $checkbox = "checkbox" . $count;

        echo "<tr><td>";
            echo $row2["TickID"];
        echo "</td><td>";
            echo $row2["fname"];
        echo "</td><td>";
            echo $row2["lname"];
        echo "</td><td>";
            echo $row2["phone"];
        echo "</td><td>";
            echo $row2["device"];
        echo "</td><td>";
            echo $row2["location"];
        echo "</td><td>";
            echo $row2["problem"];
        echo "</td><td>";
            echo $row2["time_date"];
        echo "</td><td>";
            echo $row2["completed"];
        echo "</td><td>";
            echo '<form><input type="checkbox" name=' . $row2["TickID"] . '></form>';
        echo "</td></tr>";    
    }
?>

可能有更好的方法来输出信息，但我只想能够单击复选框并从与复选框关联的行中获取数据并更改其中的一部分。非常感谢任何帮助。

Answer 1

尝试改变这一点:

echo '<form><input type="checkbox" name=' . $row2["TickID"] . '></form>';

为此: echo '<a href="process.php?id='.$row2["TickID"].'">'.$row2["fname"].'</a>';

在文件 process.php 中，您将获得如下变量

<?php 
        echo $_GET['id'];
?>