savenode.php

来自「用js做的树 用js做的树 用js做的树」· PHP 代码 · 共 35 行

<?php
	require_once('config.php'); 

	$link = mysql_pconnect($mysql_host, $mysql_user, $mysql_pasw);
	mysql_select_db ($mysql_db);
	if($_POST["item_id"]==-1){
		saveInsert($_POST["item_nm"],$_POST["item_parent_id"],$_POST["item_desc"],$_POST["item_order"]);
	}else{
		saveUpdate($_POST["item_id"],$_POST["item_nm"],$_POST["item_parent_id"],$_POST["item_desc"],$_POST["item_order"]);
	}
	
	mysql_close($link);
	
	//insert item
	function saveInsert($name,$parent_id,$desc,$order){
		$u_sql = "UPDATE tree SET item_order=item_order+1 WHERE item_parent_id=".$parent_id." AND item_order>".($order-1);
		$res = mysql_query($u_sql);        
		$sql = 	"Insert into tree(item_nm,item_parent_id,item_desc,item_order) ";
		$sql.= 	"Values('".addslashes($name)."',$parent_id,'".addslashes($desc)."',$order)";
		print($sql);
		$res = mysql_query($sql);
		$newId = mysql_insert_id();
		print("<script>top.doUpdateItem('$newId','$name');</script>");
		
	}
	//insert item
	function saveUpdate($id,$name,$parent_id,$desc,$order){
		$sql = 	"Update tree set item_nm = '".addslashes($name)."',item_parent_id = $parent_id,item_desc = '".addslashes($desc)."',item_order = $order where item_id=$id";
		print($sql);
		$res = mysql_query($sql);
		print("<script>top.doUpdateItem('$id','".addslashes($name)."');</script>");
		
	}
?>