ºÝºÝߣ

ºÝºÝߣShare a Scribd company logo
PHP ? MySQL? ???
?? ?? ????
2014. 3. 6.
GM??
Ranking ????
?

??? ??? ??? ? ? ???? ???.

?

?? ??? ???? ???.

?

??? ?? ???? ???.

?

1??? ???? ???? ???.
??? ??? ? ? ???
?!?!?!
??????
?

Explorer? Chrome? Safari?

?

? ?? ???? ?? ???? ?? ????? ???
?? ?? ??? ????

?

??? ARS? ???? ?? ??.
?????
PC(????)

?? ????

??
??? ??
??? ?
?

? ?? ????(NGINX)

?

? ????? ??(PHP)

?

??? ???(MariaDB)

?

??? ??? ?? ????
(phpMyAdmin)

??
??? ??? ??????!
WPN-XM ??
www.wpn-xm.org ???? ? ?? ??
?? ?? ???

Server Control Panel? ?? ?
Nginx, PHP, MariaDB? ???? ??
Hello world with PHP
<?php
echo "Hello world!";
?>

c:serverwwwtest.php ? ?? ?
????? http://localhost/test.php ??
Load PHP
!

IEnumerator LoadFromPhp()
{
string url = "http://localhost/test.php";
WWW www = new WWW(url);
yield return www;

!

}

if( www.isDone)
{
if( www.error == null)
{
Debug.Log("Receive Data : " + www.text);
}
else
{
Debug.Log("error : " + www.error);
}
}
IEnumerator ????
int i = 0;
i++;
Debug.Log(i);

??? ?? ??>Disk ?? ??>>>>??? ?? ??
Database
? ??? MySQL
??? ?? ??? phpMyAdmin
MySQL? ???
??? ?????? / SQL
??? ??????
?

???(Table)
?

??? ?????? ?? ?

?

?(row)? ?(column)? ??
????

???

??

1
2
3
4

???
???
????
???

2500
1300
800
1000

? ??
?

?
??? ??????
?

?(key)
?

???? ?

?

???(??), ???, ???, ??? ?
????

???

??

1
2
3
4

???
???
????
???

2500
1300
800
1000

???
SQL
?

??? ?????? ?? ???? ??? ???? ????
?? ??? ?? ?? ????? ??

?

?? ???
?

?? SELECT

?

?? UPDATE

?

?? INSERT

?

?? DELETE

?? ???? ??
SQL - SELECT
SELECT

????

*

?? ???

FROM `ranking`

ranking ?????

WHERE `score` > 0

??? 0?? ?

ORDER BY `score` DESC

??? ?? ??? ????

LIMIT 0, 20
??

20??
SQL - INSERT
INSERT INTO `ranking`

`ranking` ? ????

(`no`, `name`, `score`)

no, name, score ?? ??

VALUES

??? ?? ???

(NULL, ¡®??1¡¯, 100),
(NULL, ¡®??2¡¯, 110)
? ?? ??? ?? 1?? ??? ??
ranking ???
?

SQL ???? ??? ? ??? ??? phpMyAdmin
??
?? ??

??

??

???

??

no

int

12

-

auto increase
?? ?

name

varchar

8

-

utf8_unicode_ci

score

int

10

0

unsigned
ranking ??? ??? 1

http://localhost/
phpmyadmin/?
??
ranking ??? ??? 2
1

2

1. ?? ??? new ??
2. ?? ??? lvzero ??
3. Create ??

3
ranking ??? ??? 3
2
1

1. ?? ??? lvzero DB ??
2. ?? ??? ranking ??
3. 3 ?? ? Save ?? ??

3
ranking ??? ??? 4

?

?? ?? ?? ? Save ?? ??
PHP - ?? ??
?

dbHelper
?

?

loadRanking
?

?

?? php???? ?? ?????? ?? ??? ??? ?? ??
??? include ?? ????? ??.

ranking ????? ??? ?? ??? ???? xml ???? ??

insertScore
?

ranking ???? ??? ??? ???? ??.
Demo 1
??? ???? ??
?

