The second-hand recycling website developed by PHP realizes the function of modifying personal information
As the demand for second-hand recycling gradually increases, second-hand recycling websites have become a very popular field. Among them, the modification of personal information is a very important function, which allows users to update their personal information anytime and anywhere. This article will introduce how to use PHP to develop a second-hand recycling website and implement the function of modifying personal information.
First, we need to create a database to store the user's personal information. We can use the MySQL database and create a table named users, which contains the following fields: id (primary key), name, email, and phone.
Next, we need to create a form to enter the information that the user needs to modify. We can create a file named modify_form.php and use the following code to create the form:
<!DOCTYPE html> <html> <head> <title>修改个人信息</title> </head> <body> <h2>修改个人信息</h2> <form method="POST" action="modify_process.php"> <label>姓名:</label> <input type="text" name="name" required><br><br> <label>邮箱:</label> <input type="email" name="email" required><br><br> <label>电话:</label> <input type="tel" name="phone" required><br><br> <input type="submit" value="提交"> </form> </body> </html>
The above code creates a form containing name, email and phone input boxes, and sets the form submission method to POST, submit to the modify_process.php page for processing.
Next, we need to create a file called modify_process.php to handle form submission and update the user's personal information. Use the following code to implement:
<?php // 获取表单提交的数据 $name = $_POST['name']; $email = $_POST['email']; $phone = $_POST['phone']; // 连接数据库 $servername = "localhost"; $username = "username"; $password = "password"; $dbname = "database"; $conn = new mysqli($servername, $username, $password, $dbname); if ($conn->connect_error) { die("连接数据库失败: " . $conn->connect_error); } // 更新用户信息 $sql = "UPDATE users SET name='$name', email='$email', phone='$phone' WHERE id=1"; if ($conn->query($sql) === TRUE) { echo "个人信息更新成功"; } else { echo "个人信息更新失败: " . $conn->error; } // 关闭数据库连接 $conn->close(); ?>
The above code first obtains the name, email and phone information submitted by the form, and saves it to the corresponding variables. Then, connect to the MySQL database and execute an UPDATE statement to update the user's personal information. Finally, the corresponding prompt information is output according to the update result.
Using the above code, you can realize the personal information modification function of a simple second-hand recycling website. Users can update their personal information by visiting the modify_form.php page, filling out and submitting the form. The system will save the data submitted in the form to the database and give corresponding feedback information.
Of course, the above code is just a simple example, and issues such as data verification and security also need to be considered in actual applications. At the same time, functions need to be expanded and optimized according to actual needs. I hope this article can be helpful to developers who use PHP to develop second-hand recycling websites and implement the function of modifying personal information.
The above is the detailed content of Second-hand recycling website developed with PHP realizes personal information modification function. For more information, please follow other related articles on the PHP Chinese website!