BLT #3

BLT #3で発表した資料です。

Transcript

1. I TRIED TO MAKE “TALKING BORD” FOR BLT #3
2. ɹɹࣗݾ঺հɹɹɹɹɹ ໊લɹɹɹɹɹTOMITA ೥ྸɹɹɹɹɹ17ࡀ ܦྺɹɹɹɹɹͳΜʹ΋ͳ͠ ࣗশɹɹɹɹɹϖʔϖʔ͑Μ͡ʹ͋ ܦݧɹɹɹɹɹ൒೥͘Β͍…
3. CONTACT gmail tomita.contact@gmail.com twitter @TOMITA___twiɹ(_͸3ͭ) ·ͩ·ͩະख़Ͱ͕͢ɺ ͥͻ͓࿩͠·͠ΐ͏ʂ
4. Talking Bord Λ࡞ͬͯΈͨ
5. ؾ෇͖·ͨ͠ʁʁʁ
6. Talking Bord Λ࡞ͬͯΈͨ
7. Bord Board × ̋
8. ·͊ܝࣔ൘Λ ࡞Γ͔ͨͬͨ
9. ࢀߟࢿྉ φϯτΧPHP (ಡΜͩΒύʔϑΣΫτʹͳΓͦ͏ͳ͋ͷ΍ͭ)
10. ύΫͬͨ ࢀߟʹͨ͠
11. ߦͬͨ͜ͱ
12. 1.σʔλʔϕʔεʹ઀ଓ 2.ηΩϡϦςΟʔରࡦ 3.σʔλʔϕʔε͔Βऔಘ
13. ౰ͨΓલ ATARIMAE
14. 1.σʔλϕʔεʹ઀ଓ $link=mysql_connect(‘127.0.0.1','root',''); if(!$link){ die('ͭͳ͛ͶʔΑ͆'.mysql_error().PHP_EOL); }
15. ࣮͸ͭ·͍͍ͣͯͨ…
16. $link=mysql_connect(‘127.0.0.1','root','');
17. 127.0.0.1 192.168.33.10 ↑ͬͪ͜Ͱ΍͍ͬͯͨ…
18. άάͬͨ
19. 192.168.33.10 IPΞυϨε 127.0.0.1 ϧʔϓόοΫΞυϨε
20. 2.ηΩϡϦςΟʔରࡦ
21. SQLΠϯδΣΫγϣϯ <?php $sql="SELECT * FROM post ORDER BY created_at DESC”; $result=mysql_query($sql,$link); ?> σʔλϕʔεͷվ͟Μɺෆਖ਼औಘͷ๷ࢭ
22. εΫϦϓτૠೖ <?php echo htmlspecialchars($error,ENT_QUOTES,'utf-8'); ?> ϑΥʔϜʹJSΛ࢓ࠐ·Εͳ͍Α͏ʹ ɹɹɹɹɹɹɹɹɹɹɹλάΛΤεέʔϓ͢Δ
23. GET/POST
24. GET ʮ৘ใͷऔಘʯΛද͢ϝιου URL ʹग़ͯ͘Δ΍ͭ… ੍ݶ͕͋ΔΒ͍͠…
25. POST ৽͍͠৘ใΛొ࿥͢Δϝιου ੍ݶ͕ͳ͘ಗ໊৘ใ޲͚
26. Α͘Θ͔Βͳ͍ʂʂʂʂ
27. ਖ਼نදݱΛ࢖ͬͯΈ͔ͨͬͨͷ…
28. Ͳ͏Ͱ΋͍͍ʂʂʂ
29. ΍Γ͔ͨͬͨ͜ͱ
30. Ϟδϡʔϧ API deleteϘλϯ ࣌ؒͷௐ੔ σϓϩΠ
31. API Τϥʔॲཧ Ϟδϡʔϧ ໊લۭؒ Cookie ϑϨʔϜϫʔΫ Τϥʔॲཧ ࢀর౉͠ ந৅ϝιου Ϗοτԋࢉࢠ get post SDK
32. ·ͱΊ ͜Ε͔Β”ͳʹ͔”Λͭ͘Ζ͏
33. Thank you for your attention :D