1 <?php
2 $pdo=new PDO("mysql:host=127.0.0.1;dbname=1611d","root","root");
3 @$city=$_GET['city'];
4
5 $data=$pdo->query("select * from ditu where city='$city'")->fetch();
6
7 ?>
1 <!DOCTYPE html>
2 <html lang="en">
3 <head>
4 <meta charset="UTF-8">
5 <title>Document</title>
6 </head>
7 <body>
8 <input type="hidden" id="lng" value="<?php echo $data['lng'] ?>">
9 <input type="hidden" id="lat" value="<?php echo $data['lat'] ?>">
10 <form action="add.php" >
11 <table>
12 <tr>
13 <td><input type="text" name="city"></td></tr>
14 <tr><td><script type="text/javascript" src="http://api.map.baidu.com/api?v=2.0&ak=9mPQNpCeTmKvPVmMsHuco1STKlPZjWkN"></script>
15 <div id="allmap" style="width:320px;height:120px"></div>
16 <script type="text/javascript">
17 // 百度地图API功能
18 var map = new BMap.Map("allmap"); // 创建Map实例
19 map.centerAndZoom(new BMap.Point(116.404, 39.915), 11); // 初始化地图,设置中心点坐标和地图级别
20 //添加地图类型控件
21
22 map.enableScrollWheelZoom(true); //开启鼠标滚轮缩放
23 var new_point = new BMap.Point(document.getElementById("lng").value,document.getElementById("lat").value);
24 var marker = new BMap.Marker(new_point); // 创建标注
25 map.addOverlay(marker); // 将标注添加到地图中
26 map.panTo(new_point);
27 </script><input type="submit"></td>
28
29
30 </table>
31 </form>
32 </body>
33
34 </html>
1 <?php
2 $city=$_GET['city'];
3 $url="http://api.map.baidu.com/geocoder/v2/?address={$city}&output=json&ak=r4gLPfHgd4GaddyF1f6oIappbHX6qriA";
4 $urls=file_get_contents($url);
5 $json=json_decode($urls,true);
6 $lng=$json['result']['location']['lng'];
7 $lat=$json['result']['location']['lat'];
8 $pdo=new PDO("mysql:host=127.0.0.1;dbname=1611d","root","root");
9 if($pdo->query("select * from ditu where city='$city'")->fetch()){
10 $pdo->query("select * from ditu where city='$city'")->fetch();
11 }else if($city!=''){
12 $pdo->exec("insert into ditu(city,lng,lat)values('$city','$lng','$lat')");
13 }
14 ?><a href="index.php?city=<?php echo $city ?>">添加成功</a>;