如何合并存储单个函数的多个列表？SQL类timestamp文本处理遇数组异常

Hey there! Let's tackle your problem head-on—sounds like the core issue is indeed related to variable scope or how you're appending elements to your array, which is why only the last result sticks around. Let's break this down step by step.

First: Why Your Array Only Keeps the Last Element #

The most common culprit here is either:

• Initializing the array inside your function (so it gets reset every time the function runs), or
• Overwriting the array with = instead of appending new elements using [] in your loop.

For example, if you were doing something like this, it would overwrite the array every time:

// ❌ Wrong way - overwrites the array each time
foreach ($sql_results as $row) {
    $time_arrays = explode(':', $row['time_text']); // Replaces the array every loop
}

Instead, you need to initialize the array outside the loop/function and append to it.

Solution 1: Append Results to an External Array #

Initialize your main array outside the function or loop, then add each parsed time array to it using []:

// 1. Initialize your master array outside the loop
$all_time_arrays = [];

// 2. Function to parse the timestamp-like text into [h, m, s]
function parseTimeText($time_str) {
    return explode(':', $time_str);
}

// 3. Loop through your SQL results and append each parsed array
foreach ($sql_results as $row) {
    $time_parts = parseTimeText($row['time_column']);
    $all_time_arrays[] = $time_parts; // Append instead of overwrite
}

// Now $all_time_arrays contains every parsed time array from your SQL data!

Solution 2: Use Reference Passing (Modify the Array Directly in the Function) #

If you prefer handling the appending inside your function, you can pass the master array by reference (using &), which lets the function modify the original array instead of creating a copy:

$all_time_arrays = [];

// The & before $target_array tells PHP to pass the original array, not a copy
function parseAndAppendTime($time_str, &$target_array) {
    $time_parts = explode(':', $time_str);
    $target_array[] = $time_parts;
}

foreach ($sql_results as $row) {
    parseAndAppendTime($row['time_column'], $all_time_arrays);
}

Bonus: Adding Statistics for Your Time Data #

Since you mentioned needing to run statistics on these time values, here's a quick example of how to calculate total hours, minutes, and seconds from all your parsed data:

$total_h = 0;
$total_m = 0;
$total_s = 0;

foreach ($all_time_arrays as $time_parts) {
    // Convert each part to integer and add to totals
    $total_h += (int)$time_parts[0];
    $total_m += (int)$time_parts[1];
    $total_s += (int)$time_parts[2];
}

// Normalize the totals (convert excess seconds to minutes, minutes to hours)
$total_m += floor($total_s / 60);
$total_s = $total_s % 60;
$total_h += floor($total_m / 60);
$total_m = $total_m % 60;

echo "Total accumulated time: {$total_h}:{$total_m}:{$total_s}";

Key Takeaways #

• Always initialize your master array outside loops/functions that generate individual elements.
• Use $array[] = $new_element to append, not $array = $new_element which overwrites.
• Reference passing (&) is a handy tool if you want functions to modify external variables directly.

Hope this fixes your problem and helps you get all your time data merged properly!

内容的提问来源于stack exchange，提问作者user9604534