Creating Database

Earlier we performed CRUD operation with yii's Gii generating tool. Now we'll perform CRUD without Gii.

We'll perform a complete CRUD operation here.

The name of our Yii2 folder is dbb.

We have created a database named student and a table inside it named child.

Look at the above snapshot, this is our table's structure.

Database Configuration

To configure your database in Yii2, go to common/config/main-local.php file and write the name of your database.

We have written student as the name of our database.

<?php 
return [ 
    'components' => [ 
        'db' => [ 
            'class' => 'yii\db\Connection', 
            'dsn' => 'mysql:host=localhost;dbname=student', 
            'username' => 'root', 
            'password' => 'mysql', 
            'charset' => 'utf8', 
       ], 
        'mailer' => [ 
            'class' => 'yii\swiftmailer\Mailer', 
            'viewPath' => '@common/mail', 
            // send all mails to a file by default. You have to set 
            // 'useFileTransport' to false and configure a transport 
            // for the mailer to send real emails. 
            'useFileTransport' => true, 
        ], 
    ], 
]; 

Next TopicYII Create (Insert) Record

← prev next →