amorphis
- amorphis 赞了回答
先创建连接对象
$connection = new \yii\db\Connection([ 'dsn' => $dsn, 'username' => $username, 'password' => $password, ]); $connection->open();
查询返回多行:
$command = $connection->createCommand('SELECT * FROM post'); $posts = $command->queryAll();
返回单行:
$command = $connection->createCommand('SELECT * FROM post WHERE id=1'); $post = $command->queryOne();
查询多行单值:
$command = $connection->createCommand('SELECT title FROM post'); $titles = $command->queryColumn();
查询标量值/计算值:
$command = $connection->createCommand('SELECT COUNT(*) FROM post'); $postCount = $command->queryScalar();
要养成先查文档的习惯:
http://www.yiichina.com/doc/guide/2.0/db-dao - amorphis 收藏了教程YII2 where查询条件整理
- amorphis 2017-08-30 已签到连续签到1天,获得了5个金钱
- amorphis 收藏了教程Yii2批量插入Tips
- amorphis 收藏了源码扩展Yii2的核心验证类