// 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'
);
|
最后要加上执行语句:
$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;
$result为受影响的数据库记录数。
http://www.kofans.org/3.2/guide/database/query/builder#insert