Laravel Eloquent Model ?? : ?????? ???? ?? ?? ? ????

Eloquent ORM? ??????? ???? ???? ???? ?? ??? ?????. ? ??? ???????? ???? ????? ?? ? ????? ??? ?? ?? ?? ??? ??? ?????.

1. ?? ??? ?????

all() ???? ???? ?????? ????? ?? ???? ?????.

 <code class="php">use App\Models\Post; $posts = Post::all();</code>

??? ???? ?????. foreach ?? ?? ?? ?? ??? ???? ???? ??? ? ? ????.

 <code class="php">foreach ($posts as $post) { echo $post->title; }</code>

2. ?? ???? ?????

• find() ??? : ?? ?? ?? ?? ???? ????.

 <code class="php">$post = Post::find(1); if ($post) { echo $post->title; }</code>

• findOrFail() ??? : ???? ???? ??? 404 HTTP ??? ?????.

 <code class="php">$post = Post::findOrFail(1);</code>

• first() ??? : ??? ???? ? ?? ???? ?????.

 <code class="php">$post = Post::where('status', 'published')->first();</code>

• firstOrFail() ??? : ??? ???? ???? ??? 404 HTTP ??? ?????.

 <code class="php">$post = Post::where('status', 'published')->firstOrFail();</code>

3. ??? ?? ???? ?????

?? ? ?? ??? where ?? ?? ???? ????? ? ?????.

• ?? ?? :

 <code class="php">$posts = Post::where('status', 'published')->get();</code>

• ?? ?? :

 <code class="php">$posts = Post::where('status', 'published') ->where('user_id', 1) ->get();</code>

• orWhere ?? :

 <code class="php">$posts = Post::where('status', 'published') ->orWhere('status', 'draft') ->get();</code>

4. ?? ?? ??????

select() ???? ?? ? ?? ???? ? ?????.

 <code class="php">$posts = Post::select('title', 'content')->get();</code>

5. Pagination

paginate() ???? ??? Pagination? ???? ? ?????.

 <code class="php">$posts = Post::paginate(10);</code>

???? ???? ??? ?? ?? :

 <code class="blade">{{ $posts->links() }}</code>

6. ?? ??

chunk() ???? ?? ?? ???? ???? ??? ??? ??? ? ?????.

 <code class="php">Post::chunk(100, function ($posts) { foreach ($posts as $post) { echo $post->title; } });</code>

7. ??

orderBy() ???? ??? ???? ? ?????.

 <code class="php">$posts = Post::orderBy('created_at', 'desc')->get();</code>

8. ?? ? ???

take() ?? limit() ? skip() ??? ?? ???? ?? ? ?????.

 <code class="php">$posts = Post::take(5)->get(); // 獲取前5 條記錄$posts = Post::skip(10)->take(5)->get(); // 跳過前10 條，獲取接下來的5 條</code>

9. ?? ??

Eloquent? ??? ?? ??? ?????.

• count() : ??? ??? ????
• max() : ?? ?? ????
• min() : ???? ?????
• avg() : ??? ?????
• sum() : ??? ????

10. ?? ?? ??

?? ??? ?? ???? ???? ?? ?? ? ? ????.

• ?? ?? :

 <code class="php">$posts = Post::with('comments')->get();</code>

• ?? ?? :

 <code class="php">$posts = Post::with(['comments', 'user'])->get();</code>

11. ?? SQL ??

??? ??? ?? ?? SQL ??? ??? ? ????.

 <code class="php">use Illuminate\Support\Facades\DB; $posts = DB::select('SELECT * FROM posts WHERE status = ?', ['published']);</code>

?? ??? ????? Laravel Eloquent? ???? ?????? ???? ???? ????? ?? ? ? ????. ??? ???? ??? ????? ?? ?? ??? ?? ?? ??? ??? ???????.

? ??? Bangla ?? ?? ??? Laravel Eloquent Orm)? ?? ?????. ??? ??? PHP ??? ????? ?? ?? ??? ?????!