save.php

开源的 库存管理系统 www.minierp.cn php+ mysql

<?php

$t_AUTOID=$_GET[x_AUTOID];
if (empty($t_AUTOID)){$t_AUTOID=0;};

$t_ID    =$_GET[x_ID]; 		//联系人编号
$t_CON01 =$_GET[x_CON01];		//联系姓名
$t_ACCID =$_GET[x_ACCID];		//客户编号
$t_CON02 =$_GET[x_CON02];		//办公室电话
$t_CON03 =$_GET[x_CON03];		//手机
$t_CON04 =$_GET[x_CON04];		//传真
$t_CON05 =$_GET[x_CON05];		//职位
$t_CON06 =$_GET[x_CON06];		//部门
$t_CON07 =$_GET[x_CON07];		//生日
$t_CON08 =$_GET[x_CON08];		//家庭电话
$t_CON09 =$_GET[x_CON09];		//QQ
$t_CON10 =$_GET[x_CON10];		//MSN
$t_CON11 =$_GET[x_CON11];		//IM
$t_CON12 =$_GET[x_CON12];		//邮箱
$t_CON13 =$_GET[x_CON13];		//住址
//$t_AUTOID=$_GET[x_DT999]		//建档日期
/*
    [x_ID] 		//联系人编号
    [x_AUTOID] 		//自动编号
    [x_ACCID]		//客户编号
	[x_CON01]		//联系姓名
    [x_CON02]		//办公室电话
    [x_CON03]		//手机
    [x_CON04]		//传真
    [x_CON05]		//职位
    [x_CON06]		//部门
    [x_CON07]		//生日
    [x_CON08]		//家庭电话
    [x_CON09]		//QQ
    [x_CON10]		//MSN
    [x_CON11]		//IM
    [x_CON12]		//邮箱
    [x_CON13]		//住址
    [x_DT999]		//建档日期
*/

 include ("../inc/db.php");
 include ("../inc/phpmkrfn.php");

 	$conn = phpmkr_db_connect(HOST, USER, PASS, DB, PORT);
	$sSql = "select * from accdelt where autoid =$t_AUTOID";
	
	$rs   = phpmkr_query($sSql,$conn) or die("Failed to execute query: " . phpmkr_error() . '<br>SQL: ' . $sSql);

if (phpmkr_num_rows($rs) > 0){
	$uSql = "update accdelt set ";
	$uSql .="  id   ='$t_ID',";
	$uSql .=" accid ='$t_ACCID',";
	$uSql .=" con01 ='$t_CON01',";
	$uSql .=" con02 ='$t_CON02',";
	$uSql .=" con03 ='$t_CON03',";
	$uSql .=" con04 ='$t_CON04',";
	$uSql .=" con05 ='$t_CON05',";
	$uSql .=" con06 ='$t_CON06',";
	$uSql .=" con07 ='$t_CON07',";
	$uSql .=" con08 ='$t_CON08',";
	$uSql .=" con09 ='$t_CON09',";
	$uSql .=" con10 ='$t_CON10',";
	$uSql .=" con11 ='$t_CON11',";
	$uSql .=" con12 ='$t_CON12',";	
	$uSql .=" con13 ='$t_CON13',";	
	$uSql .=" dt999 = now()  ";
	$uSql .=" where autoid =$t_AUTOID";

	$rs   = phpmkr_query($uSql,$conn) or die("Failed to execute query: " . phpmkr_error() . '<br>SQL: ' . $uSql);
}
else
{
	$uSql = "INSERT INTO accdelt set ";
	$uSql .="  id   ='$t_ID',";
	$uSql .=" accid ='$t_ACCID',";
	$uSql .=" con01 ='$t_CON01',";
	$uSql .=" con02 ='$t_CON02',";
	$uSql .=" con03 ='$t_CON03',";
	$uSql .=" con04 ='$t_CON04',";
	$uSql .=" con05 ='$t_CON05',";
	$uSql .=" con06 ='$t_CON06',";
	$uSql .=" con07 ='$t_CON07',";
	$uSql .=" con08 ='$t_CON08',";
	$uSql .=" con09 ='$t_CON09',";
	$uSql .=" con10 ='$t_CON10',";
	$uSql .=" con11 ='$t_CON11',";
	$uSql .=" con12 ='$t_CON12',";	
	$uSql .=" con13 ='$t_CON13',";	
	$uSql .=" dt999 = now()  ";
	//$uSql .=" where autoid =$t_AUTOID";

	$rs   = phpmkr_query($uSql,$conn) or die("Failed to execute query: " . phpmkr_error() . '<br>SQL: ' . $uSql);
}
header("location:index.php");
?>