codexshaper/php-database

Laravel项目中的数据库和Eloquent。

维护者

详细信息

github.com/Codexshaper/php-database

主页

源代码

问题

安装: 575

依赖: 4

建议: 0

安全: 0

星星: 0

关注者: 1

分支: 0

开放问题: 0

v1.0 2020-06-05 06:33 UTC

Requires

Requires (Dev)

MIT 4ded2db6a895546827631c4c743bf47d783bb049

  • Md Abu Ahsan Basir <maab.career.woop@gmail.com>

databaseormphplaraveleloquent

This package is auto-updated.

Last update: 2024-09-05 17:14:41 UTC

README

License Build Status StyleCI Quality Score Downloads Latest Version on Packagist

数据库和ORM

Laravel项目中的数据库和Eloquent。

下载

composer require codexshaper/php-database

设置根门面

use Illuminate\Support\Facades\Facade;
use Illuminate\Container\Container;

Facade::setFacadeApplication(new Container);

注意：如果您已经将container设置为根门面，则请保留。

创建一个新的连接

use CodexShaper\Database\Database;

使用constructor

$db = new Database([
	"driver" 		=> "mysql",
	"host" 			=> 'localhost',
	"database" 		=> 'db_name',
	"username" 		=> 'db_user',
	"password" 		=> 'db_password',
	"prefix"   		=> 'db_prefix',
	"charset"   	=> 'utf8mb4',
	"collation"   	=> 'utf8mb4_unicode_ci',
]);

使用addConnection方法

$db = new Database;
$db->addConnection([
	"driver" 		=> "mysql",
	"host" 			=> 'localhost',
	"database" 		=> 'laravel-woocommerce',
	"username" 		=> 'root',
	"password" 		=> '',
	"prefix"   		=> 'wp_',
	"charset"   	=> 'utf8mb4',
	"collation"   	=> 'utf8mb4_unicode_ci',
]);

最后，通过run数据库来全局使用并设置Eloquent ORM

$db->run();

创建一个表

use CodexShaper\Database\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;

Schema::create('users', function (Blueprint $table) {
    $table->id();
    $table->string('name');
    $table->string('email')->unique();
    $table->timestamp('email_verified_at')->nullable();
    $table->string('password');
    $table->rememberToken();
    $table->timestamps();
});

删除一个表

use CodexShaper\Database\Facades\Schema;
Schema::dropIfExists('custom_options');