session mysql登录实现_php 完整登录函数的简单示例（带session写入，mysql数据库查询）...

这段代码比较完整，带session写入，MysqL数据库查询，感兴趣的小伙伴，下面一起跟随编程之家 jb51.cc的小编来看看吧。

经测试代码如下：

/**

* 登录函数

*

* @param

* @arrange (512.笔记) jb51.cc

**/

//escape data and strip tags

function safestrip($string){

$string = strip_tags($string);

$string = MysqL_real_escape_string($string);

return $string;

}

//function to show any messages

function messages() {

$message = '';

if($_SESSION['success'] != '') {

$message = '<span class="success" id="message">'.$_SESSION['success'].'</span>';

$_SESSION['success'] = '';

}

if($_SESSION['error'] != '') {

$message = '<span class="error" id="message">'.$_SESSION['error'].'</span>';

$_SESSION['error'] = '';

}

return $message;

}

//log user in ---------------------------------------------------

function login($username,$password){

//call safestrip function

$user = safestrip($user);

$pass = safestrip($pass);

//convert password to md5

$pass = md5($pass);

// check if the user id and password combination exist in database

$sql = MysqL_query("SELECT * FROM table WHERE username = '$user' AND password = '$pass'")or die(MysqL_error());

//if match is equal to 1 there is a match

if (MysqL_num_rows($sql) == 1) {

//set session

$_SESSION['authorized'] = true;

// reload the page

$_SESSION['success'] = 'Login Successful';

header('Location: ./index.PHP');

exit;

} else {

// login Failed save error to a session

$_SESSION['error'] = 'Sorry,wrong username or password';

}

}

//usage example

//show any errors

messages();

//pass username and password to login function the username and password would be taken from a form

login($username,$password);

总结

如果觉得编程之家网站内容还不错，欢迎将编程之家网站推荐给程序员好友。

本图文内容来源于网友网络收集整理提供，作为学习参考使用，版权属于原作者。

如您喜欢交流学习经验，点击链接加入交流1群：1065694478(已满)交流2群：163560250