时间戳

首页 > 解决方案 > 按钮使一行处于活动状态，其他行处于非活动状态

php - 按钮使一行处于活动状态，其他行处于非活动状态

问题描述

此状态（活动 1 /非活动 0）按钮使任何单个记录处于活动/非活动状态。我需要更改它，以便在单击时通过更改 tbladdress_status db 变量使该记录处于活动状态而所有其他记录处于非活动状态。

if (isset($_GET['tbladdress_status'])) {
    if ($_GET['tbladdress_status']=="ok") { 
        $statusupdate=$db->prepare("UPDATE tbl_address SET          
            tbladdress_status=:tbladdress_status
            WHERE tbladdress_id={$_GET['tbladdress_id']}                
            ");     
        $update=$statusupdate->execute(array(   
            'tbladdress_status' => $_GET['activestatus']
            )); 
        if ($update) {              
            Header("Location:../../front-address-all.php?status=ok");   
        } else {    
            Header("Location:../../front-address-all.php?status=no");
        }   
    }
}

<?php 
if ($pulladdress['tbladdress_status']==1) { ?>
<a href="nedmin/netting/pdo-process.php?tbladdress_id=<?php echo $pulladdress['tbladdress_id'] ?>&activestatus=0&tbladdress_status=ok"><button class="btn btn-success btn-xs"><?php echo _ACTIVE; ?></button>
<?php } elseif($pulladdress['tbladdress_status']==0) {?>
<a href="nedmin/netting/pdo-process.php?tbladdress_id=<?php echo $pulladdress['tbladdress_id'] ?>&activestatus=1&tbladdress_status=ok"><button class="btn btn-danger btn-xs"><?php echo _PASSIVE; ?></button>                
<?php } ?>

标签： phpsqlpdo

解决方案

推荐阅读