删除链接无法获取要删除的项目的确切ID

Question

我不明白当我的编码无法获取所选项目的ID时，将被删除，我相信这应该得到正确的ID。我使用下面的代码显示了我的所有项目。每个项目显示都有自己的删除和编辑链接。

<?php   
    $sql_select = "SELECT * FROM tblproduct LEFT JOIN productcategory ON tblproduct.prodCat = productcategory.catID ORDER BY tblproduct.id DESC"; 
    $result = $conn->query($sql_select); 

    if ($result->num_rows > 0){ 
     while($row = mysqli_fetch_assoc($result)) 
     { 
      ?> 
      <li> 
       <h3><?php echo $row['prodName']; ?></h3> 
       <div> 
        <img src="<?php echo "user_images/".$row['prodImg']; ?>" /> 
       </div> 
       <p>Code : <?php echo $row['prodCode']; ?></p> 
       <p>Price : RM<?php echo $row['prodPrice']; ?></p> 
       <p>Category : <?php echo $row['prodCat']; ?></p> 
       <p>Description : <?php echo $row['prodDesc']; ?></p> 
       <span> 
        <a class="btn btn-info" href="editform.php?edit_id=<?php echo $row['id']; ?>" title="click for edit" onclick="return confirm('sure to edit ?')"><span class="glyphicon glyphicon-edit"></span> Edit</a> 
        <a class="btn btn-danger" href="function.php?delete_id=<?php echo $row['id']; ?>" title="click for delete" onclick="return confirm('sure to delete ?')"><span class="glyphicon glyphicon-remove-circle"></span> Delete</a> 
       </span> 
      </li> 
      <?php 
     } 
    } 
?> 

参考上面的代码，当我点击删除环节，项目ID总是返回1和我的数据库只有记录其ID重新17

Answer 1

列ID不明确并且也可以来自产品类别。所以，你需要做类似下面

$sql_select = "SELECT tblproduct.id as product_id,* FROM tblproduct LEFT JOIN productcategory ON tblproduct.prodCat = productcategory.catID ORDER BY tblproduct.id DESC"; 

HTML

<a class="btn btn-danger" href="function.php?delete_id=<?php echo $row['product_id']; ?>" title="click for delete" onclick="return confirm('sure to delete ?')"><span class="glyphicon glyphicon-remove-circle"></span> Delete</a> 
</span>