YII creating Database

by Online Tutorials Library July 14, 2022

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’ => ‘yiidbConnection’,               ‘dsn’ => ‘mysql:host=localhost;dbname=student’,               ‘username’ => ‘root’,               ‘password’ => ‘mysql’,               ‘charset’ => ‘utf8’,          ],           ‘mailer’ => [               ‘class’ => ‘yiiswiftmailerMailer’,               ‘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

YII creating Database

Creating Database

Database Configuration

XSLT Element

YII2 Installation

You may also like