doulangbizhan5160 2017-04-07 22:40 采纳率: 100%
浏览 32

PHP MYSQL表删除按钮不起作用

Here is the query statement that I have. For some reason it works for another table I have but doesn't work with this table. I checked phpmyadmin to see if I would create an error but there were zero errors.

$Store_ID = filter_input(INPUT_POST,'Store_ID',FILTER_VALIDATE_INT);
//DELETE the Store

$query="DELETE FROM store_location WHERE Store_ID = :Store_ID";
$statement2=$db->prepare($query);
$statement2->bindValue(':Store_ID',$Store_ID);
$statement2->execute();
$statement2->closeCursor();   

Here is the table code for the Delete Button

           <?php foreach ($stores as $s) : ?>
        <tr>
            <td><?php echo $s['Store_ID']; ?></td>
            <td><?php echo $s['Loc_Street']; ?></td>
            <td><?php echo $s['Loc_City']; ?></td>
            <td><?php echo $s['Loc_State']; ?></td>
            <td><?php echo $s['Rent']; ?></td>
            <td><?php echo $s['License']; ?></td>   
            <td><?php echo $s['Inspect']; ?></td>  
            <td><form action="stores.php" method="post">
                    <input type ="hidden" name ="Store_ID" value ="<?php echo $s['Store_ID']; ?>"/>
                    <input type="button" name="delete" value="Delete"/>                
           </form></td>  
         </tr>
       <?php endforeach; ?>
    </table>
  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥20 求个正点原子stm32f407开发版的贪吃蛇游戏
    • ¥15 正弦信号发生器串并联电路电阻无法保持同步怎么办
    • ¥15 划分vlan后,链路不通了?
    • ¥20 求各位懂行的人,注册表能不能看到usb使用得具体信息,干了什么,传输了什么数据
    • ¥15 个人网站被恶意大量访问,怎么办
    • ¥15 Vue3 大型图片数据拖动排序
    • ¥15 Centos / PETGEM
    • ¥15 划分vlan后不通了
    • ¥20 用雷电模拟器安装百达屋apk一直闪退
    • ¥15 算能科技20240506咨询(拒绝大模型回答)