要連接數(shù)據(jù)庫，首先在配置文件中設(shè)置數(shù)據(jù)庫連接參數(shù)。 1. 在config/db.php或config/web.php中配置數(shù)據(jù)庫信息，包括DSN、用戶名、密碼等；2. 使用Yii::$app->db訪問已配置的連接；3. 編寫SQL查詢或使用Active Record操作數(shù)據(jù)；4. 創(chuàng)建測試動作驗證連接是否成功；5. 如需多數(shù)據(jù)庫支持，在配置中定義多個連接並在代碼中分別調(diào)用。通過這些步驟，可以順利實現(xiàn)Yii應(yīng)用與數(shù)據(jù)庫的連接和交互。

To connect to a database using Yii, you mainly need to configure the database connection in your application's configuration file. This tells Yii how to reach your database and what type of database you're using.

Here's how to do it step by step.

Configure the Database Connection

In a Yii application, database settings are usually defined in the config/db.php file or directly inside the config/web.php (for web applications) or config/console.php (for console apps).

A basic configuration looks like this:

 return [
    'class' => 'yii\db\Connection',
    'dsn' => 'mysql:host=localhost;dbname=your_database_name',
    'username' => 'your_username',
    'password' => 'your_password',
    'charset' => 'utf8',
];

Make sure to replace:

• your_database_name
• your_username
• your_password

If you're not using MySQL, change the DSN accordingly. For example:

• SQLite: 'dsn' => 'sqlite:@app/database/mydatabase.db'
• PostgreSQL: 'dsn' => 'pgsql:host=localhost;dbname=mydb;user=me;password=secret'

This setup is straightforward and works for most small to medium-sized projects.

Use the Database Connection in Your Code

Once configured, Yii automatically sets up the database connection when needed. You can access it anywhere in your code using Yii::$app->db .

For example, to run a simple SQL query:

 $connection = Yii::$app->db;
$command = $connection->createCommand('SELECT * FROM user WHERE id = 1');
$user = $command->queryOne();

You don't have to manually open or close the connection — Yii handles that for you.

Also, if you're using Active Record (which is common in Yii), you don't even need to write raw SQL much of the time. Just define your model classes and use methods like find() , save() , etc.

Test Your Connection

It's always a good idea to test whether your database connection works before diving into complex queries.

You can create a simple controller action like this:

 public function actionTestDb()
{
    try {
        Yii::$app->db->open();
        echo "Database connection is working!";
    } catch (\Exception $e) {
        echo "Failed to connect to the database: " . $e->getMessage();
    }
}

If you see an error message, double-check your DSN, username, and password. Also, make sure your database server is running and accessible from your app.

Common issues include:

• Incorrect host name or port
• Wrong database name
• Missing or wrong credentials
• No remote access permissions (especially on shared hosting)

Optional: Set Up Multiple Database Connections

If your project needs to connect to more than one database (like a read/write split or separate databases for different modules), Yii supports that too.

In your config file, instead of returning a single connection, you define multiple ones:

 return [
    'components' => [
        'db' => [
            'class' => 'yii\db\Connection',
            'dsn' => 'mysql:host=localhost;dbname=main_db',
            'username' => 'root',
            'password' => '',
        ],
        'db2' => [
            'class' => 'yii\db\Connection',
            'dsn' => 'mysql:host=localhost;dbname=secondary_db',
            'username' => 'root',
            'password' => '',
        ],
    ],
];

Then in your code, use them like this:

 // Main database
Yii::$app->db->createCommand(...)->execute();

// Secondary database
Yii::$app->db2->createCommand(...)->execute();

This is helpful in larger applications where data might be spread across different systems.

That's basically it. Connecting to a database in Yii is pretty straightforward once you understand how the configuration works.

以上是如何使用YII連接到數(shù)據(jù)庫？的詳細內(nèi)容。更多資訊請關(guān)注PHP中文網(wǎng)其他相關(guān)文章！