StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>I would suggest using the <a href="https://github.com/illuminate/database#usage-outside-of-laravel-4" rel="nofollow">Illuminate/Database</a> package (part of Laravel 4). You won't get the <code>DB</code> interface, because that's a special facade provided by the Laravel Framework, but all the query builder functionality is available through the capsule.</p> <p>Install <code>illuminate/database</code> using <a href="http://getcomposer.org/" rel="nofollow">composer</a> and then follow the included <a href="https://github.com/illuminate/database#usage-outside-of-laravel-4" rel="nofollow">readme notes</a> (included below for completeness).</p> <hr> <h2>Illuminate Database</h2> <h3>Usage Outside Of Laravel 4</h3> <pre class="lang-php prettyprint-override"><code>$config = array( 'fetch' => PDO::FETCH_CLASS, 'default' => 'mysql', 'connections' => array( 'mysql' => array( 'driver' => 'mysql', 'host' => 'localhost', 'database' => 'laravel', 'username' => 'root', 'password' => 'password', 'charset' => 'utf8', 'collation' => 'utf8_unicode_ci', 'prefix' => '', ), ), ); $capsule = new Illuminate\Database\Capsule($config); // If you want to use the Eloquent ORM... $capsule->bootEloquent(); // Making A Query Builder Call... $capsule->connection()->table('users')->where('id', 1)->first(); // Making A Schema Builder Call... $capsule->connection()->schema()->create('users', function($t) { $t->increments('id'); $t->string('email'); $t->timestamps(); }); </code></pre>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload