最近要做一个网页,具体内容是:上边有一个标题,下边分成两块,左边是地图。并且地图上有两个点,点击两个点有相应的提示信息,显示里最新的两条数据信息。右边是一些文字说明。本人刚开始学习,做的也不是很好
总体效果如下所示:
首先新建map.php文件,代码如下
/*
创建与数据库的连接
*/
$conn=mysql_connect("","","") or die("can not connect to server");
mysql_select_db("hdm0410292_db",$conn);
mysql_query("set names utf8");
//选择出两辆车插入的最新数据,并将两条语句存在数组里
$sql0="select * from car_info where carid='20140508'order by id desc limit 1";
$sql1="select * from car_info where carid= '20140510' order by id desc limit 1";
$sql=array($sql0,$sql1);
?>
车联网信息展示html{
height:99%}
body{
height:99.9%;
width:99%;
font-family:楷体_gb2312;
font-size:25px}
#container {height: 100%}
var lon_center = 0;
var lat_center = 0;
var map = new bmap.map("container");
function addmarker(point,index,s){
var ficon = new bmap.icon("car1.png", new bmap.size(55, 43), {
});
var sicon = new bmap.icon("car2.png", new bmap.size(55, 43), {
});
var myicon = "";
// 创建标注对象并添加到地图
if(index == 20140508)
myicon=ficon;
else
myicon=sicon;
var marker = new bmap.marker(point, {icon: myicon});
map.addoverlay(marker);
marker.addeventlistener("click",function(){
var opts={width:450,height:500,title:"详细信息"};
var infowindow = new bmap.infowindow(s,opts);
map.openinfowindow(infowindow,point);
});
}
//遍历数组里的两条sql语句
foreach ($sql as &$value) {
$query=mysql_query($value);
$row=mysql_fetch_array($query);
?>
var lon= <?php echo $row[longitude] ?>;
var lat= <?php echo $row[latitude] ?>;
lon_center += lon;
lat_center += lat;
var id=<?php echo $row[id] ?>;
var info="
"+"carid: " + "<?php echo $row[carid]?>" + "
" +
"经度: " + "<?php echo $row[longitude]?>" + "
" +
"纬度: " + "<?php echo $row[latitude]?>" + "
" +
"速度: " + "<?php echo $row[speed]?>" + "km/h" + "
" +
"加速度: " + "<?php echo $row[acceleration]?>" + "
" +
"方向: " + "<?php echo $row[direction]?>" + "
" +
"油量: " + "<?php echo $row[oil]?>" + "
" +
"地址: " + "<?php echo $row[street]?>";
var point = new bmap.point(lon, lat);
addmarker(point,<?php echo $row[carid] ?>,info);
}
?>
var center = new bmap.point(lon_center/2,lat_center/2);
map.centerandzoom(center, 17);
map.enablescrollwheelzoom();
map.php文件主要是显示数据库里的两条信息,将这两条信息在地图上的相应的位置显示出来。
然后再建title.php,这个很简单,就是显示一个标题
信息展示html{
height:100%;}
body{
height:10%;
width:99%;
font-family:楷体_gb2312;
font-size:25px}
信息展示
然后在建立详细信息说明模块info.php
$conn=mysql_connect("","","") or die("can not connect to server");
mysql_select_db("",$conn);
mysql_query("set names utf8");
$sql0="select * from car_info where carid='20140508'order by id desc limit 1";
$sql1="select * from car_info where carid= '20140510' order by id desc limit 1";
$sql=array($sql0,$sql1);
function htmtocode($content){
$content=str_replace("\n", "
", str_replace(" ", " ", $content));
return $content;
}
?>
信息展示html{
height:90%;}
body{
height:90%;
width:90%;
font-family:楷体_gb2312;
font-size:20px}
信息展示
$query=mysql_query($value);
$row=mysql_fetch_array($query);
?>
car <?php echo $row[carid]?> 详细信息
car id: <?php echo $row[carid]?>
经度: <?php echo $row[longitude]?>
纬度: <?php echo $row[latitude]?>
速度: <?php echo $row[speed]?> km/h
加速度: <?php echo $row[acceleration]?>
方向: <?php echo $row[direction]?>
油量: <?php echo $row[oil]?>
地址: <?php echo $row[street]?>
时间: <?php echo $row[date]?>
最后在写一个vanet.php文件,该文件主要是调用前三个文件
信息展示大功告成!
如您对本文有疑问或者有任何想说的,请点击进行留言回复,万千网友为您解惑!