📂 LapTH — File Browser

← Quay lại | ⬇️ Download | ▶️ Chạy file này (Tab mới)

Nội dung code:

<?php

// Use central project DB config if available
$projCfg = __DIR__ . '/../../config/config.php';
if (file_exists($projCfg)) {
	require_once $projCfg;
}
try{
	$dsn = 'mysql:host=' . (defined('DB_HOST') ? DB_HOST : 'localhost') . ';dbname=' . (defined('DB_NAME') ? DB_NAME : 'bookstore') . ';charset=utf8mb4';
	$pdh = new PDO($dsn, defined('DB_USER') ? DB_USER : 'root', defined('DB_PASS') ? DB_PASS : '');
	$pdh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
	$pdh->exec("set names 'utf8'");
}
catch(Exception $e){
		echo $e->getMessage(); exit;
}

$cat_id = isset($_GET["cat_id"])?$_GET["cat_id"]:"";
$sql ="delete from category where cat_id = :cat_id ";
$arr = array(":cat_id"=>$cat_id);

$stm = $pdh->prepare($sql);
$stm->execute($arr);
$n = $stm->rowCount();
if ($n>0) $thongbao="Da xoa $n loai sach! ";
else $thongbao="Loi xoa!";
?>
<script language="javascript">
alert("<?php echo $thongbao;?>");
window.location = "lab8_3.php";
</script>