é
ç½®å®æ°æ®åºè¿æ¥ï¼å°±å¯ä»¥ä½¿ç¨DBç±»è¿è¡æ¥è¯¢äºã
æ¥è¯¢
$results = DB::select('select * from users where id = ?', array(1));
selectæ¹æ³ä¼ä»¥æ°ç»å½¢å¼è¿åæ¥è¯¢ç»æã
æå
¥
DB::insert('insert into users (id, name) values (?, ?)', array(1, 'Dayle'));
æ´æ°
DB::update('update users set votes = 100 where name = ?', array('John'));
å é¤
DB::delete('delete from users');
注æï¼updateådeleteè¯å¥è¿ååå½±åçè¡æ°ã
éç¨è¯å¥
DB::statement('drop table users');
çå¬Queryäºä»¶
DB::listen(function($sql, $bindings, $time)
{
//
});
æ°æ®åºäºå¡
DB::transaction(function()
{
DB::table('users')->update(array('votes' => 1));
DB::table('posts')->delete();
});
注æï¼transactionéå
ä¸çä»»ä½å¼å¸¸å°ä¼å¯¼è´äºå¡èªå¨åæ»ã
ææ¶åä¹è®¸ä½ æ³èªå·±å¼å¯äºå¡ï¼
DB::beginTransaction();
ä½ ä¹å¯ä»¥èªå·±åæ»äºå¡ï¼
DB::rollback();
æåï¼ä½ å¯ä»¥éè¿commitæ¹æ³æ交äºå¡ï¼
DB::commit();
å¤ä¸ªæ°æ®åºè¿æ¥è®¿é®
å½ä½¿ç¨å¤ä¸ªæ°æ®åºè¿æ¥æ¶ï¼å¯ä»¥éè¿DB::connectionæ¹æ³è®¿é®å®ä»¬ï¼
$users = DB::connection('foo')->select(...);
ä½ å¯ä»¥éè¿PDOå®ä¾è®¿é®åçè¿æ¥ï¼
$pdo = DB::connection()->getPdo();
ææ¶åä½ éè¦éè¿æ°æ®åºï¼
DB::reconnect('foo');
å¦æå 为è¶
åºPDOå®ä¾çæ大è¿æ¥æ°éå¶èè¦æå¼è¿æ¥ï¼ä½¿ç¨disconnectæ¹æ³ï¼
DB::disconnect('foo');
æ¥è¯¢æ¥å¿
é»è®¤æ
åµä¸ï¼Laravel使ç¨æ¥å¿è®°å½å½å请æ±çæææ°æ®åºæ¥è¯¢æä½ï¼ä½æ¯æäºæ¶åï¼æ¯å¦æå
¥å¤§éæ°æ®ï¼ä¼å¼èµ·åºç¨ä½¿ç¨è¿éå
åã为äºå
³éæ¥å¿ï¼å¯ä»¥ä½¿ç¨disableQueryæ¹æ³ï¼
DB::connection()->disableQueryLog();
è·åæ¥è¯¢æ¥å¿è®°å½ï¼å¯ä»¥ç¨è¿getQueryæ¹æ³ï¼
$queries = DB::getQueryLog();
温馨提示:答案为网友推荐,仅供参考