Databases
StackOverflow2013
Postsdbo
POget values from multidimensional array with objects
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POget values from multidimensional array with objects
    text
    copied!<p>I've used a little script for importing mt940 files (file of dutch bank transactions).</p> <p>This is the array I get back but I need a little bit help to get the right values out of the array.</p> <pre><code>Array ( [0] =&gt; Statement_banking Object ( [_bank:Statement_banking:private] =&gt; ING [_account:Statement_banking:private] =&gt; 111111111 [_transactions:Statement_banking:private] =&gt; Array ( [0] =&gt; Transaction_banking Object ( [account:Transaction_banking:private] =&gt; 111111111 [accountName:Transaction_banking:private] =&gt; V. DE JONG KERKSTRAAT 1154 1234 BW [price:Transaction_banking:private] =&gt; 0.56 [debitcredit:Transaction_banking:private] =&gt; C [description:Transaction_banking:private] =&gt; 0111111111 V. DE JONG KERKSTRAAT 1154 1234 BW ENSCHEDE BET.KENM. 1004510036716378 3305330802 AFLOSSINGSTERMIJN 188616 / 1E TERMIJN [valueTimestamp:Transaction_banking:private] =&gt; 1279749600 [entryTimestamp:Transaction_banking:private] =&gt; 1279749600 [transactionCode:Transaction_banking:private] =&gt; 078 ) [1] =&gt; Transaction_banking Object ( [account:Transaction_banking:private] =&gt; 111111111 [accountName:Transaction_banking:private] =&gt; CUSTOMER NL SPOEDBETALING [price:Transaction_banking:private] =&gt; 10.45 [debitcredit:Transaction_banking:private] =&gt; C [description:Transaction_banking:private] =&gt; 0111111111 CUSTOMER NL SPOEDBETALING GE2009120212345 RE091202­3737 /RFB/NL­FMI­021209 NL­FMI­021209 VOORSCHOT COMMISSIE [valueTimestamp:Transaction_banking:private] =&gt; 1279749600 [entryTimestamp:Transaction_banking:private] =&gt; 1279749600 [transactionCode:Transaction_banking:private] =&gt; 077 ) [2] =&gt; Transaction_banking Object ( [account:Transaction_banking:private] =&gt; [accountName:Transaction_banking:private] =&gt; [price:Transaction_banking:private] =&gt; 10000.99 [debitcredit:Transaction_banking:private] =&gt; D [description:Transaction_banking:private] =&gt; VERZAMELBETALING BATCH­ID: 012345 TOTAAL 198 POSTEN [valueTimestamp:Transaction_banking:private] =&gt; 1279749600 [entryTimestamp:Transaction_banking:private] =&gt; 1279749600 [transactionCode:Transaction_banking:private] =&gt; 029 ) ) [_startPrice:Statement_banking:private] =&gt; 44 [_endPrice:Statement_banking:private] =&gt; 9945 [_timestamp:Statement_banking:private] =&gt; 1279749600 [_number:Statement_banking:private] =&gt; 100 ) ) </code></pre> <p>This key for example gives me the name and the address:</p> <pre><code>[accountName:Transaction_banking:private] =&gt; V. DE JONG KERKSTRAAT 1154 1234 BW </code></pre> <p>This key gives me the transaction price:</p> <pre><code>[price:Transaction_banking:private] =&gt; 0.56 </code></pre> <p>Any suggestions?</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload