Laravel::Eloquent ORM Part 1 ทำการให้คำสั่งคิวรี่สั้นได้อีก

class User extends Eloquent {}

	class User extends Eloquent {
	 
	     public static $table = 'my_users';
	 
	     public static $key = 'my_primary_key';
	 
	}

	$user = User::find(1);
	 
	echo $user->email;

	SELECT * FROM "users" WHERE "id" = 1

	$users = User::all();
	 
	foreach ($users as $user)
	{
	     echo $user->email;
	}

	$user = User::where('email', '=', $email)->first();
	 
	$user = User::where_email($email)->first();
	 
	$users = User::where_in('id', array(1, 2, 3))->or_where('email', '=', $email)->get();
	 
	$users = User::order_by('votes', 'desc')->take(10)->get();

	$min = User::min('id');
	$max = User::max('id');
	$avg = User::avg('id');
	$sum = User::sum('id');
	$count = User::count();
	$count = User::where('id', '>', 10)->count();

	$user = new User;
	 
	$user->email = '[email protected]';
	$user->password = 'secret';
	 
	$user->save();

$user = User::create(array('email' => '[email protected]'));

	$user = User::find(1);
 
	$user->email = '[email protected]';
	$user->password = 'new_secret';
	 
	$user->save();

class User extends Eloquent {
	 
	     public static $timestamps = true;
	 
	}

	$comment = Comment::find(1);
	$comment->touch();

	$comment = Comment::find(1);
	$comment->timestamp();
	//do something else here, but not modifying the $comment model data
	$comment->save();

	class User extends Eloquent {
	 
	     public function phone()
	     {
	          return $this->has_one('Phone');
	     }
	 
	}

$phone = User::find(1)->phone()->first();

	SELECT * FROM "users" WHERE "id" = 1
	 
	SELECT * FROM "phones" WHERE "user_id" = 1

	return $this->has_one('Phone', 'my_foreign_key');

	$phone = User::find(1)->phone;

	class Phone extends Eloquent {
	 
	     public function user()
	     {
	          return $this->belongs_to('User');
	     }
	 
	}

	echo Phone::find(1)->user()->first()->email;
	 
	echo Phone::find(1)->user->email;

	class Post extends Eloquent {
	 
	     public function comments()
	     {
	          return $this->has_many('Comment');
	     }
	 
	}

	$comments = Post::find(1)->comments()->get();
	 
	$comments = Post::find(1)->comments;

	SELECT * FROM "posts" WHERE "id" = 1
	 
	SELECT * FROM "comments" WHERE "post_id" = 1

	echo Post::find(1)->comments()->order_by('votes', 'desc')->take(10)->get();

// users:
	id    - INTEGER
	email - VARCHAR
// roles:
	id   - INTEGER
	name - VARCHAR
// role_user:
	id      - INTEGER
	user_id - INTEGER
	role_id - INTEGER

class User extends Eloquent {
	 
	     public function roles()
	     {
	          return $this->has_many_and_belongs_to('Role');
	     }
	 
	}

$roles = User::find(1)->roles()->get();

	$roles = User::find(1)->roles;

	class User extends Eloquent {
	 
	     public function roles()
	     {
	          return $this->has_many_and_belongs_to('Role', 'user_roles');
	     }
	 
	}

	class User extends Eloquent {
	 
	     public function roles()
	     {
	          return $this->has_many_and_belongs_to('Role', 'user_roles')->with('column');
	     }
	 
	}