Eloquent ORM and Slim PHP

Composer.json

[php]
{
"require":{
"slim/slim":"^3.0",
"illuminate/database": "*"
}
}
[/php]

Configuration

[php]
//configuration.php
use Illuminate\Database\Capsule\Manager as Capsule;
// Database information
$$settings[‘development’] = array(
‘driver’ => ‘mysql’,
‘host’ => ‘127.0.0.1’,
‘database’ => ‘db_name’,
‘username’ => ‘username’,
‘password’ => ‘password’,
‘collation’ => ‘utf8_general_ci’,
‘prefix’ => ”,
‘charset’ => ‘utf8’
);
$capsule = new Capsule;
$capsule->addConnection($settings[‘development’]);
$capsule->bootEloquent();
$capsule->setAsGlobal();

$conn = $capsule->connection();
[/php]

Model Class (example : table categories )

[php]
//categories.php
use Illuminate\Database\Eloquent\Model as Model;
class Categories extends Model{
}
[/php]

Implementation in Slim

[php]
//index.php
require ‘vendor/autoload.php’;
include_once ‘configuration.php’;
include_once ‘categories.php’;

$app = new \Slim\App();

$app->get(‘/categories’, function () use ($app) {
print_r( Categories::all() );
});

$app->run();
[/php]

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.