yltianmei
- yltianmei 2016-04-08 已签到连续签到1天,获得了5个金钱
- yltianmei 回复了 KillMeAgain 的回答
queryAll()
中传的不是sql语句请参考http://www.yiichina.com/doc/api/2.0/yii-db-command#queryAll()-detail
嗯 已经搞定!多谢回答!
先创建连接对象
$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万分感谢!好人呀。回答得这么如此透彻明了!
错误呢,是PHP语法错误还是MYSQL错误
Database Exception – yii\db\Exception PDOStatement::fetchAll() expects parameter 1 to be long, string given The SQL being executed was: select * from hd_article where aid<31 order by aid desc limit 1 ↵ Caused by: yii\base\ErrorException PDOStatement::fetchAll() expects parameter 1 to be long, string given in D:\WWW\web\vendor\yiisoft\yii2\db\Command.php at line 848
- yltianmei 发表了说说YII2不会呀!只会YII1.1,2.0好难学呀!