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();