$connection = Yii::app()->db;
$sql = "SELECT * FROM `project` ORDER BY id DESC";
$command = $connection->createCommand( $sql);
$result = $command->queryAll();
print_r( $result);
$sql = "SELECT * FROM `project` ORDER BY id DESC";
$command = $connection->createCommand( $sql);
$result = $command->queryAll();
print_r( $result);
$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";
$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";
}
说明:把查询条件作为参数(如例2),比较安全,可直接避免注入。要是直接用在SQL语句中,最好要经过防注入处理。
$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";
}