Accessing value of index of array within array

Question

I have an array of arrays called $excelData. print_r($excelData) returns the following:

Array ( 
[0] => Array ( 
              [0] => Array ( 
                              [0] => name 
                              [1] => test 
                              [2] => 4 
                              [3] => [email protected] 
                              [4] => it4249 
                              [5] => sha256:1000: 
                             ) 
              ) 
[1] => Array ( 
              [0] => Array ( 
                              [0] => fseconf 
                              [1] => test2 
                              [2] => 3 
                              [3] => [email protected] 
                              [4] => ft9655 
                              [5] => sha256:1000: 
                                         ) 
               ) 
)

and I'm trying to print the 4th index in each case (i.e. it4249 and ft955) with the following code:

$query = "INSERT INTO tblTest (username, fname, surname, year, email) VALUES";
$qPart = array_fill(0, count($excelData), "(?, ?, ?, ?, ?)");
$query .=  implode(",",$qPart);
$sth = $dbh->prepare($query);
$i = 1;

print_r($excelData);
echo "<br />";
echo "<br />";

Foreach($excelData As $Row){

          echo "Username: ".$Row[0][4];
          echo "<br />";
          echo "<br />";
          $sth->bindValue($i++, $Row[0][4]);
          $sth->bindValue($i++, $Row[0][0]);
          $sth->bindValue($i++, $Row[0][1]);
          $sth->bindValue($i++, $Row[0][2]);
          $sth->bindValue($i++, $Row[0][3]); 
 }

But it simply prints it4249 both times. Why does this not work and how do I get this right?

EDIT:

Changing my loop to pass by reference as below solves my problem but I have no idea why - any explanations?

Foreach($excelData As &$Row){
}

Oh strange - I've added the rest of my code in that loop in case there's something else going on? — baarkerlounger
– baarkerlounger, Commented Feb 9, 2014 at 7:53
What does $sth show? Also the same values or diffrent ones? And you can do $Row[0][4] without the quotes. — Michel
– Michel, Commented Feb 9, 2014 at 8:07

Michel · Accepted Answer · 2014-02-09 10:05:02Z

1

A little snippet to possibly find where it goes wrong. Place if before you define your query to see if it ouputs what you expect, and if it's ok after the query, and so on.

<?php
 reset($excelData);
 echo count($excelData)."<br>"; //should be 2
    do{
      echo 'KEY: '.key($excelData); //fist 0, then 1
       $tmp=current($excelData);
       echo '<pre>'.print_r($tmp,true).'</pre><br>';
       }
    while(next($excelData));
?>

It gives me the output you showed. If not, there's defenitely something wrong with your array.

answered Feb 9, 2014 at 10:05

Michel

4,1554 gold badges39 silver badges57 bronze badges

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

2 Comments

baarkerlounger Over a year ago

Yep putting this snippet directly before my Foreach loop gives me the exact array output I have above that I expect. Within my Foreach loop I'm still just echoing the same value twice though.

Michel Over a year ago

Maybe, and it's just a maybe, print_r($excelData) causes a problem. If you remove that? or make it print_r($excelData,true)?

Shankar Narayana Damodaran · Accepted Answer · 2014-02-09 07:52:16Z

0

Nest down 3 times.

foreach ($other as $arr)
{
    foreach($arr as $arr1)
    {
        foreach($arr1 as $k=>$v)
        {
        if($k==4)
        {
            echo $v.'<br/>';
            break; // as suggested by u_mulder
        }
        }
    }
}

OUTPUT :

it4249
ft9655

Demo

edited Feb 9, 2014 at 7:52

answered Feb 9, 2014 at 7:41

Shankar Narayana Damodaran

68.6k43 gold badges102 silver badges129 bronze badges

4 Comments

u_mulder Over a year ago

Use break then to stop executing last foreach after proper value found.

u_mulder Over a year ago

if ($k==4) works then there's no need to loop further last foreach. if($k==4) { echo $v.'<br/>'; break; }

Shankar Narayana Damodaran Over a year ago

Oh you are right. Added the break; Gave your creds in the code.

baarkerlounger Over a year ago

Supporting the theory that the error is not where I thought it was - this also doesn't work for me it also prints the first value twice

sud_shan · Accepted Answer · 2014-02-09 08:01:31Z

0

I have run your code . It works. There may be some problem with your array()

check demo

Check demo

answered Feb 9, 2014 at 8:01

sud_shan

3033 silver badges12 bronze badges

Collectives™ on Stack Overflow

Accessing value of index of array within array

3 Answers 3

2 Comments

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related