Using Eloquent with Slim

    Figure 1: Add Eloquent to your application.
    2. return [
    3.     'settings' => [
    4.         'determineRouteBeforeAppMiddleware' => false,
    5.         'displayErrorDetails' => true,
    6.         'db' => [
    7.             'driver' => 'mysql',
    8.             'host' => 'localhost',
    10.             'username' => 'user',
    11.             'password' => 'password',
    12.             'charset'   => 'utf8',
    13.             'collation' => 'utf8_unicode_ci',
    14.         ]
    15.     ],
    16. ];
    Figure 2: Settings array.
    Figure 3: Configure Eloquent.
    1. $container[App\WidgetController::class] = function ($c) {
    2.     $view = $c->get('view');
    3.     $logger = $c->get('logger');
    4.     $table = $c->get('db')->table('table_name');
    5.     return new \App\WidgetController($view, $logger, $table);
    6. };
    Figure 4: Pass table object into a controller.
    Figure 5: Sample controller querying the table.
    1. ...
    Figure 6: Query searching for names matching foo.

    Query the table by id

    Figure 7: Selecting a row based on id.