How to use PHP to store data after form submission

How to use PHP to implement data storage after form submission

Overview:
In website development, forms are one of the important components for interacting with users. After the user fills out the form and submits it, the submitted data usually needs to be stored for subsequent processing and data analysis. This article will introduce how to use PHP to implement data storage after form submission.

Steps:

1. Create HTML form:
   First, we need to create an HTML form on the front-end page so that users can fill in relevant information. The following is a simple example:

<form action="submit.php" method="POST">
  <label for="name">姓名：</label>
  <input type="text" name="name" id="name" required><br><br>
  
  <label for="email">邮箱：</label>
  <input type="email" name="email" id="email" required><br><br>
  
  <label for="message">留言：</label>
  <textarea name="message" id="message" required></textarea><br><br>
  
  <input type="submit" value="提交">
</form>

2. Create PHP file:
   In the above HTML, we point the form submission action to the PHP file named "submit.php" . Therefore, we need to create a file called "submit.php" to handle form submission.

<?php
// 接收表单提交的数据
$name = $_POST['name'];
$email = $_POST['email'];
$message = $_POST['message'];

// 建立数据库连接
$servername = "localhost";
$username = "数据库用户名";
$password = "数据库密码";
$dbname = "数据库名";

$conn = new mysqli($servername, $username, $password, $dbname);

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

// 将数据存储到数据库中
$sql = "INSERT INTO 表名 (name, email, message)
        VALUES ('$name', '$email', '$message')";

if ($conn->query($sql) === TRUE) {
    echo "数据存储成功";
} else {
    echo "数据存储失败: " . $conn->error;
}

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

In the above code, we first obtain the data submitted by the form through the $_POST variable and store it in the corresponding variable. Then, use the mysqli class to establish a connection to the database. Next, we use SQL statements to insert data into the specified database table. If the insertion is successful, a success message is returned; otherwise, a failure message is returned. Finally, the database connection is closed by calling the close() method.

It should be noted that the "database user name", "database password", "database name", and "table name" in the above code need to be modified according to the actual situation.

3. Create database and tables:
   In order to test the above code, we need to create the database and tables first. You can use the following SQL statement to create a database named "mydatabase" and a table named "messages":

CREATE DATABASE mydatabase;

USE mydatabase;

CREATE TABLE messages (
    id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(30) NOT NULL,
    email VARCHAR(50) NOT NULL,
    message TEXT NOT NULL
);

The above SQL statement creates a table named "messages" , which contains four fields: id, name, email and message. Among them, the id field is an auto-incrementing primary key, and the name, email, and message fields store user name, email, and message information respectively.

Conclusion:
Through the above steps, we successfully implemented the use of PHP to handle data storage after form submission. When the user fills out the form and clicks the submit button, the PHP code receives the form data and stores it in the database. We can further process or analyze the data according to actual needs.

The above is the detailed content of How to use PHP to store data after form submission. For more information, please follow other related articles on the PHP Chinese website!