JacobHsu · December 22, 2015 08:39
diff --git a/map.php b/map.php
 <?php

 error_reporting(E_ALL^E_NOTICE^E_WARNING); //關閉PHP的所有錯誤提示

 //參數接收
 // $user_id = $_POST['user_id'];

 //測試資料 
 $user_id = 17;

 //header("Content-type: application/json");
 require_once("../db.config.php");
 ?>

 <!DOCTYPE html>
 <html>
 <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <!--中文顯示-->
 <head>
 <script type="text/javascript" src="http://maps.googleapis.com/maps/api/js?sensor=false"></script>
 <script type="text/javascript" src="js/map.js"></script>
 </head>

 <body onload="initialize()">

 	       	<?php	 
 	       	         $dbh = new PDO("mysql:host=" . db('hostname') . ";dbname=" . db('dbname'), db('username'), db('password'), 
 				      array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8") ); 
 				     
 				     $arrLatLng =array();
 				     $arrScenicName =array();

 				      $locations_db_json='';
                   
 				      $sql_loc = "SELECT * FROM yourLocTable  WHERE user_id=$user_id";
 				      foreach ($dbh->query($sql_loc) as $row) {
                          $LatLng =  "(".$row['lat'].",".$row['lng'].")";  
                          $item_id =$row['id']; 
                          $ScenicName  =$row['name']; 
                          $phpecho = $phpecho.$row['id'].$LatLng; 

                          $locations_db_json.='{';
 		                  $locations_db_json.= 'latlng : new google.maps.LatLng';
 						  $locations_db_json.= $LatLng;//'(25.0336148,120.56480220000003)';
 						  $locations_db_json.=',';	
 						  $locations_db_json.= 'info :';	
 						  $locations_db_json.= '"'.$markerName.'"'; ;//'"hello"';	
 						  $locations_db_json.= '},';
        
                                     
                      }	      

      //                 $json_db ='{';
 	     //              $json_db.= 'latlng : new google.maps.LatLng';
 					 //  $json_db.= '(25.0336148,120.56480220000003)';
 					 //  $json_db.=',';	
 					 //  $json_db.= 'info :';	
 					 //  $json_db.= '"hello"';	
 					 //  $json_db.= '},';
 					 //  $json_db.='{
 						// 		latlng : new google.maps.LatLng(25.0336148,  121.56480220000003),
 						// 	    info : "world"
 						// },';
 	
 		     ?>

 			<script type="text/javascript">
                <?php $str = " debugStr from php=";?>
 			     var debugStr = '<?php echo $str.$phpecho;?>'; //php輸出字串到js要加單引 //對應寫入html的程式在map.js

 				var locations = [
                    <?php echo $locations_db_json; ?>
 				];


 			</script>	

 <div id="map_canvas" style="width: 100%;height:300px;"></div>
 <span> debug value : </span> <span id="debug"></span> 
 </body>
 </html>
	<?php

	error_reporting(E_ALL^E_NOTICE^E_WARNING); //關閉PHP的所有錯誤提示

	//參數接收
	// $user_id = $_POST['user_id'];

	//測試資料
	$user_id = 17;

	//header("Content-type: application/json");
	require_once("../db.config.php");
	?>

	<!DOCTYPE html>
	<html>
	<meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <!--中文顯示-->
	<head>
	<script type="text/javascript" src="http://maps.googleapis.com/maps/api/js?sensor=false"></script>
	<script type="text/javascript" src="js/map.js"></script>
	</head>

	<body onload="initialize()">

	<?php
	$dbh = new PDO("mysql:host=" . db('hostname') . ";dbname=" . db('dbname'), db('username'), db('password'),
	array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8") );

	$arrLatLng =array();
	$arrScenicName =array();

	$locations_db_json='';

	$sql_loc = "SELECT * FROM yourLocTable WHERE user_id=$user_id";
	foreach ($dbh->query($sql_loc) as $row) {
	$LatLng = "(".$row['lat'].",".$row['lng'].")";
	$item_id =$row['id'];
	$ScenicName =$row['name'];
	$phpecho = $phpecho.$row['id'].$LatLng;

	$locations_db_json.='{';
	$locations_db_json.= 'latlng : new google.maps.LatLng';
	$locations_db_json.= $LatLng;//'(25.0336148,120.56480220000003)';
	$locations_db_json.=',';
	$locations_db_json.= 'info :';
	$locations_db_json.= '"'.$markerName.'"'; ;//'"hello"';
	$locations_db_json.= '},';


	}

	// $json_db ='{';
	// $json_db.= 'latlng : new google.maps.LatLng';
	// $json_db.= '(25.0336148,120.56480220000003)';
	// $json_db.=',';
	// $json_db.= 'info :';
	// $json_db.= '"hello"';
	// $json_db.= '},';
	// $json_db.='{
	// latlng : new google.maps.LatLng(25.0336148, 121.56480220000003),
	// info : "world"
	// },';

	?>

	<script type="text/javascript">
	<?php $str = " debugStr from php=";?>
	var debugStr = '<?php echo $str.$phpecho;?>'; //php輸出字串到js要加單引 //對應寫入html的程式在map.js

	var locations = [
	<?php echo $locations_db_json; ?>
	];


	</script>

	<div id="map_canvas" style="width: 100%;height:300px;"></div>
	<span> debug value : </span> <span id="debug"></span>
	</body>
	</html>