Home  >  Article  >  Database  >  Yii数据库操作_MySQL

Yii数据库操作_MySQL

WBOY
WBOYOriginal
2016-06-01 13:07:221214browse

参考:https://github.com/yii2-chinesization/yii2-zh-cn/blob/master/guide-zh-CN/db-dao.md


返回多行:

$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();
更新数据:
$command = $connection->createCommand('UPDATE post SET status=1 WHERE id=1');$command->execute();
一次插入单行/多行:
// INSERT	$connection->createCommand()->insert('user', [	    'name' => 'Sam',	    'age' => 30,	])->execute();// INSERT 一次插入多行	$connection->createCommand()->batchInsert('user', ['name', 'age'], [	    ['Tom', 30],	    ['Jane', 20],	    ['Linda', 25],	])->execute();
更新:

$connection->createCommand()->update('user', ['status' => 1], 'age > 30')->execute();

删除:

$connection->createCommand()->delete('user', 'status = 0')->execute();
预处理:
$command = $connection->createCommand('SELECT * FROM post WHERE id=:id');$command->bindValue(':id', $_GET['id']);$post = $command->query();
一次预处理语句执行多次:

$command = $connection->createCommand('DELETE FROM post WHERE id=:id');$command->bindParam(':id', $id);	$id = 1;$command->execute();	$id = 2;$command->execute();

建表:
$connection->createCommand()->createTable('post', [	  'id' => 'pk',	   'title' => 'string',	   'text' => 'text',]);


Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn