current community

your communities

more stack exchange communities

company blog
Stack Exchange Inbox Reputation and Badges
tour help
stack overflow careers
Sign up ×
Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them, it only takes a minute:
up vote 0 down vote favorite

I researched this subject many times but I could not find the right answer to my question. Let me explain it.

I'm creating an app with the Google Maps API where I want to have multiple locations shown on the map, based on my database values. I'm having an object called Locations in my javascript, where I store the the variables 'name', 'lat' and 'lon' (latitude, longtitude).

var Locations =
[{  
    name: 'test',
    lat: 52.351753, 
    lon: 5.002035 

  }, 
  {     
    name: 'test2',
    lat: 52.390839, 
    lon: 4.908722

  }];

This part is where I store my locations. Although this is working, it is hardcoded. So, I want to get all my mysql database values out of the database into my javascript variable dynamically. I foreach'd through the database entry's with PHP: 

    foreach ($query as $post)
    {
        ?> <h1><?php echo $post['naam'] ?></h1> 
               <p><?php echo $post['plaats'] ?></p> 
               <p><?php echo $post['categorie'] ?></p> 
               <?php
    }

Now I tried to get all of those values and put them into my javascript variable, but without any succes.

var bedrijven = <?php echo json_encode($post); ?>;

When I console.log 'bedrijven' i'm only getting the last entry, but I want every row stored. Can someone help me with this? Would be really cool if it worked.

I hope I explained well enough.

Thanks!

share|improve this question
    
You need to show the output value of <?php echo json_encode($post); ?>; – Diodeus Oct 23 '13 at 18:26

3 Answers 3

up vote 0 down vote accepted

Try:

PHP:

function getMarkers(){
    $response = array();

    foreach ($query as $post) {

    $response[] = array(
        'name' => $post['naam'],
        'lat' => $post['plaats'],
        'lng' => $post['categorie'],
    );
}
echo json_encode($response);
}

then JS:

function addMarkers(json){
    var title =json[index]["naam"];
    var lat =json[index]["plaats"];
    var lng =json[index]["categorie"];

    marker = new google.maps.Marker({
        position: new google.maps.LatLng (lat, lng),
        map: YOUR_MAP
    });
}

jQuery.getJSON("URL OF PAGE",{
    format: "json",
    dataType: 'json',
    contentType: "application/json; charset=utf-8"},
    function(json){addMarkers(json);
});

better, to send the info with json and retrieve it with jQuery's getJSON, this may need some tweaking.. But I have created what your talking about. Shout if any further help is required.

You May have to look into this a tiny bit to configure it..

GOOD LUCK!

share|improve this answer
    
Thanks BRO! This is what I searched for... Really thanks! – Marciano Oct 26 '13 at 12:11
up vote 1 down vote

$post is your iteration variable, so it only contains one element of the array at a time. If you want the entire array, assign that:

var bedrijven = <?php echo json_encode($query); ?>;
share|improve this answer
    
True, tried that but that didnt work either. $query was just giving me the actual SQL query. – Marciano Oct 26 '13 at 12:11
    
The foreach ($query as $post) in your question implies that $query is an array of results. – Barmar Oct 26 '13 at 12:12
up vote 0 down vote

The examples on http://us1.php.net/json_encode should be helpful. It looks like your $post should be an associative array:

$post[] = ("name"=>"test","lat"=>52.351753, "lon"=> 5.002035); ?>
var bedrijven = <?php echo json_encode($post); ?>;

outputs:

var bedrijven = [{"name":"test","lat":52.351753,"lon":5.002035}];

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.