1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38

<?php

import_request_variables('pG', 'p_');
if($p_id_product!="")                        {         $id_product=trim($p_id_product);                }
if($p_id_pic!="")                    {         $id_pic=trim($p_id_pic);            }

bar_header("ลบข้อมูล"); // Bar_Header

$data_link = select_query_object("*","cms_product","id_product",$id_product);
if(file_exists($_SESSION[web_name]."/module_product/picture/".$data_link->picture))
{
    @unlink($_SESSION[web_name]."/module_product/picture/".$data_link->picture);
}
if(file_exists($_SESSION[web_name]."/module_product/attach/".$data_link->attach_file))
{
    @unlink($_SESSION[web_name]."/module_product/attach/".$data_link->attach_file);
}
// get product parent for update later
$id_parent = select_query_data("id_parent" , "cms_product" , "id_product" , "$id_product" );

$sql_del = "DELETE FROM cms_product WHERE id_product=$id_product and is_static!=1";
mysql_query ($sql_del) or die (mysql_error());

// check if parent has no child any more

$num_child = select_count ("*" ,"cms_product" , "id_parent = $id_parent");

if ($num_child == 0)
{
     $sql_update = "UPDATE cms_product SET has_child = 0 WHERE id_product = $id_parent";
    mysql_query ($sql_update) or die (mysql_error());
}
else


    echo "<center><br><br>ข้อมูลได้ถูกลบแล้ว<br><br></center>"; 
        echo "<meta http-equiv='refresh' content='2; url=index.php?mod=product_firstpage&path=product'>" ;
?>