Multidimensional array for data table

Question

How to Select key values by index

I want to create datatable but I do not know how to select exact array[1] with key values. Now my datatable cycle returns nothing

Array
(
[0] => Array
    (
        [0] => Array
            (
                [success] => 1
                [error] => 0
                [error_note] => 
            )

    )

[1] => Array
    (
        [0] => Array
            (
                [type_pay] => 0
                [oper_type] => 4
                [name_pay] => CLICK
                [name_oper] => Основной долг
                [time_pay] => 2016-05-01 00:00:00
                [amount] => 1461128
            )

        [1] => Array
            (
                [type_pay] => 1
                [oper_type] => 3
                [name_pay] => Наличные
                [name_oper] => Депозит
                [time_pay] => 2016-05-01 00:00:00
                [amount] => 207866
            )

I somehow started in PHP and decoded the Json into array

$data["reports"] = json_decode(file_get_contents('URL'), true);

I'd recommend starting by reading the php manual pages for arrays — Dale
– Dale, Commented Jun 3, 2016 at 11:26

Manjeet Barnala · Accepted Answer · 2016-06-03 13:09:40Z

1

This code will work for you, Use PHP LIST to print key to value of an array ...

<?php 
$data['reports'] = array(
                0 => array
                    (
                        0 => array
                            (
                                'success' => 1,
                                'error' => 0,
                                'error_note' => ''
                            )

                    ),
                1 => array
                    (
                        0 => array
                            (
                                'type_pay' => 0,
                                'oper_type' => 4,
                                'name_pay' => 'MNP',
                                'name_oper' => 'OPQ',
                                'time_pay'=> '2016-05-01 00:00:00',
                                'amount' => 1461128
                            ),
                         1 => array
                            (
                                'type_pay' => 1,
                                'oper_type' => 3,
                                'name_pay' => 'XYZ',
                                'name_oper' => 'ABC',
                                'time_pay' => '2016-05-01 00:00:00',
                                'amount' => 207866
                            )
                        )
                    );  

foreach($data['reports'][1] as $key => $val)
{
    while(list($k, $v) = each($val)){
        echo $k.' : '.$v.'<br>';
    }
}   
?>

This will give you :

type_pay : 0
oper_type : 4
name_pay : MNP
name_oper : OPQ
time_pay : 2016-05-01 00:00:00
amount : 1461128
type_pay : 1
oper_type : 3
name_pay : XYZ
name_oper : ABC
time_pay : 2016-05-01 00:00:00
amount : 207866

LIVE EXAMPLE : CLICK HERE

edited Jun 3, 2016 at 13:09

answered Jun 3, 2016 at 11:48

Manjeet Barnala

2,9951 gold badge13 silver badges21 bronze badges

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

6 Comments

Ravshan Abdurasulov Over a year ago

I dont know why but it returns me ("Invalid argument supplied for foreach")

Manjeet Barnala Over a year ago

but as per your your array format, I'm using the same format then please verify format of your array and let me know @RavshanAbdurasulov

Ravshan Abdurasulov Over a year ago

when I am debugging that comes for me which I putted in question however I do not know why this problem showing

Manjeet Barnala Over a year ago

@RavshanAbdurasulov Now I've replaced foreach loop in answer, try now

Ravshan Abdurasulov Over a year ago

yes there only two code first my decoding and your cycle

|

Collectives™ on Stack Overflow

Multidimensional array for data table

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related