douye2020 2018-08-13 00:39
浏览 38

错误标记映射

I'm trying to create a Google Maps map that shows info (location of the deposit and weight of the material deposited). It only shows one markers instead of multiple. I think the problem is the atribution of data to the variable $users_dump_map but I don't have the knowledge to repair the problem. What should I do?

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();
        } 
    ?>

GOOGLE MAPS MAP

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

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 基于卷积神经网络的声纹识别
    • ¥15 Python中的request,如何使用ssr节点,通过代理requests网页。本人在泰国,需要用大陆ip才能玩网页游戏,合法合规。
    • ¥100 为什么这个恒流源电路不能恒流?
    • ¥15 有偿求跨组件数据流路径图
    • ¥15 写一个方法checkPerson,入参实体类Person,出参布尔值
    • ¥15 我想咨询一下路面纹理三维点云数据处理的一些问题,上传的坐标文件里是怎么对无序点进行编号的,以及xy坐标在处理的时候是进行整体模型分片处理的吗
    • ¥15 CSAPPattacklab
    • ¥15 一直显示正在等待HID—ISP
    • ¥15 Python turtle 画图
    • ¥15 stm32开发clion时遇到的编译问题