/**
* 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);
}
