php登录连接mysql查询_PHP登录（连接数据库）小案例

实现效果

   

     

    

数据库信息

代码示例：

1. login.php

Insert title here

用户名:
密码:

<?php if(!empty($_POST['remember'])){echo 'checked="checked"';}?>>记住我

忘记密码

注册

修改密码

2. index.php

Insert title here

<?phpsession_start ();?>欢迎您---<?php echo $_SESSION['username']?>

注销

3. changepassword.php

Insert title here

changepassword.php

用户名:
原密码:
新密码:

登录

4. changgepassword_service.php

Insert title here

$link = mysqli_connect("127.0.0.1","root","liupw")

ordie("连接失败".mysqli_error($link)."
");echo "连接成功"."
";//选择数据库

$selectDB=mysqli_select_db($link, "usermanager")

ordie("选择数据库usermanager失败"."
");echo "选择数据库usermanager成功"."
";//获取表单提交的数据

$username = $_POST["username"];$oldpassword = $_POST["oldpassword"];$newpassword=$_POST["newpassword"];//表的查询

$query=mysqli_query($link, "select * from usertable")

ordie("查询失败"."
");echo "查询成功"."
";while ($result_array = mysqli_fetch_array($query)) {if($username==$result_array["username"]){if($oldpassword==$result_array["password"]){$query=mysqli_query($link, "update usertable set password='$newpassword' where username ='$username' ")

ordie("修改密码失败"."
");header("location:login.php");

}else{echo "您还没有注册";

}

}

}//关闭数据库服务器

mysqli_close($link);?>

5. recoverypassword_service.php

Insert title here

$link = mysqli_connect("127.0.0.1","root","liupw")

ordie("连接失败".mysqli_error($link)."
");echo "连接成功"."
";//选择数据库

$selectDB=mysqli_select_db($link, "usermanager")

ordie("选择数据库usermanager失败"."
");echo "选择数据库usermanager成功"."
";//获取表单提交的数据

$username = $_POST["username"];$eamil = $_POST["eamil"];//表的查询

$query=mysqli_query($link, "select * from usertable")

ordie("查询失败"."
");echo "查询成功"."
";while ($result_array = mysqli_fetch_array($query)) {if($username==$result_array["username"]){if($eamil==$result_array["usermail"]){$query=mysqli_query($link, "update usertable set password='666' where username ='$username' ")

ordie("插入失败"."
");header("location:login.php");

}

}

}//关闭数据库服务器

mysqli_close($link);?>

6. recoverypassword.php

Insert title here

recoverypassword.php

用户名:
邮箱:

7. register_service.php

Insert title here

$link = mysqli_connect("127.0.0.1","root","liupw")

ordie("连接失败".mysqli_error($link)."
");echo "连接成功"."
";//选择数据库

$selectDB=mysqli_select_db($link, "usermanager")

ordie("选择数据库usermanager失败"."
");echo "选择数据库usermanager成功"."
";//获取表单提交的数据

$username = $_POST["username"];$password = $_POST["password"];$repassword=$_POST["repassword"];$useremail=$_POST["email"];if($password==$repassword){$query=mysqli_query($link, "insert into usertable values('$username','$password','$useremail')")

ordie("插入失败"."
");header("location:login.php");

}//表的查询

//关闭数据库服务器

mysqli_close($link);?>

8. regiser.php

Insert title here

register.php

用户名:
密码:
确认密码:
邮箱:

登录

9. service.php

Insert title here

$link = mysqli_connect("127.0.0.1","root","liupw")

ordie("连接失败".mysqli_error($link)."
");echo "连接成功"."
";//选择数据库

$selectDB=mysqli_select_db($link, "usermanager")

ordie("选择数据库usermanager失败"."
");echo "选择数据库usermanager成功"."
";//表的查询

$query=mysqli_query($link, "select * from usertable")

ordie("查询失败"."
");echo "查询成功"."
";//获取表单提交的数据

$username = $_POST["username"];$password = $_POST["password"];while ($result_array = mysqli_fetch_array($query)) {if($username==$result_array["username"]){if($password==$result_array["password"]){session_start();$_SESSION['username']=$username;header("location:index.php");

}else{echo "用户密码不正确";

}

}

}//关闭数据库服务器

mysqli_close($link);?>

10. zhuxiao.php

Insert title here

$link = mysqli_connect("127.0.0.1","root","liupw")

ordie("连接失败".mysqli_error($link)."
");echo "连接成功"."
";//选择数据库

$selectDB=mysqli_select_db($link, "usermanager")

ordie("选择数据库usermanager失败"."
");echo "选择数据库usermanager成功"."
";//表的查询

$query=mysqli_query($link, "select * from usertable")

ordie("查询失败"."
");echo "查询成功"."
";//获取表单提交的数据

session_start();$username = $_SESSION['username'];while ($result_array = mysqli_fetch_array($query)) {if($username==$result_array["username"]){mysqli_query($link, "delete from usertable where username='$username'");echo "注销成功";break;

}

}//关闭数据库服务器

mysqli_close($link);?>