PHPerKaigi_2024_アンカンファレンス_-_完成度低いの歓迎LT大会

Transcript

1. PHPerKaigi 2024 ΞϯΧϯϑΝϨϯε - ׬੒౓௿͍ͷ׻ܴLTେձ @yamato_sorariku
2. օ͞ΜΠϯγσϯτରԠͯ͠·͔͢ʁ
3. ͨ͘͠ͳ͍ʁ
4. ͱ͸͍͑ɺى͖Δͱ͖͸ى͖·͢ΑͶ
5. # ݩωλ
6. # ݩωλ
7. PHPΧϯϑΝϨϯεখాݪ 2024/4/13(౔) νέοτ૿࿮ͯͨ͠Αʂ औΕͯͳ͔ͬͨਓ͸ٸ͍Ͱʂ #PR
8. ޤ͏͝ظ଴ʂ
9. ͱ͸͍͔ͳ͍ͷͰɺ ͪΐͬͱখग़͠͠·͢
10. # ΠϯγσϯτରԠʹ͓͍ͯେ੾ʹ͍ͯ͠Δ఺ 1. ΍Γ͗͢Δ͘Β͍ͷ৘ใڞ༗ 2. ௐࠪͰ͸࢖͑Δ΋ͷΛ͢΂ͯ࢖͓͏ 3. ͳʹ͔ʢձࣾPCʹϝϞ͕͔͚͋ͬͯͳ͔ͬͨʣ
11. ͱ͸͍͔ͳ͍ͷͰɺ ͪΐͬͱখग़͠͠·͢
12. # ΍Γ͗͢Δ͘Β͍ͷ৘ใڞ༗ Θ͔ͬͨ͜ͱɺରԠͯ͠΄͍͜͠ͱͳͲ͕ൃੜͨ͠Β ͲΜͲΜSlackʹॻ͍͍͖ͯؔ܎ऀʹڞ༗͠·͢ɻ ʢʢʢը૾ུʣʣʣ
13. # ௐࠪͰ͸࢖͑Δ΋ͷΛ͢΂ͯ࢖͓͏ ࢲͷ૬๮ͨͪ 1. Google Spreadsheet 2. Google BigQuery
14. ΈΜͳεϓϨουγʔτ࢖ͬͯΔʁ
15. SQL΋͔͚ΔΜͩͥʂʁ
16. େྔͷσʔλΛ ༷ʑͳύλʔϯͰ
17. SUBSTITUTEؔ਺
18. # SUBSTITUTEؔ਺ https://support.google.com/docs/answer/3094215?hl=ja
21. =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE($A$1,$A$3,A4),$B$3,B4),$C$3,C4) ࣗ෼༻: https://docs.google.com/spreadsheets/d/1yZjSROYLpC3G_rfOOsINgdNxACZW6g0POwcjtUfI6pE/edit#gid=0
23. SQL׬੒ʂʂʂʂʂʂʂʂʂ
24. σʔλϦΧόϦ׬ྃʂ
25. # Έ͍ͨͳ࿩Λ͢Δ༧ఆͰ͢ʂʂʂ
26. ͓ΘΓ