3.通过html向数据库添加数据

html端的代码:

<!DOCTYPE html>
<html>
<head>
    <meta charset="UTF-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <link rel="stylesheet" href="../assets/css/layui.css">
    <link rel="stylesheet" href="../assets/css/view.css"/>
    <title></title>
</head>
<body class="layui-view-body">
    <div class="layui-content">
        <div class="layui-row">
            <div class="layui-card">
                <div class="layui-card-header">入库操作</div>
				 <div class="layui-form layui-card-body">
				 
                  <div class="layui-form-item layui-form-text">
                    <label class="layui-form-label">商品分类</label>
                    <div class="layui-input-block">
                      <input id="gtype" placeholder="请输入内容" class="layui-input"/>
                    </div>
                  </div>
				 
				   <div class="layui-form-item layui-form-text">
                    <label class="layui-form-label">商品名称</label>
                    <div class="layui-input-block">
                      <input id="gname" placeholder="请输入内容" class="layui-input"/>
                    </div>
                  </div>
				  
				  
				   <div class="layui-form-item layui-form-text">
                    <label class="layui-form-label">商品描述</label>
                    <div class="layui-input-block">
                      <input id="gdesc" placeholder="请输入内容" class="layui-input"/>
                    </div>
                  </div>
				  
				   <div class="layui-form-item layui-form-text">
                    <label class="layui-form-label">数量单位</label>
                    <div class="layui-input-block">
                      <input id="gunit" placeholder="请输入内容" class="layui-input"/>
                    </div>
                  </div>
				  
				   <div class="layui-form-item layui-form-text">
                    <label class="layui-form-label">建议价格</label>
                    <div class="layui-input-block">
                      <input id="gprice" placeholder="请输入内容" class="layui-input"/>
                    </div>
                  </div>
				  
				   <div class="layui-form-item layui-form-text">
                    <label class="layui-form-label">商品成本</label>
                    <div class="layui-input-block">
                      <input id="gcost" placeholder="请输入内容" class="layui-input"/>
                    </div>
                  </div>
				  
				   <div class="layui-form-item layui-form-text">
                    <label class="layui-form-label">商品库存</label>
                    <div class="layui-input-block">
                      <input id="gstock" placeholder="请输入内容" class="layui-input"/>
                    </div>
                  </div>
				  
                  <div class="layui-form-item">
                    <div class="layui-input-block">
                      <a href="javascript:add();" class="layui-btn layui-btn-blue" >立即提交</a>
                
                    </div>
                  </div>
				</div>  
            </div>
        </div>
    </div>
    <script src="../assets/layui.all.js"></script>
   <script>
  function add(){
  var gtype = document.getElementById("gtype").value;
  var gname = document.getElementById("gname").value;
  var gdesc = document.getElementById("gdesc").value;
  var gunit = document.getElementById("gunit").value;
  var gcost = document.getElementById("gcost").value;
  var gprice = document.getElementById("gprice").value;
  var gstock = document.getElementById("gstock").value;
  window.location.href="add.php?gtype="+gtype+"&gname="+gname+"&gdesc="+gdesc+"&gunit="+gunit+"&gcost="+gcost+"&gstock="+gstock+"&gprice="+gprice;
 // alert('123');
  }
    </script>
</body>
</html>

php端代码:

<?php
header("Content-type: text/html; charset=utf-8");
$gtype= $_GET['gtype'];
$gname=$_GET['gname'];
$gdesc=$_GET['gdesc'];
$gunit=$_GET['gunit'];
$gprice=$_GET['gprice'];
$gcost=$_GET['gcost'];
$gstock=$_GET['gstock']; 
 
date_default_timezone_set('PRC');
$showtime=date("Y-m-d H:i:s");
$con = mysqli_connect('IP名', '数据库名', '数据库密码'); //连接数据库
mysqli_set_charset($con,"utf8"); 
mysqli_select_db($con, '2020_wlsh');
$sql = "insert into goods values  (NULL,'$gtype','$gname','$gdesc','$gunit','$gprice','$gcost','$gstock')";
mysqli_query($con, $sql);

$sql = "insert into update_add values  (NULL,'$gtype','$gname','$gdesc','$gunit','$gprice','$gcost','$gstock','$showtime','$gstock')";
mysqli_query($con, $sql);

echo "<h1>添加成功!<h1>";
echo "<script>self.location='add.html';</script>";
?>

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

豆豆豆豆芽

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付:¥1
获取中
扫码支付

您的余额不足,请更换扫码支付或充值

打赏作者

实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值