PHP develops simple book background management system complete code for new book storage
Then introduce the database file config.php file
and the ly_check.php file to determine whether the administrator is logged in
Call the css.css style in the HTML page
New book The database file is named: add.php file
<?php
include("config.php");
require_once('ly_check.php');
?>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>新书入库</title>
<link rel="stylesheet" href="css.css" type="text/css">
<script type="text/javascript">
<!--
function myform_Validator(theForm)
{
if (theForm.name.value == "")
{
alert("请输入书名。");
theForm.name.focus();
return (false);
}
if (theForm.price.value == "")
{
alert("请输入书名价格。");
theForm.price.focus();
return (false);
}
if (theForm.type.value == "")
{
alert("请输入书名所属类别。");
theForm.type.focus();
return (false);
}
return (true);
}
//--></script>
</head>
<?php
if($_POST['action']=="insert"){
$SQL = "INSERT INTO yx_books (name,price,uploadtime,type,total,leave_number)
values('".$_POST['name']."','".$_POST['price']."','".$_POST['uptime']."','".$_POST['type']."','".$_POST['total']."','".$_POST['total']."')";
$arr=mysqli_query($link,$sql);
if ($arr){
echo "<script language=javascript>alert('添加成功！');window.location='add.php'</script>";
}
else{
echo "<script>alert('添加失败');history.go(-1);</script>";
}
}
?>
<body>
<form id="myform" name="myform" method="post" action="" onsubmit="return myform_Validator(this)">
<table width="100%" height="173" border="0" align="center" cellpadding="2" cellspacing="1" class="table">
<tr>
<td colspan="2" align="left" class="bg_tr"> 后台管理 >> 新书入库</td>
</tr>
<tr>
<td width="31%" align="right" class="td_bg">书名：</td>
<td width="69%" class="td_bg">
<input name="name" type="text" id="name" size="15" maxlength="30" />
</td>
</tr>
<tr>
<td align="right" class="td_bg">价格：</td>
<td class="td_bg">
<input name="price" type="text" id="price" size="5" maxlength="15" />
</td>
</tr>
<tr>
<td align="right" class="td_bg">日期：</td>
<td class="td_bg">
<input name="uptime" type="text" id="uptime" value="<?php echo date("Y-m-d h:i:s"); ?>" />
</td>
</tr>
<tr>
<td align="right" class="td_bg">所属类别：</td>
<td class="td_bg">
<input name="type" type="text" id="type" size="6" maxlength="19" />
</td>
</tr>
<tr>
<td align="right" class="td_bg">入库总量：</td>
<td class="td_bg"><input name="total" type="text" id="total" size="5" maxlength="15" />
本</td>
</tr>
<tr>
<td align="right" class="td_bg">
<input type="hidden" name="action" value="insert">
<input type="submit" name="button" id="button" value="提交" />
</td>
<td class="td_bg">
<input type="reset" name="button2" id="button2" value="重置" />
</td>
</tr>
</table>
</form>
</body>
</html>
new file
<?php
include("config.php");
require_once('ly_check.php');
?>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>新书入库</title>
<link rel="stylesheet" href="css.css" type="text/css">
<script type="text/javascript">
<!--
function myform_Validator(theForm)
{
if (theForm.name.value == "")
{
alert("请输入书名。");
theForm.name.focus();
return (false);
}
if (theForm.price.value == "")
{
alert("请输入书名价格。");
theForm.price.focus();
return (false);
}
if (theForm.type.value == "")
{
alert("请输入书名所属类别。");
theForm.type.focus();
return (false);
}
return (true);
}
//--></script>
</head>
<?php
if($_POST['action']=="insert"){
$SQL = "INSERT INTO yx_books (name,price,uploadtime,type,total,leave_number)
values('".$_POST['name']."','".$_POST['price']."','".$_POST['uptime']."','".$_POST['type']."','".$_POST['total']."','".$_POST['total']."')";
$arr=mysqli_query($link,$sql);
if ($arr){
echo "<script language=javascript>alert('添加成功！');window.location='add.php'</script>";
}
else{
echo "<script>alert('添加失败');history.go(-1);</script>";
}
}
?>
<body>
<form id="myform" name="myform" method="post" action="" onsubmit="return myform_Validator(this)">
<table width="100%" height="173" border="0" align="center" cellpadding="2" cellspacing="1" class="table">
<tr>
<td colspan="2" align="left" class="bg_tr"> 后台管理 >> 新书入库</td>
</tr>
<tr>
<td width="31%" align="right" class="td_bg">书名：</td>
<td width="69%" class="td_bg">
<input name="name" type="text" id="name" size="15" maxlength="30" />
</td>
</tr>
<tr>
<td align="right" class="td_bg">价格：</td>
<td class="td_bg">
<input name="price" type="text" id="price" size="5" maxlength="15" />
</td>
</tr>
<tr>
<td align="right" class="td_bg">日期：</td>
<td class="td_bg">
<input name="uptime" type="text" id="uptime" value="<?php echo date("Y-m-d h:i:s"); ?>" />
</td>
</tr>
<tr>
<td align="right" class="td_bg">所属类别：</td>
<td class="td_bg">
<input name="type" type="text" id="type" size="6" maxlength="19" />
</td>
</tr>
<tr>
<td align="right" class="td_bg">入库总量：</td>
<td class="td_bg"><input name="total" type="text" id="total" size="5" maxlength="15" />
本</td>
</tr>
<tr>
<td align="right" class="td_bg">
<input type="hidden" name="action" value="insert">
<input type="submit" name="button" id="button" value="提交" />
</td>
<td class="td_bg">
<input type="reset" name="button2" id="button2" value="重置" />
</td>
</tr>
</table>
</form>
</body>
</html>
Preview
Clear
- Course Recommendations
- Courseware download
The courseware is not available for download at the moment. The staff is currently organizing it. Please pay more attention to this course in the future~
Students who have watched this course are also learning
Let's briefly talk about starting a business in PHP
Quick introduction to web front-end development
Large-scale practical Tianlongbabu development of Mini version MVC framework imitating the encyclopedia website of embarrassing things
Getting Started with PHP Practical Development: PHP Quick Creation [Small Business Forum]
Login verification and classic message board
Computer network knowledge collection
Quick Start Node.JS Full Version
The front-end course that understands you best: HTML5/CSS3/ES6/NPM/Vue/...[Original]
Write your own PHP MVC framework (40 chapters in depth/big details/must read for newbies to advance)