配置:
Nginx:
conf目录下nginx.conf配置文件。
第44行改为:root D:/wwwroot/www;
第45行改为:index index.html index.htm index.php; 加了PHP文件支持。
第65至71行改为:
(改为)location ~ \.php$ { root D:/wwwroot/www;
fastcgi_pass 127.0.0.1:9000;
fastcgi_index index.php;
fastcgi_param SCRIPT_FILENAME D:/wwwroot/www$fastcgi_script_name;
include fastcgi_params;
}
(原来)location ~ \.php$ {
# root html;
# fastcgi_pass 127.0.0.1:9000;
# fastcgi_index index.php;
# fastcgi_param SCRIPT_FILENAME /scripts$fastcgi_script_name;
# include fastcgi_params;
}
d:/wwwroot为网站的根目录。此目录也可以重新配置。找到代码:
location / {
root html;
index index.html index.htm index.php;
}
PHP:
查找定位至:;extension=php_gd2.dll,将前面的分号去掉为:extension=php_gd2.dll
查找定位至:;extension=php_mbstring.dll,将前面的分号去掉为:extension=php_mbstring.dll
查找定位至:;extension=php_mysql.dll,将前面的分号去掉为:extension=php_mysql.dll
查找定位至:;extension=php_mysqli.dll,将前面的分号去掉为:extension=php_mysqli.dll
查找定位至:;extension=php_pdo_mysql.dll,将前面的分号去掉为:extension=php_pdo_mysql.dll
查找定位至:;cgi.force_redirect = 1,将前面的分号去掉为:cgi.force_redirect = 1
查找定位至:;cgi.fix_pathinfo=1,将前面的分号去掉为:cgi.fix_pathinfo=1
查找定位至:;cgi.rfc2616_headers = 0,将前面的分号去掉并改为:cgi.rfc2616_headers = 1
flight源码包:https://github.com/mikecao/flight
Demo:index.php
<?php
require_once('flight/Flight.php');
require_once('response.php');
header("Content-Type:application/json");
function db()
{
$conn = mysql_connect("127.0.0.1","root","");
mysql_query("SET NAMES UTF8");
return $conn;
}
function get_user_list()
{
$users =array();
$sql = "select * from wordpress.wp_users";
$result = mysql_query($sql,db());
while ($row = mysql_fetch_array($result)) {
$users[] = array('user_id'=>$row['ID'],
'user_login'=>$row['user_login'],
'user_nicename'=>$row['user_nicename'],
'user_email'=>$row['user_email'],
'user_registered'=>$row['user_registered'],
'user_name'=>$row['display_name']);
}
return $users;
}
function get_user_derail($id)
{
$user =array();
$sql = "select * from wordpress.wp_users where id=".$id;
$result = mysql_query($sql,db());
while ($row = mysql_fetch_array($result)) {
$user = array('user_id'=>$row['ID'],
'user_login'=>$row['user_login'],
'user_nicename'=>$row['user_nicename'],
'user_email'=>$row['user_email'],
'user_registered'=>$row['user_registered'],
'user_name'=>$row['display_name']);
}
return $user;
}
Flight::route('/users', function(){
$users = get_user_list();
Response::show('200','返回成功',$users);
});
Flight::route('/users/@id', function($id){
$user = get_user_derail($id);
if(!empty($user))
{
//Flight::json($user);
Response::show('200','返回成功',$user);
}
else
{
Response::show('404','资源不存在',$user);
}
});
Flight::start();
?>
GET: http://localhost:8090/users
{ code: "200", message: "返回成功", data: [ { user_id: "1", user_login: "11", user_nicename: "11", user_email: "11.cd@11.corp", user_registered: "2014-05-07 02:33:19", user_name: "111" }, { user_id: "2", user_login: "leoliu", user_nicename: "leoliu", user_email: "leo.j.liu@11.com", user_registered: "2014-05-07 02:54:07", user_name: "刘, 建波" }, { user_id: "3", user_login: "1", user_nicename: "1", user_email: "11.j.11@11.com", user_registered: "2014-05-07 02:59:24", user_name: "吴, 11" } ] }
GET:http://localhost:8090/users/{userId}
{ code: "200", message: "返回成功", data: [ { user_id: "3", user_login: "1", user_nicename: "1", user_email: "11.j.11@11.com", user_registered: "2014-05-07 02:59:24", user_name: "吴, 11" } ] }