Eloquent ORM

Eloquent ORM:为数据提供activerecord实现。（每个数据库表都有一个模型与这张表对应）

定义模型：class User extends Eloquent{

            protected $table = 'users';

            protected $primaryKey='userid';  //覆盖默认主键id

            public $timestamps = false;  //不会有updated_at,created_at

        }

获得所有记录：

    $users=User::all(); $users=User::get();

    foreach(){ $value->name}

获取某一条记录：

    $user=User::find(1);

    var_dump($users->name);

获取第一条记录：

    $user=User::first();

查询+分页：

    $users = User::paginate(Config::get('config.user.page'));

查询+分页+排序：

    $users=User::orderBy('name','desc')->paginate(Config::get('config.user.page'));

根据字段名查询一条

    $user = User::where('userid', '=', $id)->firstOrFail();

    var_dump($users->name);

    $user = User::where('userid', '=', $id)->get();

    foreach(){ $value->name}

获取两条

    $users=User::take(2)->get();

    foreach(){ $value->name}

统计

    $users = User::where('userid','=','6')->count();

添加

    $user = Input::only(['alias','name','passwd','theme','autologout','rows_per_page']);

    $newuser = new User($users);

    $newuser->passwd = md5($newuser->passwd);

    $user->save();

    $usergroup=new UserGroup();

    $usergroup->userid=$userid;

    $usergroup->usrgrpid=$usrgrpid;

    $usergroup->save();

修改

    User::where('userid', '=', $user['userid'])->update($user);

删除

    UserGroup::where('userid','=',$userid)->where('usrgrpid','=',$usrgrpid)->delete();