每日博客5.28

<?php
session_start();
 if($_SESSION["username"]=="")
 {
   echo "<script>javascript:alert('对不起，请您先登陆！');location.href='index.php';</script>";
   exit;
 }
include_once 'conn.php';
$ndate =date("Y-m-d");
$addnew=$_POST["addnew"];
if ($addnew=="1" )
{
   $shangpinbianhao=$_POST["shangpinbianhao"];
    $shangpinmingcheng=$_POST["shangpinmingcheng"];
    $pinpai=$_POST["pinpai"];
    $jiage=$_POST["jiage"];
    $kucunshuliang=$_POST["kucunshuliang"];
    $goumaishuliang=$_POST["goumaishuliang"];
    $goumairen=$_POST["goumairen"];
    $jine=$_POST["jine"];
    
   //lixandonxgjixelxb
   $jinej=$kucunshuliang*$goumaishuliang;
   //ischongfu("select id from goumaiche where goumairen='".$goumairen."'");
   $sql="insert into goumaiche(shangpinbianhao,shangpinmingcheng,pinpai,jiage,kucunshuliang,goumaishuliang,goumairen,jine) values('$shangpinbianhao','$shangpinmingcheng','$pinpai','$jiage','$kucunshuliang','$goumaishuliang','$goumairen','$jinej') ";
   mysql_query($sql);
   $sql="update shangpinxinxi set kucunshuliang=kucunshuliang-'".$goumaishuliang."' where shangpinbianhao='".$shangpinbianhao."'";
   mysql_query($sql);

   //danjuzhixi;mysql_query($sql);
   echo "<script>javascript:alert('操作成功!');location.href='shangpinxinxilist.php';</script>";
}
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3c.org/TR/1999/REC-html401-19991224/loose.dtd">

<HTML xmlns="http://www.w3.org/1999/xhtml"><HEAD>

<TITLE>购买车</TITLE>
<META http-equiv=Content-Type content="text/html; charset=gb2312">
<LINK href="qtimages/style.css" type=text/css rel=stylesheet>
<META content="MSHTML 6.00.2900.6058" name=GENERATOR></HEAD>


<script type="text/javascript" src="js/My97DatePicker/WdatePicker.js" charset="gb2312"></script>
<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();
}
   function check()
{
   if(document.form1.shangpinbianhao.value==""){alert("请输入商品编号");document.form1.shangpinbianhao.focus();return false;}
    if(document.form1.shangpinmingcheng.value==""){alert("请输入商品名称");document.form1.shangpinmingcheng.focus();return false;}
    if((/^(+|-)?(0|[1-9]d*)(.d*[1-9])?$/.test(document.form1.goumaishuliang.value))){}else{alert("购买数量必需数字型");document.form1.goumaishuliang.focus();return false;}
    if(parseFloat(document.form1.kucunshuliang.value)<parseFloat(document.form1.goumaishuliang.value)){alert("对不起，库存数量必需大于购买数量");return false;}
   
}
   function gow()
   {
      location.href='goumaicheadd.php?jihuabifffanhao='+document.form1.jihuabifffanhao.value+"&id=<?php echo $_GET["id"]?>";
   }
</script>
<!--hxsglxiangdxongjxs-->
<BODY>
<?php include_once 'qttop.php';?>
<TABLE cellSpacing=0 cellPadding=0 width=1120 align=center bgColor=#ffffff 
border=0>
  <TBODY>
  <TR>
    <TD width=5>&nbsp;</TD>
    <TD vAlign=top width=230>
      <?php include_once 'qtleft.php';?>
      </TD>
    <TD vAlign=top width=10>&nbsp;</TD>
    <TD vAlign=top>
      <TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
        <TBODY>
        <TR>
          <TD vAlign=bottom height=40>
            <TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
              <TBODY>
              <TR>
                <TD width=44 height=40><IMG height=35 
                  src="qtimages/B0039.gif" 
                  width=30></TD>
                <TD width=11>&nbsp;</TD>
                <TD width=209><span class="red"><strong>购买车</strong></span></TD>
                <TD vAlign=bottom align=right width=50></TD>
                <TD vAlign=bottom align=right width=45>&nbsp;</TD>
                <TD align=left width=291>&nbsp;&nbsp;</TD>
              </TR></TBODY></TABLE></TD></TR>
        <TR>
          <TD bgColor=#dadada height=1></TD></TR>
        <TR>
          <TD bgColor=#f6f6f6 height=4></TD></TR>
        <TR>
          <TD bgColor=#ffffff height=6>
        
        
        
       <?php
 $sql="select * from shangpinxinxi where id=".$_GET["id"];
 $query=mysql_query($sql);
 $rowscount=mysql_num_rows($query);
 if($rowscount>0)
 {
   $shangpinbianhao=mysql_result($query,0,shangpinbianhao);
   $shangpinmingcheng=mysql_result($query,0,shangpinmingcheng);
   $pinpai=mysql_result($query,0,pinpai);
   $jiage=mysql_result($query,0,jiage);
   $kucunshuliang=mysql_result($query,0,kucunshuliang);
   
 }