?? ???

?

IEnumerator UploadScore()
?

?

??? ??? ??

IEnumerator LoadRank()
?

?? 10?? ??? ??? ??? ??
?? ??? ??
url ??
WWWForm? ?? ?? ??? ??
WWW(url, WWWForm) ??

yield return WWW;

WWW ?? ?? ??
WWW ?? ?? ??
WWW.text? ?? ?? ??

??
Demo 2
?? ??
?

???? ??? ?? ?? ??
?

?

?? ?? ??(PHP, C#, Unity Project)

?? ??
?

??(Web Server) ??? ????.

?

??? AssetStore? ?? ??? ?????.

?

??? ?? ?? 5???? ??? ???????.
?????.
Ad

More Related Content

What's hot (20)

Initiation ¨¤ l'algorithmiqueInitiation ¨¤ l'algorithmique
Initiation ¨¤ l'algorithmique
Abdoulaye Dieng
?
A starA star
A star
meriem sari
?
Alga matrizes pseudo inversa e afinsAlga matrizes pseudo inversa e afins
Alga matrizes pseudo inversa e afins
mmmno
?
La metodologia Top - Down - applicazione al C++
La metodologia Top - Down - applicazione al C++La metodologia Top - Down - applicazione al C++
La metodologia Top - Down - applicazione al C++
I.S.I.S. "Antonio Serra" - Napoli
?
Polymorphism in c++(ppt)
Polymorphism in c++(ppt)Polymorphism in c++(ppt)
Polymorphism in c++(ppt)
Sanjit Shaw
?
polymorphism
polymorphism polymorphism
polymorphism
Imtiaz Hussain
?
²¢ÐÐ¥×¥í¥°¥é¥ß¥ó¥°¤È¾@¾A¥â¥Ê¥É
²¢ÐÐ¥×¥í¥°¥é¥ß¥ó¥°¤È¾@¾A¥â¥Ê¥É²¢ÐÐ¥×¥í¥°¥é¥ß¥ó¥°¤È¾@¾A¥â¥Ê¥É
²¢ÐÐ¥×¥í¥°¥é¥ß¥ó¥°¤È¾@¾A¥â¥Ê¥É
Kousuke Ruichi
?
Programming in C Basics
Programming in C BasicsProgramming in C Basics
Programming in C Basics
Bharat Kalia
?
Cours de programmation en cCours de programmation en c
Cours de programmation en c
benouini rachid
?
C++ 11 Features
C++ 11 FeaturesC++ 11 Features
C++ 11 Features
Jan R¨¹egg
?
Serie recurrents & arithmetiquesSerie recurrents & arithmetiques
Serie recurrents & arithmetiques
mohamed_SAYARI
?
Let's Talk Locks!
Let's Talk Locks!Let's Talk Locks!
Let's Talk Locks!
C4Media
?
Ch08
Ch08Ch08
Ch08
nathanurag
?
PerceptronPerceptron
Perceptron
koki Ou
?
(2013 DEVIEW) ????? ?????? ??? ?????
(2013 DEVIEW) ????? ??????  ??? ????? (2013 DEVIEW) ????? ??????  ??? ?????
(2013 DEVIEW) ????? ?????? ??? ?????
?? ?
?
°ä/°ä++¤È°Â±ð²ú´¡²õ²õ±ð³¾²ú±ô²â¤òÀûÓä·¤¿¥é¥¤¥Ö¥é¥ê¿ª°k
°ä/°ä++¤È°Â±ð²ú´¡²õ²õ±ð³¾²ú±ô²â¤òÀûÓä·¤¿¥é¥¤¥Ö¥é¥ê¿ª°k°ä/°ä++¤È°Â±ð²ú´¡²õ²õ±ð³¾²ú±ô²â¤òÀûÓä·¤¿¥é¥¤¥Ö¥é¥ê¿ª°k
°ä/°ä++¤È°Â±ð²ú´¡²õ²õ±ð³¾²ú±ô²â¤òÀûÓä·¤¿¥é¥¤¥Ö¥é¥ê¿ª°k
µv˾ ÒÁÌÙ
?
Arrays
ArraysArrays
Arrays
Dr. Abhineet Anand
?
Cours javaCours java
Cours java
Zakaria Mouammin
?
Code Correcteurs d'Erreurs :  Code lin¨¦aire, code cyclique , code goppa  Code Correcteurs d'Erreurs :  Code lin¨¦aire, code cyclique , code goppa
Code Correcteurs d'Erreurs : Code lin¨¦aire, code cyclique , code goppa
SALMARACHIDI1
?
Cours ML et Deep Learning M2 2022-2023.pdfCours ML et Deep Learning M2 2022-2023.pdf
Cours ML et Deep Learning M2 2022-2023.pdf
UrbainNgatoua
?
Initiation ¨¤ l'algorithmiqueInitiation ¨¤ l'algorithmique
Initiation ¨¤ l'algorithmique
Abdoulaye Dieng
?
Alga matrizes pseudo inversa e afinsAlga matrizes pseudo inversa e afins
Alga matrizes pseudo inversa e afins
mmmno
?
Polymorphism in c++(ppt)
Polymorphism in c++(ppt)Polymorphism in c++(ppt)
Polymorphism in c++(ppt)
Sanjit Shaw
?
²¢ÐÐ¥×¥í¥°¥é¥ß¥ó¥°¤È¾@¾A¥â¥Ê¥É
²¢ÐÐ¥×¥í¥°¥é¥ß¥ó¥°¤È¾@¾A¥â¥Ê¥É²¢ÐÐ¥×¥í¥°¥é¥ß¥ó¥°¤È¾@¾A¥â¥Ê¥É
²¢ÐÐ¥×¥í¥°¥é¥ß¥ó¥°¤È¾@¾A¥â¥Ê¥É
Kousuke Ruichi
?
Programming in C Basics
Programming in C BasicsProgramming in C Basics
Programming in C Basics
Bharat Kalia
?
Cours de programmation en cCours de programmation en c
Cours de programmation en c
benouini rachid
?
Serie recurrents & arithmetiquesSerie recurrents & arithmetiques
Serie recurrents & arithmetiques
mohamed_SAYARI
?
Let's Talk Locks!
Let's Talk Locks!Let's Talk Locks!
Let's Talk Locks!
C4Media
?
PerceptronPerceptron
Perceptron
koki Ou
?
(2013 DEVIEW) ????? ?????? ??? ?????
(2013 DEVIEW) ????? ??????  ??? ????? (2013 DEVIEW) ????? ??????  ??? ?????
(2013 DEVIEW) ????? ?????? ??? ?????
?? ?
?
°ä/°ä++¤È°Â±ð²ú´¡²õ²õ±ð³¾²ú±ô²â¤òÀûÓä·¤¿¥é¥¤¥Ö¥é¥ê¿ª°k
°ä/°ä++¤È°Â±ð²ú´¡²õ²õ±ð³¾²ú±ô²â¤òÀûÓä·¤¿¥é¥¤¥Ö¥é¥ê¿ª°k°ä/°ä++¤È°Â±ð²ú´¡²õ²õ±ð³¾²ú±ô²â¤òÀûÓä·¤¿¥é¥¤¥Ö¥é¥ê¿ª°k
°ä/°ä++¤È°Â±ð²ú´¡²õ²õ±ð³¾²ú±ô²â¤òÀûÓä·¤¿¥é¥¤¥Ö¥é¥ê¿ª°k
µv˾ ÒÁÌÙ
?
Cours javaCours java
Cours java
Zakaria Mouammin
?
Code Correcteurs d'Erreurs :  Code lin¨¦aire, code cyclique , code goppa  Code Correcteurs d'Erreurs :  Code lin¨¦aire, code cyclique , code goppa
Code Correcteurs d'Erreurs : Code lin¨¦aire, code cyclique , code goppa
SALMARACHIDI1
?
Cours ML et Deep Learning M2 2022-2023.pdfCours ML et Deep Learning M2 2022-2023.pdf
Cours ML et Deep Learning M2 2022-2023.pdf
UrbainNgatoua
?

Similar to PHP ? MySQL? ??? ?? ?? ???? (20)

Node and Express Configuration
Node and Express ConfigurationNode and Express Configuration
Node and Express Configuration
jiseob kim
?
[????????] ??? ???? ??? init script ??? ??(??? ???? ??? ????)
[????????] ??? ???? ??? init script ??? ??(??? ???? ??? ????)[????????] ??? ???? ??? init script ??? ??(??? ???? ??? ????)
[????????] ??? ???? ??? init script ??? ??(??? ???? ??? ????)
NAVER CLOUD PLATFORM???? ???? ???
?
Laravel install on Windows
Laravel install on WindowsLaravel install on Windows
Laravel install on Windows
hojin lee
?
?? ??? ??? ?? CruiseControl.NET? Windows Terminal
?? ??? ??? ?? CruiseControl.NET? Windows Terminal?? ??? ??? ?? CruiseControl.NET? Windows Terminal
?? ??? ??? ?? CruiseControl.NET? Windows Terminal
OnGameServer
?
Startup JavaScript 7 - Node.JS ??
Startup JavaScript 7 - Node.JS ??Startup JavaScript 7 - Node.JS ??
Startup JavaScript 7 - Node.JS ??
Circulus
?
20170813 django api server unit test and remote debugging
20170813 django api server unit test and remote debugging20170813 django api server unit test and remote debugging
20170813 django api server unit test and remote debugging
Jongwon Han
?
2016 NDC - ???? ??? ??? ?? ?? ??? ??
2016 NDC  - ???? ???  ??? ?? ?? ??? ??2016 NDC  - ???? ???  ??? ?? ?? ??? ??
2016 NDC - ???? ??? ??? ?? ?? ??? ??
iFunFactory Inc.
?
Cruise control net_and_terminal_with_gamedev
Cruise control net_and_terminal_with_gamedevCruise control net_and_terminal_with_gamedev
Cruise control net_and_terminal_with_gamedev
Heo Seungwook
?
IBM DataPower OS(DPOS) ? CLI ??
IBM DataPower OS(DPOS) ? CLI ??IBM DataPower OS(DPOS) ? CLI ??
IBM DataPower OS(DPOS) ? CLI ??
JungWoon Lee
?
Windows Debugging Technique #3
Windows Debugging Technique #3Windows Debugging Technique #3
Windows Debugging Technique #3
Wooseok Seo
?
??? ?? ????? ???, ??? ?? ??? ?? ??
??? ?? ????? ???, ??? ?? ??? ?? ????? ?? ????? ???, ??? ?? ??? ?? ??
??? ?? ????? ???, ??? ?? ??? ?? ??
if kakao
?
Laravel ?? ??????? ?????????? #1
Laravel ?? ??????? ?????????? #1Laravel ?? ??????? ?????????? #1
Laravel ?? ??????? ?????????? #1
?? ?
?
Node js[stg]onimusha 20140822
Node js[stg]onimusha 20140822Node js[stg]onimusha 20140822
Node js[stg]onimusha 20140822
?? ?
?
Unity cookbook 18
Unity cookbook 18Unity cookbook 18
Unity cookbook 18
Jihun Soh
?
web study 1day
web study 1dayweb study 1day
web study 1day
?? ?
?
[APM] Homepage bbs
[APM] Homepage bbs[APM] Homepage bbs
[APM] Homepage bbs
Kim Heejin
?
?? ??? ?? ??? (???, ???? Naver)
?? ??? ?? ??? (???, ???? Naver)?? ??? ?? ??? (???, ???? Naver)
?? ??? ?? ??? (???, ???? Naver)
Seungmo Koo
?
[IGC 2017] ??? ??? - ?? ???? ?? ?? ? ????
[IGC 2017] ??? ??? - ?? ???? ?? ?? ? ????[IGC 2017] ??? ??? - ?? ???? ?? ?? ? ????
[IGC 2017] ??? ??? - ?? ???? ?? ?? ? ????
? ??
?
Node.js ???
Node.js ???Node.js ???
Node.js ???
SeungHyun Lee
?
[??? ??] EC2?? ????? ????
[??? ??] EC2?? ????? ????[??? ??] EC2?? ????? ????
[??? ??] EC2?? ????? ????
Jay Park
?
Node and Express Configuration
Node and Express ConfigurationNode and Express Configuration
Node and Express Configuration
jiseob kim
?
Laravel install on Windows
Laravel install on WindowsLaravel install on Windows
Laravel install on Windows
hojin lee
?
?? ??? ??? ?? CruiseControl.NET? Windows Terminal
?? ??? ??? ?? CruiseControl.NET? Windows Terminal?? ??? ??? ?? CruiseControl.NET? Windows Terminal
?? ??? ??? ?? CruiseControl.NET? Windows Terminal
OnGameServer
?
Startup JavaScript 7 - Node.JS ??
Startup JavaScript 7 - Node.JS ??Startup JavaScript 7 - Node.JS ??
Startup JavaScript 7 - Node.JS ??
Circulus
?
20170813 django api server unit test and remote debugging
20170813 django api server unit test and remote debugging20170813 django api server unit test and remote debugging
20170813 django api server unit test and remote debugging
Jongwon Han
?
2016 NDC - ???? ??? ??? ?? ?? ??? ??
2016 NDC  - ???? ???  ??? ?? ?? ??? ??2016 NDC  - ???? ???  ??? ?? ?? ??? ??
2016 NDC - ???? ??? ??? ?? ?? ??? ??
iFunFactory Inc.
?
Cruise control net_and_terminal_with_gamedev
Cruise control net_and_terminal_with_gamedevCruise control net_and_terminal_with_gamedev
Cruise control net_and_terminal_with_gamedev
Heo Seungwook
?
IBM DataPower OS(DPOS) ? CLI ??
IBM DataPower OS(DPOS) ? CLI ??IBM DataPower OS(DPOS) ? CLI ??
IBM DataPower OS(DPOS) ? CLI ??
JungWoon Lee
?
Windows Debugging Technique #3
Windows Debugging Technique #3Windows Debugging Technique #3
Windows Debugging Technique #3
Wooseok Seo
?
??? ?? ????? ???, ??? ?? ??? ?? ??
??? ?? ????? ???, ??? ?? ??? ?? ????? ?? ????? ???, ??? ?? ??? ?? ??
??? ?? ????? ???, ??? ?? ??? ?? ??
if kakao
?
Laravel ?? ??????? ?????????? #1
Laravel ?? ??????? ?????????? #1Laravel ?? ??????? ?????????? #1
Laravel ?? ??????? ?????????? #1
?? ?
?
Node js[stg]onimusha 20140822
Node js[stg]onimusha 20140822Node js[stg]onimusha 20140822
Node js[stg]onimusha 20140822
?? ?
?
Unity cookbook 18
Unity cookbook 18Unity cookbook 18
Unity cookbook 18
Jihun Soh
?
web study 1day
web study 1dayweb study 1day
web study 1day
?? ?
?
[APM] Homepage bbs
[APM] Homepage bbs[APM] Homepage bbs
[APM] Homepage bbs
Kim Heejin
?
?? ??? ?? ??? (???, ???? Naver)
?? ??? ?? ??? (???, ???? Naver)?? ??? ?? ??? (???, ???? Naver)
?? ??? ?? ??? (???, ???? Naver)
Seungmo Koo
?
[IGC 2017] ??? ??? - ?? ???? ?? ?? ? ????
[IGC 2017] ??? ??? - ?? ???? ?? ?? ? ????[IGC 2017] ??? ??? - ?? ???? ?? ?? ? ????
[IGC 2017] ??? ??? - ?? ???? ?? ?? ? ????
? ??
?
[??? ??] EC2?? ????? ????
[??? ??] EC2?? ????? ????[??? ??] EC2?? ????? ????
[??? ??] EC2?? ????? ????
Jay Park
?
Ad

PHP ? MySQL? ??? ?? ?? ????