一、系统介绍
本系统实现了:用户登陆、日志审计、监控规则、用户管理。
二、系统展示
1.用户登陆
2.监控日志
3.监控规则
4.用户管理
三、代码展示
<?php
session_start();
include("conn.php");
session_start();
if($_SESSION["username"]==""){
echo "<script>alert('对不起,您还没有登录请登录后继续刚才的操作!');window.location.href='index.php';</script>";
}
$id=$_GET["id"];
$username=$_SESSION["username"];
$user=$mysqli->query("select id from tb_reader where username='$username'");
$rsuser=$user->fetch_array();
$userid=$rsuser["id"];
$shijian=date("Y-m-d");
if($id==""){
echo "<script language='javascript'>alert('图书参数丢失!');history.back();</script>";
}
$query=$mysqli->query("select * from tb_borrow where readerid='$userid' and bookid='$id'");
$result=$query->fetch_array();
if($result!=false){
echo "<script language=javascript>alert('您已经提交了该图书的借阅申请,不能重复提交!');history.back();window.close();</script>";
}
else{
$off=$mysqli->query("set autocommit=0");
$mysqli->query("BEGIN");
$sql=$mysqli->query("insert into tb_borrow(bookid,readerid,shijian,operator)values('$id','$userid','$shijian','个人申请')");
$sql2=$mysqli->query("insert into tb_borrowlist(bookid,readerid,shijian,operator)values('$id','$userid','$shijian','个人申请')");
if($sql && $sql2){
$mysqli->query("COMMIT");
echo "<script language='javascript'>alert('借阅申请提交成功!');history.back();</script>";
$mysqli->query("END");
$on=$mysqli->query("set autocommit=1");
}else{
$mysqli->query("ROLLBACK");
$mysqli->query("END");
$on=$mysqli->query("set autocommit=1");
echo "<script language='javascript'>alert('借阅申请提交失败!');history.back();</script>";
}
}
?>
四、获取源码
点击下载
基于php+mysql日志审计管理系统