Skip to content

yiisoft/db

Folders and files

NameName
Last commit message
Last commit date

Latest commit

1da8e94 · Jan 27, 2025
Dec 7, 2024
Mar 26, 2023
Jan 13, 2025
Jan 27, 2025
Jan 27, 2025
Jan 11, 2022
Apr 27, 2024
Jul 13, 2023
Nov 29, 2020
Mar 31, 2023
Jan 22, 2025
May 1, 2024
Aug 23, 2024
Jan 27, 2025
Apr 29, 2023
Dec 12, 2024
Jan 11, 2022
Nov 28, 2024
May 4, 2024
May 4, 2024
Aug 23, 2024

Repository files navigation

Yii

Yii Database

Latest Stable Version Total Downloads Build status codecov static analysis type-coverage

Yii Database is a framework-agnostic package to work with different types of databases, such as MariaDB, MySQL, MSSQL, Oracle, PostgreSQL and SQLite.

Using the package, you can perform common database tasks such as creating, reading, updating, and deleting records in a database table, as well as executing raw SQL queries.

$rows = (new Query($db))  
    ->select(['id', 'email'])  
    ->from('{{%user}}')  
    ->where(['last_name' => 'Smith'])  
    ->limit(10)  
    ->all();

The package is designed to be flexible and can be extended to support extra database types or to customize the way it interacts with databases.

There is an ActiveRecord implementation built on top of it. It allows interacting with database tables using objects, similar to the way you would use ORM (Object-Relational Mapping) frameworks like Doctrine or Hibernate.

Requirements

  • PHP 8.1 or higher.

Documentation

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.

Support the project

Open Collective

Follow updates

Official website Twitter Telegram Facebook Slack