php连接mysql实例之修改用户密码

瞬间H

于 2021-11-25 18:45:20 发布

阅读量855

点赞数

分类专栏： web前端文章标签： mysql php 数据库

本文链接：https://blog.csdn.net/weixin_43923136/article/details/121544438

版权

web前端专栏收录该内容

5 篇文章 0 订阅

订阅专栏

功能:实现修改用户密码

代码如下:
modify_pass.html

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>revise</title>
    <link rel="stylesheet" href="css/modify_pass.css">
</head>
<body>
    <img class="background" id="background" src="images/1.png">
    <div class="overall" id="overall">
        <div class="revise" id="revise">
            <p>revise_pass</p>
        </div>
        <form action="modify_pass.php" method="POST" enctype="multipart/form-data">
        	<div class="revisebox" id="revisebox">
            		<input type="password" id="current_pass" name="current_pass" placeholder="输入当前密码"/><br><br>
            		<input type="password" id="password" name="pass" placeholder="输入新密码"/><br><br>
            		<input type="password" id="confirm" name="confirm" placeholder="确认新密码"/><br>
        	</div>
        	<div class="confirms" id="confirms">
            		<input type="submit" name=submit id="conf" value="确认">
        	</div>
        </form>
</body>
</html>

modify_pass.php

<?php
session_start();
require("config.php");

$current_pass = md5(trim($_POST['current_pass']));
$pass = md5(trim($_POST['pass']));
$confirm = md5(trim($_POST['confirm']));

if($current_pass == ''){
	echo '<script>alert("请输入当前密码!");</script>';
	exit(0);
}
if($pass == ''){
	echo '<script>alert("请输入新密码");</script>';
	exit(0);
}
if($pass != $confirm){
	echo '<script>alert("密码不一致")</script>';
	echo '<script>window.location="modify_pass.html";</script>';
	exit(0);
}

$conn = new mysqli($servername,$username,$password,$dbname);
if($conn->connect_error){
	die("数据库连接失败:".$conn->connect_error);
	exit(0);
}else{
	$sql = "select * from user where username='".$_SESSION['UserName']."' and password='$current_pass' and confirm='$confirm'";
	$res = mysqli_query($conn,$sql); //查询结果保存在$res对象中
	$row = mysqli_fetch_array($res,MYSQLI_NUM); //把$res转换成索引数组
	if(!is_null($row)){
		$update="update user set password='$pass' where username='".$_SESSION['UserName']."'";
		$res1=mysqli_query($conn,$update);
		echo "<script>alert('密码修改成功!');</script>";
		echo "<script>window.location='index.html'</script>";
	}
}

?>

瞬间H

关注

0
点赞
踩
2

收藏

觉得还不错? 一键收藏
0
评论
php连接mysql实例之修改用户密码

功能:实现修改用户密码代码如下:modify_pass.html<!DOCTYPE html><html lang="en"><head> <meta charset="UTF-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <meta name="viewport" content="width=device-width, initial-
复制链接

扫一扫