将Silex与Redbean Orm集成

这是一个非常基本的设置，如下所示。

由于Redbean提供了静态类的外观RedBean_Facade，在文档中称为R，因此几乎不需要将其注册为Silex应用程序的服务。

理想情况下，您应该在Composer中同时安装Silex和Redbean。在Redbean Github页面上，它告诉您如何在Composer中使用它。

<?php

require __DIR__.'/vendor/autoload.php';

use Silex\Application;
use Symfony\Component\HttpFoundation\Request;
use Symfony\Component\HttpFoundation\Response;
use RedBean_Facade as R;

$app = new Application();

$app['db.connection.default.driver'] = "mysql";
$app['db.connection.default.host'] = "localhost";
$app['db.connection.default.name'] = "mydatabase";
$app['db.connection.default.user'] = "user";
$app['db.connection.default.password'] = "password";

$app['db.connection.default.rsn'] = $app->share(function () use ($app) {
    return sprintf('%s:host=%s;dbname=%s',
        $app['db.connection.default.driver'],
        $app['db.connection.default.host'],
        $app['db.connection.default.name']
    );
});

R::setup(
    $app['db.connection.default.rsn'],
    $app['db.connection.default.user'],
    $app['db.connection.default.password']
);

$app->get('/article/{id}/show', function ($id) {
    $article = R::load('article', $id );

    // do something with $article, then
    // return an HTML page of the article.
});

$app->get('/article/new', function () {
    // return an HTML page with a form that contains
    // input fields with HTML name attributes set to
    // 'title' and 'body' for example.
});

$app->post('/article/new', function (Request $request) use ($app) {
    $article = R::dispense('article');

    $article->title = $request->request->get('title');
    $article->body = $request->request->get('body');

    $id = R::store($article);

    return $app->redirect(sprintf('/article/%d/show', $id));
});

$app->run();