在一个循环mysqlfetch数组中为按钮添加另一列 - adding another column for buttons in a loop mysql fetch array

adding another column for buttons in a loop mysql fetch array

嗨，我想在数据表的最后一列添加图标或按钮（编辑和删除）。

这是HTML代码：

<table id="product-grid"  cellpadding="0" cellspacing="0" border="0" class="display" width="100%">
        <thead>
        <tr>
        <th>Item No.</th>
          <th>Item</th>
          <th>Description</th>
          <th>Unit</th>
          <th>Unit Cost</th>
          <th>Category</th>
          <th>Quantity</th>
          <th>Action</th>
        </tr>
        </thead>
        </table>

这是我的php查询

$data = array();
while( $row=mysqli_fetch_array($query) ) {  // preparing an array
    $nestedData=array();
    $nestedData[] = $row["pro_id"];
    $nestedData[] = $row["pro_name"];
    $nestedData[] = $row["pro_desc"];
    $nestedData[] = $row["unit_name"];
    $nestedData[] = $row["pro_price"];
    $nestedData[] = $row["cat_name"];
    $nestedData[] = $row["quantity"];
    $data[] = $nestedData;
}

我想在$nestedData[] = $row["quantity"]; 之后添加它

感谢

<tr>
<th>Item No.</th>
<th>Item</th>
<th>Description</th>
<th>Unit</th>
<th>Unit Cost</th>
<th>Category</th>
<th>Quantity</th>
<th>Action</th>
</tr>
<?php
while( $row=mysqli_fetch_array($query) ) {  // preparing an array
  ?>
<tr>
    <td><?php echo $row["pro_id"];?></td>
    <td><?php echo $row["pro_name"];?></td>
    <td><?php echo $row["pro_desc"];?></td>
    <td><?php echo $row["unit_name"];?></td>
    <td><?php echo $row["pro_price"];?></td>
    <td><?php echo $row["cat_name"];?></td>
    <td><?php echo $row["quantity"];?></td>
    <input type = "submit" name="your_button_name" value = "your_button_name">
</tr>    
<?php } ?>

像这样使用

<tr>
<th>Item No.</th>
<th>Item</th>
<th>Description</th>
<th>Unit</th>
<th>Unit Cost</th>
<th>Category</th>
<th>Quantity</th>
<th>Action</th>
</tr>
<?php
while( $row=mysqli_fetch_array($query) ) {  // preparing an array
  ?>
<tr>
    <td><?php echo $row["pro_id"];?></td>
    <td><?php echo $row["pro_name"];?></td>
    <td><?php echo $row["pro_desc"];?></td>
    <td><?php echo $row["unit_name"];?></td>
    <td><?php echo $row["pro_price"];?></td>
    <td><?php echo $row["cat_name"];?></td>
    <td><?php echo $row["quantity"];?></td>
<td><a href="edit.php?id=<?php echo $row["pro_id"];?>">Edit</a> <a href="delete.php?id=<?php echo $row["pro_id"];?>">Delete</a> </td>
</tr>    
<?php } ?>