How to connect to the database using php yii framework-YII-php.cn

How to connect to the database using php yii framework

angryTom

Release： 2019-11-04 14:15:58

Original

2868 people have browsed it

This article mainly introduces the database configuration and SQL operation example tutorials in PHP's Yii framework. Yii supports binding a variety of databases. The article mainly gives examples of the use of various query statements in Yii. Need Friends can refer to

php yii framework how to connect to the database

Database access ( DAO)

Yii includes a data access layer (DAO) built on PHP PDO. DAO provides a unified API for different databases. ActiveRecord provides databases and models ( M, Model) in MVC, QueryBuilder is used to create dynamic query statements. DAO provides simple and efficient SQL queries, which can be used in various places to interact with the database.

Yii supports the following databases by default ( DBMS):

MySQLMariaDBSQLitePostgreSQLCUBRID: Version>= 9.3. (Due to a bug in the PHP PDO extension, the reference value will be invalid, so you need to use 9.3 on both the client and server side of CUBRID)OracleMSSQL: Version> =2005.

1. Configuration

To start using the database, you first need to configure the database connection component, which is achieved by adding the db component to the application configuration (the "basic" Web application is config/web.php), DSN (Data Source Name) is the data source name, used to specify database information. As shown below:

return [
  // ...
  &#39;components&#39; => [
    // ...
    &#39;db&#39; => [
      &#39;class&#39; => &#39;yii\db\Connection&#39;,
      &#39;dsn&#39; => &#39;mysql:host=localhost;dbname=mydatabase&#39;, // MySQL, MariaDB
      //&#39;dsn&#39; => &#39;sqlite:/path/to/database/file&#39;, // SQLite
      //&#39;dsn&#39; => &#39;pgsql:host=localhost;port=5432;dbname=mydatabase&#39;, // PostgreSQL
      //&#39;dsn&#39; => &#39;cubrid:dbname=demodb;host=localhost;port=33000&#39;, // CUBRID
      //&#39;dsn&#39; => &#39;sqlsrv:Server=localhost;Database=mydatabase&#39;, // MS SQL Server, sqlsrv driver
      //&#39;dsn&#39; => &#39;dblib:host=localhost;dbname=mydatabase&#39;, // MS SQL Server, dblib driver
      //&#39;dsn&#39; => &#39;mssql:host=localhost;dbname=mydatabase&#39;, // MS SQL Server, mssql driver
      //&#39;dsn&#39; => &#39;oci:dbname=//localhost:1521/mydatabase&#39;, // Oracle
      &#39;username&#39; => &#39;root&#39;, //数据库用户名
      &#39;password&#39; => &#39;&#39;, //数据库密码
      &#39;charset&#39; => &#39;utf8&#39;,
    ],
  ],
  // ...
];

Copy after login

2. After configuring the connection component, you can use the following syntax to access:

$connection = \Yii::$app->db;

Copy after login

If you want to connect to the database through ODBC, you need to configure the yii\db\Connection::driverName property, for example:

&#39;db&#39; => [
  &#39;class&#39; => &#39;yii\db\Connection&#39;,
  &#39;driverName&#39; => &#39;mysql&#39;,
  &#39;dsn&#39; => &#39;odbc:Driver={MySQL};Server=localhost;Database=test&#39;,
  &#39;username&#39; => &#39;root&#39;,
  &#39;password&#39; => &#39;&#39;,
],

Copy after login

If you do not want to define the database connection as a global application component, It can be initialized directly in the code:

$connection = new \yii\db\Connection([
  &#39;dsn&#39; => $dsn,
   &#39;username&#39; => $username,
   &#39;password&#39; => $password,
]);
$connection->open();

Copy after login

3. If you need to perform additional SQL queries after creating the connection, you can add the following code to the application configuration file:

return [
  // ...
  &#39;components&#39; => [
    // ...
    &#39;db&#39; => [
      &#39;class&#39; => &#39;yii\db\Connection&#39;,
      // ...
      &#39;on afterOpen&#39; => function($event) {
        $event->sender->createCommand("SET time_zone = &#39;UTC&#39;")->execute();
      }
    ],
  ],
  // ...
];

Copy after login

If executing SQL does not return any data, you can use the execute method in the command:

$command = $connection->createCommand(&#39;UPDATE post SET status=1 WHERE id=1&#39;);
$command->execute();

Copy after login

You can use the insert, update, and delete methods. These methods will generate appropriate SQL based on the parameters and execute it.

// INSERT
$connection->createCommand()->insert(&#39;user&#39;, [
  &#39;name&#39; => &#39;Sam&#39;,
  &#39;age&#39; => 30,
])->execute();
// INSERT 一次插入多行
$connection->createCommand()->batchInsert(&#39;user&#39;, [&#39;name&#39;, &#39;age&#39;], [
  [&#39;Tom&#39;, 30],
  [&#39;Jane&#39;, 20],
  [&#39;Linda&#39;, 25],
])->execute();
// UPDATE
$connection->createCommand()->update(&#39;user&#39;, [&#39;status&#39; => 1], &#39;age > 30&#39;)->execute();
// DELETE
$connection->createCommand()->delete(&#39;user&#39;, &#39;status = 0&#39;)->execute();

Copy after login

Recommended: "YII Tutorial"

The above is the detailed content of How to connect to the database using php yii framework. For more information, please follow other related articles on the PHP Chinese website!