??? ??? ??? ???? ?? ?? ? ?? ??? ???? ????? ??? ???? ???? ?? ??? ?? ??? ?? ??? ?????.

? ????? ThinkPHP ?????? ???? ?? ? ??? ???? ??? ?????. PHP ?????? ThinkPHP ?????? ??? ??? ? ??? ??? ? ????.

?? ?? ??? ???? ???? ????? ??? ?? ??? ?????.

• id: ?? ??
• customer_name: ?? ??
• order_date: ?? ??
• amount: ?? ??

at ThinkPHP ???????? ORM(Object Relational Mapping)? ???? ??????? ???? SQL ??? ???? ? ????. ??? ?? ??? ????.

namespace?app\model;

use?think\Model;

class?Order?extends?Model
{
????protected?$table?=?'order';?//?數(shù)據(jù)表名
????
????public?function?scopeThisMonth($query)
????{
????????return?$query->whereBetweenTime('order_date',?'month');
????}
}

? ?? ????? ?? ? ??? ?? ???? ???? ThisMonth?? ??? ?????. ?? ? ?? ??? ?? ??? ???? ?? ThinkPHP? ??? whereBetweenTime ???? ??????.

?? ?????? ??? ??? ? ????.

namespace?app\controller;

use?think\Controller;
use?app\model\Order;

class?OrderController?extends?Controller
{
????public?function?thisMonth()
????{
????????$orders?=?Order::thisMonth()->select();
????????return?json($orders);
????}
}

? ??????? Order ??? ThisMonth ??? ???? ?? ??? JSON ???? ?????. ?? ??? ??? ???? ?? ?? ThinkPHP? ??? ?? ?? ??? ??? ? ????.

????? ???? ???? ???? ?? ??? API ??? ???? ???.

use?think\facade\Route;

Route::get('/order/this-month',?'OrderController@thisMonth');

??? ??? ?? ?? ??? ??? ?? ? ?? ???? ???? ??? ??? ? ????. ??? ?????? ???? ??? API ????? ?????.

??? ??? ThinkPHP ?????? ???? ??? ? ??????? ???? ??? ? ??? ???? ??? ?? ??? ??? ?????. ? ?? ? ?????? ??? ?? ?????? ??? ??? ????.

? ??? ThinkPHP ?????? ???? ?? ? ??? ???? ??? ?? ??? ??? ?? ?????. ??? ??? PHP ??? ????? ?? ?? ??? ?????!