/*
包括的文件
*/
/*
login.php
*/
<?php
require('./mysql.php');
$username=$_REQUEST['username'];
$passwd=$_REQUEST['passwd']
session_start();
$_SESSION['s_username']=$username;
$query_user="select * from user where username = '$username' and passwd = '$passwd'";
$db=new mysql();//实例化类mysql
$result = $db->query_exec($query_user);//验证用户
$num_results=$result->num_rows;//取得数据库中的记录行
if($num_results==0)
{
echo 'login fail!!';
?>
}else{
header("Location: ./index.php");
}
?>
/*
templates/login.tpl
*/
用户名: | |
密码: | |
验证码: |
/*
mysql.php
*/
var $db_host = 'localhost';
var $db_username= 'root';
var $db_password= '123';
var $db_database= 'new';
$db =mysql_connect($ db_host,$db_username,$-> db_password,$-> db_database);
if (mysqli_connect_errno()) {
echo "连接数据库失败!";
exit;
}
return $db;
}
}
?>
/*
效果为*/