PHP R::setup方法代碼示例

 public function setupMySql($host, $name, $user, $password)
 {
     $this->dbHost = $host;
     $this->dbName = $name;
     $this->dbUser = $user;
     $this->dbPassword = $password;
     R::setup('mysql:host=' . $host . ';dbname=' . $name, $user, $password);
     return $this;
 }

 public function run()
 {
     global $slim;
     $view = new \Slim\Views\Smarty();
     $view->parserExtensions = ['vendor/slim/views/SmartyPlugins'];
     $this->slim = $slim = new Slim(['view' => $view, 'templates.path' => 'views']);
     $this->slim->setName('um');
     R::setup('mysql:host=localhost;dbname=um', 'root', '');
     // add middleware
     $this->addMiddleware(new AuthMiddleware());
     $this->route = new Route($this->slim);
     $this->route->run();
     $this->slim->run();
 }

 public static function setupBeforeClass()
 {
     try {
         R::setup('sqlite:tests.db');
     } catch (Exception $ex) {
     }
 }

 public static function DBSetup()
 {
     $config = \Config::getSection("DB1");
     if (!self::$CONNECTED) {
         R::setup('mysql:host=localhost;dbname=' . $config['dbname'], $config['username'], $config['password']);
         self::$CONNECTED = true;
     }
 }

 /**
  * Create the controller action service
  *
  * @param ContainerInterface $container
  * @return \Ultradata\Home\Controller\HomePageAction
  */
 public function __invoke(ContainerInterface $container)
 {
     // set up database connection
     $config = $this->getConfig($container);
     \RedBeanPHP\R::setup(sprintf("mysql:host=%s;dbname=%s", $config['host'], $config['dname']), $config['username'], $config['password']);
     $router = $container->get('Zend\\Expressive\\Router\\RouterInterface');
     $template = $container->has('Zend\\Expressive\\Template\\TemplateRendererInterface') ? $container->get('Zend\\Expressive\\Template\\TemplateRendererInterface') : null;
     $controller = new Controller($router, $template);
     return $controller;
 }

 public function register(Container $app)
 {
     $app['db'] = function () use($app) {
         $options = array('dsn' => null, 'username' => null, 'password' => null, 'frozen' => false);
         if (isset($app['db.options'])) {
             $options = array_replace($options, $app['db.options']);
         }
         R::setup($options['dsn'], $options['username'], $options['password'], $options['frozen']);
     };
 }

 public function register(Container $c)
 {
     $settings = $c["settings"];
     $options = ['dsn' => null, 'username' => null, 'password' => null, 'frozen' => false];
     if (isset($settings["redbean.setup"])) {
         $options = array_merge($options, $settings["redbean.setup"]);
     }
     $c["redbean"] = R::setup($options["dns"], $options["username"], $options["password"], $options["frozen"]);
     $c["redbean.helper"] = new \CodePasha\RedBean\Support\RedBeanHelper();
     R::getRedBean()->setBeanHelper($c["redbean.helper"]);
     R::setAutoResolve(true);
 }

 /**
  * Connect to existing database handle with RedBeans
  */
 public static function connectExisting()
 {
     static $connected = null;
     if (!$connected) {
         R::setup(connect::$dbh);
         $connected = true;
     }
     $freeze = conf::getMainIni('rb_freeze');
     if ($freeze == 1) {
         R::freeze(true);
     }
 }

 /**
  * Register the service provider.
  *
  * @return void
  */
 public function register()
 {
     //Get DB configs from app/config/database.php
     $default = Config::get('database.default');
     $connections = Config::get('database.connections');
     $db_host = $connections[$default]['host'];
     $db_user = $connections[$default]['username'];
     $db_pass = $connections[$default]['password'];
     $db_name = $connections[$default]['database'];
     $db_driver = $connections[$default]['driver'];
     //Run the R::setup command based on db_type
     if ($default != 'sqlite') {
         $conn_string = $db_driver . ':host=' . $db_host . ';dbname=' . $db_name;
     } else {
         $conn_string = $db_driver . ':' . $db_name;
     }
     R::setup($conn_string, $db_user, $db_pass);
 }

 public function run()
 {
     global $slim;
     $view = new \Slim\Views\Smarty();
     $view->parserExtensions = ['vendor/slim/views/SmartyPlugins'];
     $this->slim = $slim = new Slim(['view' => $view, 'templates.path' => 'views']);
     $this->slim->setName('um');
     R::setup('mysql:host=localhost;dbname=lighting_durag', 'root', '');
     // R::setup('mysql:host=localhost;dbname=lighting_durag', 'root', 'mysql@umi');
     R::ext('xdispense', function ($type) {
         return R::getRedBean()->dispense($type);
     });
     // add middleware
     $this->addMiddleware(new AuthMiddleware());
     $this->route = new Route($this->slim);
     $this->route->run();
     $this->slim->run();
 }

 protected static function init()
 {
     if (self::$_inited) {
         return;
     }
     $c = static::conf();
     shuffle($c['write']);
     shuffle($c['read']);
     self::$_mcs = $c['write'];
     self::$_scs = array_merge($c['read'], $c['write']);
     R::setup();
     foreach (self::$_mcs as $i => $c) {
         R::addDatabase("write:{$i}", sprintf('mysql:host=%s;port=%d;dbname=%s', $c['host'], $c['port'], $c['dbname']), $c['username'], $c['password']);
     }
     foreach (self::$_scs as $i => $c) {
         R::addDatabase("read:{$i}", sprintf('mysql:host=%s;port=%d;dbname=%s', $c['host'], $c['port'], $c['dbname']), $c['username'], $c['password']);
     }
     self::$_inited = true;
 }

 *
 * @author Jairo E. Vengoechea R.
 *
 */
