Skip to content

[READ ONLY] Subtree split of the Illuminate Database component (see laravel/framework)

License

Notifications You must be signed in to change notification settings

illuminate/database

Folders and files

NameName
Last commit message
Last commit date

Latest commit

Feb 21, 2025
cb2be10 · Feb 21, 2025
Jun 28, 2024
Apr 4, 2024
Feb 18, 2025
Feb 13, 2025
Feb 12, 2025
Feb 18, 2025
Feb 12, 2025
Feb 6, 2025
Feb 21, 2025
Feb 13, 2025
Feb 1, 2022
Sep 3, 2021
May 27, 2019
Feb 21, 2025
Feb 21, 2025
May 2, 2022
Jun 4, 2019
Jan 22, 2025
Jun 9, 2024
Nov 23, 2023
Feb 13, 2024
Apr 25, 2022
Oct 21, 2021
Jan 9, 2025
Feb 12, 2025
Jul 4, 2019
Mar 15, 2024
Apr 22, 2022
Feb 12, 2025
Mar 29, 2024
Apr 6, 2022
Feb 22, 2022
Feb 12, 2025
Feb 12, 2025
Jul 19, 2022
Jul 5, 2021
Sep 9, 2024
Jan 14, 2021
Feb 13, 2025
Jan 13, 2023
Nov 15, 2023
Feb 12, 2025
Aug 15, 2023
Feb 19, 2025

Repository files navigation

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 = ?', [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.

About

[READ ONLY] Subtree split of the Illuminate Database component (see laravel/framework)

Resources

License

Stars

Watchers

Forks

Packages

No packages published

Languages