/** * Get first data from table by id * * @param $id * @return mixed */ public static function byId($id) { $instance = static::getInstance(); return DB::table($instance->table)->where($instance->primary, $id)->first(); }
public function complex() { $memberList = DB::table('member')->limit(100)->get(); Cache::store('member_list_cache', $memberList); Session::set('member_list', Cache::get('member_list_cache')); $this->data['member_list'] = Session::get('member_list'); DB::beginTransaction(); DB::insert('test', array('val1' => 'A', 'val2' => 'B')); $insert_id = DB::insertId(); DB::update('test', 'test_id', $insert_id - 1, array('val1' => 'A2', 'val2' => 'B2')); DB::delete('test', 'test_id', $insert_id - 3); DB::commit(); $sql = "SELECT * FROM member WHERE email = ? AND name LIKE ?"; $this->data['member_list'] = DB::getAllQuery($sql, array('*****@*****.**', '%Elips%')); Blade::render('testing', $this->data); }