亚洲国产日韩欧美一区二区三区,精品亚洲国产成人av在线,国产99视频精品免视看7,99国产精品久久久久久久成人热,欧美日韩亚洲国产综合乱

一、PDO預(yù)處理

• laravel發(fā)送給mysql的語句 - toSql()

    public function orwhere(){
        // $res = DB::table('admin')->where('gid',0)->orWhere('ispasswd',1)->get(['id','username','real_name']);
        $res = DB::table('admin')->where('gid',0)->orWhere('ispasswd',1)->toSql();
        echo '<pre>';
        print_r($res);
    }

二、連表查詢

• 原生查詢

• 鏈?zhǔn)讲樵?/li>

    // 連表查詢
    public function join(){
        $res = DB::table('admin')->join('admin_group','admin.gid','=','admin_group.gid')->get();
        echo '<pre>';
        print_r($res);
    }

三、中間件

• 中間件的創(chuàng)建

<?php
namespace App\Http\Middleware;
use Illuminate\Http\Request;
use Closure;
// 中間件
class Mycheck{
    public function handle(Request $request,Closure $next){
        $a = 3;
        $b = 5;
        echo 'a+b='.($a+$b);
        return $next($request);
    }
}

• 注冊(cè)中間件

• 觸發(fā)中間件

Route::get('/home/join','Home@join')->middleware('mycheck');

• 阻斷中間件下面進(jìn)程執(zhí)行

// 中間件
class Mycheck{
    public function handle(Request $request,Closure $next){
        $a = 3;
        $b = 5;
        echo 'a+b='.($a+$b);
        return response('aaa',200);
        return $next($request);
    }
}