How can I store results from MySQL to PHP array?

Question

I tried storing data to php array from mysql using under code. But it's not working. This code:

echo $answerArray[count][i];

shows the correct result. But this code:

echo $answerArray[0][0];

doesn´t show anything.

What should I do to fix it? Thank you.

Full code:

   $count = 0; //answer count
   $answerArray = array();
    while ($row = mysqli_fetch_array($resultFromR, MYSQLI_ASSOC)) { //add array from db
     for($i = 0; $i < $questionNumber; $i++) {
     $j = $i + 1;
     $answerArray[count][i] = $row["num$j"];
     echo $answerArray[count][i]; //is working.
     }
$count++;
}
echo '<br />';
echo $answerArray[0][0]; //something wrong!!! I cannot get anything from this.

$answerArray[count][i] ?? Should be $answerArray[$count][$i] for a starter — Yanick Rochon
– Yanick Rochon, Commented Oct 9, 2011 at 7:24

Alon Eitan · Accepted Answer · 2011-10-09 07:24:59Z

2

maybe this will work

 $answerArray[$count][$i] = $row["num$j"];

(add $ before count and i)

answered Oct 9, 2011 at 7:24

Alon Eitan

12k8 gold badges51 silver badges61 bronze badges

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

Comments

Rohit Chopra · Accepted Answer · 2011-10-09 07:24:13Z

1

Not sure but shouldn't the [i] be [$i]?

answered Oct 9, 2011 at 7:24

Rohit Chopra

2,8214 gold badges30 silver badges33 bronze badges

3 Comments

Olli Over a year ago

yes, I think about this too. But he/she says that [i] is working. And it cannot work. AFAIK.

Yanick Rochon Over a year ago

I believe that if your error reporting is set to none, $array[i] is equal to $array['i'] so, this is why it works when echo $array[i] afterwards. But echo $array[0] will not, even if $i = 0, and all that without a single warning

tobyodavies Over a year ago

$foo[i] is equivalent to $foo['i'] if i is not a defined constant, so reading $answerArray[count][i] should work, I assume that is what he means by working and [0][0] not working

Collectives™ on Stack Overflow

How can I store results from MySQL to PHP array?

2 Answers 2

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related