php登录用户信息存放在,PHP中使用session实现保存用户登录信息

PHP中使用session实现保存用户登录信息

if(isset($_POST['submit'])){//用户提交登录表单时执行如下代码

$dbc = mysqli_connect(DB_HOST,DB_USER,DB_PASSWORD,DB_NAME);

$user_username = mysqli_real_escape_string($dbc,trim($_POST['username']));

$user_password = mysqli_real_escape_string($dbc,trim($_POST['password']));

if(!empty($user_username)&&!empty($user_password)){

//MySql中的'SHA()函数用于对字符串进行单向加密

$query = "SELECT user_id, username FROM mismatch_user WHERE username = '$user_username' AND "."password = SHA('$user_password')";

//用用户名和密码进行查询

$data = mysqli_query($dbc,$query);

//若查到的记录正好为一条，则设置SESSION，同时进行页面重定向

if(mysqli_num_rows($data)==1){

$row = mysqli_fetch_array($data);

$_SESSION['user_id']=$row['user_id'];

$_SESSION['username']=$row['username'];

$home_url = 'loged.php';

header('Location: '.$home_url);

}else{//若查到的记录不对，则设置错误信息

$error_msg = 'Sorry, you must enter a valid username and password to log in.';

}

}else{

$error_msg = 'Sorry, you must enter a valid username and password to log in.';

}

}

}else{//如果用户已经登录，则直接跳转到已经登录页面

$home_url = 'loged.php';

header('Location: '.$home_url);

}

?>

Mismatch - Log In

Msimatch - Log In

if(!isset($_SESSION['user_id'])){

echo '

'.$error_msg.'

';

?>

Log In

Username:

value="<?php if(!empty($user_username)) echo $user_username; ?>" />

Password:

}

?>

3、登入页面：loged.php

?

1

2

3

4

5

6

7

8

9

10

11

12

//使用会话内存储的变量值之前必须先开启会话

session_start();

//使用一个会话变量检查登录状态

if(isset($_SESSION['username'])){