mysql统计用户在线时长_php如何利用session和mysql来统计用户在线时常

//登录代码

header("Content-type: text/html; charset=utf-8");

// 创建连接

$conn = new mysqli("localhost", "root", "root","litong");

// 检测连接

if ($conn->connect_error) {

die("连接失败: " . $conn->connect_error);

}

$adminname=$_POST['adminname'];//用户名

$password=md5($_POST['password']);//密码

$query = "select * from admin where (adminname = '{$adminname}' && password = '{$password}')";

$result = $conn->query($query);

if($result){//判断用户是否存在

$admin = $result->fetch_assoc();

$time = time();

$sql = "update admin set login_time = '{$time}'";//把用户登录时间保存

$res=$conn->query($sql);

if ($res){

//把数据存进session中

$_SESSION['uid'] = $admin['id'];

$_SESSION['login_time'] = time();

header("location:index.php");//登录成功跳转

}

}

?>