yii直接执行sql
来源:互联网 发布:redis 16个数据库 编辑:程序博客网 时间:2024/06/04 20:54
例1
$connection = Yii::app()->db;
$sql = "SELECT * FROM `project` ORDER BY id DESC";
$command = $connection->createCommand($sql);
$result = $command->queryAll();
$sql = "SELECT * FROM `project` ORDER BY id DESC";
$command = $connection->createCommand($sql);
$result = $command->queryAll();
print_r($result);
例2
$db = Yii::app()->db; //you have to define db connection in config/main.php
$sql = "select sum(if(starttime>'09:00:00',1,0)) as late,
sum(if(endtime<'18:00:00',1,0)) as early
from present where userid=:userid and date between :date_start and :date_end"
$results = $db->createCommand($sql)->query(array(
':userid' => 115,':date_start'=>'2009-12-1',':date_end'=>'2009-12-31',
));
foreach($results as $result){
echo $result['late']," and ",$result['early']," /n";
}
sum(if(endtime<'18:00:00',1,0)) as early
from present where userid=:userid and date between :date_start and :date_end"
$results = $db->createCommand($sql)->query(array(
':userid' => 115,':date_start'=>'2009-12-1',':date_end'=>'2009-12-31',
));
foreach($results as $result){
echo $result['late']," and ",$result['early']," /n";
}
例3
$sql = "select sum(if(starttime>'09:00:00',1,0)) as late,
sum(if(endtime<'18:00:00',1,0)) as early
from present where userid=115 and date between '2009-12-1' and '2009-12-31'"
$results = $db->createCommand($sql)->query();
foreach($results as $result){
echo $result['late']," and ",$result['early']," /n";
}
from present where userid=115 and date between '2009-12-1' and '2009-12-31'"
$results = $db->createCommand($sql)->query();
foreach($results as $result){
echo $result['late']," and ",$result['early']," /n";
}
例4
$oDbConnection = Yii::app()->db; // Getting database connection (config/main.php has to set up database
// Here you will use your complex sql query using a string or other yii ways to create your query
$oCommand = $oDbConnection->createCommand('SELECT * FROM my_table WHERE myAttr = :myValue');
// Bind the parameter
$oCommand->bindParam(':myValue', $myValueThatCameFromPostOrAnywereElse, PDO::PARAM_STR);
// Here you will use your complex sql query using a string or other yii ways to create your query
$oCommand = $oDbConnection->createCommand('SELECT * FROM my_table WHERE myAttr = :myValue');
// Bind the parameter
$oCommand->bindParam(':myValue', $myValueThatCameFromPostOrAnywereElse, PDO::PARAM_STR);
$oCDbDataReader = $oCommand->queryAll(); // Run query and get all results in a CDbDataReader
说明:把查询条件作为参数(如例2),比较安全,可直接避免注入。要是直接用在SQL语句中,最好要经过防注入处理。
come from http://blog.csdn.net/straul/article/details/6320858
- yii直接执行sql
- yii 直接执行SQl语句
- Yii - 直接执行SQL语句
- Yii 直接执行SQL语句
- Yii直接执行sql语句的方法小结
- Yii 直接执行SQL语句的几种使用方法
- Yii中直接使用sql
- 直接执行SQL查询
- django 直接执行SQL
- Mybatis 直接执行SQL
- 在Yii中直接使用sql
- mybatis直接执行sql语句
- mybatis直接执行sql语句
- Hibernate直接执行原生SQL
- Hibernate直接执行SQL语句
- mybatis直接执行sql语句
- Yii PDO方式执行SQL语句
- yii 执行sql语句方法集
- 一个初略看起来不错的网站(关于嵌入式linux等)
- 1034. Head of a Gang
- 纯PHP Codeigniter(CI) ThinkPHP效率测试
- POJ 1753 枚举二进制+BFS
- 空间布局的一点心得
- yii直接执行sql
- SQL经典面试题目总结
- js 中的replace()方法
- TCP/IP,http,socket,长连接,短连接——小结。
- C#点击“生成解决方案”项目不编译
- IOS中 Block简介与用法(一)
- 如何分析驱动蓝屏
- [转载]6 个用于数据处理的超强 JavaScript 库
- 怎么写makefile?