1.创建test数据库并建立user表
user表结构如下
2.编写lineMysql.php
实现连接mysql数据库，并创建查询，插入等方法
<?phpclass Mysql{private $host;private $root;private $passwords;private $database;#析构函数，具有构造函数的类，在创建对象时会调用构造函数，完成一些初始化的操作。function __construct($host,$root,$passwords,$database){$this->host = $host; # $this-> 在类本身内部使用本类的属性或者方法$this->root = $root;$this->passwords = $passwords;$this->database = $database;$this->connect();}#连接数据库function connect(){$this->conn=mysqli_connect($this->host,$this->root,$this->passwords);#连接数据库服务器mysqli_query($this->conn,"set names utf8");#设置字符集mysqli_select_db($this->conn,$this->database);#选择数据库}#创建查询结果集function query($sql){return mysqli_query($this->conn,$sql);}#返回结果集中的记录总数function rows($result){return mysqli_num_rows($result);}#自定义查询方法selectbyIdfunction selectbyUser($table,$username){return $this->query("SELECT * FROM $table where username='$username'");}//自定义插入数据方法function insert($table,$username,$password){$this->query("INSERT INTO $table (username,password) VALUES ('$username','$password')");}#mysql_fetch_assoc() 函数从结果集中取得一行作为关联数组。function assoc($result){return mysqli_fetch_assoc($result);}#数据库关闭function dbClose(){mysqli_close($this->conn);}}$db = new Mysql("localhost","root","123456","test");?>
3.login.php
登录页面
<form action="" method="post"><p>用户名：<input type="text" name="username" value=""></p><p>密码：<input type="text" name="password" value=""></p><input type="submit" value="登录"></form><a href="register.php">注册</a><?phpsession_start();require("lineMysql.php");if(!empty($_POST['username'])){$username = $_POST['username'];$password = $_POST['password'];$select = $db->selectbyUser("user", $username);# $db-> 调用实例化对象db中的方法$rows=$db->rows($select); #返回的结果集记录总数 $assoc = $db->assoc($select); #从结果集中取得一行作为关联数组if(empty($rows)){echo "<script>alert('该用户不存在！')</script>";}else{if($password==$assoc['password']){$_SESSION['username']=$username;header('Location:loginSuccess.php');}else{echo "<script>alert('密码错误！')</script>";}}}?>
4.loginSuccess.php
登录成功页
<?phpsession_start();if (isset($_SESSION['username'])) {echo '欢迎您，'.$_SESSION["username"];}?><br><a href="login.php">注销</a>
5.register.php
注册页面
<form action="" method="post"><p>用户名：<input type="text" name="username" value=""></p><p>密码：<input type="text" name="password1" value=""></p><p>确认密码：<input type="text" name="password2" value=""></p><input type="submit" value="注册"></form><?phpsession_start();require("lineMysql.php");if(!empty($_POST['username'])){$username = $_POST['username'];$password = $_POST['password1'];$select = $db->selectbyUser("user", $username);$rows=$db->rows($select); #返回的结果集记录总数if(empty($rows)){if(!empty($_POST['password1'])){if($_POST['password1'] != $_POST['password2']){echo "<script>alert('两次输入密码不同！')</script>";}else{$db->insert("user","$username","$password");header('Location:registerSuccess.php');}}else{echo "<script>alert('请输入密码！')</script>";}}else{echo "<script>alert('该用户名已被注册！')</script>";}}?>
6.registerSuccess.php
注册成功页
注册成功！<a href="login.php">去登录</a>
7.最后将整个项目文件放到wampserver的www目录下，通过浏览器访问login.php页面即可。
