yiisoft/db

yiisoft/db has 215 GitHub stars and 49 forks. Star changes are not measured yet. Last checked 2026-11-14 02:18 UTC. Last push 2026-11-12.

So werden diese Zahlen gemessen

215 Sterne 49 Forks

Gemessener Sternzuwachs

in 24h: Verlauf wird gesammelt
in 7 days: Verlauf wird gesammelt
in 15 days: Verlauf wird gesammelt
in 1 month: Verlauf wird gesammelt

Nettoänderungen in überlappenden Zeiträumen, keine Tagessummen. Fehlende Messwerte bleiben leer. Sterne zeigen Interesse, nicht Qualität.

Über uns

Yii Database Library

Daten

README.md

Original

Yii 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:

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.
pdo PHP 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();
    }
)