D7net
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
home
/
skyconb
/
adminyacine
/
Filename :
category-delete.php
back
Copy
<?php ob_start(); ?> <?php include_once('includes/header.php'); ?> <?php if (isset($_GET['id'])) { $ID = clean($_GET['id']); } else { $ID = clean(""); } $sql = "SELECT COUNT(*) as num FROM tbl_channel WHERE category_id = '$ID'"; $channels = $connect->query($sql); $channels = $channels->fetch_array(); $channels = $channels['num']; if ($channels > 0) { $_SESSION['msg'] = "Categories cannot be deleted because there are still active channels"; header( "Location:category.php"); exit; } else { // get image file from table $sql_image = "SELECT category_image FROM tbl_category WHERE cid = '$ID'"; $result = $connect->query($sql_image); $row = $result->fetch_assoc(); $category_image = $row['category_image']; // delete data from menu table $sql_delete = "DELETE FROM tbl_category WHERE cid = '$ID'"; $delete = $connect->query($sql_delete); // if delete data success if ($delete) { $delete_image = unlink('upload/category/'.$category_image); $_SESSION['msg'] = "Category deleted successfully..."; header( "Location: category.php"); exit; } } ?> <?php include_once('includes/footer.php'); ?>