JSON query to a table?

[joecooper]

Hi,

 

I dont know if many of you have heard of bitcoins? its just a virtual currency with real value...

 

I have got the daemon running for it, and have connected it to PHP.

 

The code i am using to return all transactions is:

 

print_r($bitcoin->listtransactions("")); echo "\n";

 

 

 

This will return:

 

Array

(

    [0] => Array

        (

            [account] =>

            [address] => 1ALtJaqGiShyGMVNRNn77E67PuBKc9FLyo

            [category] => receive

            [amount] => 0.001

            [confirmations] => 13

            [txid] => 0f36872c60da25b29ff3a8efa91d931e26fe1a4354da280f3d69234c8b521c8c

            [time] => 1314115260

        )

 

    [1] => Array

        (

            [account] =>

            [category] => move

            [time] => 1314115550

            [amount] => -0.001

            [otheraccount] => 4

            [comment] =>

        )

 

)

 

 

How could i output this info into a table instead of the above?

 

Thanks

 

 

[requinix]

foreach ($bitcoin->listtransactions("") as $transaction) {
    // insert into database
    // use $transaction["category"] and $transaction["time"] and so on
}

If you aren't sure how to go from there, search for PHP+MySQL tutorials.

[silkfire]

Do you mean an SQL table or an (X)HTML table?

 

If the latter:

 

<table>
<?
   $transactions = $bitcoin->listtransactions('');

   foreach ($transactions as $field) {
?>
      <tr>
         <td><?=$field['account']?></td>
         <td><?=$field['address']?></td>
        <td><?=$field['category']?></td>

         ... and so on ...
      </tr>
<?
   }
?>
</table>

[doddsey_65]

The above answer is good but please dont follow the code to the letter. use of the short tags "<?" can cause alot of problems if your server doesnt have the short_tags option enabled. Get into the habbit of using <?php

[silkfire]

Ye it's common sense to use '<?php' thanks Doddey.

[joecooper]

ahh thanks people! thats what i needed!! i have enabled short tags also .