kohana直接执行query写法sql语句

最新推荐文章于 2019-11-20 18:33:53 发布

lumengabc

最新推荐文章于 2019-11-20 18:33:53 发布

阅读量2.1k

点赞数

分类专栏： kohana

本文链接：https://blog.csdn.net/webnoties/article/details/17219509

版权

kohana 专栏收录该内容

30 篇文章 0 订阅

订阅专栏

   
   
       
       
        
         
         // Create a new SELECT query 
        
        
         
         $query 
         = DB::query(Database::SELECT,  
         'SELECT * FROM users' 
         ); 
        
        
        
            
        
        
         
         // Create a new DELETE query 
        
        
         
         $query 
         = DB::query(Database:: 
         DELETE 
         ,  
         'DELETE FROM users WHERE id = 5' 
         ); 
        
        
         
         
 
        
        
         
          
           
           // Create a new UPDATE query 
           
           
           $query 
           = DB::query(Database:: 
           DELETE 
           ,  
           'UPDATE users SET title=3 WHERE id = 5' 
           );

最后要加上执行语句：

$result = $query ->execute();


$query = DB::insert('users', array('username', 'password'))->values(array('fred', 'p@5sW0Rd'));
INSERT INTO `users` (`username`, `password`) VALUES ('fred', 'p@5sW0Rd')


$query = DB::update('users')->set(array('username' => 'jane'))->where('username', '=', 'john');
UPDATE `users` SET `username` = 'jane' WHERE `username` = 'john'


		$fields = array('cityname', 'pinyin', 'py', 'p');
		$query = DB::insert('city', $fields);
		foreach($data as $k=>$v)
		{
			$query->values($v);
		}
		$query->execute();
		
		echo $query;
		return $query;