How to use PHP to implement data investigation and statistical analysis functions

How to use PHP to implement data investigation and statistical analysis functions

Abstract: With the popularity of the Internet and the explosive growth of data, data investigation and statistical analysis have become more and more important The more important it is. This article will introduce how to use PHP language to implement data investigation and statistical analysis functions, including data collection, storage, processing and display, and provide relevant code examples.

Introduction:
In modern society, data investigation and statistical analysis is an important task. It not only helps us understand user needs and product market conditions, but also guides decision-making and optimizes business processes. As a widely used scripting language, PHP is fast, concise, flexible and very suitable for processing data.

1. Data collection
Data collection is the first step in data investigation and statistical analysis, and can be carried out in a variety of ways, such as online forms, API interfaces, database queries, etc. The following is a sample code for using PHP to implement online form data collection:

<form method="POST" action="collect_data.php">
  <label for="name">姓名：</label>
  <input type="text" id="name" name="name"><br>
  
  <label for="age">年龄：</label>
  <input type="number" id="age" name="age"><br>
  
  <input type="submit" value="提交">
</form>

// collect_data.php
$name = $_POST["name"];
$age = (int)$_POST["age"];

// 将数据存储到数据库或文件中
// ...

2. Data storage
After data collection, the data needs to be stored in a database or file for subsequent processing and analysis. The following is a sample code for using PHP to store data into a MySQL database:

// connect.php
$servername = "localhost";
$username = "your_username";
$password = "your_password";
$dbname = "your_database";

$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
    die("连接失败: " . $conn->connect_error);
}

// save_data.php
require("connect.php");

$name = $_POST["name"];
$age = (int)$_POST["age"];

$sql = "INSERT INTO survey_data (name, age) VALUES ('$name', $age)";

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

$conn->close();

3. Data processing and statistical analysis
After the data is stored, the data can be processed and analyzed to obtain valuable insights. in conclusion. The following is an example code for using PHP to implement statistical analysis of data:

// analyze_data.php
require("connect.php");

$sql = "SELECT age, COUNT(*) AS count FROM survey_data GROUP BY age";

$result = $conn->query($sql);

if ($result->num_rows > 0) {
    while ($row = $result->fetch_assoc()) {
        echo "年龄: " . $row["age"] . "，人数: " . $row["count"] . "<br>";
    }
} else {
    echo "没有数据";
}

$conn->close();

4. Data display and visualization
Finally, the processed and analyzed data will be displayed to the user in the form of a chart or table. Present results more visually. The following is a sample code that uses PHP to display data in tabular form:

// display_data.php
require("connect.php");

$sql = "SELECT * FROM survey_data";

$result = $conn->query($sql);

if ($result->num_rows > 0) {
    echo "<table>";
    echo "<tr><th>姓名</th><th>年龄</th></tr>";
    while ($row = $result->fetch_assoc()) {
        echo "<tr><td>" . $row["name"] . "</td><td>" . $row["age"] . "</td></tr>";
    }
    echo "</table>";
} else {
    echo "没有数据";
}

$conn->close();

Conclusion:
Through the above code examples, we have learned how to use the PHP language to implement data investigation and statistical analysis functions. Data collection, storage, processing and display are important aspects of data investigation and statistical analysis, and PHP, as a flexible and easy-to-use scripting language, can facilitate data processing and analysis. I hope this article will be helpful to everyone and can play a positive role in practical applications.

The above is the detailed content of How to use PHP to implement data investigation and statistical analysis functions. For more information, please follow other related articles on the PHP Chinese website!