PHP développe un système de gestion backend de livres simple, un nouveau code complet de stockage de livres

Introduisez ensuite le fichier de base de données config.php

et le fichier ly_check.php pour déterminer si l'administrateur est connecté

Appelez le style css.css dans la page HTML

Nouveau livre Le fichier de stockage s'appelle : fichier add.php

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


Formation continue
||
<?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>
soumettreRéinitialiser le code
  • Recommandations de cours
  • Téléchargement du didacticiel