How to use PHP functions for form data storage and display?

How to use PHP functions to store and display form data?

With the development of the Internet, the storage and display of form data has become a very important function. As a commonly used server-side programming language, PHP has powerful processing power and flexibility, and is very suitable for processing forms.

In this article, we will introduce how to use PHP functions to store and display form data, and provide some code examples to help readers understand better.

1. Storage of form data
   After the form is submitted, we need to save the data filled in by the user to a database or other storage method. PHP provides some database operation functions, such as mysqli_connect(), mysqli_query(), etc., which can facilitate database connection and query. Below is a sample code that demonstrates how to store form data into a MySQL database.

<?php
// 数据库连接配置
$host = "localhost";
$username = "root";
$password = "";
$database = "mydb";

// 连接数据库
$conn = mysqli_connect($host, $username, $password, $database);

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

// 获取表单数据
$name = $_POST['name'];
$email = $_POST['email'];
$message = $_POST['message'];

// 构建SQL语句
$sql = "INSERT INTO form_data (name, email, message) VALUES ('$name', '$email', '$message')";

// 执行SQL语句
if (mysqli_query($conn, $sql)) {
    echo "数据存储成功";
} else {
    echo "数据存储失败: " . mysqli_error($conn);
}

// 关闭数据库连接
mysqli_close($conn);
?>

In the above example, we first need to configure the database connection information. Then, use the mysqli_connect() function to connect to the database. Next, obtain the form data through the $_POST array. Finally, build the SQL statement and perform the insert using the mysqli_query() function.

2. Display of form data
   After storing the form data, we need to display it on the web page. PHP provides some functions, such as mysqli_fetch_assoc(), mysqli_fetch_array(), etc., for extracting data from the database. Below is a code example that demonstrates how to get data from a MySQL database and display it on a web page.

<?php
// 数据库连接配置
$host = "localhost";
$username = "root";
$password = "";
$database = "mydb";

// 连接数据库
$conn = mysqli_connect($host, $username, $password, $database);

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

// 查询数据库并获取数据
$sql = "SELECT * FROM form_data";
$result = mysqli_query($conn, $sql);

// 显示数据
if (mysqli_num_rows($result) > 0) {
    while ($row = mysqli_fetch_assoc($result)) {
        echo "姓名: " . $row['name'] . "<br>";
        echo "邮箱: " . $row['email'] . "<br>";
        echo "留言: " . $row['message'] . "<br><br>";
    }
} else {
    echo "没有数据";
}

// 关闭数据库连接
mysqli_close($conn);
?>

In the above example, we first need to configure the database connection information. Then use the mysqli_connect() function to connect to the database. Next, construct the SQL statement and use the mysqli_query() function to perform the query operation. Finally, use the mysqli_num_rows() function to determine whether there is data, and loop through the mysqli_fetch_assoc() function to obtain each piece of data and display it on the web page.

Through the above sample code, we can see how to use PHP functions to store and display form data. Readers can make corresponding modifications and expansions according to their actual needs. I hope this article can be helpful to everyone!

The above is the detailed content of How to use PHP functions for form data storage and display?. For more information, please follow other related articles on the PHP Chinese website!