View Code - 20260723

brand_manage.php | 20260723_000646.php Initial Domain Snapshot

<?php
declare(strict_types=1);
require_once __DIR__ . '/auth.php';
require_login();
require_once __DIR__ . '/partials/header.php';
$SHOP_ID = (int)$_SESSION['owner']['shop_id'];
$error=''; $success='';

/* UPDATE / TOGGLE */
if (isset($_POST['action'])) {
    $id = (int)$_POST['brand_id'];

if ($_POST['action']==='toggle') {
        $pdo->prepare("
            UPDATE brand SET is_active=IF(is_active=1,0,1)
            WHERE brand_id=? AND shop_id=?
        ")->execute([$id,$SHOP_ID]);
        $success='Brand status updated.';
    }

if ($_POST['action']==='edit') {
        $name=trim($_POST['brand_name']);
        try {
            $pdo->prepare("
                UPDATE brand SET brand_name=?
                WHERE brand_id=? AND shop_id=?
            ")->execute([$name,$id,$SHOP_ID]);
            $success='Brand updated.';
        } catch(Throwable $e){
            $error='Duplicate brand.';
        }
    }
}

/* ADD */
if ($_SERVER['REQUEST_METHOD']==='POST' && !isset($_POST['action'])) {
    $name=trim($_POST['brand_name']);
    try{
        $pdo->prepare("
            INSERT INTO brand (shop_id,brand_name,is_active)
            VALUES (?,?,1)
        ")->execute([$SHOP_ID,$name]);
        $success='Brand added.';
    }catch(Throwable $e){
        $error='Brand exists.';
    }
}

$data=$pdo->prepare("
    SELECT brand_id,brand_name,is_active
    FROM brand WHERE shop_id=? ORDER BY brand_name
");
$data->execute([$SHOP_ID]);
$rows=$data->fetchAll();
?>
<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>Brand Manage</title>
<meta name="viewport" content="width=device-width,initial-scale=1">
<link rel="stylesheet" href="assets/css/main.css">
</head>
<body class="font-md">

<div class="header"><h2>Brand Manage</h2></div>
<div class="container">

<div class="card">
<?php if($error): ?><div class="alert alert-danger"><?=h($error)?></div><?php endif;?>
<?php if($success): ?><div class="alert alert-success"><?=h($success)?></div><?php endif;?>
<form method="post">
<div class="form-group">
<label>Brand Name</label>
<input type="text" name="brand_name" required>
</div>
<button class="btn btn-primary">Add Brand</button>
</form>
</div>

<div class="card">
<h3>Brands</h3>
<?php foreach($rows as $b): ?>
<form method="post" class="mb-sm">
<input type="hidden" name="brand_id" value="<?=$b['brand_id']?>">
<input type="text" name="brand_name" value="<?=h($b['brand_name'])?>" class="mb-sm">
<button name="action" value="edit" class="btn btn-secondary">Save</button>
<button name="action" value="toggle" class="btn btn-danger">
<?=$b['is_active']?'Disable':'Enable'?>
</button>
</form>
<hr>
<?php endforeach;?>
</div>

</div>
</body>
</html>