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

PHP, ??? ?? ?? ??? ???? ?? ?? ?? ??

??? ??

3.png

?? ?? ?, ????? ??? ??? "?? ???? ?? ???? ????"?? ??????? ????

?? "?? ???? ???" ?? ??? ?????.

?? ????? ?? ???? ?? ?? '?? ??'? ? ?? ?????.

1618.png

??, ???? ????? ??? ???? ???. 

<?php
if ($_SESSION['id']==""){
   echo "<script language=javascript>alert('您還沒有登陸');window.location='landing.php'</script>";
   exit();
}
?>

??? ??? SQL ??? ?????. ?? ??? ???? ?? ????? ?? ??? ?? ??? ????, ???? ?? ???? ?? ??? 1?? ?????. 

<?php
$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 ("刪除借書記錄失敗：".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>";
?>


???? ??
||
<?php $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ù)量失敗：".mysqli_error($link)); ?>