[Sommaire] [Imprimer]

   1  <?php 
   2      require_once ('config.php'); 
   3  
   4      $link = mysql_pconnect($mysql_host, $mysql_user, $mysql_pasw);
   5      mysql_select_db ($mysql_db);
   6      deleteNode($_POST["item_id"]);
   7      mysql_close($link);
   8      
   9      //insert item
  10  	function deleteNode($id){
  11          deleteBranch($id);
  12          deleteSingleNode($id);
  13          print("<script>top.doDeleteTreeItem('$id');</script>");
  14      }
  15  	function deleteSingleNode($id){
  16          $d_sql = "Delete from tree where item_id=".$id;
  17          $resDel = mysql_query($d_sql);
  18      }
  19  	function deleteBranch($pid){
  20          $s_sql = "Select item_id from tree where item_parent_id=$pid";
  21          $res = mysql_query($s_sql);
  22          if($res){
  23              while($row=mysql_fetch_array($res)){
  24                  deleteBranch($row['item_id']);
  25                  deleteSingleNode($row['item_id']);
  26              }
  27              
  28          }
  29      }
  30  ?>