session_start();
/** @constant __PUBLIC__ Public folder*/
define('__PUBLIC__', dirname(__FILE__));
/** @constant __ROOT__ Root folder*/
define('__ROOT__', dirname(dirname(__FILE__)));
/** @constant __DEV__ */
define('__DEV__', true);
/** Config */
require_once __ROOT__ . '/routing/config.php';
//Importing config.php
require_once __ROOT__ . '/core/MCN.php';
use MCN\MCN;
//Importing Bower Includer
require_once __ROOT__ . '/core/Includer.php';
//vendors
require_once __ROOT__ . '/vendor/autoload.php';
//initiate DB
use RedBeanPHP\R;
R::setup('mysql:host=' . $config['dbhost'] . ';dbname=' . $config['dbname'], $config['dbuser'], $config['dbpass']);
R::setAutoResolve(TRUE);
//initialising the app
$MCN = new MCN();
$includes = $MCN->includes();
foreach ($includes as $inc) {
    require_once $inc;
}
$MCN->route();

<?php

//turn all reporting on
error_reporting(E_ALL);
ini_set('display_errors', 1);
require 'vendor/autoload.php';
\RedBeanPHP\R::setup('mysql:host=localhost;dbname=db_smi', 'root', 'root');
$logWriter = new \Slim\LogWriter(fopen(__DIR__ . '/logs/log-' . date('Y-m-d', time()), 'a'));
$customConfig = array();
\Slim\Slim::registerAutoloader();
$app = new \Slim\Slim(array('log.writer' => $logWriter, 'custom' => $customConfig));
/*
$app->add(new \Slim\Middleware\HttpBasicAuthentication([
    "realm" => "Protected",
    "relaxed" => array("localhost"),
    "users" => [
        "root" => "r0Ot_C0n643"
    ]
]));
*/
//Including all resources
foreach (glob("resources/*.php") as $filename) {
    require_once $filename;
}
$app->run();

<?php

// set the timezone
date_default_timezone_set('Europe/London');
// -----------------------------------------------------------------------------
// Service factories
// -----------------------------------------------------------------------------
// monolog
$container['logger'] = function ($c) {
    $settings = $c['settings']['logger'];
    $logger = new \Monolog\Logger($settings['name']);
    $logger->pushProcessor(new \Monolog\Processor\UidProcessor());
    $logger->pushHandler(new \Monolog\Handler\StreamHandler($settings['path'], \Monolog\Logger::DEBUG));
    return $logger;
};
$container['dsn'] = function ($c) {
    $settings = $c['settings']['database'];
    $dsn = $settings['driver'] . ':host=' . $settings['host'] . (!empty($settings['port']) ? ';port=' . $settings['port'] : '') . ';dbname=' . $settings['database'];
    return $dsn;
};
$frozen = $container['settings']['database']['frozen'];
//with namespace Model
define('REDBEAN_MODEL_PREFIX', '\\App\\Models\\');
\RedBeanPHP\R::setup($container['dsn'], $container['settings']['database']['username'], $container['settings']['database']['password'], $frozen);
// database mysqli connection
$container['database'] = function ($c) {
    $settings = $c['settings']['database'];
    $connection = new \PDO($c['dsn'], $settings['username'], $settings['password']);
    //$connection = new mysqli($settings['host'], $settings['username'], $settings['password'], $settings['database']);
    return $connection;
};

use router\Router;
use RedBeanPHP\R;
use http\HttpContext;
use handler\Handlers;
use handler\json\JsonHandler;
use handler\http\HttpStatusHandler;
use handler\json\Json;
use handler\http\HttpStatus;
use http\HttpSession;
use auth\service\HttpAuth;
use auth\provider\HtpasswdProvider;
include __DIR__ . '/../vendor/autoload.php';
include 'Model_Post.php';
// setup database
R::setup('sqlite:../db/dbfile.db');
// all dates in UTC timezone
date_default_timezone_set("UTC");
ini_set('date.timezone', 'UTC');
$router = new Router();
$auth = new HttpAuth(new HtpasswdProvider('../db/.htpasswd'), 'Posts admin');
$handlers = Handlers::get();
$handlers->add(new JsonHandler());
$handlers->add(new HttpStatusHandler());
/**
 * Fetch all posts
 *
 * @return Json array with all posts
 */
$router->route('posts-list', '/posts', function () {
    $result = [];