֎෦ҕୗͷཱ৔͔Β ൒͹ڧҾʹLaravelΛಋೖͨ͠࿩ LaraLab vol.1 2017/09/13 @shibuya 21cafe

Yudai Shinnoki @konoki_nannoki Freelance Engineer ͓΋ͳҊ࣮݅੷ PHPɺΠϯϑϥɺAndroid(Java) ษڧத SwiftɺReact Native ࠷ۙͷڵຯ Architecting on AWS 21ສԁ+੫͸ϋʔυϧ͕ߴ͍…

Brush-UPֶͼ •  LaravelΛ࢖ͬͨγεςϜΛ9/4ʹެ։͠·ͨ͠ https://www.brush-up.jp

ൿ఻ͷλϨ •  PHP 5.3 •  MySQL 5.1 •  Smarty

ൿ఻ͷλϨ •  PHP 5.3 •  MySQL 5.1 •  Smarty •  Shift-JISͱ૬ੑ͕ѱ͘ɺ{literal}Ͱ ғΘͳ͍ͱΤϥʔʹͳͬͨΓ͢Δ จࣈίʔυ͸Shift-JIS

ൿ఻ͷλϨ •  PHP 5.3 •  MySQL 5.1 •  Smarty •  Shift-JISͱ૬ੑ͕ѱ͘ɺ{literal}Ͱ ғΘͳ͍ͱΤϥʔʹͳͬͨΓ͢Δ •  όʔδϣϯ؅ཧ͞Ε͍ͯͳ͍ •  ͱ͜ΖͲ͜Ζʹྺ࢙Λײ͡ΒΕΔ •  CentOSͳͷʹ/user/local/apache2ͷ ઈରύε͕ϋʔυίʔυ͞ΕͯͨΓ͢Δ จࣈίʔυ͸Shift-JIS

No content

γεςϜߏ੒ •  આಘͷ͠қ͔͞ΒɺLaravel 5.1 LTS Λબ୒ •  PHP 7.0 (7.1͡Όͳ͍ཧ༝͸ಛʹແ͍) •  Laravel 5.5 LTS ͕ 8/30 ʹϦϦʔε •  طଘγεςϜ͔Βஈ֊తʹҠߦ •  nginxͰURL͝ͱʹϦόʔεϓϩΩγ •  DBεΩʔϚ͕มΘΔͱطଘγεςϜͷमਖ਼ ΋ඞཁʹͳΔͷͰɺطଘγεςϜ͕ඞཁͳ͘ ͳ͔ͬͯΒDBΛݟ௚͢

࣮૷্ͷ՝୊ ① طଘDBͱͷ࿈ܞ

EloquentϞσϧͷ࣮૷ •  protected $table •  ໋໊نଇʹԊ͍ͬͯͳ͍৔߹ඞਢ •  protected $primaryKey •  Model::whereΛ࢖͏͚ͩͩͬͨΒ࣮͸ෆཁ •  relationを考えると設定しておいたほうが無難 •  const CREATED_AT, const UPDATED_AT •  ͲͪΒ΋ෆཁͳΒ public $timestamps = false; •  updateͷΈෆཁͳΒ public function setUpdatedAt($value) { }

ෳ਺छྨͷEloquentϞσϧͰϧʔϓ͍ͨ͠ •  Illuminate\Database\Eloquent\Collectionʹ ෳ਺classΛಥͬࠐΜͰ΋໰୊ͳ͍ •  EloquentϞσϧʹڞ௨ͷΞΫηαʔΛ࣮૷͢Δ •  has-Oneͳؔ܎͕ଟஈʹͳ͍ͬͯΔ৔߹ ҰஈʹͳΔΑ͏ʹΞΫηαʔͰΤΠϦΞε ͓ͯ͘͠ͱUndefined ErrorΛҙࣝ͠ͳ͍ͰࡁΉ

࣮૷্ͷ՝୊ ② Shift-JISରԠ

/config/database.php ͷจࣈίʔυઃఆ •  DBͷจࣈίʔυΛແࢹͯ͠ ’charset’ => ’utf8’ •  ͨͿΜ SET NAMES utf8 ͱಉ͡ޮՌ •  varcharͰ͸͏·͍͕͘͘blobͰจࣈԽ͚͢Δ •  ૉ௚ʹ’charset’ => ’sjis’ •  ιʔε͸UTF8ʹ͍ͨ͠ͷͰɺ EloquentϞσϧ͔ΒAttributeऔಘ࣌ʹม׵ •  Illuminate\Database\Eloquent\ModelΛ ܧঝͨ͠ abstract class SjisBaseModel Λ࣮૷ͯ͠ڞ௨ॲཧΛॻ͘ํ਑

No content

public function getAttribute($key) ͷ override •  ͢΂ͯͷΞΫηαʔʹڞ௨ͳॲཧΛॻ͚Δ •  ݸผʹΞΫηαʔ͕͋Δ৔߹ͦͷޙʹݺ͹ΕΔ •  getAttribute ʹSJIS->UTF8ม׵Λॻ͘৔߹ getFooAttribute ͸SJISͰฦ͢ඞཁ͕͋Δ(ʂ)

public function getAttribute($key) ͷ override •  ͢΂ͯͷΞΫηαʔʹڞ௨ͳॲཧΛॻ͚Δ •  ݸผʹΞΫηαʔ͕͋Δ৔߹ͦͷޙʹݺ͹ΕΔ •  getAttribute ʹSJIS->UTF8ม׵Λॻ͘৔߹ getFooAttribute ͸SJISͰฦ͢ඞཁ͕͋Δ(ʂ) •  protected function getAttributeFromArray Λ override ͢Δ͜ͱͰDB͔Βऔಘͨ͠σʔλ ͷΈΛม׵Ͱ͖ͨ

No content

ݸਓతʹ ͍͍ͱײͨ͡ͱ͜Ζ

BladeʹૉͷPHPίʔυ͕ॻ͚Δ •  ࠔͬͨΒͱΓ͋͑ͣ Ͱॻ͚͹͍͍ •  ίϯϙʔωϯτͬΆ͘@include Ͱ͖Δ

BladeʹૉͷPHPίʔυ͕ॻ͚Δ •  ࠔͬͨΒͱΓ͋͑ͣ Ͱॻ͚͹͍͍ •  ίϯϙʔωϯτͬΆ͘@include Ͱ͖Δ ͪΐͬͱෳࡶͳॲཧ ͉ ςϯϓϨʔτ

ιʔείʔυ͕௥͍΍͍͢ʢؾ͕͢Δʣ •  PHPStorm Ͱߋʹշద •  ʮLaravelɹPHPStormʯͱ͔Ͱݕࡧ͢Δͱ ηοτΞοϓͷ৘ใ͕Ͱͯ͘Δ •  ܕએݴΛ࢖͏ͱΰϦΰϦͱิ׬ͯ͘͠ΕΔ •  ઌड़ͷgetAttributeFromArray ΋ ͜ͷ͓ӄͰؾ͚ͮͨ

·ͱΊ •  ࣮૷্ͷ੍໿͕ଟ͍৔߹Ͱ΋ɺ LaravelͳΒॊೈʹରԠͰ͖Δͱײͨ͡ •  DBͷݟ௚͠΋͍ͩͿָʹͳΓͦ͏ •  Laravel 5.5 LTSҠߦʹ͍ͭͯͷ৘ใ͕ ͋ͬͨΒڭ͍͑ͯͩ͘͞