fupaysave.php

来自「开源的 库存管理系统 www.minierp.cn php+ mysql」· PHP 代码 · 共 42 行

<?php

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

$t_FUP01 =$_GET[x_FUP01];	 	//编号
$t_FUP02 =$_GET[x_FUP02]; 		//名称



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



$m_tablename="fupay";

	$FIELDSTR  =" FUP01  ='$t_FUP01',";
	$FIELDSTR .=" FUP02  ='$t_FUP02',";
	$FIELDSTR .=" DT999  = now()  ";

 	$conn = phpmkr_db_connect(HOST, USER, PASS, DB, PORT);
//***************************送货单主表更新***************************
	$sSql = "select * from $m_tablename 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 $m_tablename set ";
	$uSql .=$FIELDSTR;
	$uSql .=" where autoid =$t_AUTOID";
}
else
{
	$uSql  = "INSERT INTO $m_tablename set  ";
	$uSql .=$FIELDSTR;

 }

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