SQL results to PHP array

Question

I've got the following sql query:

$sql = "SELECT lat, lang
        FROM users";

I then use the following code to put the results of the array into two arrays, one for lat and one for lang.

$i = 0;

foreach($results as $row) {
    $latArray = array();
    $langArray = array();
    $latArray[$i] = $row['lat'];
    $langArray[$i] = $row['lang'];          
    $i = ($i + 1);
}

However, it seems that only the last value that is passed to the array is stored. When I echo out each value of the array I get the following error: Undefined offset: 0 which I believe means theres nothing at latArray[0].

I'm sure I've missed something obvious here but why aren't all the values copied to the new array?

Move the "$latArray = array();" and line after that before foreach. — Fergus
– Fergus, Commented Apr 7, 2013 at 18:05

sybear · Accepted Answer · 2013-04-07 18:05:10Z

3

$i = 0;
$latArray = array(); //Declare once, do not redeclare in the loop
$langArray = array();
foreach($results as $row) {
    $latArray[$i] = $row['lat'];
    $langArray[$i] = $row['lang'];          
    $i = ($i + 1);
}

answered Apr 7, 2013 at 18:05

sybear

7,7921 gold badge25 silver badges38 bronze badges

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

Comments

TheEwook · Accepted Answer · 2013-04-07 18:05:36Z

1

Declare your array before the loop

$latArray = array();
$langArray = array();

foreach($results as $row) {
    $latArray[$i] = $row['lat'];
    $langArray[$i] = $row['lang'];          
    $i = ($i + 1);
}

answered Apr 7, 2013 at 18:05

TheEwook

11.2k6 gold badges39 silver badges55 bronze badges

Comments

user1317647 · Accepted Answer · 2013-04-07 18:08:07Z

1

You should put

$latArray = array();
$langArray = array();

Before foreach cycle (like you do with your counter $i), 'cause with every new value from $result it resets thous values..

so your code will look like:

$i = 0;
$latArray = array();
$langArray = array();
foreach($results as $row) {
    $latArray[$i] = $row['lat'];
    $langArray[$i] = $row['lang'];          
    $i = ($i + 1);
}

answered Apr 7, 2013 at 18:08

user1317647

Comments

Jeffrey Nicholson Carré · Accepted Answer · 2013-04-07 18:08:16Z

0

use fetch_assoc instead:

$latArray = array();
        $langArray = array();
    while($row = mysql_fetch_assoc($your_query)){



    $latArray[$i] = $row['lat'];
    $langArray[$i] = $row['lang'];          
    $i++;
}

if u are using msqli us mysqli_fetch_assoc

answered Apr 7, 2013 at 18:08

Jeffrey Nicholson Carré

3,0381 gold badge28 silver badges46 bronze badges

1 Comment

Jeffrey Nicholson Carré Over a year ago

:) true the array was declared inside the loop

Collectives™ on Stack Overflow

SQL results to PHP array

4 Answers 4

Comments

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related