| Server IP : 66.29.137.217 / Your IP : 3.143.110.248 Web Server : LiteSpeed System : Linux premium294.web-hosting.com 4.18.0-513.11.1.lve.el8.x86_64 #1 SMP Thu Jan 18 16:21:02 UTC 2024 x86_64 User : gltevjme ( 1095) PHP Version : 7.0.33 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /home/gltevjme/public_html/ad4Lg8Q4min/ |
Upload File : |
<?php require_once('header.php'); ?>
<?php
// Preventing the direct access of this page.
if(!isset($_REQUEST['id'])) {
header('location: logout.php');
exit;
} else {
// Check the id is valid or not
$statement = $pdo->prepare("SELECT * FROM tbl_category WHERE category_id=?");
$statement->execute(array($_REQUEST['id']));
$total = $statement->rowCount();
if( $total == 0 ) {
header('location: logout.php');
exit;
}
}
?>
<?php
// Getting photo ID to unlink from folder
$statement = $pdo->prepare("SELECT * FROM tbl_news WHERE category_id=?");
$statement->execute(array($_REQUEST['id']));
$result = $statement->fetchAll(PDO::FETCH_ASSOC);
foreach ($result as $row) {
unlink('../assets/uploads/'.$row['photo']);
}
// Delete from tbl_news
$statement = $pdo->prepare("DELETE FROM tbl_news WHERE category_id=?");
$statement->execute(array($_REQUEST['id']));
// Delete from tbl_category
$statement = $pdo->prepare("DELETE FROM tbl_category WHERE category_id=?");
$statement->execute(array($_REQUEST['id']));
header('location: category.php');
?>