yiisoft/db has 212 GitHub stars and 49 forks. GitHot measured 0 stars in 24 hours. Last checked 2026-11-19 13:38 UTC. Last push 2026-11-12.
측정된 스타 증가
- in 24h
- 0
- in 7 days
- 기록 수집 중
- in 15 days
- 기록 수집 중
- in 1 month
- 기록 수집 중
서로 겹치는 기간의 순증가량이며 일별 합계가 아닙니다. 측정값이 없으면 비워 둡니다. 스타는 관심도를 나타내며 품질을 보장하지 않습니다.
소개
Yii Database Library
데이터README.md
OriginalYii Database
Framework-agnostic database abstraction layer that provides a set of classes to connect and interact with various database management systems (DBMS) using a unified API, including a powerful query builder.
Available database drivers:
- Yii DB MSSQL
- Yii DB MySQL (also supports MariaDB)
- Yii DB Oracle
- Yii DB PostgreSQL
- Yii DB SQLite
Optional packages that provide additional functionality:
- Yii Active Record provides an object-oriented interface for working with database tables, similar to ORM frameworks such as Doctrine or Hibernate.
- Yii DB Migration allows you to manage database schema using migrations.
Requirements
- PHP 8.1 - 8.5.
pdoPHP extension.
Installation
To install yiisoft/db you must install at least one database driver:
[!TIP] To cache database schema information, install PSR-16 implementation. For example, yiisoft/cache or one of the other cache handlers. It's strongly recommended for production.
General Usage
To connect to a database, create an instance of the appropriate driver:
use Yiisoft\Db\Sqlite\Connection;
use Yiisoft\Db\Sqlite\Driver;
/**
* @var Psr\SimpleCache\CacheInterface $cache
*/
// Creating a database connection
$db = new Connection(
new Driver('sqlite:memory:'),
new SchemaCache($cache),
);
You can then use the $db object to execute SQL queries, manage transactions, and perform other database operations.
Here are some examples:
use Yiisoft\Db\Connection\ConnectionInterface;
/**
* @var ConnectionInterface $db
*/
// Query builder
$rows = $db
->select(['id', 'email'])
->from('{{%user}}')
->where(['last_name' => 'Smith'])
->limit(10)
->all();
// Insert
$db->createCommand()
->insert(
'{{%user}}',
[
'email' => '[email protected]',
'first_name' => 'Mike',
'last_name' => 'Smith',
],
)
->execute();
// Transaction
$db->transaction(
static function (ConnectionInterface $db) {
$db->createCommand()
->update('{{%user}}', ['status' => 'active'], ['id' => 1])
->execute();
$db->createCommand()
->update('{{%profile}}', ['visibility' => 'public'], ['user_id' => 1])
->execute();
}
)
Documentation
- Guide: English, Português - Brasil
- Internals
If you need help or have a question, the Yii Forum is a good place for that. You may also check out other Yii Community Resources.
License
The Yii Database is free software. It is released under the terms of the BSD License.
Please see LICENSE for more information.
Maintained by Yii Software.