如何为每个汽车产品添加“预订按钮”？

Question

我想为每个汽车产品添加“预订”按钮。但它只显示第一辆车的一个按钮。$sql = "SELECT * FROM car";if($result = mysqli_query($link, $sql)){if(mysqli_num_rows($result) > 0){    echo "<table>";        echo "<tr>";            echo "<th>Id</th>";            echo "<th>Name</th>";            echo "<th>Price(RM)</th>";            echo "<th>Colour</th>";            echo "<th>Mode</th>";            echo "<th>Image</th>";            echo "<th>Status</th>";            echo "<td><button onclick=\"book_car('" . $row['car_id'] .             "')\">Book</button></td>";    while($row = mysqli_fetch_array($result)){        echo "<tr>";            echo "<td>" . $row['car_id'] . "</td>";            echo "<td>" . $row['car_name'] . "</td>";            echo "<td>" . $row['car_price'] . "</td>";            echo "<td>" . $row['car_colour'] . "</td>";            echo "<td>" . $row['car_mode'] . "</td>";            echo "<td><img src='" . $row['car_image'] . "' height='100'             width='100'></td>";            echo "<td>" . $row['car_status'] . "</td>";        echo "</tr>";    }没有错误。但我只想为每个汽车产品显示“预订”按钮。

Answer 1

这仅仅是因为您的按钮不在while 循环中！

你也没有关闭第一个tr标签。

正确的代码：

$sql = "SELECT * FROM car";

if($result = mysqli_query($link, $sql)){

if(mysqli_num_rows($result) > 0){

echo "<table>";

    echo "<tr>";

        echo "<th>Id</th>";

        echo "<th>Name</th>";

        echo "<th>Price(RM)</th>";

        echo "<th>Colour</th>";

        echo "<th>Mode</th>";

        echo "<th>Image</th>";

        echo "<th>Status</th>";

        echo "<th>action</th>";<!-- Added this line -->

     echo "</tr>";<!-- Added this line -->

while($row = mysqli_fetch_array($result)){

    echo "<tr>";

        echo "<td>" . $row['car_id'] . "</td>";

        echo "<td>" . $row['car_name'] . "</td>";

        echo "<td>" . $row['car_price'] . "</td>";

        echo "<td>" . $row['car_colour'] . "</td>";

        echo "<td>" . $row['car_mode'] . "</td>";

        echo "<td><img src='" . $row['car_image'] . "' height='100' 

        width='100'></td>";

        echo "<td>" . $row['car_status'] . "</td>";

        echo "<td><button onclick=\"book_car('" . $row['car_id'] . 

        "')\">Book</button></td>";<!-- Replaced This line -->

    echo "</tr>";

}

echo "</table>";