How to convert data in database into HTML content in PHP

PHP is an open source server-side scripting language that is widely used in the development of web applications and dynamic websites. Among them, database management and operation is one of the important applications of PHP. In many web applications, it is a common requirement to extract information from a database and display it to the user. This article will introduce how to use PHP to convert data in the database into HTML content.

1. Connect to the database

First, we need to connect to the database. A series of development tools are provided in PHP, such as PDO and MySQLi extensions, to easily connect and interact with a variety of databases. Here we take the MySQL database as an example to demonstrate how to connect to the database.

$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database_name";

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

// 检查连接是否成功
if ($conn->connect_error) {
    die("连接失败: " . $conn->connect_error);
}

2. Read information from the database

Next, we need to read information from the database. Usually, we need to use SQL query statements to extract information from tables. For example, the following code can read all the data in the "users" table:

$sql = "SELECT * FROM users";
$result = $conn->query($sql);

After executing this statement, the variable $result will hold the query result object. We use the $num_rows attribute to get the number of rows in the result, and use the $fetch_assoc() method to fetch the data for each row from the result object. For example:

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

3. Convert the read information into HTML

Finally, we need to convert the read information into HTML and display it to the user. This can output HTML markup and data using PHP's echo statement. For example, the following code can convert the read user information into HTML:

if ($result->num_rows > 0) {
    // 输出每一行数据
    while($row = $result->fetch_assoc()) {
        echo "<div>";
        echo "<h2 id="row-name">" . $row["name"] . "</h2>";
        echo "<p>" . $row["email"] . "</p>";
        echo "</div>";
    }
} else {
    echo "0 结果";
}

Embed this code into the HTML page to display the information in the database to the user.

Summary

This article introduces how to use PHP to connect to the database and convert the read information into HTML. This technology can be applied to various web applications to help developers build dynamic websites faster and improve user experience. If you are developing a web application, you can try this transformation to better manage your database and display information.

The above is the detailed content of How to convert data in database into HTML content in PHP. For more information, please follow other related articles on the PHP Chinese website!