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>";
?>