How To get index row and column in array 2D php

Question

I have an array of data like this . This array is the result of a database query , I want to get the index of rows and columns . I tried to get the index of each row but nonetheless failed. so, can anyone help me?

Query Result

array(
(int) 0 => array( 
            'B' => array(
                        'company' => 'ABC' 
            ), 
            'User' => array( 
                        'company' => 'abc' 
            ), 
            (int) 0 => array(
                            'date_part' => '3',
                            'jumlah' => null, 
                            'jumbuy' => '50990', 
                            'admin' => '50010' 
            ),
            (int) 1 => array(
                            'date_part' => '4',
                            'jumlah' => null, 
                            'jumbuy' => '98990', 
                            'admin' => '2010' 
            )
),
(int) 1 => array(
            'B' => array( 
                        'company' => 'BCD'
            ), 
            'User' => array( 
                            'company' => 'bcd' 
            ), 
            (int) 0 => array( 
                            'date_part' => '3',
                            'jumlah' => null, 
                            'jumbuy' => '65000', 
                            'admin' => '5000' 
            ),
            (int) 1 => array( 
                                'date_part' => '4',
                                'jumlah' => null, 
                                'jumbuy' => '9000', 
                                'admin' => '5000' 
            )
),
(int) 3 => array(
            'B' => array(
                        'company' => 'CDE'
            ), 
            'User' => array( 
                            'company' => 'cde' 
            ), 
            (int) 0 => array(
                            'date_part' => '4',
                            'jumlah' => null, 
                            'jumbuy' => '34566', 
                            'admin' => '2010' 
            )
)
);

Get Index

for ($row = 0; $row < count($array); $row++) {
    for($col = 0; $col < count(.....); $col++ ) {
       echo "Baris [row] kolom [colum]"; // output row and column
    }
}

You can use foreach loop.

chandresh_cool
– chandresh_cool

2015-05-07 06:57:37 +00:00
Commented May 7, 2015 at 6:57 — chandresh_cool
– chandresh_cool, Commented May 7, 2015 at 6:57
@chandresh_cool's can you tell me?

faizal 3696
– faizal 3696

2015-05-07 06:59:47 +00:00
Commented May 7, 2015 at 6:59 — faizal 3696
– faizal 3696, Commented May 7, 2015 at 6:59

Gunaseelan · Accepted Answer · 2015-05-07 07:34:37Z

3

The below code will give you all the indexes of this given array.

I checked the given array with the following code in my localhost.

And it gives us all the keys and the values in this array.

Try this

<?php
foreach($array as $arr=>$value ) 
{
  foreach($value as $ar=>$a)
  {
    echo $ar."<br>"; 
    foreach($a as $res =>$r)
    {
        echo $res.": ";
        echo $r;
        echo "<br>";
    }
  }
}
?>

edited May 7, 2015 at 7:34

answered May 7, 2015 at 7:20

Gunaseelan

2,5405 gold badges41 silver badges45 bronze badges

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

5 Comments

faizal 3696 Over a year ago

how about using the statement for

Gunaseelan Over a year ago

With for loop, It is hard to get the array keys that's why we use foreach loop instead of for.

Gunaseelan Over a year ago

As for as I know, Using for loop, you can get the key and values from single dimensional array. It is hard to get key and values of a multi-dimensional array using for loop. So we prefer foreach loop.

faizal 3696 Over a year ago

#gunaseelan I have seen the link , on the web for looping script for rows and columns have been known for rows and columns

faizal 3696 Over a year ago

#gunaseelan so if I use a script "for with count". the data will automatically show according to the amount of data

pavel · Accepted Answer · 2015-05-07 07:02:41Z

1

Use nested foreach for echoes keys:

foreach ($array as $row => $v) {
    foreach ($v as $col => $val) {
        echo 'row: ' . $row . ', col: ' . $col . '<br>';
    }
}

answered May 7, 2015 at 7:02

pavel

27.3k11 gold badges47 silver badges63 bronze badges

Comments

Jagadeesh · Accepted Answer · 2015-05-07 07:11:14Z

1

use the following

foreach ($values as $inde => $value) {
    foreach ($value as $key => $result) {
        echo '['. $inde.'] ---' .$key . '<br>'; 
    }
}

output will be

[0] ---B
[0] ---User
[0] ---0
[0] ---1
[1] ---B
[1] ---User
[1] ---0
[1] ---1
[3] ---B
[3] ---User
[3] ---0

answered May 7, 2015 at 7:11

Jagadeesh

7541 gold badge6 silver badges26 bronze badges

1 Comment

faizal 3696 Over a year ago

#jagadeesh's how for value?

Collectives™ on Stack Overflow

How To get index row and column in array 2D php

3 Answers 3

5 Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

5 Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related