Get first element from array using key

Question

I am very new to PHP (coming from JS) so am having trouble debugging this issue.
I have imported a .csv to render to a html table and am trying to retrieve a column so I can order the table. The table contains 5 headings (Date, TransactionNumber, CustomerNumber, Reference, Amount). I can retrieve all of the values except the Date column. That just returns an empty value.

<?php
  $rows = array_map('str_getcsv', file('BankTransactions.csv'));
  $header = array_shift($rows);
  $csv = array();
  foreach ($rows as $row) {
    $csv[] = array_combine($header, $row);
  }

  print_r($csv[0]['Date']);
  print_r("\n")
?>

// .csv
Date,TransactionNumber,CustomerNumber,Reference,Amount
2016-12-10 1:54PM,NUF5V6PT3U,5156,Purchase at JB HiFi,-2498
2016-12-4 4:54AM,J82964EFPS,2347,Refund,5424
2016-12-12 5:25PM,ZUFBQGCKTK,5683,Fee Refund,254
2016-12-01 12:00AM,XHNCASYLBR,2347,Purchase at Coles,-8873
2016-11-23 10:34PM,S98EBHDWG3,3423,Wages,198700
2017-09-23 9:34AM,MPNQYKVJ3G,4657,Purchase at Chemist Warehouse,-584
2015-11-23 10:34PM,74CQKEGSHB,2173,Refund,-3514
2015-11-23 10:35PM,WPTJMNVH4U,4527,Purchase at Hungry Monkey,45245
2017-01-01 12:00AM,U6BD3M75FD,7577,Interest,2778

Strange because using your code (just copy/paste), I got 2016-12-10 1:54PM as output. Could you please set error_reporting(E_ALL); in order to see is there any errors? — mitkosoft
– mitkosoft, Commented Mar 12, 2020 at 9:12
This is disappointing. Its a literal copy paste from my IDE. @mitkosoft where do I set that error_reporting? — Tristan
– Tristan, Commented Mar 12, 2020 at 9:16
@Tristan, paste this line on the very top of your page that contains this script. Is there any other PHP code there that may cause a problem, or that's all btw? — mitkosoft
– mitkosoft, Commented Mar 12, 2020 at 9:17
Guess: Your CSV file is probably encoded in UTF-8 with a BOM? PHP does not handle BOMs properly, so the very first line you read from the file will still contain it at the start, and therefor the first column value will also still contain it. Your key inside the $csv array is not actually Date, but [BOM]Date, but you don’t see it in the print_r output. (See stackoverflow.com/questions/10290849 or gist.github.com/chrisguitarguy/6096271 for suggestions how the BOM can be removed.) — C3roe
– C3roe, Commented Mar 12, 2020 at 9:28

C3roe · Accepted Answer · 2020-03-12 10:29:40Z

2

Your CSV file is probably encoded in UTF-8 with a BOM, Byte Order Mark.

PHP does (still) not handle BOMs properly when reading files, so the very first line you read from the file will still contain it at the start, and therefor the first column value will also still contain it. So your key inside the $csv array is not actually Date, but [BOM]Date, but you don’t see that in the print_r output (a BOM isn’t actually “visible” per se.)

See How to remove multiple UTF-8 BOM sequences or https://gist.github.com/chrisguitarguy/6096271 for suggestions how the BOM can be removed.

answered Mar 12, 2020 at 10:29

C3roe

97.6k15 gold badges100 silver badges172 bronze badges

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

Comments

Ashman Malik · Accepted Answer · 2020-03-17 11:52:40Z

0

You need to fetch the transaction for each field. Here: https://www.php.net/manual/en/function.fgetcsv.php

I am using the exact same CSV file and made a solution for an interview. The CSV file's can be tested on the below link: https://paduademo.azurewebsites.net/

<?php foreach ($transactions as $transaction) : ?>
                    <tr>
                        <td><?php echo $transaction['Date']; ?></td>
                        <td><?php echo $transaction['TransactionNumber']; ?></td>
                        <td><?php echo ($transaction['Valid'])? 'Yes': 'No'; ?></td>
                        <td><?php echo $transaction['CustomerNumber']; ?></td>
                        <td><?php echo $transaction['Reference']; ?></td>
                        <td><span class="<?php echo ($transaction['type'] == 'Credit')? 'text-danger': 'text-success'; ?>"><?php echo (($transaction['type'] == 'Credit')? '-': '') . '$' . $transaction['Amount']; ?></span></td>
                    </tr>
<?php endforeach; ?>

The screenshot is below:

edited Mar 17, 2020 at 11:52

answered Mar 17, 2020 at 11:45

Ashman Malik

2673 silver badges15 bronze badges

1 Comment

Tristan Over a year ago

Ha ha. Looks like you will be getting the job. My final solution was way below that.

Collectives™ on Stack Overflow

Get first element from array using key

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related