亚洲国产日韩欧美一区二区三区,精品亚洲国产成人av在线,国产99视频精品免视看7,99国产精品久久久久久久成人热,欧美日韩亚洲国产综合乱

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

Introduce the database file config.php

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

Create a complete return code file huanshu.php

<?php
require ('config.php');
//如果沒有登錄，退出
if ($_SESSION['id']==""){
   echo "<script language=javascript>alert('您還沒有登陸');window.location='landing.php'</script>";
   exit();
}
$book_id=$_GET["book_id"];
//構(gòu)建sql語句還書
//在lend表中刪除該借書記錄
$returnsql="DELETE FROM lend where book_id='$book_id' and user_id=".$_SESSION['id'];
mysqli_query($link,$returnsql) or die ("刪除借書記錄失?。?quot;.mysqli_errno($link));
//在book表中增加一本現(xiàn)存書數(shù)量
$booksql="UPDATE yx_books SET leave_number=leave_number+1 where id='$book_id'";
mysqli_query($link,$booksql) or die ("增加剩余書數(shù)量失?。?quot;.mysqli_error($link));
echo "<script language=javascript>alert('還書成功');window.location='index.php'</script>";
?>


Continuing Learning
||
<?php require ('config.php'); //如果沒有登錄，退出 if ($_SESSION['id']==""){ //echo "<script language=javascript>alert('您還沒有登陸');window.location='landing.php'</script>"; exit(); } $book_id=$_GET["book_id"]; //構(gòu)建sql語句還書 //在lend表中刪除該借書記錄 $returnsql="DELETE FROM lend where book_id='$book_id' and user_id=".$_SESSION['id']; mysqli_query($link,$returnsql) or die ("刪除借書記錄失?。?quot;.mysqli_errno($link)); //在book表中增加一本現(xiàn)存書數(shù)量 $booksql="UPDATE yx_books SET leave_number=leave_number+1 where id='$book_id'"; mysqli_query($link,$booksql) or die ("增加剩余書數(shù)量失?。?quot;.mysqli_error($link)); //echo "<script language=javascript>alert('還書成功');window.location='index.php'</script>"; ?>
submitReset Code