[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      if($_POST["item_id"]==-1){
   7          saveInsert($_POST["item_nm"],$_POST["item_parent_id"],$_POST["item_desc"],0);
   8      }else{
   9          saveUpdate($_POST["item_id"],$_POST["item_nm"],$_POST["item_parent_id"],$_POST["item_desc"],0);
  10      }
  11      
  12      mysql_close($link);
  13      
  14      //insert item
  15  	function saveInsert($name,$parent_id,$desc,$order){
  16          $sql =     "Insert into tree(item_nm,item_parent_id,item_desc,item_order) ";
  17          $sql.=     "Values('".addslashes($name)."',$parent_id,'".addslashes($desc)."',$order)";
  18          print($sql);
  19          $res = mysql_query($sql);
  20          $newId = mysql_insert_id();
  21          print("<script>top.doUpdateItem('$newId','$name');</script>");
  22          
  23      }
  24      //insert item
  25  	function saveUpdate($id,$name,$parent_id,$desc,$order){
  26          $sql =     "Update tree set item_nm = '".addslashes($name)."',item_parent_id = $parent_id,item_desc = '".addslashes($desc)."',item_order = $order where item_id=$id";
  27          print($sql);
  28          $res = mysql_query($sql);
  29          print("<script>top.doUpdateItem('$id','".addslashes($name)."');</script>");
  30          
  31      }
  32  ?>