dpr77335 2015-01-12 16:05
浏览 38
已采纳

地理位置插入到sql中

I want to parse users geolocation into my database.

In my database there are 2 rows called: latitude and longitude, I want the location to be stored into those rows.

Here is the HTML5 API that gets the location:

<script>
    var x=document.getElementById("demo");
    function getLocation() {
        if (navigator.geolocation) {
            navigator.geolocation.getCurrentPosition(showPosition);
        } else {
            x.innerHTML="Geolocation is not supported by this browser.";}
        }

    function showPosition(position) {
        x.innerHTML="Latitude: " + position.coords.latitude + 
    "<br>Longitude: " + position.coords.longitude;  
    }

    getLocation();

</script>

Here is the page that has the submit form

<div class="modal" id="myModal">
    <div class="modal-dialog">
        <div class="modal-content">
            <div class="modal-header">
                <button type="button" class="close" data-dismiss="modal" aria-hidden="true"><span class="fui-cross"></span></button>
                <h4 class="modal-title"><center>Post</center></h4>
            </div>
            <div class="modal-body">
                <form action="parse_post.php" method="post" name="form1" enctype="multipart/form-data">
                    <input name="post_type" type="hidden" value="a" />
                    <div class="form-group">
                        <textarea class="form-control" name="description" rows="6" maxlength="450" placeholder="write something"></textarea>
                    </div>
                    <div class="pull-right">
                    </div>
                    <div class="form-group">          
                        <div id="demo" onLoad=""></div>          
                        <div class="pull-right">
                            <input name="" type="submit" class="btn btn-info" value="Post" onclick="javascript:return validateMyForm();"/> 
                            <input name="uid" type="hidden" value="<?php echo $_SESSION['id']; ?>" />
                            <input name="upass" type="hidden" value="<?php echo $_SESSION['userpass']; ?>" />        
                        </div>
                    </div>

Any help would be appreciated Thanks

  • 写回答

1条回答 默认 最新

  • drny60365 2015-01-12 16:08
    关注

    #Demo is not a form field, so when you submit it nothing will be passed to the server. Try this instead

    <input id="demo" type="text" />
    

    Script

    <script>
        var x=document.getElementById("demo");
        function getLocation()
        {
            if (navigator.geolocation)
            {
                navigator.geolocation.getCurrentPosition(showPosition);
            }
            else
            {
                x.value = "Geolocation is not supported by this browser.";
            }
        }
    
        function showPosition(position)
        {
            x.value ="Latitude: " + position.coords.latitude + 
            "<br>Longitude: " + position.coords.longitude;  
        }
        getLocation();
    
    </script>
    

    UPDATE

    I figured there'd be more to this. Doesn't make sense to send those values as a combined string. Do this instead:

    <input id="latitude" name="latitude" type="text" />
    <input id="longitude" name="longitude" type="text" />
    

    Script

    <script>
        function getLocation()
        {
            if (navigator.geolocation)
            {
                navigator.geolocation.getCurrentPosition(showPosition);
            }
        }
    
        function showPosition(position)
        {
            document.getElementById("latitude").value = position.coords.latitude; 
            document.getElementById("longitude").value = position.coords.longitude; 
        }
        getLocation();
    
    </script>
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 seatunnel-web使用SQL组件时候后台报错,无法找到表格
  • ¥15 fpga自动售货机数码管(相关搜索:数字时钟)
  • ¥15 用前端向数据库插入数据,通过debug发现数据能走到后端,但是放行之后就会提示错误
  • ¥30 3天&7天&&15天&销量如何统计同一行
  • ¥30 帮我写一段可以读取LD2450数据并计算距离的Arduino代码
  • ¥15 C#调用python代码(python带有库)
  • ¥15 飞机曲面部件如机翼,壁板等具体的孔位模型
  • ¥15 vs2019中数据导出问题
  • ¥20 云服务Linux系统TCP-MSS值修改?
  • ¥20 关于#单片机#的问题:项目:使用模拟iic与ov2640通讯环境:F407问题:读取的ID号总是0xff,自己调了调发现在读从机数据时,SDA线上并未有信号变化(语言-c语言)