// Set up a current path resolver so the paginator can generate proper links
Paginator::currentPathResolver(function () {
return isset($_SERVER['REQUEST_URI']) ? strtok($_SERVER['REQUEST_URI'], '?') : '/';
});
// Set up a current page resolver
Paginator::currentPageResolver(function ($pageName = 'page') {
$page = isset($_REQUEST[$pageName]) ? $_REQUEST[$pageName] : 1;
return $page;
});
$perPage = 5;
// results per page
$columns = ['*'];
// (optional, defaults to *) array of columns to retrieve from database
$pageName = 'page';
// (optional, defaults to 'page') query string parameter name for the page number
if (User::all()->count() <= $perPage) {
exit("Need more than <strong>{$perPage}</strong> users in your <i>illuminate_non_laravel</i> database to see this work");
}
// Set $page (optional, defaults to null) to the current page;
// if this is not set, the currentPageResolver will be used
$page = isset($_REQUEST[$pageName]) ? $_REQUEST[$pageName] : null;
// Query and paginate the results
$results = User::orderBy('id')->paginate($perPage, $columns, $pageName, $page);
// Display the table of users
echo '<h1>Users</h1>';
echo '<table>';
foreach ($results as $user) {
echo "<tr><td>User number {$user->id}</td></tr>";
}
echo '<table>' . "\n";
// Render the Bootstrap framework compatible pagination html;
* Requires: illuminate/database
*
* @source https://github.com/illuminate/database
*/
$app = new \Slim\Slim();
$app->add(new \Zeuxisoo\Whoops\Provider\Slim\WhoopsMiddleware());
$app->get('/', function () {
$capsule = new Capsule();
$capsule->addConnection(['driver' => 'mysql', 'host' => 'localhost', 'database' => 'illuminate_non_laravel', 'username' => 'root', 'password' => '', 'charset' => 'utf8', 'collation' => 'utf8_unicode_ci', 'prefix' => '']);
// Set the event dispatcher used by Eloquent models... (optional)
$capsule->setEventDispatcher(new Dispatcher(new Container()));
// Set the cache manager instance used by connections... (optional)
// $capsule->setCacheManager(...);
// Make this Capsule instance available globally via static methods... (optional)
$capsule->setAsGlobal();
// Setup the Eloquent ORM... (optional; unless you've used setEventDispatcher())
$capsule->bootEloquent();
// Use it
echo '<pre>';
$user = Capsule::table('users')->where('id', 1)->get();
var_dump($user);
$users = User::all();
var_dump($users);
// More examples and docs here: https://github.com/illuminate/database
});
$app->get('/encapsulated', function () {
echo '<pre>';
$users = UserEncapsulated::all();
var_dump($users);
});
$app->run();
