<?php // use Illuminate\Database\Capsule\Manager as DB; class_alias('Illuminate\\Database\\Capsule\\Manager', 'DB'); // Database information $settings = ['mysql' => ['driver' => 'mysql', 'host' => 'localhost', 'database' => 'phpbelfast', 'username' => 'root', 'password' => 'root', 'charset' => 'utf8', 'collation' => 'utf8_general_ci', 'prefix' => ''], 'sqlite' => ['driver' => 'sqlite', 'database' => __DIR__ . '/../tmp/database.sqlite', 'prefix' => '']]; $capsule = new DB(); $capsule->addConnection($settings['mysql']); $capsule->setFetchMode(PDO::FETCH_OBJ); $capsule->setAsGlobal(); $capsule->bootEloquent();
<?php class_alias('Illuminate\\Database\\Capsule\\Manager', 'DB'); $capsule = new DB(); $capsule->addConnection(['driver' => getenv('DB_DRIVER') !== false ? getenv('DB_DRIVER') : 'mysql', 'host' => getenv('DB_HOST') !== false ? getenv('DB_HOST') : 'localhost', 'port' => getenv('DB_PORT') !== false ? getenv('DB_PORT') : '3306', 'username' => getenv('DB_USER') !== false ? getenv('DB_USER') : 'username', 'password' => getenv('DB_PASS') !== false ? getenv('DB_PASS') : 'password', 'database' => getenv('DB_NAME') !== false ? getenv('DB_NAME') : 'database', 'prefix' => getenv('DB_PREFIX') !== false ? getenv('DB_PREFIX') : '', 'charset' => 'utf8', 'collation' => 'utf8_unicode_ci']); $capsule->setAsGlobal(); $capsule->bootEloquent();
// 'driver' => 'mysql', // 'host' => 'localhost', // 'database' => 'test', // 'username' => 'root', // 'password' => '', // 'charset' => 'utf8', // 'collation' => 'utf8_unicode_ci', // 'prefix' => '' // ), // 'sqlite' => array( // 'driver' => 'sqlite', // 'database' => __DIR__.'/../db/dbfile.db', // 'prefix' => '' // ), // ), // ); $onnections = array('lv4' => array('driver' => 'mysql', 'host' => 'localhost', 'database' => 'lv4', 'username' => 'root', 'password' => '', 'charset' => 'utf8', 'collation' => 'utf8_unicode_ci', 'prefix' => ''), 'test' => array('driver' => 'mysql', 'host' => 'localhost', 'database' => 'test', 'username' => 'root', 'password' => '', 'charset' => 'utf8', 'collation' => 'utf8_unicode_ci', 'prefix' => ''), 'sqlite' => array('driver' => 'sqlite', 'database' => __DIR__ . '/../db/dbfile.db', 'prefix' => '')); $capsule->addConnection($onnections['lv4'], 'lv4'); $capsule->addConnection($onnections['test'], 'default'); $capsule->addConnection($onnections['sqlite'], 'sqlite'); use Illuminate\Events\Dispatcher; use Illuminate\Container\Container; $capsule->setEventDispatcher(new Dispatcher(new Container())); $capsule->setAsGlobal(); $capsule->bootEloquent(); $observer = new PostObserver(); $capsule->getContainer()->instance('PostObserver', $observer); $pdo = $capsule->getConnection()->getPdo(); R::setup($pdo); // $dsn = 'mysql:host='.$host.';dbname='.$db; // R::setup($dsn,$user,$pass);