php password change page

PHP Password Change Page

We need to use passwords when performing many business operations. The issue of password confidentiality has always been a very important topic. When it comes to data security, passwords should be encrypted using the highest level of protection. But even if your password is impeccable, if you forget it, your data will become inaccessible. In this case, we need a password change tool to help us reset a new password to ensure that the data can be used in a timely manner.

In PHP, creating a password change page is relatively simple. The following are the main steps and implementation process.

Step 1 - Establish a database connection

The first step is to establish a database connection. Here we can use MySQL database. In PHP's MySQL function, we can use the mysqli_connect() function to connect to the MySQL database.

Sample code:

$dbhost = 'localhost'; //Database host name
$dbname = 'mydatabase'; //Database name
$dbuser = 'root' ; //Database username
$dbpass = ''; //Database password

$conn = mysqli_connect("$dbhost", "$dbuser", "$dbpass") or die ("Connect Error");

mysqli_select_db($conn,"$dbname") or die ("Cannot connect to the database");

If the connection fails, "Connection error" or " Cannot connect to database" and other prompt messages.

Step 2 - Create a password change form

We need to create a password change form in HTML.

Sample code:

Old password:

##New password:

Confirm password:

at In this form, we define three input boxes to obtain the old password, new password and confirm password. What should be noted here is that we need to set the type attribute in the password input box to "password" so that the password can be hidden.

Step 3 - Processing form data

Processing form data is a very important step. In this step, we must verify whether the data entered by the user meets the specifications. We also need to determine whether the old password entered by the user is correct, and confirm whether the new password entered twice is the same.

First, we need to verify whether the data is complete. In this example, all three of our input boxes are required. Therefore, we need to use the HTML5 required attribute to confirm that the user has entered the required fields.

Sample code:

This required attribute ensures that the input content in the form cannot be empty.

Next, we need to get the old password entered by the user and encrypt it. The reason we want to encrypt the password is to save it to the database. In this case, we can use the md5() function in PHP.

Sample code:

$oldpassword = md5($_POST['oldpassword']);

Next, we need to verify whether the old password entered by the user is correct, which requires Query the database.

Sample code:

$sql = "SELECT * FROM userdata WHERE password = '$oldpassword'";

$result = mysqli_query($conn, $sql) or die(mysqli_error ($conn));

if(mysqli_num_rows($result) > 0) {

//Old password verification successful
} else {
//Old password verification failed
}

Here, we query the stored passwords from the userdata table. If the number of rows returned by the query result is greater than 0, it means that the old password entered is correct; otherwise, the old password verification fails.

After successfully verifying the old password, we need to verify again whether the new password meets the requirements and confirm whether the two new password inputs are consistent. After the verification is complete, we need to encrypt the new password and write it to the database.

Sample code:

$newpassword = md5($_POST['newpassword']);

$sql = "UPDATE userdata SET password='$newpassword' WHERE id ='$id'";

$result = mysqli_query($conn, $sql) or die(mysqli_error($conn));

In this example, we use the UPDATE statement of SQL to The new password is written to the userdata table.

Step 4 - Display the results of updating password

The last step, we need to display the results of updating password.

We can call the mysqli_affected_rows() function to determine whether the update is successful. If the update is successful, this function returns the number of updated rows (usually 1); otherwise it returns 0.

Sample code:

if(mysqli_affected_rows($conn) > 0) {

echo "Password changed successfully";
} else {
echo "Password changed Failed, please try again";
}

Finally, by combining all the codes together, we can create a complete PHP password change page.

Full code:

$dbhost = 'localhost'; //Database host name
$dbname = 'mydatabase'; //Database name
$dbuser = 'root'; //Database user name
$dbpass = ''; //Database password

$conn = mysqli_connect("$dbhost", "$dbuser", "$dbpass ") or die ("Connection error");

mysqli_select_db($conn,"$dbname") or die ("Cannot connect to database");

if(isset($_POST ['submit'])) {
$oldpassword = md5($_POST['oldpassword']);
$newpassword = md5($_POST['newpassword']);
$confirmpassword = md5( $_POST['confirmpassword']);
$id = $_POST['id'];

$sql = "SELECT * FROM userdata WHERE password = '$oldpassword'";
$ result = mysqli_query($conn, $sql) or die(mysqli_error($conn));

if(mysqli_num_rows($result) > 0) {

if($newpassword == $confirmpassword) {
  $sql = "UPDATE userdata SET password='$newpassword' WHERE id='$id'";
  $result = mysqli_query($conn, $sql) or die(mysqli_error($conn));

  if(mysqli_affected_rows($conn) > 0) {
    echo "密码修改成功";
  } else {
    echo "密码修改失败，请重试";
  }
} else {
  echo "两次输入的新密码不一致，请重新输入";
}

} else {

echo "旧密码验证失败";

}
}
?>

Old password:

New password:

Confirm password:

Through the above steps, we can create a complete PHP password modification page to ensure data security.

The above is the detailed content of php password change page. For more information, please follow other related articles on the PHP Chinese website!