How to implement modifiable information on PHP web pages-PHP Problem-php.cn

Home

Backend Development

PHP Problem

How to implement modifiable information on PHP web pages

PHPz

Mar 29, 2023 am 11:30 AM

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);
}
?>

Copy after login

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 结果";
}

Copy after login

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;
}

Copy after login

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.

<!DOCTYPE html>
<html>
<body>

<form action="update.php" method="post">
 <label for="name">Name:</label><br>
 <input type="text" id="name" name="name"><br>
 <label for="email">Email:</label><br>
 <input type="text" id="email" name="email"><br><br>
 <input type="submit" value="Submit">
</form> 

</body>
</html>

Copy after login

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"];
?>

Copy after login

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;
}

Copy after login

3. Close the connection.

$conn->close();

Copy after login

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:





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();
?>

Copy after login

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!

Statement of this Website

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn