Laravelの検索機能の実装方法 Oct. 23, 2022 • 0 likes •

Laravelにおける検索機能のハンズオンをした際の資料

Transcript

1. Laravelͷݕࡧػೳͷ࣮૷ํ๏ MVCϞσϧͷ f lowʹԊͬͯ 2021/07/11 @yoshit a ro PHPษڧձ ߨٛʹͯ
2. ❏ର৅ͱͳΔํ • L a r a vel৮Γͨͯͷํ ❏಺༰ • ݕࡧػೳ࣮૷ • ࣮૷࣌ͷλεΫࡉ෼Խ • ্هʹै͍λεΫͷ࣮ߦ • MVCͷྲྀΕΛ౿·͑ͯ • +αͷิ଍
3. ɾLaravelͷݕࡧػೳͷ࣮૷ํ๏ 1. Routingઃఆ 2. Client ͷ Request P a r a meter औಘ 3. औಘͨ͠ P a r a meter Ͱ Query Λ࡞੒ 4. Query Ͱ৘ใΛऔಘ͠Viewʹ౉͢ 5. ݕࡧ method Λ Model ʹ੾Γ෼͚Δ 6. Request P a r a meter Λ C a st ͢Δ 7. ·ͱΊ MVCϞσϧͷ f lowʹԊͬͯ
4. ɾLaravelͷݕࡧػೳͷ࣮૷ํ๏ 1. Routingઃఆ 2. Client ͷ Request P a r a meter औಘ 3. औಘͨ͠ P a r a meter Ͱ Query Λ࡞੒ 4. Query Ͱ৘ใΛऔಘ͠Viewʹ౉͢ 5. ݕࡧ method Λ Model ʹ੾Γ෼͚Δ 6. Request P a r a meter Λ C a st ͢Δ 7. ·ͱΊ MVCϞσϧͷ f lowʹԊͬͯ
5. ΫϥΠΞϯτ Laravelʹ͓͚ΔMVCͷྲྀΕͱΠϝʔδ router web.php View Controller ArticleController.php Model Article.php articel.blade.php JS CSS img HTTP Ϩεϙϯε ϨϯμϦϯά HTTP ϦΫΤετ URLͰRouting ඞཁͳΒ DBΞΫηε σʔλΛ౉͢ CRUD ॲཧ݁Ռ σʔλΛૹΔ
6. 1. Routingઃఆ 1. form λάͰΞΫγϣϯ࣌ͷߦ͖ઌΛઃఆ͢Δ 2. web.php ʹURL/Controller/Action Λઃఆ͢Δ
7. 1. form λάͰΞΫγϣϯ࣌ͷߦ͖ઌΛઃఆ͢Δ
8. 2. web.php ʹURL/Controller/Action Λઃఆ͢Δ
9. ɾLaravelͷݕࡧػೳͷ࣮૷ํ๏ 1. Routingઃఆ 2. Client ͷ Request P a r a meter औಘ 3. औಘͨ͠ P a r a meter Ͱ Query Λ࡞੒ 4. Query Ͱ৘ใΛऔಘ͠Viewʹ౉͢ 5. ݕࡧ method Λ Model ʹ੾Γ෼͚Δ 6. Request P a r a meter Λ C a st ͢Δ 7. ·ͱΊ MVCϞσϧͷ f lowʹԊͬͯ
10. ΫϥΠΞϯτ Laravelʹ͓͚ΔMVCͷྲྀΕͱΠϝʔδ router web.php View Controller ArticleController.php Model Article.php articel.blade.php JS CSS img HTTP Ϩεϙϯε ϨϯμϦϯά HTTP ϦΫΤετ URLͰRouting ඞཁͳΒ DBΞΫηε σʔλΛ౉͢ CRUD ॲཧ݁Ռ σʔλΛૹΔ
11. 2. Client ͷ Request Parameter औಘ 1. input λάͷ v a lue ଐੑΛઃఆ͢Δ 2. Controller Ͱ RequestP a r a meter Λऔಘ
12. 1. input λάͷ value ଐੑΛઃఆ͢Δ
13. 2. Controller Ͱ RequestParameter Λऔಘ
14. 2. ࣮૷ͯ͠Έ·͠ΐ͏ʂ
15. ɾLaravelͷݕࡧػೳͷ࣮૷ํ๏ 1. Routingઃఆ 2. Client ͷ Request P a r a meter औಘ 3.औಘͨ͠ P a r a meter Ͱ Query Λ࡞੒ 4. Query Ͱ৘ใΛऔಘ͠Viewʹ౉͢ 5. ݕࡧ method Λ Model ʹ੾Γ෼͚Δ 6. Request P a r a meter Λ C a st ͢Δ 7. ·ͱΊ MVCϞσϧͷ f lowʹԊͬͯ
16. 3. औಘͨ͠ Parameter Ͱ Query Λ࡞੒ 1. Eloquent or QueryBuirder ?? 2. جຊతʹ͸ Eloquent Λ࢖͏΂͖
17. 1. Eloquent or QueryBuirder ?? → Eloquent
18. 1. Eloquent or QueryBuirder ?? → QueryBuirder
19. 2. 2. جຊతʹ͸ Eloquent Λ࢖͏΂͖ • جຊ͸EloquentΛ࢖͍·͠ΐ͏ • Ͱ΋ࠓճ͸QueryBuilderͰॻ͖·͢ʢসʣ
20. 2. ɾ Eloquent ͷಛ௃ͱϝϦοτ • Eloquent ͸ɺL a r a vel ͕ఏڙ͍ͯ͠Δ O/R Ϛού • Eloquent O/R Ϛού͸ ActiveRecord ύλʔϯͰ࣮૷͞Ε͍ͯΔ • SQL ͱ͍͏ผͷݴޠΛɺΞϓϦέʔγϣϯʢ L a r a vel ʣʹհೖͤͣࡁΉ • ςʔϒϧಉ࢜ͷؔ܎ੑΛఆٛͰ͖Δ • ࠶ར༻ੑ΍֦ுੑ͕ߴ͍ ɾ Eloquent ͷσϝϦοτ • SQL ͕ॻ͚ͳͯ͘΋ɺσʔλऔಘ͕Ͱ͖Δ • Ͳ͏͍͏ΫΤϦΛൃߦ͍ͯ͠Δͷ͔Θ͔Βͳ͍ • ಛఆͷϝιουΛ࢖͏ͱɺαϒΫΤϦΛ࢖࣮ͬͯߦ͢Δ ɾ Eloquent ͷ࢖༻৔໘ • ύϑΥʔϚϯεΑΓ΋҆શੑΛऔΓ͍ͨ • ࣮֬ʹɺϦϨʔγϣϯʹԊͬͨσʔλऔಘΛ͍ͨ͠ • ಛఆͷঢ়گԼͰͷ৚݅෇͚΍ɺॲཧͷ࣮ߦΛ࣮૷͍ͨ͠
21. 2. ɾ QueryBuilder ͷಛ௃ͱϝϦοτ • L a r a vel ͕ఏڙ͍ͯ͠ΔΫΤϦΛੜ੒͢ΔͨΊͷϝιου܈ɻ • SQL ϥΠΫʹΫΤϦΛॻ͘͜ͱ͕Ͱ͖Δ • Eloquent ͱൺ΂ͯߴ଎ • ൃߦ͞Ε͍ͯΔΫΤϦ͕ղΓ΍͍͢ • SQL Λॻ͚Ε͹ֶशίετ͸௿͍ ɾ QueryBuilder ͷσϝϦοτ • ࣗྗͰߟྀ͠ͳ͚Ε͹͍͚ͳ͍఺͕͋Δ • ςʔϒϧಉ࢜ͷ݁߹͸Λߦ͏ඞཁ͕͋ΓϦϨʔγϣϯΛਖ਼͘͠೺Ѳ͠൓ө͢Δඞཁ͕͋ Δ • ࿦ཧ࡟আͷ৚݅͸ɺࣗ෼Ͱ৚݅ࢦఆ͢Δ • ͦ΋ͦ΋ SQL จͰؒҧͬͨॻ͖ํΛॻ͍ͯ͸͍͚ͳ͍ ɾ QueryBuilder ͷ࢖༻৔໘ • ෳࡶͳ৚݅΍େྔͷσʔλΛѻ͏ͷͰɺύϑΥʔϚϯεΛٻΊ͍ͨ ʢݕࡧը໘ɺҰཡը໘ͱ͔ʣ • ෳࡶͳ৚݅ͷΫΤϦΛɺൃߦ͍ͨ͠
22. 2. ɾ Eloquent ͷಛ௃ • Eloquent ͸ɺL a r a vel ͕ఏڙ͍ͯ͠Δ O/R Ϛού • SQL ͱ͍͏ผͷݴޠΛɺΞϓϦέʔγϣϯʢ L a r a vel ʣʹհೖͤͣࡁΉ • ςʔϒϧಉ࢜ͷؔ܎ੑΛఆٛͰ͖Δ • ࠶ར༻ੑ΍֦ுੑ͕ߴ͍ ɾ QueryBuilder ͷಛ௃ • L a r a vel ͕ఏڙ͍ͯ͠ΔΫΤϦΛੜ੒͢ΔͨΊͷϝιου܈ɻ • SQL ϥΠΫʹΫΤϦΛॻ͘͜ͱ͕Ͱ͖Δ • Eloquent ͱൺ΂ͯߴ଎ • ൃߦ͞Ε͍ͯΔΫΤϦ͕ղΓ΍͍͢ • SQL Λॻ͚Ε͹ֶशίετ͸௿͍
23. 2. ࣮૷ͯ͠Έ·͠ΐ͏ʂ
24. ɾLaravelͷݕࡧػೳͷ࣮૷ํ๏ 1. Routingઃఆ 2. Client ͷ Request P a r a meter औಘ 3. औಘͨ͠ P a r a meter Ͱ Query Λ࡞੒ 4. Query Ͱ৘ใΛऔಘ͠Viewʹ౉͢ 5. ݕࡧ method Λ Model ʹ੾Γ෼͚Δ 6. Request P a r a meter Λ C a st ͢Δ 7. ·ͱΊ MVCϞσϧͷ f lowʹԊͬͯ
25. 4. QueryBuilder Ͱ৘ใΛऔಘ͠Viewʹ౉͢ ࣮૷ͯ͠Έ·͠ΐ͏ʂ
26. ɾLaravelͷݕࡧػೳͷ࣮૷ํ๏ 1. Routingઃఆ 2. Client ͷ Request P a r a meter औಘ 3. औಘͨ͠ P a r a meter Ͱ Query Λ࡞੒ 4. Query Ͱ৘ใΛऔಘ͠Viewʹ౉͢ 5. ݕࡧ method Λ Model ʹ੾Γ෼͚Δ 6. Request P a r a meter Λ C a st ͢Δ 7. ·ͱΊ MVCϞσϧͷ f lowʹԊͬͯ
27. 5. ݕࡧ method Λ Model ʹ੾Γ෼͚Δ 1. ݕࡧػೳهड़෦෼͸ϏδωεϩδοΫ૚ʹॻ͖·͠ΐ͏ʂ 2. ͦͷޙʹ Controller Ͱݺͼग़͠·͠ΐ͏ʂ
28. ΫϥΠΞϯτ 2. 3૚ΞʔΩςΫνϟͱLeravelͰͷMVCͷؔ܎ Webαʔό ΞϓϦέʔγϣϯαʔό DBαʔό ※ड෇ ※۩ମతͳॲཧ ※σʔλϕʔε HTTP HTTP ϓϨθϯςʔγϣϯ૚ ϏδωεϩδοΫ૚ σʔλΞΫηε૚ Ϣʔβʔͱͷ ΍ΓऔΓ ɾϖʔδͷಡΈऔΓ ɾೖྗͷड෇ ϓϩάϥϜͰ ॲཧΛߦ͏ ɾϧʔϧΛ΋ͭ DBΛૢ࡞͠ ݁ՌΛอଘ͢Δ ɾॻ͔ͳ͍ࣄ΋͋Δ View Controller Model CRUD ॲཧ݁Ռ
29. Ϙπͳ ݕࡧػೳ RequestP a r a meter 3ͭͷ৔߹ ϧʔϧΛҰͭҰͭ ifจͰॻ͍ͪΌ͏ Α͋͘Δ΍ͭ😊
30. ϦϑΝΫλϦϯά(ະ׬੒)
31. 2. ࣮૷ͯ͠Έ·͠ΐ͏ʂ
32. ɾLaravelͷݕࡧػೳͷ࣮૷ํ๏ 1. Routingઃఆ 2. Client ͷ Request P a r a meter औಘ 3. औಘͨ͠ P a r a meter Ͱ Query Λ࡞੒ 4. Query Ͱ৘ใΛऔಘ͠Viewʹ౉͢ 5. ݕࡧ method Λ Model ʹ੾Γ෼͚Δ 6. Request P a r a meter Λ C a st ͢Δ 7. ·ͱΊ MVCϞσϧͷ f lowʹԊͬͯ
34. 6. Request Parameter Λ Cast ͢Δ 1. GET/POST Ͱͷ RequestP a r a meter ͸ೖྗ஋νΣοΫ 2. ܕม׵(C a st) ɺRequestP a r a meter ͸શ෦ String Β͍͠
35. https://www.php.net/m a nu a l/j a / l a ngu a ge.types.type- juggling.php#l a ngu a ge.types.typec a sting PHP ϚχϡΞϧ>ݴޠϦϑΝϨϯε >ܕ>ܕͷ૬ޓม׵ ΑΓҾ༻
36. https://www.php.net/m a nu a l/j a / l a ngu a ge.types.decl a r a tions.php ʮPHP ϚχϡΞϧ>ݴޠϦϑΝϨϯε>ܕ>ܕએݴ ʯ ΑΓҾ༻
37. 2. ࣮૷ͯ͠Έ·͠ΐ͏ʂ
38. ɾLaravelͷݕࡧػೳͷ࣮૷ํ๏ 1. Routingઃఆ 2. Client ͷ Request P a r a meter औಘ 3. औಘͨ͠ P a r a meter Ͱ Query Λ࡞੒ 4. Query Ͱ৘ใΛऔಘ͠Viewʹ౉͢ 5. ݕࡧ method Λ Model ʹ੾Γ෼͚Δ 6. Request P a r a meter Λ C a st ͢Δ 7. ·ͱΊ MVCϞσϧͷ f lowʹԊͬͯ
39. 7. ·ͱΊ 1. ػೳ࣮૷͸λεΫΛࡉ෼Խͯ͠؆୯ʹ͠Α͏ 2. MVCϞσϧͱͦΕͧΕͷ໾ׂΛҙࣝ͠·͠ΐ͏