gpt4 book ai didi

php - 使用 php 不显示谷歌地图

转载 作者:可可西里 更新时间:2023-11-01 01:04:49 25 4
gpt4 key购买 nike

我有一个 php 代码,它从数据库(测试)和表名 manu 获取位置信息,它是使用 wamp 中的 phpmyadmin 创建的,并使用标记在 map 上显示这些位置。感知经纬度值的位置详情。

已更新

<?
$dbname ='test'; //Name of the database
$dbuser =''; //Username for the db
$dbpass =''; //Password for the db
$dbserver ='localhost'; //Name of the mysql server

$dbcnx = mysql_connect ("$dbserver", "$dbuser", "$dbpass");
mysql_select_db("$dbname") or die(mysql_error());
?>


<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8"/>
<style type="text/css">
body { font: normal 10pt Helvetica, Arial; }
#map { width: 350px; height: 300px; border: 0px; padding: 0px; }
</style>
<script src="http://maps.google.com/maps/api/js?v=3&sensor=false" type="text/javascript" ></script>
<script type="text/javascript" src="js/jquery.js"></script>
<script type="text/javascript">

var icon = new google.maps.MarkerImage("http://maps.google.com/mapfiles/ms/micons/blue.png",
new google.maps.Size(32, 32), new google.maps.Point(0, 0),
new google.maps.Point(16, 32));
var center = null;
var map = null;
var currentPopup;
var bounds = new google.maps.LatLngBounds();
function addMarker(lat, lng, info) {
var pt = new google.maps.LatLng(lat, lng);
bounds.extend(pt);
var marker = new google.maps.Marker({
position: pt,
icon: icon,
map: map
});
var popup = new google.maps.InfoWindow({
content: info,
maxWidth: 300
});

google.maps.event.addListener(marker, "click", function() {
if (currentPopup != null) {
currentPopup.close();
currentPopup = null;
}
popup.open(map, marker);
currentPopup = popup;
});
google.maps.event.addListener(popup, "closeclick", function() {
map.panTo(center);
currentPopup = null;
});
}
function initMap() {
map = new google.maps.Map(document.getElementById("map"), {
center: new google.maps.LatLng(0, 0),
zoom: 14,
mapTypeId: google.maps.MapTypeId.ROADMAP,
mapTypeControl: false,
mapTypeControlOptions: {
style: google.maps.MapTypeControlStyle.HORIZONTAL_BAR
},
navigationControl: true,
navigationControlOptions: {
style: google.maps.NavigationControlStyle.SMALL
}
});


$.getJSON('googlescript.php', function(items)
{
for (var i = 0; i < items.length; i++)
{
(function(item)
{
addMarker(item.lat, item.long, item.name + ' ' + item.desc);
})(items[i]);
}

});


center = bounds.getCenter();
map.fitBounds(bounds);
}

</script>
</head>
<body onload="initMap()" style="margin:0px; border:0px; padding:0px;">
<div id="map"></div>
</body>
</html>

googlescript.php 文件代码:

   <?php

$dbname ='test'; //Name of the database
$dbuser =''; //Username for the db
$dbpass =''; //Password for the db
$dbserver ='localhost'; //Name of the mysql server
$tbl_name ='manu';

$dbcnx = mysql_connect ("$dbserver", "$dbuser", "$dbpass");
mysql_select_db("$dbname") or die(mysql_error());

$query = mysql_query("SELECT * FROM manu")or die(mysql_error());

header('Content-Type: application/json');

$rows = array();
while ($row = mysql_fetch_array($query))
{
$rows[] = $row;
}
echo json_encode($rows);
exit;
?>

最佳答案

HTML 页面

body onload="initMap()" //you forget to close it.<br/>
div id="map"

在 html 文件中进行了以下更改。

script src="http://maps.google.com/maps/api/js?v=3&sensor=false"    type="text/javascript"
script type="text/javascript" src="js/jquery.js"
script type="text/javascript">
var icon = new google.maps.MarkerImage("http://maps.google.com/mapfiles/ms/micons/blue.png",
new google.maps.Size(32, 32), new google.maps.Point(0, 0),
new google.maps.Point(16, 32));
var center = null;
var map = null;
var currentPopup;
var bounds = new google.maps.LatLngBounds();
function addMarker(lat, lng, info)
{
var pt = new google.maps.LatLng(lat, lng);
bounds.extend(pt);
var marker = new google.maps.Marker(
{
position: pt,
icon: icon,
map: map
});
var popup = new google.maps.InfoWindow(
{
content: info,
maxWidth: 300
});<p></p>

<pre><code> google.maps.event.addListener(marker, "click", function()
{
if (currentPopup != null)
{
currentPopup.close();
currentPopup = null;
}
popup.open(map, marker);
currentPopup = popup;
});
google.maps.event.addListener(popup, "closeclick", function()
{
map.panTo(center);
currentPopup = null;
});
}
</code></pre>

<p>function initMap()
{
map = new google.maps.Map(document.getElementById("map"), {
center: new google.maps.LatLng(0, 0),
zoom: 14,
mapTypeId: google.maps.MapTypeId.ROADMAP,
mapTypeControl: false,
mapTypeControlOptions:
{
style: google.maps.MapTypeControlStyle.HORIZONTAL_BAR
},
navigationControl: true,
navigationControlOptions:
{
style: google.maps.NavigationControlStyle.SMALL
}
});</p>

<pre><code>// getjson code goes here which is as below because i was unable to format it here so i wrote it downward.

center = bounds.getCenter();
map.fitBounds(bounds);
</code></pre>

<p>}
/script>
</p>


$.getJSON('googlescript.php', function(items)<br/>
{<br/>
for (var i = 0; i < items.length; i++) <br/>{<br/>
(function(item) <br/>{<br/>
addMarker(item.lat, item.long, item.name + ' ' + item.desc);<br/>
})(items[i]);<br/>
}<br/>
<br/> });

我用过$.getJSON('googlescript.php',所以你需要创建一个 googlescript.php文件并将下面的代码粘贴到其中。


<code>$query = mysql_query("SELECT * FROM manu")or die(mysql_error());

header('Content-Type: application/json');

$rows = array();
while ($row = mysql_fetch_array($query))
{
$rows[] = $row;
}
echo json_encode($rows);
exit;
</code>


?>

现在检查它的运行情况,我相信您会得到想要的结果。不要忘记更改 jquery 路径和更改数据库连接设置,请正确放置 jquery 路径。

关于php - 使用 php 不显示谷歌地图,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/13720383/

25 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com