{"id":9212,"date":"2020-10-30T10:00:58","date_gmt":"2020-10-30T01:00:58","guid":{"rendered":"https:\/\/www.gigas-jp.com\/appnews\/?p=9212"},"modified":"2020-10-29T18:49:46","modified_gmt":"2020-10-29T09:49:46","slug":"laravel-eloquent%e3%81%a8%e3%83%9a%e3%83%bc%e3%82%b8%e3%83%8d%e3%83%bc%e3%82%b7%e3%83%a7%e3%83%b31","status":"publish","type":"post","link":"https:\/\/www.gigas-jp.com\/appnews\/archives\/9212","title":{"rendered":"[Laravel] Eloquent\u3068\u30da\u30fc\u30b8\u30cd\u30fc\u30b7\u30e7\u30f3(1)"},"content":{"rendered":"\n

\u4eca\u56de\u306fLaravel\u6a19\u6e96\u306eO\/R\u30de\u30c3\u30d1\u30fc\u300cEloquent\u300d\u3092\u4f7f\u7528\u3057\u305f\u30c7\u30fc\u30bf\u53d6\u5f97\u65b9\u6cd5\u3092\u7d39\u4ecb\u3057\u305f\u3044\u3068\u601d\u3044\u307e\u3059\u3002<\/p>\n\n\n\n\n\n\n\n

\u30d7\u30e9\u30a4\u30de\u30ea\u30ad\u30fc\u3092\u4f7f\u7528\u3057\u305f\u30ec\u30b3\u30fc\u30c9\u691c\u7d22<\/h4>\n\n\n\n

\u30d7\u30e9\u30a4\u30de\u30ea\u30ad\u30fc(id)\u3092\u30ad\u30fc\u3068\u3057\u3066\u6761\u4ef6\u8a2d\u5b9a\u3092\u304a\u3053\u306a\u3044\u691c\u7d22\u3092\u304a\u3053\u306a\u3046\u5834\u5408\u3001SQL\u3067\u306f\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u8a18\u8ff0\u3057\u307e\u3059\u3002<\/p>\n\n\n\n

select * from students where id = '1';<\/code><\/pre>\n\n\n\n

Eloquent\u3092\u4f7f\u7528\u3057\u305f\u5834\u5408\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u3057\u3066\u30b7\u30f3\u30d7\u30eb\u306b\u53d6\u5f97\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n
Student::find(1);<\/code><\/pre>\n\n\n\n
Eloquent\u3067\u306f\u3001\u521d\u671f\u72b6\u614b\u3067\u306fid(int, auto_increment)\u3092\u30d7\u30e9\u30a4\u30de\u30ea\u30ad\u30fc\u3068\u3057\u3066\u53d6\u308a\u6271\u308f\u308c\u307e\u3059\u3002
 id\u4ee5\u5916\u306e\u4efb\u610f\u306e\u30ab\u30e9\u30e0\u3092\u30d7\u30e9\u30a4\u30de\u30ea\u30ad\u30fc\u3068\u3057\u3066\u8a2d\u5b9a\u3057\u3066\u3044\u308b\u5834\u5408\u306f\u3001Model\u306e\u8abf\u6574\u304c\u5fc5\u8981\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n
\u30c6\u30fc\u30d6\u30eb\u5185\u306e\u7279\u5b9a\u306e\u30ab\u30e9\u30e0\u3092\u53d6\u5f97\u3059\u308b\u5834\u5408\u306f\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u8a18\u8ff0\u3057\u307e\u3059\u3002<\/p>\n\n\n\n
Student::find(1)->name;<\/code><\/pre>\n\n\n\n
\u4efb\u610f\u306e\u30ab\u30e9\u30e0\u306b\u691c\u7d22\u6761\u4ef6\u3092\u8a2d\u5b9a\u3057\u3066\u62bd\u51fa\u3059\u308b<\/h4>\n\n\n\n
SQL\u3067\u306f\u4ee5\u4e0b\u306e\u3088\u3046\u306bwhere\u3092\u4f7f\u7528\u3057\u3066\u4efb\u610f\u306e\u30ab\u30e9\u30e0\u306b\u691c\u7d22\u6761\u4ef6\u3092\u8a2d\u5b9a\u3057\u3066\u30ec\u30b3\u30fc\u30c9\u3092\u62bd\u51fa\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n
select * from students where name = '\u5c71\u7530';<\/code><\/pre>\n\n\n\n

Eloquent\u3067\u4e0a\u8a18\u306e\u3088\u3046\u306a\u6761\u4ef6\u8a2d\u5b9a\u3092\u304a\u3053\u306a\u3046\u5834\u5408\u3001where\u30e1\u30bd\u30c3\u30c9\u3092\u4f7f\u7528\u3057\u307e\u3059\u3002<\/p>\n\n\n\n
Student::where('name','\u5c71\u7530')->get();<\/code><\/pre>\n\n\n\n
\u4e0a\u8a18\u3067\u691c\u7d22\u3092\u304a\u3053\u306a\u3063\u305f\u5834\u5408\u3001\u300c\u540d\u524d\u300d\u304c\u300c\u5c71\u7530\u300d\u306e\u30ec\u30b3\u30fc\u30c9\u304c\u8907\u6570\u3042\u308b\u5834\u5408\u3082\u8003\u3048\u3089\u308c\u307e\u3059\u3002
 \u6700\u521d\u306e1\u4ef6\u306e\u307f\u53d6\u5f97\u3057\u305f\u3044\u5834\u5408\u306f\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u6307\u5b9a\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n
Student::where('name','\u5c71\u7530')->first();<\/code><\/pre>\n\n\n\n
where\u30e1\u30bd\u30c3\u30c9\u3067\u306e\u6761\u4ef6\u6307\u5b9a\u65b9\u6cd5<\/h4>\n\n\n\n
where\u30e1\u30bd\u30c3\u30c9\u3067\u306f\u4e0a\u8a18\u306e\u3088\u3046\u306a\u5b8c\u5168\u4e00\u81f4\u3067\u306e\u6761\u4ef6\u6307\u5b9a\u4ee5\u5916\u3067\u3082\u3001\u67d4\u8edf\u306a\u6761\u4ef6\u8a2d\u5b9a\u304c\u53ef\u80fd\u3067\u3059\u3002
 \u30b5\u30f3\u30d7\u30eb\u3092\u4ee5\u4e0b\u306b\u8a18\u8f09\u3057\u307e\u3059\u3002<\/p>\n\n\n\n
Student::where('age','<','20')->get();<\/code><\/pre>\n\n\n\n
\u4e0a\u8a18\u306e\u3088\u3046\u306b\u8a18\u8f09\u3059\u308b\u3053\u3068\u3067\u300c\u5e74\u9f62\u304c20\u6b73\u4ee5\u4e0b\u306e\u5b66\u751f\u300d\u304c\u62bd\u51fa\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n
Student::where('email','like','%gmail%')->get();<\/code><\/pre>\n\n\n\n
\u4e0a\u8a18\u306e\u3088\u3046\u306b\u8a18\u8f09\u3059\u308b\u3053\u3068\u3067\u30e1\u30fc\u30eb\u30a2\u30c9\u30ec\u30b9\u306b\u300cgmail\u300d\u3068\u3044\u3046\u6587\u5b57\u5217\u3092\u542b\u3093\u3060\u30ec\u30b3\u30fc\u30c9\u304c\u62bd\u51fa\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n\n
whereIn\u30e1\u30bd\u30c3\u30c9\u3092\u4f7f\u7528\u3057\u3066\u5bfe\u8c61\u3092\u7d5e\u308a\u8fbc\u3080\u3053\u3068\u3082\u53ef\u80fd\u3067\u3059\u3002
 \u691c\u7d22\u30d5\u30a9\u30fc\u30e0\u306b\u8907\u6570\u9078\u629e\u306e\u30c1\u30a7\u30c3\u30af\u30dc\u30c3\u30af\u30b9\u304c\u7528\u610f\u3055\u308c\u3066\u3044\u308b\u5834\u5408\u306a\u3069\u306b\u4fbf\u5229\u306b\u4f7f\u7528\u3067\u304d\u307e\u3059\u3002
 \u4ee5\u4e0b\u306e\u3088\u3046\u306b\u8a18\u8f09\u3059\u308b\u3053\u3068\u3067\u90fd\u9053\u5e9c\u770c\u304c\u300c\u5927\u962a\u300d\u307e\u305f\u306f\u300c\u6771\u4eac\u300d\u307e\u305f\u306f\u300c\u540d\u53e4\u5c4b\u300d\u306e\u3044\u305a\u308c\u304b\u306b\u5c5e\u3059\u308b\u30ec\u30b3\u30fc\u30c9\u306e\u53d6\u5f97\u304c\u304a\u3053\u306a\u3048\u307e\u3059\u3002<\/p>\n\n\n\n
Student::whereIn('pref',['\u5927\u962a','\u6771\u4eac','\u540d\u53e4\u5c4b'])->get();<\/code><\/pre>\n\n\n\n
\u307e\u305f\u3001whereBetween\u3067\u7bc4\u56f2\u3092\u7d5e\u308a\u8fbc\u3093\u3060\u691c\u7d22\u3082\u53ef\u80fd\u3067\u3059\u3002
 \u4ee5\u4e0b\u306e\u4f8b\u3067\u306f\u5e74\u9f62\u304c10\u6b73\u304b\u308920\u6b73\u307e\u3067\u306e\u5b66\u751f\u306e\u30ec\u30b3\u30fc\u30c9\u3092\u62bd\u51fa\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n
Student::whereBetween('age',['10','20'])->get();<\/code><\/pre>\n\n\n\n
\u4ee5\u4e0a\u3067\u7d39\u4ecb\u3057\u305f\u30e1\u30bd\u30c3\u30c9\u306f\u305d\u308c\u305e\u308c\u5426\u5b9a\u5f62\u3082\u7528\u610f\u3055\u308c\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n
\u4ee5\u4e0b\u306e\u4f8b\u3067\u306f\u90fd\u9053\u5e9c\u770c\u304c\u300c\u5927\u962a\u300d\u307e\u305f\u306f\u300c\u6771\u4eac\u300d\u307e\u305f\u306f\u300c\u540d\u53e4\u5c4b\u300d\u4ee5\u5916<\/strong>\u3067\u767b\u9332\u3055\u308c\u3066\u3044\u308b\u30ec\u30b3\u30fc\u30c9\u306e\u53d6\u5f97\u304c\u304a\u3053\u306a\u3048\u307e\u3059\u3002<\/p>\n\n\n\n
Student::whereNotIn('pref',['\u5927\u962a','\u6771\u4eac','\u540d\u53e4\u5c4b'])->get();\n<\/code><\/pre>\n\n\n\n
\u4ee5\u4e0b\u306e\u4f8b\u3067\u306f\u5e74\u9f62\u304c10\u6b73\u304b\u308920\u6b73\u307e\u3067\u3067\u306f\u306a\u3044<\/strong>\u5b66\u751f\u306e\u30ec\u30b3\u30fc\u30c9\u3092\u62bd\u51fa\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n
Student::whereNotBetween('age',['10','20'])->get();<\/code><\/pre>\n\n\n\n
\u30ec\u30b3\u30fc\u30c9\u30ab\u30e9\u30e0\u304cNull\u304b\u3069\u3046\u304b\u306e\u5224\u5b9a\u3092\u304a\u3053\u306a\u3046\u306b\u306f\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u8a18\u8f09\u3057\u307e\u3059\u3002<\/p>\n\n\n\n
Student::whereNull('name')->get();<\/code><\/pre>\n\n\n\n
Null\u3067\u306f\u306a\u3044\u30ec\u30b3\u30fc\u30c9\u3092\u62bd\u51fa\u3059\u308b\u5834\u5408\u306f\u4ee5\u4e0b\u306e\u3088\u3046\u306b\u8a18\u8f09\u3057\u307e\u3059\u3002<\/p>\n\n\n\n
Student::whereNotNull('name')->get();<\/code><\/pre>\n\n\n\n
\u6b21\u56de\u306f\u8907\u6570\u306e\u691c\u7d22\u6761\u4ef6\u3092\u7d44\u307f\u5408\u308f\u305b\u3066\u4f7f\u7528\u3059\u308b\u65b9\u6cd5\u3092\u7d39\u4ecb\u3057\u307e\u3059\u3002<\/p>\n\n\n\n
\u91d1\u66dc\u65e5\u62c5\u5f53\uff1anishida<\/p>\n
\n            
<\/g:plusone><\/div>\n            
 \"\u3053\u306e\u30a8\u30f3\u30c8\u30ea\u30fc\u3092\u306f\u3066\u306a\u30d6\u30c3\u30af\u30de\u30fc\u30af\u306b\u8ffd\u52a0\"<\/a>