StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
5959616
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2011-05-11T05:22:06.657
FavoriteCount
0
LastActivityDate
2011-05-11T05:27:21.850
LastEditDate
2011-05-11T05:27:21.850
LastEditorUserId
143295
OwnerUserId
143295
ParentId
5959451
PostTypeId
2
Score
2
ViewCount
0
LastEditorDisplayName
text
Body
First of all, you are on the right track, but you just need to understand the separate concepts of server-side and client-side languages and how they can interact. PHP doesn't "pass" variables to JavaScript, but what it does do is generate whatever HTML document you want. That HTML document then can contain JavaScript, which will execute as the page is rendered by the browser. So, think of your PHP as making the JavaScript code: Example of PHP outputting JavaScript code in HTML page: <pre><code><script type="text/javascript"> var testval = "<?php echo "Hello, " . (5 + 3) . "!" ?>"; // "Hello, 8! </script> </code></pre> Now, I looked up the tutorial, and actually the code in your question is not the right code — instead it is the code to create the map, and the lat/long parameters in your example are for the center, not a marker. So, in your PHP page, you want to do the following: <ol> <li>Somewhere, you need to create the map: <code>var map = new google.maps.Map...</code> (as shown in the tutorial)</li> <li>Next, get the <code>$map</code> array with array items containing the <code>'lng'</code> and <code>'lat'</code> keys. (Note: you should always wrap array key names with quotes)</li> <li>Inside an opened script tag use <code><?php</code> to create a PHP code block, and create your <code>foreach</code> loop. For each item, create the JavaScript code needed to create the marker.</li> </ol> Example of foreach loop: <pre><code><script type="text/javascript"> <?php foreach($map as $row) { $lng = $row['lng']; $lat = $row['lat']; ?> // Creating a marker and positioning it on the map new google.maps.Marker({ position: new google.maps.LatLng(<?php echo $lat ?>, <?php echo $lng; ?>), map: map }); <?php } ?> </script> </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POMySQL data in javascript using PHP's foreach loop (Googlel Maps API)
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USNicole
UserOwnerUserId
1. USNicole
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POMySQL data in javascript using PHP's foreach loop (Googlel Maps API)
 singulars
 PostTypePostTypeId
 PTQuestion
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
2. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
3. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTAcceptedByOriginator
CommentsPostId
1. This table or related slice is empty.

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.