Slim框架引入Eloquent ORM

来源：互联网发布：复杂网络的特性编辑：程序博客网时间：2024/06/05 17:36

一、添加Slim的数据库配置：

$config = [        'settings' => [                'determineRouteBeforeAppMiddleware'=>false,                'displayErrorDetails'=>true,                'db'=>[                        'driver'=>'mysql',                        'host'=>'localhost',                        'database'=>'wechat',                        'username'=>'root',                        'password'=>'zxj1105511101',                        'charset'=>'utf8',                        'collation'=>'utf8_unicode_ci',                        'prefix'=>'',                ]        ]];$app = new \Slim\App($config);

二、添加ORM的Service factory（配置Eloquent）：

$container = $app->getContainer();$container['db'] = function($container){        $capsule = new \Illuminate\Database\Capsule\Manager;        $capsule->addConnection($container['settings']['db']);        $capsule->setAsGlobal();        $capsule->bootEloquent();        return $capsule;};

三、传递table object到controller中：

$container[\App\WidgetController::class] = function($c){        $table = $c->get('db')->table('users');        return new \App\WidgetController($table);};

四、从controller中查询数据库的表：

<?phpnamespace App;use Illuminate\Database\Query\Builder;use Psr\Http\Message\ServerRequestInterface as Request;use Psr\Http\Message\ResponseInterface as Response;class WidgetController{       protected $table;    public function __construct(        Builder $table    ) {         $this->table = $table;    }    public function __invoke(Request $request, Response $response, $args)    {           return $response;    }    public function getUser(Request $request, Response $response, $args)    {        $records = $this->table->where('username','like','%test%')->get();        foreach($records as $value){                print_r($value->username)."<br>";        }    }    }

五、以controller的methods作为路由的回调函数：

$app->get('/test',App\WidgetController::class.':getUser');

阅读全文

0 0