2017 © Pedro Peláez
 

library database

The Illuminate Database package.

image

illuminate/database

The Illuminate Database package.

  • Friday, July 27, 2018
  • by taylorotwell
  • Repository
  • 107 Watchers
  • 1529 Stars
  • 5,387,014 Installations
  • PHP
  • 3463 Dependents
  • 67 Suggesters
  • 382 Forks
  • 37 Open issues
  • 100 Versions
  • 10 % Grown

The 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., (*1)

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., (*2)

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., (*3)

Once the Capsule instance has been registered. You may use it like so:, (*4)

Using The Query Builder, (*5)

$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:, (*6)

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

Using The Schema Builder, (*7)

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

Using The Eloquent ORM, (*8)

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., (*9)

The Versions

27/07 2018

5.6.x-dev

5.6.9999999.9999999-dev https://laravel.com

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql

26/07 2018

5.5.x-dev

5.5.9999999.9999999-dev https://laravel.com

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql

26/07 2018

dev-master

9999999-dev https://laravel.com

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql

23/07 2018

v5.6.29

5.6.29.0 https://laravel.com

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql

16/07 2018

v5.6.28

5.6.28.0 https://laravel.com

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql

10/07 2018

v5.6.27

5.6.27.0 https://laravel.com

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql

20/06 2018

v5.6.26

5.6.26.0 https://laravel.com

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql

12/06 2018

v5.6.25

5.6.25.0 https://laravel.com

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql

04/06 2018

v5.6.24

5.6.24.0 https://laravel.com

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql

21/05 2018

v5.6.23

5.6.23.0 https://laravel.com

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql

15/05 2018

v5.6.22

5.6.22.0 https://laravel.com

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql

08/05 2018

5.2.x-dev

5.2.9999999.9999999-dev http://laravel.com

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql

07/05 2018

v5.6.21

5.6.21.0 https://laravel.com

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql

02/05 2018

v5.6.20

5.6.20.0 https://laravel.com

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql

29/04 2018

v5.6.19

5.6.19.0 https://laravel.com

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql

17/04 2018

v5.6.17

5.6.17.0 https://laravel.com

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql

09/04 2018

v5.6.16

5.6.16.0 https://laravel.com

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql

30/03 2018

v5.6.15

5.6.15.0 https://laravel.com

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql

26/03 2018

v5.6.13

5.6.13.0 https://laravel.com

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql

26/03 2018

v5.6.14

5.6.14.0 https://laravel.com

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql

15/03 2018

v5.5.40

5.5.40.0 https://laravel.com

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql

14/03 2018

v5.6.12

5.6.12.0 https://laravel.com

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql

09/03 2018

v5.6.10

5.6.10.0 https://laravel.com

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql

09/03 2018

v5.6.11

5.6.11.0 https://laravel.com

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql

06/03 2018

v5.5.37

5.5.37.0 https://laravel.com

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql

06/03 2018

v5.5.39

5.5.39.0 https://laravel.com

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql

06/03 2018

v5.6.8

5.6.8.0 https://laravel.com

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql

06/03 2018

v5.6.9

5.6.9.0 https://laravel.com

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql

28/02 2018

v5.6.7

5.6.7.0 https://laravel.com

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql

27/02 2018

v5.5.36

5.5.36.0 https://laravel.com

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql

27/02 2018

v5.6.6

5.6.6.0 https://laravel.com

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql

22/02 2018

v5.5.35

5.5.35.0 https://laravel.com

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql

22/02 2018

v5.6.5

5.6.5.0 https://laravel.com

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql

20/02 2018

v5.6.4

5.6.4.0 https://laravel.com

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql

08/02 2018

v5.6.1

5.6.1.0 https://laravel.com

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql

08/02 2018

v5.6.2

5.6.2.0 https://laravel.com

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql

08/02 2018

v5.6.3

5.6.3.0 https://laravel.com

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql

07/02 2018

v5.6.0

5.6.0.0 https://laravel.com

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql

05/02 2018

v5.5.34

5.5.34.0 https://laravel.com

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql

24/01 2018

v5.5.33

5.5.33.0 https://laravel.com

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql

19/01 2018

5.3.x-dev

5.3.9999999.9999999-dev https://laravel.com

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql

19/12 2017

v5.5.28

5.5.28.0 https://laravel.com

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql

07/12 2017

5.4.x-dev

5.4.9999999.9999999-dev https://laravel.com

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql

05/11 2017

5.1.x-dev

