php - 谷歌地图帮助放置标记

Question

对 PHP/Wordpress 相当陌生我已经看过一百万个地方，但几乎没有找到对我有帮助的地方。我试图从数据库加载位置并显示在 WordPress 页面上(我正在制作自定义插件)，然后将结果映射到谷歌地图实例上。地址已经有纬度和经度。

我可以将其加载并显示在页面上，但不会在 map 上放置标记。任何帮助将不胜感激。

map 实例

<script>
function initialize($Item)
{
var mapProp = {
  center:new google.maps.LatLng(53.548099, -113.522532),
  zoom:18,
  mapTypeId:google.maps.MapTypeId.SATELLITE
  };
var map=new google.maps.Map(document.getElementById("map")
  ,mapProp);
echo ("addMarker($lat, $lon,'<b>$name</b><br/>$desc');\n");
}

google.maps.event.addDomListener(window, 'load', initialize);
</script>

数据库工作

if(isset($_POST['SubmitButton'])){ //check if form was submitted

// Set variables
$data = array();
$input = $_POST['text']; //get input text
$table = $_POST['field']; //get Table
$org = $_POST['org'];

// Check if input is empty

if(!empty($input)){

// Debug line comment out
// echo "<script type='text/javascript'>alert('You Entered: ".$input." from ".$table." looking for ".$org."');</script>";

global $wpdb;

// Check if Organization set to all or something else
if ($_POST['org'] == "All") {

$feed = $wpdb->get_results("SELECT * from wp_NBDonation where $table     like '%{$input}%' order by Type;");
} else { 

$feed = $wpdb->get_results("SELECT * from wp_NBDonation where $table     like '%{$input}%' and Type in('$org','Both');");
}

echo "<ul id='list'>";
// if 0 results display message
    if($feed==null){
        echo "<script type='text/javascript'>alert('No results found.');</script>";
    }else{

if( is_array( $feed ) && count( $feed ) > 0 ) {
foreach($feed as $item){
    $data[] = $feed;
    echo "<li id='item'>";
    echo "<h2>".$item->Type."<br>";
    echo $item->Name."</h2>";
    echo "<hr>";
    echo "<span id='head'>Address:</span><br>";
    echo $item->Address."<br>";
    echo $item->City." ".$item->State_Province."<br>";
    echo $item->Postalcode."<br>";
    echo "<br>";
    echo "<span id='head'>Phone:</span> ".$item->ContactNumber."  <br>";
    echo "<span id='head'>Email: </span> <a href='mailto:".$item->Email."?Subject=Donation Inquiry'>".$item->Email."  </a><br>";
    echo "<span id='head'>Website: </span> <a href='http://".$item->Website."'target=_blank>".$item->Website."</a><br>";
    echo "<br>";
    echo "<span id='head'>Instructions:</span><br>";
    echo $item->ContactInstructions."<br><br>";
    echo "<span id='head'>Payment Method: </span><br>";
    echo $item->PaymentMethod."<br>";
    echo "</li>";  // closes Item
    $lat=$Item->lat;
    $lon=$Item->lng;
    $name=$Item->Name;
    $desc=$Item->Type;

} // end ForEach
} // end if array
} // end if null
echo "<script type='text/javascript'>alert(print_r($data));</script>";

?>
<div id='map'></div>

Answer 1

我不确定 initialize 内部的 AddMarker() 函数引用了什么。

Google Maps API reference for Markers建议两种创建标记的方法:

1. 在初始化中使用 new google.maps.Marker()功能
2. 在初始化函数之外使用 varmarker = new google.maps.Marker()，然后调用 marker.setMap()