CRUD ด้วย Eloquent

สร้าง — save()

<?php
$post = new Post();
$post->title = "Hello World";
$post->body  = "My first post";
$post->save(); // INSERT INTO posts ...

สร้าง — create()

<?php
$post = Post::create([
    "title" => "Hello World",
    "body"  => "My first post",
    "user_id" => auth()->id(),
]);

firstOrCreate และ updateOrCreate

<?php
// Find or create:
$tag = Tag::firstOrCreate(["name" => "PHP"]);

// Update or create:
$setting = Setting::updateOrCreate(
    ["key" => "theme"],
    ["value" => "dark"]
);

อ่าน — all()

<?php
$posts = Post::all(); // SELECT * FROM posts
foreach ($posts as $post) {
    echo $post->title;
}

อ่าน — find()

<?php
$post = Post::find(1);
$post = Post::findOrFail(1); // throws ModelNotFoundException if missing

อ่าน — where()

<?php
$published = Post::where("is_published", true)
                 ->where("user_id", $userId)
                 ->orderBy("created_at", "desc")
                 ->get();

อัปเดต — save()

<?php
$post = Post::findOrFail(1);
$post->title = "Updated Title";
$post->save(); // UPDATE posts SET title=... WHERE id=1

อัปเดต — update()

<?php
Post::where("user_id", $userId)
    ->update(["is_published" => false]);

ลบ — delete()

<?php
$post = Post::findOrFail(1);
$post->delete(); // DELETE FROM posts WHERE id=1

ลบ — destroy()

<?php
Post::destroy(1);
Post::destroy([1, 2, 3]); // delete multiple

การแบ่งหน้า

<?php
$posts = Post::latest()->paginate(15);
// In Blade: {{ $posts->links() }}

สรุป

ตรวจสอบความเข้าใจ