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'];
}