function del_child($parent = null) { if (!empty($parent)) { for ($x = 0; $x < count($_SESSION['modelmenu']); $x++) { $elmenu = $_SESSION['modelmenu'][$x]; if ($elmenu[0] == $parent) { unset($_SESSION['modelmenu'][$x]); } if ($elmenu[3] == $parent) { unset($_SESSION['modelmenu'][$x]); del_child($elmenu[0]); } } } }
function del_child($id) { global $pro_class_table; global $product_table; global $pic_no_pic; global $pro_pic_table; global $pro_size_table; global $pro_color_table; global $pro_stock_table; global $pro_size_relate_table; global $pro_color_relate_table; global $pro_download_table; $unit2 = new product(); $unit2->table = $product_table; $sql = "select id,pic,pic2 from `{$pro_class_table}` where upid='{$id}'"; $res = mysql_query($sql); if (mysql_num_rows($res) > 0) { while ($row = mysql_fetch_array($res)) { if ($row['pic'] != $pic_no_pic) { @unlink($row['pic']); } //移除圖片 if ($row['pic2'] != $pic_no_pic) { @unlink($row['pic2']); } //移除圖片 del_child($row['id']); } } $sql = "DELETE from `{$pro_class_table}` where id='{$id}'"; mysql_query($sql); $sql = "select id from `{$product_table}` where upid='{$id}'"; $res = mysql_query($sql); while ($row = mysql_fetch_array($res)) { $unit2->id = $row['id']; $unit2->get_db_var(); $unit2->del(); //刪除產品 remove_home_num($unit2->id); //維持首頁勾選數量 if ($unit2->pic != $pic_no_pic) { @unlink($unit2->pic); } //移除圖片 //CLEAN RELATED DATA UP BEGIN----------------------------------------------------------------------- //刪除其它圖片資料 $sql2 = "select * from `{$pro_pic_table}` where `upid`='" . $unit2->id . "'"; $res2 = mysql_query($sql2); while ($row2 = mysql_fetch_array($res2)) { @unlink($row2['pic']); @unlink($row2['s_pic']); } $sql = "DELETE from `{$pro_pic_table}` where `upid`='" . $unit2->id . "'"; mysql_query($sql); //刪除檔案資料 $sql2 = "select * from `{$pro_download_table}` where `upid`='" . $unit2->id . "'"; $res2 = mysql_query($sql2); while ($row2 = mysql_fetch_array($res2)) { @unlink($row2['file']); } $sql = "DELETE from `{$pro_download_table}` where `upid`='" . $unit2->id . "'"; mysql_query($sql); //刪除庫存資料 $sql2 = "SELECT id from `{$pro_color_relate_table}` where `upid`='" . $unit2->id . "'"; $res2 = mysql_query($sql2); while ($row2 = mysql_fetch_array($res2)) { $sql2 = "DELETE from `{$pro_stock_table}` where `upid`='" . $row2['id'] . "'"; mysql_query($sql2); } //刪除顏色資料 $sql = "DELETE from `{$pro_color_relate_table}` where `upid`='" . $unit2->id . "'"; mysql_query($sql); //刪除大小資料 $sql = "DELETE from `{$pro_size_relate_table}` where `upid`='" . $unit2->id . "'"; mysql_query($sql); //END --------------------------------------------------------------------------------------- } }
<?php error_reporting(E_ERROR | E_PARSE); include '../../helper/db_connect.php'; connect_database(); $id = $_GET['id']; $parent_id = $_GET['p_id']; $childs = get_person_detial($parent_id); $child = mysql_fetch_assoc($childs); print_r($child); if ($child['MOTHER_ID'] == $id) { $type = "MOTHER_ID"; } else { if ($child['PARENT_ID'] == $id) { $type = "PARENT_ID"; } } del_child($parent_id, $type); echo "<script type='text/javascript'>"; echo "window.history.back();"; echo "</script>";
$img->set_width($pic_width); //決定縮圖大小,大圖大小 $img->set_savepath("../images/" . date("Y-m-d")); //設定儲存路徑 $pic2 = $img->save(); } else { $pic2 = $_POST['pic2']; } if ($check == 'upd') { $unit->table = $pro_class_table; $unit->get_vars(); $unit->pic = $pic; $unit->pic2 = $pic2; $buff = array(); $unit->get_history($unit->upid, $buff); $unit->upd(); $tool->show(get_msg("upd_success"), $_SERVER['HTTP_REFERER']); exit; } if (isset($_POST['del'])) { $id = $_POST['id']; for ($i = 0; $i < count($id); $i++) { del_child($id[$i]); } if (count($id) > 0) { $tool->show(get_msg("del_success"), $_SERVER['HTTP_REFERER']); } else { $tool->error(get_msg("del_fail")); } exit; }