如何快速實現REST API集成以優化業務流程
<?php
/**
* 數據庫配置信息
*/
$db_config = array(
'host' => "localhost",
'user' => "root",
//'password' => "password",
'password' => "root",
//'database' => "gis"
'database' => "map"
);
/**
* flush outputbuffer并將其輸出到客戶端，可實現即時輸出
* @param unknown_type $str
*/
function qk_echo($str) {
echo $str;
ob_flush();//刷新緩存
flush();
}
/**
* Helper 類，用于接收http請求并對外提供服務
*/
class Helper{
private $db_config;
public function __construct($db_config){
$this->db_config=$db_config;
}
/**
* 對外提供api接口
* @param method api名稱
*/
public function do_api(){
$method=$_GET['method'];
$result="";
switch ($method) {
case 'get_trj':
# code...
$result=$this->get_trj();
break;
default:
# code...
break;
}
qk_echo($result); //Response
}
/**
* 獲取軌跡信息，以字符串的形式返回
*/
public function get_trj(){
//初始化數據庫連接
$conn=mysql_connect($this->db_config['host'], $this->db_config['user'],$this->db_config['password']);
//選擇數據庫
@mysql_select_db($this->db_config['database'],$conn);
//$table_name="trajectory";
//$table_name="ap_max";
$table_name="wifi_state";
//$sql="select id,lng,lat,ssid,rssiMax,rssiMin,wifi_mac,testPointNum,wifi_mac_used from ".$table_name;
//$sql="select id,lon,lat,time,encyptiontype,rssi,name from ".$table_name;
$sql="select id,lon,lat,time,encyptiontype,rssi,name from wifi_state";
// 執行sql查詢
$rs=mysql_query($sql,$conn);
$result=array();
while($row=mysql_fetch_row($rs)){
//加入經緯度信息
//echo $row[1];
$result[]=array($row[1],$row[2],$row[3],$row[4],$row[5],$row[6]);
//$result[]=array($row[1],$row[2],$row[3],$row[4]);
}
//關閉數據集
@mysql_close($rs);
//返回結果
return json_encode($result);
}
}
/*$link=mysql_connect("localhost","root","root");
if(!$link) echo "FAILD!連接錯誤，用戶名密碼不對";
else echo "OK!可以連接"; */
$helper=new Helper($db_config);
$helper->do_api();
$helper->get_trj();數據庫名：map
表名：wifi_state
導出文件（可直接導入Mysql）：
-- phpMyAdmin SQL Dump
-- version phpStudy 2014
-- http://www.phpmyadmin.net
--
-- 主機: localhost
-- 生成日期: 2017 年 03 月 15 日 08:37
-- 服務器版本: 5.5.53
-- PHP 版本: 5.4.45
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- 數據庫: map
--
CREATE DATABASE map DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
USE map;
-- --------------------------------------------------------
--
-- 表的結構 wifi_state
--
CREATE TABLE IF NOT EXISTS wifi_state (
id int(10) NOT NULL,
time date NOT NULL,
lat varchar(123) NOT NULL,
lon varchar(123) NOT NULL,
name varchar(123) NOT NULL,
encyptiontype varchar(123) NOT NULL,
rssi varchar(123) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- 轉存表中的數據 wifi_state
--
INSERT INTO wifi_state (id, time, lat, lon, name, encyptiontype, rssi) VALUES
(1, '2017-03-08', '39.915', '116.408', 'netgear41', 'unlocked', '0'),
(1, '2017-03-08', '39.910', '116.401', 'netgear41', 'unlocked', '0'),
(1, '2017-03-08', '39.917', '116.406', 'netgear41', 'unlocked', '0'),
(1, '2017-03-08', '39.912', '116.408', 'netgear41', 'unlocked', '0'),
(1, '2017-03-08', '39.910', '116.407', 'netgear41', 'unlocked', '0');
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;百度地圖取Mysql數據打點
鏈接: https://pan.baidu.com/s/1qSnSOtudYanU5Oi_cl28gA
提取碼: fn9s文章轉自微信公眾號@PHP自學中心
