Exemplo n.º 1
0
function delete_category($category_id)
{
    $conn = connDB();
    $total_product = get_total_product($category_id);
    if ($total_product != 0) {
        /*
        mysql_query("UPDATE tbl_category SET category_active_status='inactive', category_visibility_status='0' WHERE category_id='$category_id'", $conn);
        
        $sql            = "SELECT * from tbl_category AS cat LEFT JOIN tbl_category_relation AS rel ON cat.category_id = rel.category_parent WHERE category_id='$category_id'";
        $query          = mysql_query($sql, $conn);
        $category_child = array();
        
        while($result = mysql_fetch_array($query)){
           array_push($category_child, $result['category_child']);
        }
        
        foreach($category_child AS $category_child_){
           mysql_query("UPDATE tbl_category SET category_active_status='inactive', category_visibility_status='0' WHERE category_id='$category_child_'", $conn);
        }
        */
        $_SESSION["alert"] = 'error';
        $_SESSION["msg"] = "Can't delete item(s) because it contains one or more item under it.";
    } else {
        $get_order = mysql_query("SELECT * from tbl_tag WHERE category_id = '{$category_id}'", $conn);
        if (mysql_num_rows($get_order) != null) {
            $get_order_array = mysql_fetch_array($get_order);
            $category_order = $get_order_array["category_order"];
        }
        unlink('../' . $get_order_array['image']);
        mysql_query("UPDATE tbl_tag SET category_order = category_order-1 WHERE category_order > '{$category_order}'", $conn);
        //$category_parent_redirect = $_GET["parent_category"];
        mysql_query("DELETE FROM tbl_tag WHERE category_id = '{$category_id}'", $conn);
        $category_relation = mysql_query("SELECT * from tbl_tag_relation WHERE category_parent = '{$category_id}'", $conn);
        if (mysql_num_rows($category_relation) != null) {
            for ($counter = 1; $counter <= mysql_num_rows($category_relation); $counter++) {
                $category_relation_array = mysql_fetch_array($category_relation);
                $category_child = $category_relation_array["category_child"];
                mysql_query("DELETE FROM tbl_tag_relation WHERE category_parent = '{$category_child}' OR category_child = '{$category_child}'", $conn);
                mysql_query("DELETE FROM tbl_tag WHERE category_id = '{$category_child}'", $conn);
            }
        }
        mysql_query("DELETE FROM tbl_tag_relation WHERE category_child = '{$category_id}' OR category_parent = '{$category_id}'", $conn);
        $_SESSION["alert"] = 'success';
        $_SESSION["msg"] = 'You successfully delete';
    }
}
Exemplo n.º 2
0
                   </thead>
                   
                   <tbody>
                   
				   <?php 
if ($total_query < 1) {
    ?>
<tr><td class="no-record" colspan="8">No records found.</td></tr><?php 
}
?>
                   <?php 
// Loop 1
$row = 0;
foreach ($listing_order as $all_category) {
    $row++;
    $getTotal = get_total_product($all_category['category_id']);
    ?>
                      <tr id="<?php 
    echo "row_" . $row;
    ?>
" onclick="selectRow('<?php 
    echo $row;
    ?>
')">
                        <td>
                          <input type="checkbox" name="category_id[]" value="<?php 
    echo $all_category['category_id'];
    ?>
" id="<?php 
    echo "check_" . $row;
    ?>