Table data processing skills in PHP

In website development, tables are a common element used to display data, perform data entry and data processing, etc. In PHP, processing table data is also a relatively common operation. In this article, we will introduce some commonly used PHP table data processing techniques.

1. Get data from the form

In PHP, form data can be obtained through $_POST or $_GET. $_POST is when the form is submitted using the POST method, $_GET is when the form is submitted using the GET method. When there are multiple controls with the same name in the form, you can use an array to save the values ​​of these controls. Such as the following form:

<form method="post" action="">
  <label for="name">姓名:</label>
  <input type="text" name="name"><br>
  <label for="email">邮箱:</label>
  <input type="text" name="email"><br>
  <input type="submit" value="提交">
</form>

In PHP, you can get the form data in the following ways:

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

2. Sort the table data

If you want To sort the data in the table, you can use PHP's built-in functions sort() and rsort(). Among them, sort() is ascending sort and rsort() is descending sort. Both functions change the key values ​​of the array.

For example, sort the following array in ascending order:

$numbers = array(10, 5, 8, 3, 6);
sort($numbers);
print_r($numbers);

The output result is:

Array ( [0] => 3 [1] => 5 [2] => 6 [3] => 8 [4] => 10 )

3. Paging table data

When there is a lot of table data, in order to facilitate users to browse and process, the data needs to be paginated. In PHP, we can use the LIMIT keyword to implement paging. LIMIT can receive two parameters, the first parameter is the offset, and the second parameter is the number of records returned.

For example, if we have a students table with 100 records, we want to display 10 records per page. We can use the following code to achieve this:

$page = isset($_GET['page']) ? $_GET['page'] : 1;
$limit = 10;
$offset = ($page - 1) * $limit;

$query = "SELECT * FROM `students` LIMIT $offset, $limit";

Among them, $page represents the current page number, $limit represents the number of records displayed on each page, and $offset represents the offset.

4. Search table data

When there is a lot of table data, we may need to search the data to quickly find the information we need. In PHP, you can use the LIKE keyword of the SELECT statement to implement fuzzy search.

For example, if we want to search for students whose name contains "Zhang" in the students table, we can use the following code:

$name = isset($_GET['name']) ? $_GET['name'] : '';
$query = "SELECT * FROM `students` WHERE `name` LIKE '%$name%'";

Where, $name represents the search keyword, in the SQL statement Use % to represent the wildcard character.

5. Summary tabular data

When there is a large amount of tabular data, we may need to summarize, count and calculate the data. In PHP, you can use the SUM, AVG, COUNT, MIN and MAX functions of the SELECT statement to achieve this.

For example, if we want to calculate the average score of all students in the students table, we can use the following code:

$query = "SELECT AVG(`score`) FROM `students`";

Where, the AVG function is used to calculate the average.

6. Export table data

When table data needs to be uploaded or saved, we may need to export the data in CSV, Excel or other formats. In PHP, you can use the fputcsv function to save data to a file in CSV format. In Excel, CSV files can be imported into workbooks.

For example, if we want to save the following array as a CSV file:

$students = array(
  array('id', 'name', 'score'),
  array(1, '张三', 80),
  array(2, '李四', 90),
  array(3, '王五', 85),
);

We can use the following code to save it as a CSV file:

$fp = fopen('students.csv', 'w');
foreach ($students as $student) {
    fputcsv($fp, $student);
}
fclose($fp);

The above is what is commonly used in PHP Table data processing skills. Mastering these skills can make it easier for us to process tabular data and improve work efficiency.

The above is the detailed content of Table data processing skills in PHP. For more information, please follow other related articles on the PHP Chinese website!