5.1.9999999.9999999-dev http://laravel.com

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql

17/10 2017

v5.5.17

5.5.17.0 https://laravel.com

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql

16/10 2017

v5.5.16

5.5.16.0 https://laravel.com

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql

03/09 2017

v5.5.2

5.5.2.0 https://laravel.com

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql

29/08 2017

v5.5.0

5.5.0.0 https://laravel.com

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql

24/08 2017

v5.4.36

5.4.36.0 https://laravel.com

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql

15/06 2017

v5.4.27

5.4.27.0 https://laravel.com

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql

12/04 2017

v5.4.19

5.4.19.0 https://laravel.com

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql

03/04 2017

v5.4.17

5.4.17.0 https://laravel.com

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql

22/02 2017

v5.4.13

5.4.13.0 https://laravel.com

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql

03/02 2017

v5.4.9

5.4.9.0 https://laravel.com

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql

24/01 2017

v5.4.0

5.4.0.0 https://laravel.com

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql

14/11 2016

v5.3.23

5.3.23.0 https://laravel.com

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql

04/10 2016

v5.3.16

5.3.16.0 https://laravel.com

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql

25/08 2016

v5.3.4

5.3.4.0 https://laravel.com

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql

25/08 2016

v5.2.45

5.2.45.0 http://laravel.com

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql

23/08 2016

v5.3.0

5.3.0.0 https://laravel.com

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql

10/08 2016

v5.2.43

5.2.43.0 http://laravel.com

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql

10/08 2016

v5.1.41

5.1.41.0 http://laravel.com

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql

06/06 2016

v5.2.37

5.2.37.0 http://laravel.com

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql

15/05 2016

v5.2.32

5.2.32.0 http://laravel.com

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql

27/04 2016

v5.2.31

5.2.31.0 http://laravel.com

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql

01/04 2016

v5.2.28

5.2.28.0 http://laravel.com

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql

29/03 2016

v5.2.27

5.2.27.0 http://laravel.com

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql

23/03 2016

v5.2.25

5.2.25.0 http://laravel.com

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql

23/03 2016

v5.2.26

5.2.26.0 http://laravel.com

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql

22/03 2016

v5.2.24

5.2.24.0 http://laravel.com

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql

24/02 2016

v5.2.21

5.2.21.0 http://laravel.com

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql

24/02 2016

v5.1.31

5.1.31.0 http://laravel.com

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql

17/02 2016

v5.2.19

5.2.19.0 http://laravel.com

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql

17/02 2016

v5.1.30

5.1.30.0 http://laravel.com

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql

06/01 2016

v5.2.7

5.2.7.0 http://laravel.com

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql

31/12 2015

v5.2.6

5.2.6.0 http://laravel.com

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql

31/12 2015

v5.1.28

5.1.28.0 http://laravel.com

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql

20/12 2015

v5.2.0

5.2.0.0 http://laravel.com

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql

29/11 2015

v5.1.25

5.1.25.0 http://laravel.com

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql

28/10 2015

v5.1.22

5.1.22.0 http://laravel.com

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql

14/10 2015

v5.1.20

5.1.20.0 http://laravel.com

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql

03/09 2015

v5.1.16

5.1.16.0 http://laravel.com

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql

01/09 2015

v5.1.13

5.1.13.0 http://laravel.com

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql

20/07 2015

v5.1.8

5.1.8.0 http://laravel.com

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql

03/07 2015

v5.1.6

5.1.6.0 http://laravel.com

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql

15/06 2015

v5.1.2

5.1.2.0 http://laravel.com

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql

08/06 2015

v5.1.1

5.1.1.0 http://laravel.com

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql

02/06 2015

5.0.x-dev

5.0.9999999.9999999-dev http://laravel.com

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql

02/06 2015

v5.0.33

5.0.33.0 http://laravel.com

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql

19/04 2015

v5.0.28

5.0.28.0 http://laravel.com

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql

04/04 2015

v5.0.27

5.0.27.0 http://laravel.com

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql

03/04 2015

v5.0.26

5.0.26.0 http://laravel.com

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql

01/04 2015

v5.0.25

5.0.25.0 http://laravel.com

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql

27/03 2015

v5.0.22

5.0.22.0 http://laravel.com

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql

11/02 2015

v5.0.4

5.0.4.0

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql

02/02 2015

v5.0.0

5.0.0.0

The Illuminate Database package.

  Sources   Download

MIT

The Requires

 

orm database laravel sql