?>
<form id="form1" name="form1" method="post" action="">
<table width="98%" border="0"  align="center" cellpadding="3" cellspacing="1" bordercolor="#00FFFF" style="border-collapse:collapse" class="newsline">    
   <tr><td>商品编号：</td><td><input name='shangpinbianhao' type='text' id='shangpinbianhao' value='' style='border:solid 1px #000000; color:#666666' />&nbsp;*</td></tr><script language="javascript">document.form1.shangpinbianhao.value='<?php echo $shangpinbianhao?>';</script>
    <tr><td>商品名称：</td><td><input name='shangpinmingcheng' type='text' id='shangpinmingcheng' value='' style='border:solid 1px #000000; color:#666666' />&nbsp;*</td></tr><script language="javascript">document.form1.shangpinmingcheng.value='<?php echo $shangpinmingcheng?>';</script>
    <tr><td>品牌：</td><td><input name='pinpai' type='text' id='pinpai' value='' style='border:solid 1px #000000; color:#666666' /></td></tr><script language="javascript">document.form1.pinpai.value='<?php echo $pinpai?>';</script>
    <tr><td>价格：</td><td><input name='jiage' type='text' id='jiage' value='' style='border:solid 1px #000000; color:#666666' /></td></tr><script language="javascript">document.form1.jiage.value='<?php echo $jiage?>';</script>
    <tr><td>库存数量：</td><td><input name='kucunshuliang' type='text' id='kucunshuliang' value='' style='border:solid 1px #000000; color:#666666' /></td></tr><script language="javascript">document.form1.kucunshuliang.value='<?php echo $kucunshuliang?>';</script>
    <tr><td>购买数量：</td><td><input name='goumaishuliang' type='text' id='goumaishuliang' value='' style='border:solid 1px #000000; color:#666666' />&nbsp;必需数字型</td></tr>
    <tr><td>购买人：</td><td><input name='goumairen' type='text' id='goumairen' value='<?php echo $_SESSION['username'];?>' style='border:solid 1px #000000; color:#666666' readonly='readonly' /></td></tr>
    <tr><td>金额：</td><td><input name='jine' type='text' id='jine' value='' style='border:solid 1px #000000; color:#666666; background-color:#CCCCCC' />&nbsp;此项不必填写，系统自动计算</td></tr>
    

    <tr>
      <td>&nbsp;</td>
      <td><input type="hidden" name="addnew" value="1" />
        <input type="submit" name="Submit" value="确定" onClick="return check();"  style='border:solid 1px #000000; color:#666666' />
      <input type="reset" name="Submit2" value="重置" style='border:solid 1px #000000; color:#666666' /></td>
    </tr>
  </table>
</form>
<p>&nbsp;</p>
<?php
   function ischongfu($sql)
   {
      $query=mysql_query($sql);
      $rowscount=mysql_num_rows($query);
      if($rowscount>0)
      {
         echo "<script>javascript:alert('对不起，该购买人已经存在，请换其他购买人!');history.back();</script>";
         exit;
      }
      
   }
?>
               
               
               
               
     </TD>
        </TR></TBODY></TABLE>
      </TD>
    <TD width=5>&nbsp;</TD></TR></TBODY></TABLE>
<?php include_once 'qtdown.php';?>
<!-- dfexnxxiaxng -->
</BODY></HTML>

【推广】 免费学中医，健康全家人
原文地址：https://www.cnblogs.com/wanghaoning/p/14914902.html