0
1

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?

More than 5 years have passed since last update.

Lalavel Eloquentの使用

0
Last updated at Posted at 2020-06-06

Laravel Eloquentの記述

modelファイルの作成

$ php artisan make:model Hoge

Model created successfully.

class Hoge は DBテーブルの hoges とバインドされる
(DBテーブルは、最初が小文字で複数形)

app/Hoge.php

namespace App;

use Illuminate\Database\Eloquent\Model;

class Hoge extends Model
{
    protected $table = '{テーブル名}'; //DBテーブルとclass名が違う場合、テーブル名を指定する
}

Controller を編集

insertの記述(1)

app/Http/Controllers
use DB;
use App\Hoge

class HogeController extends Controller
{
    public function index(){
        $hoge = new Hoge();  //インスタンスの作成
        $hoge->last_name = $request->imput('last_name');
        $hoge->first_name = $request->imput('first_name');
        $result = $hoge->save();      //insert実行

        return ;
    }
}

insertの記述(2)

app/Http/Controllers
use DB;
use App\Hoge

class HogeController extends Controller
{
    public function index(){
        Hoge::create($request->all());  //入力値全てを取得

        return ;
    }
}
app/app/Hoge.php
class Hoge extends Model
{
    protected $fillable = [    //DBに登録するname属性を記載
        'last_name',
        'first_name',
    ];
}

updateの記述

app/Http/Controllers
use DB;
use App\Hoge

class HogeController extends Controller
{
    public function index(){
        $hoge = Hoge::where('id', 1)->frist();  
        $hoge->last_name = '田中';
        $hoge->first_name = '太朗';
        $result = $hoge->save();      //update実行

        return ;
    }
}
app/Http/Controllers
use DB;
use App\Hoge

class HogeController extends Controller
{
    public function index(){
        $result = Hoge::where('id', 1)->updata([
            'age' => '20'
        ]);

        return ;
    }
}

deleteの記述(論理削除)

app/Hoge.php

namespace App;

use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\SoftDeletes; //追記

class Hoge extends Model
{
   use SoftDeletes; //追記

   protected $dates = ['deleted_at']; //追記
}
app/Http/Controllers
use DB;
use App\Hoge

class HogeController extends Controller
{
    public function index(){
        $result = Hoge::where('id', 1)->delete();

        return ;
    }
}

deleteの記述(物理削除)

app/Http/Controllers
use DB;
use App\Hoge

class HogeController extends Controller
{
    public function index(){
        $hoge = Hoge::where('id', 1)->frist();  
        $result = $hoge->delete();      //delete実行
        return ;
    }
}

DBから取得した返すカラムを指定する

class Title extends Model
{
  protected $visible = ['id','title','url'];
}

0
1
0

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
0
1

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?