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

	$comment = new Comment(array('message' => 'A new comment.'));
	 
	$post = Post::find(1);
	 
	$comment = $post->comments()->insert($comment);

	$comments = array(
	    array('message' => 'A new comment.'),
	    array('message' => 'A second comment.'),
	);
	 
	$post = Post::find(1);
	 
	$post->comments()->save($comments);

	$role = new Role(array('title' => 'Admin'));
	 
	$user = User::find(1);
	 
	$role = $user->roles()->insert($role);

	$user->roles()->attach($role_id);

	$user->roles()->attach($role_id, array('expires' => $expires));

$user->roles()->sync(array(1, 2, 3));

	$user = User::find(1);
	 
	$pivot = $user->roles()->pivot();[/code]
Pivot คือ model ของตารางกลางนะครับ ตัวอย่างข้างล่างนี้ค้นไปวนลูปโชว์ไปเลยครับ:
[code]	foreach ($user->roles()->pivot()->get() as $row)
	{
	    //
	}

	$user = User::find(1);
	 
	foreach ($user->roles as $role)
	{
	    echo $role->pivot->created_at;
	}

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

	class Book extends Eloquent {
	 
	     public function author()
	     {
	          return $this->belongs_to('Author');
	     }
	 
	}

	foreach (Book::all() as $book)
	{
	     echo $book->author->name;
	}

	foreach (Book::with('author')->get() as $book)
	{
	     echo $book->author->name;
	}

	SELECT * FROM "books"
	 
	SELECT * FROM "authors" WHERE "id" IN (1, 2, 3, 4, 5, …)

	$books = Book::with(array('author', 'publisher'))->get();

	$books = Book::with(array('author', 'author.contacts'))->get();

	class Book extends Eloquent {
	 
	     public $includes = array('author');
	 
	     public function author()
	     {
	          return $this->belongs_to('Author');
	     }
	 
	}

	foreach (Book::all() as $book)
	{
	     echo $book->author->name;
	}

	$users = User::with(array('posts' => function($query)
	{
	    $query->where('title', 'like', '%first%');
	 
	}))->get();

	public function set_password($password)
	{
	    $this->set_attribute('hashed_password', Hash::make($password));
	}

	$this->password = "my new password";

	public function get_published_date()
	{
	    return date('M j, Y', $this->get_attribute('published_at'));
	}

	echo $this->published_date;

	$user = new User(array(
	    'username' => 'first last',
	    'password' => 'disgaea'
	));
	 
	$user->save();

	$user = new User;
	 
	$user->fill(array(
	    'username' => 'first last',
	    'password' => 'disgaea'
	));
	 
	$user->save();

	public static $accessible = array('email', 'password', 'name');

	User::accessible(array('email', 'password', 'name'));

	return json_encode($user->to_array());

	class User extends Eloquent {
	 
	    public static $hidden = array('password');
	 
	}

$author->delete();