當我點擊刪除按鈕時，我試圖從數據表中刪除數據，數據將被刪除，以便在管理端進行快速操作，但我的代碼劑量不起作用，我試圖修復它，但我沒有看到這里的代碼有任何問題，這是我的代碼 <div class="table-responsive"><table id="datas" class="table table-striped table-bordered fixed" style="width:100%"> <thead style="color:black;" > <th>id</th> <th>Company Name</th> <th>Product Name</th> <th>Weight</th> <th>Price Per Gram</th> <th>Quantity</th> <th>Type</th> <th>Category</th> <th>Product Price</th> <th>Image</th> <th>Total Price</th> <th class="text-center">Actions</th> </thead> <?php $get = mysqli_query($conn,"SELECT * FROM stock;"); ?> <tbody> <?php while ($row=mysqli_fetch_array($get)) { $id=$row['id']; $company=$row['company_name']; $name=$row['product_name']; $weight=$row['weight']; $price_per_gram=$row['price_per_gram']; $quantity=$row['quantity']; $type=$row['type']; $category=$row['category']; $price=$row['product_price']; $img=$row['img']; $total=$row['total_price']; ?> <tr> <td ><?php echo $id;?></td> <td><?php echo $company;?></td> <td><?php echo $name;?></td> <td><?php echo $weight;?> g</td> <td><?php echo $price_per_gram;?> $</td> <td><?php echo $quantity;?></td> <td><?php echo $type;?></td> <td><?php echo $category;?></td> <td><?php echo $price;?></td> <td> <?php } ?> </tbody></table>我給刪除按鈕一個值，當點擊，所以它會刪除與該值，但它似乎沒有工作，任何人都可以幫助我
1 回答
慕哥6287543
TA貢獻1831條經驗 獲得超10個贊
你必須把桌子放在標簽里面<form></form>
<div class="table-responsive">
<form>
<table id="datas" class="table table-striped table-bordered fixed" style="width:100%">
<thead style="color:black;" >
<th>id</th>
<th>Company Name</th>
<th>Product Name</th>
<th>Weight</th>
<th>Price Per Gram</th>
<th>Quantity</th>
<th>Type</th>
<th>Category</th>
<th>Product Price</th>
<th>Image</th>
<th>Total Price</th>
<th class="text-center">Actions</th>
</thead>
<?php
$get = mysqli_query($conn,"SELECT * FROM stock;");
?>
<tbody>
<?php
while ($row=mysqli_fetch_array($get)) {
$id=$row['id'];
$company=$row['company_name'];
$name=$row['product_name'];
$weight=$row['weight'];
$price_per_gram=$row['price_per_gram'];
$quantity=$row['quantity'];
$type=$row['type'];
$category=$row['category'];
$price=$row['product_price'];
$img=$row['img'];
$total=$row['total_price'];
?>
<tr>
<td ><?php echo $id;?></td>
<td><?php echo $company;?></td>
<td><?php echo $name;?></td>
<td><?php echo $weight;?> g</td>
<td><?php echo $price_per_gram;?> $</td>
<td><?php echo $quantity;?></td>
<td><?php echo $type;?></td>
<td><?php echo $category;?></td>
<td><?php echo $price;?></td>
<td>
<img src="product_img/<?php echo $img; ?>" style="height:5rem;width:5rem;border-radius:10px;">
</td>
<td><?php echo $total;?></td>
<td style="width: 20px"> <a href="editstock.php?id=<?php echo $id;?>" class="btn btn-gradient-primary">Edit</a>
<button class="btn btn-danger" name="delete" type="submit" value="<?php echo "$id" ?>">Delete</button> </td>
</tr>
<?php } ?>
</tbody>
</table>
</form>
<?php
if (isset($_POST['delete'])) {
$delete = mysqli_query($conn,"DELETE FROM stock WHERE id= ".$_POST['delete']." ");
header("location:viewstcok.php");
} ?>
- 1 回答
- 0 關注
- 77 瀏覽
添加回答
舉報
0/150
提交
取消