PHP: Delete Array from 2D-Array

Question

I am uploading a CSV file/report with 10 columns but at the end of the CSV file there are a few lines that just give details about the report like

Generated By: XXX

Company Name

Report Run @ 2019-03-14

When I load the array, the keys are just numeric (from 0-9) but I wanted to make it be an associative array based on the column headers. Unfortunately this will not work for the last few lines since the array dimensions are different (1 vs 10)

Here is my code:

$csv = array_map('str_getcsv', file($_FILES['file']['tmp_name']));
array_walk($csv, function(&$a) use ($csv) {
    if(count($csv[0]) != count($a)) {
        $a = null; // Remove the array
    } else {
        $a = array_combine($csv[0], $a); 
    }
});
array_shift($csv); # remove column header

When I do $a = null; it sort of 'deletes it' by replacing it with NULL. When I iterate through the arrays I do if(is_null($row)) continue; to ignore the NULL element. Is there a way to actually delete the array?

Possible duplicate of stackoverflow.com/questions/26377761/…? — Daniel G
– Daniel G, Commented Mar 14, 2019 at 19:37
You could use array_filter() with no callback to remove null elements. — Nigel Ren
– Nigel Ren, Commented Mar 14, 2019 at 19:38
Can you provide a sample CSV with 5 real lines of data and the desired PHP array result? — MonkeyZeus
– MonkeyZeus, Commented Mar 14, 2019 at 19:39
array_filter($csv) was not actually removing the null values — Bijan
– Bijan, Commented Mar 14, 2019 at 19:44
You may find the most straightforward way is to read the file in a loop and only add lines which have the full set of fields. At the moment you are loading the file and processing the whole file twice at least. — Nigel Ren
– Nigel Ren, Commented Mar 14, 2019 at 19:45

Don't Panic · Accepted Answer · 2019-03-14 19:41:23Z

2

I think it's more straightforward without array_walk. array_walk is just going to apply the function to every member of the array. Setting it to null doesn't mean it's gone, it just has a null value as you've seen. If you really want it gone, you need to unset it. Just refer to $csv by key and unset the ones you don't want.

$keys = array_shift($csv);
$expected_count = count($keys);
foreach ($csv as $index => $values) {
    if (count($values) == $expected_count) {
        $csv[$index] = array_combine($keys, $values);
    } else {
        unset($csv[$index]);
    }
}

answered Mar 14, 2019 at 19:41

Don't Panic

41.9k11 gold badges70 silver badges87 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Bijan Over a year ago

I marked this as solution because it solved my problem but I ended up doing if (count($values) != $expected_count) continue; since I realized I don't really need to manipulate the array if I can just skip the rows with incorrect columns and continue parsing within the foreach

Mruf · Accepted Answer · 2019-03-14 19:37:48Z

0

Array_filter($csv); afterwards will remove all null/false/0 from your array.

So it may be smarter to write a custom function to remove null only.

answered Mar 14, 2019 at 19:37

Mruf

8088 silver badges17 bronze badges

Collectives™ on Stack Overflow

PHP: Delete Array from 2D-Array

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related