Laravel database and eloquent for php project.
composer require codexshaper/php-database
use Illuminate\Support\Facades\Facade;
use Illuminate\Container\Container;
Facade::setFacadeApplication(new Container);
Note: If you alraedy setup container
as a root facade then leave it.
use CodexShaper\Database\Database;
$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',
]);
$db = new Database;
$db->addConnection([
"driver" => "mysql",
"host" => 'localhost',
"database" => 'laravel-woocommerce',
"username" => 'root',
"password" => '',
"prefix" => 'wp_',
"charset" => 'utf8mb4',
"collation" => 'utf8mb4_unicode_ci',
]);
$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');