php - 错误标记图
问题描述
我正在尝试创建一个显示信息(沉积位置和沉积材料重量)的谷歌地图。它只显示一个标记而不是多个。我认为问题是数据归因于变量 $users_dump_map 但我没有修复问题的知识。我应该怎么办?
PHP
<?php
$db_name = 'db.db';
$db_drvr = 'sqlite';
$user_info = Array();
$user_dumps = Array();
$containers = Array();
$users_dumps_map = Array();
try{
$pdo = new PDO("$db_drvr:$db_name");
$ui_query = $pdo->prepare('SELECT * FROM users WHERE id = :user_id');
$ui_query->bindParam(':user_id', $_POST['user_id'], PDO::PARAM_INT);
$ui_query->execute();
$user_info = $ui_query->fetch(PDO::FETCH_ASSOC);
$ud_query = $pdo->prepare('SELECT * FROM garbage WHERE user_id = :user_id');
$ud_query->bindParam(':user_id', $_POST['user_id'], PDO::PARAM_INT);
$ud_query->execute();
$user_dumps = $ud_query->fetchAll(PDO::FETCH_ASSOC);
$c_query = $pdo->prepare('SELECT * FROM containers');
$c_query->execute();
$c_results = $c_query->fetchAll(PDO::FETCH_ASSOC);
foreach( $c_results as $dump ){
$containers[$dump['id']] = $dump['location'];
$users_dumps_map[$dump['id']] = $dump['coord'];
}
}
catch(PDOException $e){
var_dump($e);
$user_info = Array();
$user_dumps = Array();
$users_dumps_map = Array();
}
?>
谷歌地图
echo' <script>
function myMap() {
var myCenter = new google.maps.LatLng('.$users_dumps_map[$dump['container_id']].');
var mapCanvas = document.getElementById("map");
var mapOptions = {
center: myCenter,
zoom: 5
};
var map = new google.maps.Map(mapCanvas, mapOptions);
var marker = new google.maps.Marker({
position: myCenter
});
marker.setMap(map);
var infowindow = new google.maps.InfoWindow({
content: "'.$dump['quantity'].'"
});
infowindow.open(map, marker);
}
</script>';
asfasdf
解决方案
推荐阅读
- sql - MSSQL 对 DB 产品进行排序 每日
- java - Netbeans 忽略 .m2 中安装的 jars
- magento - Magento / CSV 导入 - 产品在商店中不可见
- python - 如何在 Firebase 云消息传递中检查消息传递?
- python - Python firebase数据库浅层获取数据
- java - Spring Boot Thymeleaf 将图像渲染为 base64 字符串
- c# - DateTime.MaxValue 在 mysql 中保存为零
- python - 响应 = request.urlopen(url) 不工作
- python - RuntimeError:pytorch中的cuda运行时错误(8)
- wordpress - 高级自定义字段 - WPML 问题