How to solve php array error problem

Solution to php array error: 1. Fetch data one by one when processing data, with statements such as "while($data = $pdo->fetch()){}"; 2. The data is organized into an array for processing, and can be obtained, processed, and deleted in a loop.

Recommended: "PHP Video Tutorial"

The problem of error reporting when the amount of data in the php array is too large

When doing an excel export, an error will be reported when the amount of data exceeds 2,000 pieces. At first I thought the server or database had crashed. However, when an error is reported, the page responds very quickly, and it does not seem like a server performance problem. Later, after repeated testing, it was found that functions such as fetchAll in pdo were used when processing data to load all the data into an array at once, causing problems similar to memory overflow.

Solution:

When processing the data, you can take the data one by one, such as:

while($data = $pdo->fetch()){
......
}

If you must organize the data into an array and then process it, you can Acquire, process, and delete in a loop, such as:

while($data = $pdo->fetch()){
......
$arr[data['name']][] = $data;
.........
unset($arr);
}

The above is the detailed content of How to solve php array error problem. For more information, please follow other related articles on the PHP Chinese website!