Iye akoko kika: 4 iṣẹju
database.php
in config
lianaFaili yii wa ninu itọsọna naa config
ti ohun elo Laravel rẹ.
Ninu faili naa database.php
ṣee ṣe definish ọpọ database awọn isopọ. Gbogbo asopọ gbọdọ jẹ definited bi ohun orun. Eto naa yẹ ki o ni alaye wọnyi:
driver
: awakọ data lati lo;host
: oruko host
tabi adirẹsi IP
ti olupin data;port
: nọmba ibudo olupin data;database
: orukọ database;username
: orukọ olumulo fun sisopọ si database;password
: ọrọigbaniwọle fun sisopọ si database;Fun apẹẹrẹ, koodu atẹle defiAwọn asopọ data meji wa, ọkan fun MySQL ati ọkan fun PostgreSQL:
'connections' => [
'sqlite' => [
'driver' => 'sqlite',
'url' => env('DATABASE_URL'),
'database' => env('DB_DATABASE', database_path('database.sqlite')),
'prefix' => '',
'foreign_key_constraints' => env('DB_FOREIGN_KEYS', true),
],
'mysql' => [
'driver' => 'mysql',
'url' => env('DATABASE_URL'),
'host' => env('DB_HOST', '127.0.0.1'),
'port' => env('DB_PORT', '3306'),
'database' => env('DB_DATABASE', 'forge'),
'username' => env('DB_USERNAME', 'forge'),
'password' => env('DB_PASSWORD', ''),
'unix_socket' => env('DB_SOCKET', ''),
'charset' => 'utf8mb4',
'collation' => 'utf8mb4_unicode_ci',
'prefix' => '',
'prefix_indexes' => true,
'strict' => true,
'engine' => null,
'options' => extension_loaded('pdo_mysql') ? array_filter([
PDO::MYSQL_ATTR_SSL_CA => env('MYSQL_ATTR_SSL_CA'),
]) : [],
],
'pgsql' => [
'driver' => 'pgsql',
'url' => env('DATABASE_URL'),
'host' => env('DB_HOST', '127.0.0.1'),
'port' => env('DB_PORT', '5432'),
'database' => env('DB_DATABASE', 'forge'),
'username' => env('DB_USERNAME', 'forge'),
'password' => env('DB_PASSWORD', ''),
'charset' => 'utf8',
'prefix' => '',
'prefix_indexes' => true,
'schema' => 'public',
'sslmode' => 'prefer',
],
Lẹhin defiNi kete ti o ba ni awọn asopọ data, o le lo wọn ninu koodu rẹ Laravel
. Lati ṣe eyi, o le lo awọn facade
ti database. Nibẹ facade
database pese a ti iṣọkan ni wiwo fun ibaraenisepo pẹlu infomesonu.
Lati yipada laarin awọn asopọ data data, o le lo ọna naa Connection()
della facade
Awọn apoti isura infomesonu. Ọna naa Connection()
gba awọn orukọ ti awọn database asopọ bi ohun ariyanjiyan.
Fun apẹẹrẹ, koodu atẹle naa lọ lati mysql DB si pgsql DB:
use Illuminate\Support\Facades\DB;
DB::connection('pgsql');
Ni kete ti o yipada si asopọ data data, o le lo lati beere ati ṣe ajọṣepọ pẹlu data data.
Awọn anfani lọpọlọpọ lo wa si lilo awọn data data lọpọlọpọ ni Laravel, pẹlu:
Eyi ni diẹ ninu awọn iṣe ti o dara julọ fun lilo awọn data data pupọ ni Laravel:
Connection()
lati lọ lati ọkan DB si miiran - eyi yoo ran ọ lọwọ lati yago fun ṣiṣe lairotẹlẹ query saili database ti ko tọ.Lilo awọn apoti isura infomesonu pupọ ni Laravel le jẹ ọna nla lati mu iṣẹ ṣiṣe, aabo, ati iwọn ti ohun elo rẹ dara si. Nipa titẹle awọn iṣe ti o dara julọ ti a ṣalaye ninu nkan yii, o le lo awọn apoti isura data pupọ ni Laravel ni imunadoko.
Ercole Palmeri
Awọn miliọnu eniyan sanwo fun awọn iṣẹ ṣiṣanwọle, san awọn idiyele ṣiṣe alabapin oṣooṣu. O jẹ ero ti o wọpọ pe o…
Coveware nipasẹ Veeam yoo tẹsiwaju lati pese awọn iṣẹ esi iṣẹlẹ ikọlu cyber. Coveware yoo funni ni awọn oniwadi ati awọn agbara atunṣe…
Itọju isọtẹlẹ jẹ iyipada ti eka epo & gaasi, pẹlu imotuntun ati ọna imudani si iṣakoso ọgbin.…
UK CMA ti ṣe ikilọ kan nipa ihuwasi Big Tech ni ọja itetisi atọwọda. Nibẹ…