How to implement modifiable information on PHP web pages

In website development, it is very important to provide users with interactive and modifiable information. PHP is a very popular server-side programming language that can be used to develop dynamic websites. This article will introduce how to implement modifiable information on PHP web pages.

1. Basic Principle

The information on the web page is usually stored in a database. PHP provides many functions for operating databases. We can obtain, modify, add, delete data in the database through these functions, and display it on the web page. The following takes the MySQL database as an example.

1. Connect to the database

To connect to the MySQL database in PHP, you need to use mysqli or PDO extension. The specific connection method is as follows:

<?php $servername = "localhost";
$username = "username";
$password = "password";
$dbname = "myDB";

// 创建连接
$conn = new mysqli($servername, $username, $password, $dbname);

// 检测连接
if ($conn->connect_error) {
 die("连接失败: " . $conn->connect_error);
}
?>

2. Query data

You need to use the SELECT statement to query data. The following is an example:

$sql = "SELECT id, name, email FROM users";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
 // 输出数据
 while($row = $result->fetch_assoc()) {
     echo "id: " . $row["id"]. " - Name: " . $row["name"]. " " . $row["email"]. "<br>";
 }
} else {
 echo "0 结果";
}

3. Modify data

You need to use the UPDATE statement to modify data. The following is an example:

$sql = "UPDATE users SET email='newemail@example.com' WHERE id=1";

if ($conn->query($sql) === TRUE) {
 echo "记录更新成功";
} else {
 echo "Error updating record: " . $conn->error;
}

2. Implementing a modifiable web page

After understanding the basic principles, we can start to implement a modifiable web page. First you need to create an HTML form for updating data.

nbsp;html>

 Name:
 
 Email:
 

 

 

This form contains two text boxes for entering your name and email. After submission, the data is sent to the update.php page for processing.

The update.php page needs to complete the following steps:

1. Establish a connection and obtain form data.

<?php $servername = "localhost";
$username = "username";
$password = "password";
$dbname = "myDB";

// 创建连接
$conn = new mysqli($servername, $username, $password, $dbname);

// 检测连接
if ($conn->connect_error) {
 die("连接失败: " . $conn->connect_error);
}

$name = $_POST["name"];
$email = $_POST["email"];
?>

2. Update the data in the database.

$sql = "UPDATE users SET email='$email' WHERE name='$name'";

if ($conn->query($sql) === TRUE) {
 echo "记录更新成功";
} else {
 echo "Error updating record: " . $conn->error;
}

3. Close the connection.

$conn->close();

Finally, combine these two pages into one. That is, the data is displayed in the show.php page and a button linked to the update.php page is provided. Clicking the button can enter the form page for modifying the data. The following is an example:

nbsp;html>



connect_error) {
 die("连接失败: " . $conn->connect_error);
}

$sql = "SELECT id, name, email FROM users";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
 // 输出数据
 while($row = $result->fetch_assoc()) {
     echo "id: " . $row["id"]. " - Name: " . $row["name"]. " " . $row["email"]. "
";
     echo "修改

";
 }
} else {
 echo "0 结果";
}

$conn->close();
?>

3. Summary

This article introduces how to implement modifiable information on PHP web pages. By connecting to the database, querying data, modifying data and other operations, we can easily realize the interactivity and editability of the website.

The above is the detailed content of How to implement modifiable information on PHP web pages. For more information, please follow other related articles on the PHP Chinese website!