PHP form processing: form data chart display and statistics

PHP form processing: form data chart display and statistics

In web development, forms are a common way of data interaction. After a user fills out a form and submits it, we usually need to process and analyze the form data in order to better understand user behavior and make decisions. This article will introduce how to use PHP to process form data, and use charts to display and statistical data.

1. Receive form data
First, we need to create an HTML page containing the form and set up the PHP script that is called when submitting the form. In PHP scripts, we use $_POST or $_GET to receive form data, depending on the method attribute of the form. For example, if it is a form submitted by the POST method, you can use the following code to receive data:

$name = $_POST['name'];
$email = $_POST['email'];

2. Store data
After receiving the form data, we can choose to store the data in the database. Here, we take the MySQL database as an example and use the mysqli function to connect and save data. The following is a sample code:

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

// 插入数据
$query = "INSERT INTO users (name, email) VALUES ('$name', '$email')";
mysqli_query($conn, $query);
mysqli_close($conn);

3. Chart display and statistics
After storing the data in the database, we can generate charts by querying the database and analyzing the data. Here we introduce a commonly used PHP chart library - Chart.js.

First, we need to introduce the Chart.js script file into the HTML page. The latest version can be downloaded from the Chart.js official website (https://www.chartjs.org). Then, we use the following code to generate a histogram:

<canvas id="myChart"></canvas>
<script>
    // 获取数据
    <?php
        $query = "SELECT * FROM users";
        $result = mysqli_query($conn, $query);
        $data = array();
        while ($row = mysqli_fetch_assoc($result)) {
            $data[] = $row;
        }
        mysqli_close($conn);
        echo "var data = " . json_encode($data) . ";";
    ?>

    // 绘制图表
    var ctx = document.getElementById('myChart').getContext('2d');
    var chart = new Chart(ctx, {
        type: 'bar',
        data: {
            labels: data.map(function(item) {
                return item.name;
            }),
            datasets: [{
                label: '表单数据统计',
                data: data.map(function(item) {
                    return item.email;
                }),
                backgroundColor: 'rgba(75, 192, 192, 0.2)',
                borderColor: 'rgba(75, 192, 192, 1)',
                borderWidth: 1
            }]
        },
        options: {
            scales: {
                y: {
                    beginAtZero: true
                }
            }
        }
    });
</script>

In the above code, we first query the database through PHP and get the data. Then, convert the query results to JSON format and pass the data to JavaScript. Finally, use the Chart.js API to generate the histogram and bind the data to the chart.

Summary
This article introduces how to process form data through PHP and use the Chart.js library to generate chart displays and statistics. By rationally utilizing these technologies, we can better analyze and understand user behavior and provide strong support for decision-making. I hope this article will be helpful to your web development work!

The above is the detailed content of PHP form processing: form data chart display and statistics. For more information, please follow other related articles on the PHP Chinese website!