php modify registered information

With the continuous development of the Internet, the function of online registration has become a necessary condition for various websites. However, it is also common that user information may need to be modified after registration. Especially on some websites that require users to enter real information, users may make mistakes when filling in the information, or their personal information may have changed and need to be modified.

For PHP programmers, it is not difficult to handle the user information modification function. Below is a simple tutorial on how to modify user registration information through PHP.

1. Create database

First, we need to create a database and related tables to store user registration information. In this tutorial, we use MySQL as an example. The following is the table we want to create:

CREATE TABLE users (
id INT(11) NOT NULL AUTO_INCREMENT,
username VARCHAR(255) NOT NULL,
password VARCHAR(255) NOT NULL,
email VARCHAR(255) NOT NULL,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (id)
);

In the above table, we define the user's ID, username, password, email, creation time and update time. At the same time, we set the user ID to automatically grow to ensure that each user has a unique ID.

2. Creating a PHP page

Before creating a PHP page, we need to make sure we are connected to the database. The following is a simple PHP database connection code:

$username = "your_username";
$password = "your_password";
$database = "your_database";
$host = "localhost";

$conn = mysqli_connect($host, $username, $password, $database);

if (!$conn) {

die("Connection failed: " . mysqli_connect_error());

} else {

echo "Connected successfully";

}
?>

After the connection is successful, we can create a PHP page to handle the function of modifying user information. The following is a simple PHP page:

if (isset($_POST['submit'])) {
$username = $_POST['username'];
$password = $_POST['password'];
$email = $_POST['email'];

$sql = "UPDATE users SET username = '{$username}', password = '{$password}', email = '{$email}' WHERE id = '{$id}'";

$result = mysqli_query($conn, $sql);

if ($result) {

   echo "Record updated successfully";

} else {

   echo "Record update failed: " . mysqli_error($conn);

}
} else {
$id = $_GET['id'];

$sql = "SELECT * FROM users WHERE id = '{$id}'";

$result = mysqli_query($conn, $sql);

$row = mysqli_fetch_assoc($ result);
?>

Update User Info

<label>Username:</label><br>
<input type="text" name="username" value="<?php echo $row['username']; ?>"><br>
<label>Password:</label><br>
<input type="password" name="password" value="<?php echo $row['password']; ?>"><br>
<label>Email:</label><br>
<input type="email" name="email" value="<?php echo $row['email']; ?>"><br>
<input type="submit" name="submit" value="Update">

}
?>

and above In the PHP page, we first determine whether there is submitted data. If there is submitted data, we get the data from the form and use the SQL UPDATE statement to update the data into the database. If the update is successful, "Record updated successfully" will be output.

If no data is submitted, we will get the user's ID from the URL and use the SQL SELECT statement to get the corresponding user information from the database. Subsequently, we display the user information in the corresponding form so that the user can make modifications.

3. Test function

Finally, we need to test whether our user information modification function is functioning properly. First, insert some test data into the database. Then, visit the page http://localhost/update_user_info.php?id=1 (assuming the user ID is 1), and you will see a form for modifying user information. Enter the new username, password, email, and click the "Update" button to submit. If the update is successful, we will see the "Record updated successfully" prompt.

Summary

Through the above steps, we can quickly build a simple user information modification function. In practical applications, we can also modify and optimize according to our own needs. At the same time, we also need to pay attention to protecting the security of user information, such as encrypting and saving passwords to avoid security issues.

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