add to array values

Question

I geting from mysql data:

$starcik_o = mysql_query("select id, mapa, miasto, nazwa_obiektu from oferty where id = 28");
        while($data = mysql_fetch_array($starcik_o, MYSQL_ASSOC)) $punkty[] = $data;

And I want to add another table in to this array, I trying to do it like that:

foreach ($punkty as $item)
        {
        $deserialized = unserialize($item['mapa']);
        $punkty['long'] = $deserialized['lng'];
        $punkty['lat'] = $deserialized['lat'];
        }

But it's not working like I want to, becouse var_dump($punkty); showing me

array(3) 
{ 
    [0]=> array(4) 
    { 
    ["id"]=> string(2) "28" 
    ["mapa"]=> string(97) "a:3:{s:3:"lat";s:17:"49.21103723075132";s:3:"lng";s:18:"22.330280542373657";s:4:"zoom";s:2:"17";}" 
    ["miasto"]=> string(5) "Cisna" 
    ["nazwa_obiektu"]=> string(44) "Cisna - noclegi u Mirosławy w Bieszczadach" 
    } 
    ["long"]=> string(18) "22.330280542373657" 
    ["lat"]=> string(17) "49.21103723075132" 
}

Why are you referencing $punkty within your foreach loop? I have never seen this convention before. — Matt
– Matt, Commented Jul 27, 2012 at 13:00
@ariel Also, this is the obligatory note that mysql_* functions are being deprecated. Use PDO (php.net/manual/en/book.pdo.php) or Mysqli (php.net/manual/en/book.mysqli.php) going forward — Matt
– Matt, Commented Jul 27, 2012 at 13:04

Ozerich · Accepted Answer · 2012-07-27 12:59:47Z

3

    foreach ($punkty as &$item)
    {
        $deserialized = unserialize($item['mapa']);
        $item['long'] = $deserialized['lng'];
        $item['lat'] = $deserialized['lat'];
    }

answered Jul 27, 2012 at 12:59

Ozerich

2,0101 gold badge19 silver badges25 bronze badges

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

1 Comment

Mark Baker Over a year ago

Don't forget to unset($item) after the end of the foreach() loop

Lee · Accepted Answer · 2012-07-27 13:00:44Z

1

use

foreach ($punkty as $key => $item)
        {
        $deserialized = unserialize($item['mapa']);
        $punkty[$key]['long'] = $deserialized['lng'];
        $punkty[$key]['lat'] = $deserialized['lat'];
        }

answered Jul 27, 2012 at 13:00

Lee

10.6k4 gold badges39 silver badges45 bronze badges

2 Comments

Ozerich Over a year ago

foreach($punkty as &$item) is shortly

Lee Over a year ago

I agree, it's the way i'd do it too. except i like to suggest solutions that the poster is more likely to have seen or understand. Understanding referencing and when to use them when your new to programming can be difficult, so he's more likely to copy and paste your solution and not actually understand what's going on. However i don't disagree its the better way in most situations

Kanaiya Katarmal · Accepted Answer · 2012-07-27 13:01:16Z

1

$starcik_o = mysql_query("select id, mapa, miasto, nazwa_obiektu from oferty where id = 28");
            while($data = mysql_fetch_array($starcik_o, MYSQL_ASSOC))
{
$punkty1[] = $data[' id'];
$punkty2[] = $data['mapa'];
$punkty3[] = $data['miasto'];
$punkty4[] = $data['nazwa_obiektu'];
.....
}
try this code

answered Jul 27, 2012 at 13:01

Kanaiya Katarmal

6,1384 gold badges32 silver badges56 bronze badges

Comments

newfurniturey · Accepted Answer · 2012-07-27 13:00:56Z

0

Your loop is doing what it's being told to do: it's taking the lat and lng fields from each item and writing it to the $punkty array.

I'm under the assumption that you want the lat and lng fields to be in each individual item though, not the top-level of the array. In that case, change the loop to be:

foreach ($punkty as &$item) {   // added the '&' to reference the item
    $deserialized = unserialize($item['mapa']);
    $item['long'] = $deserialized['lng'];   // saving "long" to item
    $item['lat'] = $deserialized['lat'];    // saving "lat" to item
}

answered Jul 27, 2012 at 13:00

newfurniturey

38.6k10 gold badges99 silver badges105 bronze badges

Collectives™ on Stack Overflow

add to array values

4 Answers 4

1 Comment

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related