xiaoshoujilu_updt.php

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

<?php 
$id=$_GET["id"];
include_once 'conn.php';
$ndate =date("Y-m-d");
$addnew=$_POST["addnew"];
if ($addnew=="1" )
{

	$bianhao=$_POST["bianhao"];$leibie=$_POST["leibie"];$yanse=$_POST["yanse"];$chexing=$_POST["chexing"];$huandangfangshi=$_POST["huandangfangshi"];$kucun=$_POST["kucun"];$jiage=$_POST["jiage"];$xiaoshoushuliang=$_POST["xiaoshoushuliang"];$shenfenzheng=$_POST["shenfenzheng"];$xingming=$_POST["xingming"];$dianhua=$_POST["dianhua"];$beizhu=$_POST["beizhu"];
	$sql="update xiaoshoujilu set bianhao='$bianhao',leibie='$leibie',yanse='$yanse',chexing='$chexing',huandangfangshi='$huandangfangshi',kucun='$kucun',jiage='$jiage',xiaoshoushuliang='$xiaoshoushuliang',shenfenzheng='$shenfenzheng',xingming='$xingming',dianhua='$dianhua',beizhu='$beizhu' where id= ".$id;
	mysql_query($sql);
	echo "<script>javascript:alert('修改成功!');location.href='xiaoshoujilu_list.php';</script>";
}
?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>修改销售记录</title><link rel="stylesheet" href="css.css" type="text/css"><script language="javascript" src="js/Calendar.js"></script>
</head>
<script language="javascript">
	
	
	function OpenScript(url,width,height)
{
  var win = window.open(url,"SelectToSort",'width=' + width + ',height=' + height + ',resizable=1,scrollbars=yes,menubar=no,status=yes' );
}
	function OpenDialog(sURL, iWidth, iHeight)
{
   var oDialog = window.open(sURL, "_EditorDialog", "width=" + iWidth.toString() + ",height=" + iHeight.toString() + ",resizable=no,left=0,top=0,scrollbars=no,status=no,titlebar=no,toolbar=no,menubar=no,location=no");
   oDialog.focus();
}
</script>
<body>
<p>修改销售记录： 当前日期： <?php echo $ndate; ?></p>
<?php
$sql="select * from xiaoshoujilu where id=".$id;
$query=mysql_query($sql);
$rowscount=mysql_num_rows($query);
if($rowscount>0)
{
?>
<form id="form1" name="form1" method="post" action="">
<table width="100%" border="1" align="center" cellpadding="3" cellspacing="1" bordercolor="#00FFFF" style="border-collapse:collapse"> 

      <tr><td>编号：</td><td><input name='bianhao' type='text' id='bianhao' value='<?php echo mysql_result($query,$i,bianhao);?>' /></td></tr><tr><td>类别：</td><td><input name='leibie' type='text' id='leibie' value='<?php echo mysql_result($query,$i,leibie);?>' /></td></tr><tr><td>颜色：</td><td><input name='yanse' type='text' id='yanse' value='<?php echo mysql_result($query,$i,yanse);?>' /></td></tr><tr><td>车型：</td><td><input name='chexing' type='text' id='chexing' value='<?php echo mysql_result($query,$i,chexing);?>' /></td></tr><tr><td>换档方式：</td><td><input name='huandangfangshi' type='text' id='huandangfangshi' value='<?php echo mysql_result($query,$i,huandangfangshi);?>' /></td></tr><tr><td>库存：</td><td><input name='kucun' type='text' id='kucun' value='<?php echo mysql_result($query,$i,kucun);?>' /></td></tr><tr><td>价格：</td><td><input name='jiage' type='text' id='jiage' value='<?php echo mysql_result($query,$i,jiage);?>' /></td></tr><tr><td>销售数量：</td><td><input name='xiaoshoushuliang' type='text' id='xiaoshoushuliang' value='<?php echo mysql_result($query,$i,xiaoshoushuliang);?>' /></td></tr><tr><td>身份证：</td><td><input name='shenfenzheng' type='text' id='shenfenzheng' value='<?php echo mysql_result($query,$i,shenfenzheng);?>' /></td></tr><tr><td>姓名：</td><td><input name='xingming' type='text' id='xingming' value='<?php echo mysql_result($query,$i,xingming);?>' /></td></tr><tr><td>电话：</td><td><input name='dianhua' type='text' id='dianhua' value='<?php echo mysql_result($query,$i,dianhua);?>' /></td></tr><tr><td>备注：</td><td><input name='beizhu' type='text' id='beizhu' value='<?php echo mysql_result($query,$i,beizhu);?>' /></td></tr>
   
   
    <tr>
      <td>&nbsp;</td>
      <td><input name="addnew" type="hidden" id="addnew" value="1" />
      <input type="submit" name="Submit" value="修改" style='border:solid 1px #000000; color:#666666' />
      <input type="reset" name="Submit2" value="重置" style='border:solid 1px #000000; color:#666666' /></td>
    </tr>
  </table>
</form>
<?php
	}
?>