在线时间:8:00-16:00
迪恩网络APP
随时随地掌握行业动态
扫描二维码
关注迪恩网络微信公众号
开源软件名称(OpenSource Name):illuminate/database开源软件地址(OpenSource Url):https://github.com/illuminate/database开源编程语言(OpenSource Language):PHP 100.0%开源软件介绍(OpenSource Introduction):Illuminate DatabaseThe 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 InstructionsFirst, 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();
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. |
2023-10-27
2022-08-15
2022-08-17
2022-09-23
2022-08-13
请发表评论