Community Learn Tools Library Leisure
search
English

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">&nbsp;后台管理&nbsp;>>&nbsp;新书入库</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>


Continuing Learning
||
<?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>
submitReset Code
Previous section Next Section
Tutorial List
get help
  • 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

The latest ThinkPHP 5.1 world premiere video tutorial (60 days to become a PHP expert online training course)  492410 plays