{"id":243,"date":"2016-01-24T12:43:09","date_gmt":"2016-01-24T12:43:09","guid":{"rendered":"http:\/\/codebee.co.th\/labs\/?p=243"},"modified":"2017-02-08T03:35:58","modified_gmt":"2017-02-08T03:35:58","slug":"unity-c-%e0%b9%82%e0%b8%ab%e0%b8%a5%e0%b8%94%e0%b9%81%e0%b8%a5%e0%b8%b0%e0%b9%81%e0%b8%aa%e0%b8%94%e0%b8%87-json-data-%e0%b8%95%e0%b8%b4%e0%b8%94%e0%b8%90%e0%b8%b2%e0%b8%99%e0%b8%82%e0%b9%89%e0%b8%ad","status":"publish","type":"post","link":"https:\/\/www.codebee.co.th\/labs\/unity-c-%e0%b9%82%e0%b8%ab%e0%b8%a5%e0%b8%94%e0%b9%81%e0%b8%a5%e0%b8%b0%e0%b9%81%e0%b8%aa%e0%b8%94%e0%b8%87-json-data-%e0%b8%95%e0%b8%b4%e0%b8%94%e0%b8%90%e0%b8%b2%e0%b8%99%e0%b8%82%e0%b9%89%e0%b8%ad\/","title":{"rendered":"Unity C# \u0e42\u0e2b\u0e25\u0e14\u0e41\u0e25\u0e30\u0e41\u0e2a\u0e14\u0e07 JSON Data \u0e15\u0e34\u0e14\u0e10\u0e32\u0e19\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25 PHP & MySQL"},"content":{"rendered":"

Unity C# \u0e42\u0e2b\u0e25\u0e14\u0e41\u0e25\u0e30\u0e41\u0e2a\u0e14\u0e07 JSON Data \u0e15\u0e34\u0e14\u0e10\u0e32\u0e19\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25 PHP & MySQL<\/h3>\n

1. \u0e1c\u0e21\u0e40\u0e17\u0e2a\u0e42\u0e14\u0e22\u0e2d\u0e2d\u0e01\u0e41\u0e1a\u0e1a\u0e10\u0e32\u0e19\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e07\u0e48\u0e32\u0e22 \u0e46 \u0e19\u0e30\u0e04\u0e23\u0e31\u0e1a\u0e21\u0e35\u0e41\u0e04\u0e48 2 field \u0e04\u0e37\u0e2d id,name \u0e15\u0e32\u0e21\u0e23\u0e39\u0e1b\u0e04\u0e23\u0e31\u0e1a
\n\"unity-c#-php-mysql-connect-1\"<\/a><\/p>\n

<\/p>\n

2. \u0e2a\u0e23\u0e49\u0e32\u0e07\u0e44\u0e1f\u0e25\u0e4c connect.php \u0e2a\u0e33\u0e2b\u0e23\u0e31\u0e1a\u0e15\u0e34\u0e14\u0e15\u0e48\u0e2d\u0e10\u0e32\u0e19\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25<\/p>\n

<?php\r\n\r\ndefine(\"db_server\", \"localhost\");  \r\ndefine(\"db_username\", \"root\");\r\ndefine(\"db_password\", \"root\");\r\ndefine(\"db_name\", \"dbname\");  \r\n\t\r\n$conn = mysql_connect(db_server,db_username,db_password);\r\nmysql_select_db(db_name, $conn);\r\nmysql_query('SET NAMES UTF8');\r\n\r\n?><\/pre>\n
3. \u0e2a\u0e23\u0e49\u0e32\u0e07\u0e44\u0e1f\u0e25\u0e4c saveload.php \u0e2a\u0e33\u0e2b\u0e23\u0e31\u0e1a\u0e23\u0e31\u0e1a\u0e04\u0e48\u0e32\u0e08\u0e32\u0e01 C# \u0e41\u0e25\u0e30\u0e1a\u0e31\u0e19\u0e17\u0e36\u0e01\u0e25\u0e07\u0e10\u0e32\u0e19\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25 \u0e1e\u0e23\u0e49\u0e2d\u0e21\u0e01\u0e31\u0e1a return json data \u0e01\u0e25\u0e31\u0e1a\u0e44\u0e1b<\/p>\n
<?php\r\n\r\nrequire_once(\"connect.php\");\r\n\r\n$name = $_REQUEST['name'];\r\n\r\nif($name != \"\"){\r\n\t$sql = \"INSERT INTO member SET name='$name'\";\r\n\t$result = mysql_query($sql);\r\n}\r\n$sql = \"SELECT*FROM member\";\r\n$result = mysql_query($sql);\r\n\r\n$data = array();\r\nwhile ($row = mysql_fetch_assoc($result)) {\r\n    $r = array(\r\n        'id' => $row['id'],\r\n        'name' => $row['name']\r\n    );\r\n\tarray_push($data,$r);\r\n}\r\necho json_encode($data);\r\n\r\n?><\/pre>\n
4. \u0e40\u0e1b\u0e34\u0e14\u0e42\u0e1b\u0e23\u0e41\u0e01\u0e23\u0e21 unity \u0e02\u0e36\u0e49\u0e19\u0e21\u0e32 \u0e17\u0e14\u0e25\u0e2d\u0e07\u0e2a\u0e23\u0e49\u0e32\u0e07 InputField \u0e41\u0e25\u0e30 Button \u0e43\u0e2b\u0e49\u0e21\u0e35\u0e2b\u0e19\u0e49\u0e32\u0e15\u0e32\u0e1b\u0e23\u0e30\u0e21\u0e32\u0e13\u0e19\u0e35\u0e49 \u0e2a\u0e48\u0e27\u0e19\u0e19\u0e35\u0e49 \u0e15\u0e32\u0e21\u0e43\u0e08\u0e17\u0e48\u0e32\u0e19\u0e1c\u0e39\u0e49\u0e0a\u0e21\u0e04\u0e23\u0e31\u0e1a
\n   \"unity-c#-php-mysql-connect-3\"<\/a><\/p>\n
5. \u0e04\u0e25\u0e34\u0e01\u0e02\u0e27\u0e32\u0e17\u0e35\u0e48\u0e2b\u0e19\u0e49\u0e32\u0e15\u0e48\u0e32\u0e07 Hierarchy \u0e40\u0e25\u0e37\u0e2d\u0e01 Create Empty \u0e40\u0e23\u0e32\u0e08\u0e30\u0e44\u0e14\u0e49 GameObject \u0e21\u0e32\u0e43\u0e2b\u0e49\u0e15\u0e31\u0e49\u0e07\u0e0a\u0e37\u0e48\u0e2d\u0e43\u0e2b\u0e21\u0e48\u0e27\u0e48\u0e32 AppController \u0e2a\u0e33\u0e2b\u0e23\u0e31\u0e1a GameObject \u0e15\u0e31\u0e27\u0e19\u0e35\u0e49\u0e08\u0e30\u0e40\u0e1b\u0e47\u0e19\u0e27\u0e31\u0e15\u0e16\u0e38\u0e40\u0e1b\u0e25\u0e48\u0e32 \u0e46 \u0e19\u0e30\u0e04\u0e23\u0e31\u0e1a \u0e40\u0e2d\u0e32\u0e44\u0e27\u0e49\u0e43\u0e2a\u0e48 C# Script \u0e17\u0e35\u0e48\u0e40\u0e23\u0e32\u0e08\u0e30\u0e40\u0e02\u0e35\u0e22\u0e19\u0e40\u0e1e\u0e34\u0e48\u0e21\u0e20\u0e32\u0e22\u0e2b\u0e25\u0e31\u0e07
\n\"unity-c#-php-mysql-connect-4\"<\/a><\/p>\n
6. \u0e40\u0e2a\u0e23\u0e47\u0e08\u0e41\u0e25\u0e49\u0e27\u0e43\u0e2b\u0e49\u0e17\u0e33\u0e01\u0e32\u0e23\u0e40\u0e1e\u0e34\u0e48\u0e21 C# script \u0e44\u0e1b\u0e17\u0e35\u0e48 AppController \u0e01\u0e14\u0e44\u0e1b\u0e17\u0e35\u0e48 Inspector->Add Component->New script \u0e15\u0e31\u0e49\u0e07\u0e0a\u0e37\u0e48\u0e2d\u0e27\u0e48\u0e32 AppController \u0e01\u0e14\u0e1b\u0e38\u0e48\u0e21 Create And Add
\n   \"unity-c#-php-mysql-connect-5\"<\/a><\/p>\n
7. \u0e43\u0e2b\u0e49\u0e2a\u0e31\u0e07\u0e40\u0e01\u0e15\u0e38\u0e17\u0e35\u0e48\u0e2a\u0e48\u0e27\u0e19\u0e02\u0e2d\u0e07\u0e41\u0e17\u0e1a project \u0e40\u0e23\u0e32\u0e08\u0e30\u0e44\u0e14\u0e49\u0e44\u0e1f\u0e25\u0e4c AppControler.cs \u0e21\u0e32\u0e43\u0e2b\u0e49\u0e14\u0e31\u0e1a\u0e40\u0e1a\u0e34\u0e49\u0e25\u0e04\u0e25\u0e34\u0e01
\n   \u0e23\u0e30\u0e1a\u0e1a\u0e08\u0e30\u0e40\u0e1b\u0e34\u0e14\u0e42\u0e1b\u0e23\u0e41\u0e01\u0e23\u0e21 MonoDevelop \u0e02\u0e36\u0e49\u0e19\u0e21\u0e32\u0e04\u0e23\u0e31\u0e1a
\n   \u0e41\u0e25\u0e30\u0e01\u0e48\u0e2d\u0e19\u0e17\u0e35\u0e48\u0e40\u0e23\u0e32\u0e08\u0e30\u0e44\u0e1b\u0e40\u0e02\u0e35\u0e22\u0e19\u0e42\u0e04\u0e4a\u0e14\u0e17\u0e35\u0e48\u0e44\u0e1f\u0e25\u0e4c\u0e19\u0e35\u0e49 \u0e43\u0e2b\u0e49\u0e44\u0e1b\u0e42\u0e2b\u0e25\u0e14 LitJson \u0e21\u0e32\u0e44\u0e27\u0e49\u0e43\u0e19 assets \u0e01\u0e48\u0e2d\u0e19\u0e04\u0e23\u0e31\u0e1a
\n   \u0e42\u0e2b\u0e25\u0e14\u0e17\u0e35\u0e48 https:\/\/lbv.github.io\/litjson\/<\/a>
\n   \"unity-c#-php-mysql-connect-6\"<\/a><\/p>\n
8. \u0e43\u0e19 AppController.cs \u0e43\u0e2b\u0e49\u0e40\u0e23\u0e32\u0e2a\u0e23\u0e49\u0e32\u0e07\u0e15\u0e31\u0e27\u0e41\u0e1b\u0e23\u0e41\u0e1a\u0e1a public \u0e02\u0e36\u0e49\u0e19\u0e21\u0e32 \u0e40\u0e1e\u0e37\u0e48\u0e2d\u0e40\u0e0a\u0e37\u0e48\u0e2d\u0e21\u0e42\u0e22\u0e07\u0e01\u0e31\u0e1a InputField \u0e41\u0e25\u0e30 Button \u0e17\u0e35\u0e48\u0e40\u0e23\u0e32\u0e2a\u0e23\u0e49\u0e32\u0e07\u0e44\u0e27\u0e49\u0e01\u0e48\u0e2d\u0e19\u0e2b\u0e19\u0e49\u0e32\u0e19\u0e35\u0e49<\/p>\n
using UnityEngine;\r\nusing UnityEngine.UI;\r\nusing System.Collections;\r\nusing LitJson; \/\/ import json \u0e40\u0e02\u0e49\u0e32\u0e21\u0e32\u0e23\u0e2d\u0e44\u0e27\u0e49\u0e40\u0e25\u0e22\r\n\r\npublic class AppController : MonoBehaviour {\r\n\r\n\tpublic Button btnSubmit;\r\n\tpublic InputField txtName;\r\n}<\/pre>\n
9. \u0e43\u0e19\u0e2b\u0e19\u0e49\u0e32\u0e15\u0e48\u0e32\u0e07 hierarchy \u0e40\u0e25\u0e37\u0e2d\u0e01 AppController \u0e41\u0e25\u0e49\u0e27\u0e17\u0e33\u0e01\u0e32\u0e23\u0e40\u0e0a\u0e37\u0e48\u0e2d\u0e21\u0e42\u0e22\u0e07 \u0e42\u0e14\u0e22\u0e01\u0e32\u0e23\u0e25\u0e32\u0e01 Button \u0e41\u0e25\u0e30 InputField \u0e44\u0e1b\u0e41\u0e17\u0e19\u0e04\u0e48\u0e32\u0e15\u0e31\u0e27\u0e41\u0e1b\u0e23\u0e17\u0e35\u0e48\u0e40\u0e23\u0e32\u0e40\u0e02\u0e35\u0e22\u0e19\u0e44\u0e27\u0e49\u0e04\u0e37\u0e2d btnSubmit \u0e41\u0e25\u0e30 txtName
\n\"unity-c#-php-mysql-connect-7\"<\/a><\/p>\n
10. \u0e40\u0e1b\u0e34\u0e14\u0e44\u0e1f\u0e25\u0e4c AppController.cs \u0e02\u0e36\u0e49\u0e19\u0e21\u0e32\u0e04\u0e23\u0e31\u0e1a \u0e41\u0e25\u0e49\u0e27\u0e40\u0e02\u0e35\u0e22\u0e19\u0e42\u0e04\u0e4a\u0e14 \u0e40\u0e1e\u0e34\u0e48\u0e21\u0e02\u0e36\u0e49\u0e19\u0e21\u0e32\u0e1b\u0e23\u0e30\u0e21\u0e32\u0e13\u0e19\u0e35\u0e49\u0e04\u0e23\u0e31\u0e1a<\/p>\n
private JsonData userData;\r\n\r\n\tvoid Start () {\r\n\t\tbtnSubmit.onClick.AddListener (delegate {\r\n\t\t\tDebug.Log(\"click !\");\r\n\t\t\tStartCoroutine(submitMyName());\r\n\t\t});\r\n\t}\r\n\r\n\tIEnumerator submitMyName () {\r\n\t\tif (txtName.text.Length <= 0) {\r\n\t\t\tDebug.Log (\"please enter name\");\r\n\t\t\treturn false;\r\n\t\t}\r\n\t\tDebug.Log(\"submit !\");\r\n\t\tWWWForm form = new WWWForm();\r\n\t\tform.AddField(\"name\",txtName.text);\r\n\r\n\t\tWWW www = new WWW(\"http:\/\/localhost:8888\/saveload.php\", form);\r\n\t\tyield return www;\r\n\r\n\t\tuserData = JsonMapper.ToObject(www.text);\r\n\r\n\t\tint maxUser = userData.Count;\r\n\t\tfor(int i=0;i<maxUser;i++)\r\n\t\t{\r\n\t\t\tDebug.Log(userData[i][\"name\"]);\r\n\t\t}\r\n\t\tStopCoroutine (submitMyName());\r\n\t}<\/pre>\n
11. \u0e25\u0e2d\u0e07\u0e01\u0e14\u0e1b\u0e38\u0e48\u0e21 play \u0e17\u0e14\u0e2a\u0e2d\u0e1a\u0e14\u0e39\u0e04\u0e23\u0e31\u0e1a \u0e08\u0e30\u0e40\u0e2b\u0e47\u0e19\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e17\u0e35\u0e48\u0e40\u0e23\u0e32\u0e01\u0e23\u0e2d\u0e01\u0e44\u0e1b\u0e17\u0e38\u0e01 \u0e46 \u0e04\u0e23\u0e31\u0e49\u0e07 \u0e16\u0e39\u0e01\u0e1a\u0e31\u0e19\u0e17\u0e36\u0e01\u0e41\u0e25\u0e30\u0e23\u0e35\u0e40\u0e17\u0e34\u0e19\u0e04\u0e48\u0e32\u0e01\u0e25\u0e31\u0e1a\u0e21\u0e32\u0e17\u0e35\u0e48\u0e2b\u0e19\u0e49\u0e32\u0e15\u0e48\u0e32\u0e07 Console \u0e17\u0e35\u0e48\u0e40\u0e2b\u0e25\u0e37\u0e2d\u0e01\u0e47\u0e2a\u0e38\u0e14\u0e41\u0e25\u0e49\u0e27\u0e41\u0e15\u0e48\u0e08\u0e30\u0e40\u0e2d\u0e32\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e44\u0e1b\u0e17\u0e33\u0e2d\u0e30\u0e44\u0e23\u0e04\u0e23\u0e31\u0e1a
\n\"unity-c#-php-mysql-connect-8\"<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Unity C# \u0e42\u0e2b\u0e25\u0e14\u0e41\u0e25\u0e30\u0e41\u0e2a\u0e14\u0e07 JSON Data \u0e15\u0e34\u0e14\u0e10\u0e32\u0e19\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25 PHP & MySQL 1. \u0e1c\u0e21\u0e40\u0e17\u0e2a\u0e42\u0e14\u0e22\u0e2d\u0e2d\u0e01\u0e41\u0e1a\u0e1a\u0e10\u0e32\u0e19\u0e02\u0e49\u0e2d\u0e21\u0e39\u0e25\u0e07\u0e48\u0e32\u0e22 \u0e46 \u0e19\u0e30\u0e04\u0e23\u0e31\u0e1a\u0e21\u0e35\u0e41\u0e04\u0e48 2 field \u0e04\u0e37\u0e2d id,name \u0e15\u0e32\u0e21\u0e23\u0e39\u0e1b\u0e04\u0e23\u0e31\u0e1a<\/p>\n","protected":false},"author":1,"featured_media":684,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"video","meta":{"footnotes":""},"categories":[45,1222],"tags":[15,821,16,43,44,836,996,997,1002,1003,23],"class_list":["post-243","post","type-post","status-publish","format-video","has-post-thumbnail","hentry","category-mobile-development-","category-unity3d-development","tag-c-","tag-php-json-","tag-unity-c","tag-43","tag-44","tag--unity3d","tag-996","tag-997","tag-1002","tag-1003","tag--hybrid","post_format-post-format-video"],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.codebee.co.th\/labs\/wp-json\/wp\/v2\/posts\/243","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.codebee.co.th\/labs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.codebee.co.th\/labs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.codebee.co.th\/labs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.codebee.co.th\/labs\/wp-json\/wp\/v2\/comments?post=243"}],"version-history":[{"count":18,"href":"https:\/\/www.codebee.co.th\/labs\/wp-json\/wp\/v2\/posts\/243\/revisions"}],"predecessor-version":[{"id":2448,"href":"https:\/\/www.codebee.co.th\/labs\/wp-json\/wp\/v2\/posts\/243\/revisions\/2448"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.codebee.co.th\/labs\/wp-json\/wp\/v2\/media\/684"}],"wp:attachment":[{"href":"https:\/\/www.codebee.co.th\/labs\/wp-json\/wp\/v2\/media?parent=243"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.codebee.co.th\/labs\/wp-json\/wp\/v2\/categories?post=243"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.codebee.co.th\/labs\/wp-json\/wp\/v2\/tags?post=243"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}