Lub sijhawm nyeem ntawv kwv yees: 4 minuti
database.php
in config
directoryCov ntaub ntawv no nyob hauv phau ntawv teev npe config
ntawm koj daim ntawv thov Laravel.
Hauv cov ntaub ntawv database.php
yog ua tau definish ntau qhov sib txuas database. Txhua qhov kev sib txuas yuav tsum yog definited li ib array. Lub array yuav tsum muaj cov ntaub ntawv hauv qab no:
driver
: tus neeg tsav tsheb database siv;host
:npe host
los yog qhov chaw nyob IP
ntawm lub database server;port
: database server chaw nres nkoj naj npawb;database
: lub npe database;username
: tus username rau kev txuas mus rau lub database;password
: tus password rau kev txuas mus rau database;Piv txwv li, cov cai hauv qab no defiMuaj ob qhov kev sib txuas database, ib qho rau MySQL thiab ib qho rau 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',
],
Tom qab defiThaum koj muaj kev sib txuas database, koj tuaj yeem siv lawv hauv koj cov cai Laravel
. Txhawm rau ua qhov no, koj tuaj yeem siv lub facade
ntawm lub database. Nyob ntawd facade
database muab ib tug unified interface rau interacting nrog databases.
Txhawm rau hloov ntawm kev sib txuas hauv database, koj tuaj yeem siv txoj kev Connection()
della facade
Cov ntaub ntawv. Txoj kev Connection()
siv lub npe ntawm kev sib txuas database raws li kev sib cav.
Piv txwv li, cov cai hauv qab no mus los ntawm mysql DB mus rau pgsql DB:
use Illuminate\Support\Facades\DB;
DB::connection('pgsql');
Thaum koj hloov mus rau qhov kev sib txuas database, koj tuaj yeem siv nws los nug thiab cuam tshuam nrog cov ntaub ntawv.
Muaj ntau cov txiaj ntsig rau kev siv ntau cov ntaub ntawv hauv Laravel, suav nrog:
Nov yog qee qhov kev coj ua zoo tshaj plaws rau kev siv ntau cov ntaub ntawv hauv Laravel:
Connection()
mus los ntawm ib DB mus rau lwm tus - qhov no yuav pab tau koj kom tsis txhob ua yuam kev khiav lus nug sul database yuam kev.Kev siv ntau cov ntaub ntawv hauv Laravel tuaj yeem yog txoj hauv kev zoo los txhim kho kev ua haujlwm, kev ruaj ntseg, thiab ua kom muaj zog ntawm koj daim ntawv thov. Los ntawm kev ua raws li cov kev coj ua zoo tshaj plaws tau piav qhia hauv tsab xov xwm no, koj tuaj yeem siv ntau cov ntaub ntawv hauv Laravel zoo.
Ercole Palmeri
Ntau lab tus tib neeg them rau cov kev pabcuam streaming, them tus nqi them txhua hli. Nws yog ib qho kev xav tias koj…
Coveware los ntawm Veeam yuav txuas ntxiv muab kev pabcuam cyber extortion xwm txheej teb. Coveware yuav muaj peev xwm ua pov thawj thiab kho…
Kev kwv yees kev saib xyuas yog hloov pauv cov roj & roj sector, nrog rau txoj hauv kev tshiab thiab muaj txiaj ntsig rau kev tswj cov nroj tsuag.…
UK CMA tau tshaj tawm lus ceeb toom txog Big Tech tus cwj pwm hauv kev lag luam kev txawj ntse. Nyob ntawd…