yii框架数据库操作

return [
    'class' => 'yii\db\Connection',
    'dsn' => 'mysql:host=localhost;dbname=mydatabase',
    'username' => 'myuser',
    'password' => 'mypassword',
    'charset' => 'utf8',
];

namespace app\models;

use yii\db\ActiveRecord;

class User extends ActiveRecord
{
    public static function tableName()
    {
        return 'users';
    }
}

// 获取所有用户
$users = User::find()->all();

// 根据ID获取用户
$user = User::findOne(1);

// 条件查询
$users = User::find()->where(['status' => 1])->all();

// 排序和分页
$users = User::find()->orderBy('created_at DESC')->offset(10)->limit(10)->all();

$transaction = Yii::$app->db->beginTransaction();
try {
    // 执行数据库操作
    $user = User::findOne(1);
    $user->status = 2;
    $user->save();

    // 提交事务
    $transaction->commit();
} catch (\Exception $e) {
    // 回滚事务
    $transaction->rollBack();
    throw $e;
}