PHP数组值偏移调整求助：修正Excel导入数据库年龄错位问题

Got it, let's sort out this age row-shift problem you're facing when importing Excel data into your PHP database. Here's a straightforward, adaptable solution to adjust the array exactly as you need:

Step 1: Structure your original array #

First, let's formalize your input array in valid PHP syntax:

$originalArray = [
    ['Name', 'Age'],
    ['Name 1', 20],
    ['Name 2', 21],
    ['Name 3', 22],
    ['Name 4', 23],
    ['Name 5', 24],
];

Step 2: Generate the adjusted array #

We'll loop through the original data, pairing each name with the age from the next row (and handle the final row by extending the age sequence):

$adjustedArray = [];
$totalRows = count($originalArray);

for ($i = 0; $i < $totalRows; $i++) {
    // Grab the name from the current row
    $name = $originalArray[$i][0];
    
    // Assign the correct age based on position
    if ($i < $totalRows - 1) {
        // For all rows except the last, use age from the next row to fix the shift
        $age = $originalArray[$i + 1][1];
    } else {
        // For the final row, increment the existing age to maintain the sequence
        $age = $originalArray[$i][1] + 1;
    }
    
    // Add the corrected pair to the new array
    $adjustedArray[] = [$name, $age];
}

Step 3: Check the result #

If you print $adjustedArray, you'll get exactly the output you requested:

// Output:
[
    ['Name', 20],
    ['Name 1', 21],
    ['Name 2', 22],
    ['Name 3', 23],
    ['Name 4', 24],
    ['Name 5', 25],
]

Quick breakdown of how this works: #

• For every row except the last, we match the current row's name with the next row's age—directly fixing the错位 (row shift) from your Excel import.
• For the final entry, since there's no subsequent row to pull an age from, we increment the last existing age by 1 to keep the sequence consistent (as shown in your desired output).

This code is flexible too—if your Excel import has more rows down the line, it’ll automatically handle them without needing edits.

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