use multi dimensional array outside loop scope in php

Question

i want to use arrData array outside loop too, how to declare it outside loops scope, as if now it is not being populated correctly

  $SQL = "SELECT * FROM DailyData WHERE User='$_SESSION[userID]'"; 
    $result = mysql_query($SQL); 
    $i=0; 
    // trying this
    $arrData= array();
    $arrData []= array();
    while($row = mysql_fetch_array($result)) 
    { 
    echo $row['Score'] . " " . $row['Date']; 
    $arrData[i][1]=$row['Date']; 
    $arrData[i][2]=$row['Score']; 
    $i++; 
    echo "<br />"; 
    }

Can you be a little more specific, it appears that your variable $arrData is residing within the outer scope of the while-loop.. so this code should be golden — Garuda
– Garuda, Commented Aug 7, 2011 at 22:25
but how to properly declare it outside loop's scope, because it is not getting populated right — PUG
– PUG, Commented Aug 7, 2011 at 22:27
Just use $arrData = array(); You dont need the $arrdata [] = array(); when youŕe in the loop and specify the $arrData[i][x], it will automagically create an array on i for you — Garuda
– Garuda, Commented Aug 7, 2011 at 22:28

Peter Ajtai · Accepted Answer · 2011-08-07 22:41:55Z

2

$arrData is available outside the scope of the while loop.

Looks like you forgot the dollar sign:

$arrData[i][1]=$row['Date']; 
$arrData[i][2]=$row['Score'];

Should be

$arrData[$i][1]=$row['Date']; 
$arrData[$i][2]=$row['Score'];

In the original, PHP thinks you mean $arrData['i'], which means you keep over writing $arrData['i'][1] and $arrData['i'][2] - however, you are incrementing $i, so you want to to make use of that variable - $arrData[$i][1] and $arrData[$i][2].

edited Aug 7, 2011 at 22:41

answered Aug 7, 2011 at 22:35

Peter Ajtai

57.8k13 gold badges124 silver badges143 bronze badges

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

Comments

Quasdunk · Accepted Answer · 2011-08-07 22:31:42Z

1

I guess this may be what you're looking for:

  $SQL = "SELECT * FROM DailyData WHERE User='$_SESSION[userID]'"; 
  $result = mysql_query($SQL); 
  $arrData= array();

  while($row = mysql_fetch_array($result)) 
  { 
    $arrData[]=$row;
    //you can also do some output here if you want
  }

  //arrData is now available outside the while-loop
  foreach($arrData as $row) {
    echo $row['Score'] . ' ' . $row['Date'] . '<br />'; 
  }

answered Aug 7, 2011 at 22:31

Quasdunk

15.2k3 gold badges39 silver badges47 bronze badges

1 Comment

Garuda Over a year ago

What you are doing here is exactly the same as $arrData = mysql_fetch_array($result); btw :p

Collectives™ on Stack Overflow

use multi dimensional array outside loop scope in php

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related