You cannot select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
mmmwhy 43f468ad0a no message 10 years ago
..
Capsule no message 10 years ago
Connectors no message 10 years ago
Console no message 10 years ago
Eloquent no message 10 years ago
Events no message 10 years ago
Migrations no message 10 years ago
Query no message 10 years ago
Schema no message 10 years ago
Connection.php no message 10 years ago
ConnectionInterface.php no message 10 years ago
ConnectionResolver.php no message 10 years ago
ConnectionResolverInterface.php no message 10 years ago
DatabaseManager.php no message 10 years ago
DatabaseServiceProvider.php no message 10 years ago
DetectsLostConnections.php no message 10 years ago
Grammar.php no message 10 years ago
MigrationServiceProvider.php no message 10 years ago
MySqlConnection.php no message 10 years ago
PostgresConnection.php no message 10 years ago
QueryException.php no message 10 years ago
README.md no message 10 years ago
SQLiteConnection.php no message 10 years ago
SeedServiceProvider.php no message 10 years ago
Seeder.php no message 10 years ago
SqlServerConnection.php no message 10 years ago
composer.json no message 10 years ago

README.md

Illuminate Database

The Illuminate Database component is a full database toolkit for PHP, providing an expressive query builder, ActiveRecord style ORM, and schema builder. It currently supports MySQL, Postgres, SQL Server, and SQLite. It also serves as the database layer of the Laravel PHP framework.

Usage Instructions

First, create a new "Capsule" manager instance. Capsule aims to make configuring the library for usage outside of the Laravel framework as easy as possible.

use Illuminate\Database\Capsule\Manager as Capsule;

$capsule = new Capsule;

$capsule->addConnection([
    'driver'    => 'mysql',
    'host'      => 'localhost',
    'database'  => 'database',
    'username'  => 'root',
    'password'  => 'password',
    'charset'   => 'utf8',
    'collation' => 'utf8_unicode_ci',
    'prefix'    => '',
]);

// Set the event dispatcher used by Eloquent models... (optional)
use Illuminate\Events\Dispatcher;
use Illuminate\Container\Container;
$capsule->setEventDispatcher(new Dispatcher(new Container));

// Make this Capsule instance available globally via static methods... (optional)
$capsule->setAsGlobal();

// Setup the Eloquent ORM... (optional; unless you've used setEventDispatcher())
$capsule->bootEloquent();

composer require "illuminate/events" required when you need to use observers with Eloquent.

Once the Capsule instance has been registered. You may use it like so:

Using The Query Builder

$users = Capsule::table('users')->where('votes', '>', 100)->get();

Other core methods may be accessed directly from the Capsule in the same manner as from the DB facade:

$results = Capsule::select('select * from users where id = ?', array(1));

Using The Schema Builder

Capsule::schema()->create('users', function($table)
{
    $table->increments('id');
    $table->string('email')->unique();
    $table->timestamps();
});

Using The Eloquent ORM

class User extends Illuminate\Database\Eloquent\Model {}

$users = User::where('votes', '>', 1)->get();

For further documentation on using the various database facilities this library provides, consult the Laravel framework documentation.