PHP develops simple book borrowing system and complete book borrowing function implementation code

Introduce the database file config.php

<?php include("config.php");?>

Create a complete book borrowing code file jieshu.php.

<?php include("config.php");?>
<html>
<head>
  <meta charset="UTF-8">
  <title>借书功能页</title>
</head>
<body>
<?php
// 如果图书编号没填写，提示用户
$book_id = $_GET['book_id'];
if ($book_id==""){
   echo "<script language=javascript>alert('编号不正确');window.location='index.php'</script>";
   exit();
}
else {
   ?>
   <?php
   // 借书
   // 查看用户ID是否已填
   if ($_SESSION['id']==""){
      echo "<script language=javascript>alert('您还没有登陆');window.location='landing.php'</script>";
      exit();
   }else{
      // 可以正常借书，记录之
      // 获得当前日期
      $now = date("Y-m-d,H-i-m");
      $lendsql="INSERT INTO lend(book_id, book_title, lend_time, user_id) values('$book_id','$title','$now','".$_SESSION['id']."')";
      mysqli_query($link,$lendsql);

      // 借出后需要在该书记录中库存剩余数减一
      mysqli_query($link,"update yx_books set leave_number=leave_number-1 where id='$book_id'");
      echo "<script language=javascript>alert('借阅完成');window.location='index.php'</script>";
      ?>
      <?php
   }
}
?>
</body>
</html>

Continuing Learning

new file

<?php include("config.php");?> <html> <head> <meta charset="UTF-8"> <title>借书功能页</title> </head> <body> <?php // 如果图书编号没填写，提示用户 $book_id = $_GET['book_id']; if ($book_id==""){ //echo "<script language=javascript>alert('编号不正确');window.location='index.php'</script>"; exit(); } else { ?> <?php // 借书 // 查看用户ID是否已填 if ($_SESSION['id']==""){ //echo "<script language=javascript>alert('您还没有登陆');window.location='landing.php'</script>"; exit(); }else{ // 可以正常借书，记录之 // 获得当前日期 $now = date("Y-m-d,H-i-m"); $lendsql="INSERT INTO lend(book_id, book_title, lend_time, user_id) values('$book_id','$title','$now','".$_SESSION['id']."')"; mysqli_query($link,$lendsql); // 借出后需要在该书记录中库存剩余数减一 mysqli_query($link,"update yx_books set leave_number=leave_number-1 where id='$book_id'"); //echo "<script language=javascript>alert('借阅完成');window.location='index.php'</script>"; ?> <?php } } ?> </body> </html>

submit Reset Code

Automatic operation

PHP develops simple book borrowing system and complete book borrowing function implementation code

ElementaryImperial CMS enterprise imitation website tutorial

ElementaryNewbies with zero foundation in WordPress build personal blogs and corporate websites

ElementaryUltimate CMS zero-based website building instruction video

ElementaryFront-end project-Shangyou [HTML/CSS/JS technology comprehensive practice]

IntermediateVue3.0 from 0 to build a universal backend management system project practice

ElementaryZero-based front-end course [Vue advanced learning and practical application]

ElementaryWEB front-end tutorial [HTML5+CSS3+JS]

ElementaryQuick introduction to apipost

IntermediateVue3+TypeScript practical tutorial-enterprise-level project practice

ElementaryLet's briefly talk about starting a business in PHP

IntermediateVUE e-commerce project (front-end & back-end dual project actual combat)

ElementaryApipost practical application [api, interface, automated testing, mock]