Databases
StackOverflow2013
Postsdbo
POMySQL data in javascript using PHP's foreach loop (Googlel Maps API)
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POMySQL data in javascript using PHP's foreach loop (Googlel Maps API)
    primarykey
    data
    text
    <p>I'm trying to use the Google Maps V3 API to create markers on a google map. I have the coordinates of the markers in mySQL database, and is currently in a PHP array in my .php file. Now how do I use a foreach() loop (or another suitable method) to loop through the elements in my PHP array and create a new google map marker with each iteration of the loop?</p> <p>PS: My PHP is decent, but not my javscript knowledge. The tutorial I'm following now on creating the markers is at <a href="http://www.svennerberg.com/2009/07/google-maps-api-3-markers/" rel="nofollow">http://www.svennerberg.com/2009/07/google-maps-api-3-markers/</a></p> <p><strong>Code</strong></p> <p>I'm using Codeigniter framework, so the controller+model file already retrieved the necessary data(name, lng, lat...) into an array $map. I can loop the array using the usual method:</p> <pre><code>foreach($map as $row) { $lng = $row[lng] // this is not necessary, its just to show what is in the array $lat = $row[lat] // now how do I use this loop to create new marker code in javascript? } </code></pre> <p>The JS code for creating a google map marker which has to be created once per foreach loop iteration is like:</p> <pre><code>var map = new google.maps.Map(document.getElementById('map'), { zoom: 7, center: new google.maps.LatLng($lng, $lat), // how do i pass the PHP variables into the JS code? mapTypeId: google.maps.MapTypeId.ROADMAP }); </code></pre> <p>So my question is how do i pass the PHP variables in the PHP array to create the JS code above, once per each foreach() loop iteration?</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USNyxynyx
    1. USNyxynyxx
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POMySQL data in javascript using PHP's foreach loop (Googlel Maps API)
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    2. VO
      singulars
      1. POMySQL data in javascript using PHP's foreach loop (Googlel Maps API)
      1. This table or related slice is empty.
      1. VTUpMod
    1. COshow some code that you have so far so we can help you
      singulars
      1. POMySQL data in javascript using PHP's foreach loop (Googlel Maps API)
      1. USIbu
    2. COAdded some code into original post...
      singulars
      1. POMySQL data in javascript using PHP's foreach loop (Googlel Maps API)
      1. USNyxynyxx
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload