<?php error_reporting(0); ini_set("display_errors", 0); require_once "../mysql.class.php"; $db = new MySqlClass(); $db->conectar("casablancanew"); $dia = date('w'); $hora = date('H'); if ($hora >= 8 and $hora < 14) { $hora = 1; } if ($hora >= 14 and $hora <= 23) { $hora = 2; } if ($dia >= 1 and $dia <= 4) { $dia = 1; } if ($dia == 6 or $dia == 5) { if ($hora >= 8 and $hora < 14) { $hora = 1; } if ($hora >= 14 and $hora <= 23) { $hora = 2; } $dia = 2; } if ($dia == 0) { if ($hora >= 8 and $hora < 14) { $hora = 1; }
<script type="text/javascript" src="js/jquery-1.5.min.js"></script> <script src="js/thickbox-compressed.js" type="text/javascript"></script> <script type="text/javascript" src="http://maps.google.com/maps/api/js?sensor=false"></script> <script type="text/javascript"> //初始化地图 function initialize(){ var myOptions = { zoom:9, center:new google.maps.LatLng(39.9056266666667,116.38993), mapTypeId: google.maps.MapTypeId.ROADMAP } var map = new google.maps.Map(document.getElementById("mainMap"),myOptions); setMarkers(map,beaches); } <?php $DB = new MySqlClass(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME); $sql = "SELECT a.code, c.username, note, latitude, longitude, create_date, altitude, address_zh FROM `cta_message` a JOIN cta_members_imei b ON a.send_account = b.imei JOIN cta_members c ON b.uid = c.uid ORDER BY `code` DESC LIMIT 0 , 10 "; $result = $DB->ExeSql($sql); echo "var beaches = ["; while ($row = $DB->getRowResult($result)) { $code = $row['code']; $username = $row['username']; $note = $row['note']; $latitude = $row['latitude']; $longitude = $row['longitude']; $altitude = $row['altitude']; $create_date = $row['create_date']; $address = $row['address_zh']; echo "['{$username}:{$note}<br/>{$address}', {$latitude}, {$longitude}, 4],\n"; } echo "['Maroubra Beach', -33.950198, 151.259302, 1]];";
<?php require_once '../config.inc.php'; require_once '../include/db_class.php'; $colorArray = array("black", "brown", "green", "purple", "yellow", "blue", "gray", "orange", "red", "white"); $DB = new MySqlClass(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME); if (!$_GET['uid']) { //无此用户ID时显示所有信息 $sql = ""; } else { $uid = $_GET['uid']; $sql = "SELECT * FROM `cta_message` a JOIN `cta_members_imei` b on a.send_account=b.imei WHERE b.uid={$uid} ORDER BY `a`.`code` DESC LIMIT 0 , 8 "; $result = $DB->ExeSql($sql); $imgurl = "http://maps.google.com/maps/api/staticmap?&size=305x305&maptype=roadmap"; $listnote = ""; $bigMap = ""; $i = 1; while ($row = $DB->getRowResult($result)) { $note = $row['note']; $latitude = $row['latitude']; $longitude = $row['longitude']; $create_date = $row['create_date']; $imgurl .= "&markers=color:" . $colorArray[$i - 1] . "|label:{$i}|{$latitude},{$longitude}"; $listnote .= "<li>{$note}|{$create_date}</li>"; $bigMap .= "['{$note}', {$latitude}, {$longitude}, 4],"; $i += 1; } $imgurl .= "&sensor=false"; } switch (@$_GET['fun']) { case 'big':
<? include("mysql.class.php"); $db= new MySqlClass(); $db->conectar("casablancanew"); $dia=date('w'); $hora=date('H'); if ($hora>=8 and $hora<14){ $hora=1; } if ($hora>=14 and $hora<=23){ $hora=2; } if ($dia>=1 and $dia<=4){ $dia=1; } if ($dia==6 or $dia==5){ if ($hora>=8 and $hora<14){ $hora=1; } if ($hora>=14 and $hora<=23){ $hora=2; } $dia=2; }