<h3>Unity C# à¹à¸«à¸¥à¸à¹à¸¥à¸°à¹à¸ªà¸à¸ JSON Data à¸à¸´à¸à¸à¸²à¸à¸à¹à¸à¸¡à¸¹à¸¥ PHP &#038; MySQL</h3>
<p>1. à¸à¸¡à¹à¸à¸ªà¹à¸à¸¢à¸à¸à¸à¹à¸à¸à¸à¸²à¸à¸à¹à¸à¸¡à¸¹à¸¥à¸à¹à¸²à¸¢ ๠à¸à¸°à¸à¸£à¸±à¸à¸¡à¸µà¹à¸à¹ 2 field à¸à¸·à¸ id,name à¸à¸²à¸¡à¸£à¸¹à¸à¸à¸£à¸±à¸<br />
<a href="http://codebee.co.th/labs/wp-content/uploads/2016/01/unity-c-php-mysql-connect-1.png" rel="attachment wp-att-244"><img src="http://codebee.co.th/labs/wp-content/uploads/2016/01/unity-c-php-mysql-connect-1-620x92.png" alt="unity-c#-php-mysql-connect-1" width="620" height="92" class="alignnone size-medium wp-image-244" data-full="https://codebee.co.th/labs/wp-content/uploads/2016/01/unity-c-php-mysql-connect-1.png" data-full-size="905x135" /></a></p>
<p><!--more--></p>
<p>2. สรà¹à¸²à¸à¹à¸à¸¥à¹ connect.php สำหรัà¸à¸à¸´à¸à¸à¹à¸à¸à¸²à¸à¸à¹à¸à¸¡à¸¹à¸¥</p>
<pre class="lang:php decode:true " ><;?php 
 
define("db_server", "localhost"); 
define("db_username", "root"); 
define("db_password", "root"); 
define("db_name", "dbname"); 
	 
$conn = mysql_connect(db_server,db_username,db_password); 
mysql_select_db(db_name, $conn); 
mysql_query('SET NAMES UTF8'); 
 
?>;</pre>
<p>3. สรà¹à¸²à¸à¹à¸à¸¥à¹ saveload.php สำหรัà¸à¸£à¸±à¸à¸à¹à¸²à¸à¸²à¸ C# à¹à¸¥à¸°à¸à¸±à¸à¸à¸¶à¸à¸¥à¸à¸à¸²à¸à¸à¹à¸à¸¡à¸¹à¸¥ à¸à¸£à¹à¸à¸¡à¸à¸±à¸ return json data à¸à¸¥à¸±à¸à¹à¸</p>
<pre class="lang:php decode:true " ><;?php 
 
require_once("connect.php"); 
 
$name = $_REQUEST['name']; 
 
if($name != ""){ 
	$sql = "INSERT INTO member SET name='$name'"; 
	$result = mysql_query($sql); 
} 
$sql = "SELECT*FROM member"; 
$result = mysql_query($sql); 
 
$data = array(); 
while ($row = mysql_fetch_assoc($result)) { 
 $r = array( 
 'id' =>; $row['id'], 
 'name' =>; $row['name'] 
 ); 
	array_push($data,$r); 
} 
echo json_encode($data); 
 
?>;</pre>
<p>4. à¹à¸à¸´à¸à¹à¸à¸£à¹à¸à¸£à¸¡ unity à¸à¸¶à¹à¸à¸¡à¸² à¸à¸à¸¥à¸à¸à¸ªà¸£à¹à¸²à¸ InputField à¹à¸¥à¸° Button à¹à¸«à¹à¸¡à¸µà¸«à¸à¹à¸²à¸à¸²à¸à¸£à¸°à¸¡à¸²à¸à¸à¸µà¹ สà¹à¸§à¸à¸à¸µà¹ à¸à¸²à¸¡à¹à¸à¸à¹à¸²à¸à¸à¸¹à¹à¸à¸¡à¸à¸£à¸±à¸<br />
 <a href="http://codebee.co.th/labs/wp-content/uploads/2016/01/unity-c-php-mysql-connect-3.png" rel="attachment wp-att-250"><img src="http://codebee.co.th/labs/wp-content/uploads/2016/01/unity-c-php-mysql-connect-3.png" alt="unity-c#-php-mysql-connect-3" width="515" height="559" class="alignnone size-full wp-image-250" data-full="https://codebee.co.th/labs/wp-content/uploads/2016/01/unity-c-php-mysql-connect-3.png" data-full-size="515x559" /></a></p>
<p>5. à¸à¸¥à¸´à¸à¸à¸§à¸²à¸à¸µà¹à¸«à¸à¹à¸²à¸à¹à¸²à¸ Hierarchy à¹à¸¥à¸·à¸à¸ Create Empty à¹à¸£à¸²à¸à¸°à¹à¸à¹ GameObject มาà¹à¸«à¹à¸à¸±à¹à¸à¸à¸·à¹à¸à¹à¸«à¸¡à¹à¸§à¹à¸² AppController สำหรัภGameObject à¸à¸±à¸§à¸à¸µà¹à¸à¸°à¹à¸à¹à¸à¸§à¸±à¸à¸à¸¸à¹à¸à¸¥à¹à¸² ๠à¸à¸°à¸à¸£à¸±à¸ à¹à¸à¸²à¹à¸§à¹à¹à¸ªà¹ C# Script à¸à¸µà¹à¹à¸£à¸²à¸à¸°à¹à¸à¸µà¸¢à¸à¹à¸à¸´à¹à¸¡à¸ ายหลัà¸<br />
<a href="http://codebee.co.th/labs/wp-content/uploads/2016/01/unity-c-php-mysql-connect-4.png" rel="attachment wp-att-253"><img src="http://codebee.co.th/labs/wp-content/uploads/2016/01/unity-c-php-mysql-connect-4.png" alt="unity-c#-php-mysql-connect-4" width="200" height="285" class="alignnone size-full wp-image-253" data-full="https://codebee.co.th/labs/wp-content/uploads/2016/01/unity-c-php-mysql-connect-4.png" data-full-size="200x285" /></a></p>
<p>6. à¹à¸ªà¸£à¹à¸à¹à¸¥à¹à¸§à¹à¸«à¹à¸à¸³à¸à¸²à¸£à¹à¸à¸´à¹à¸¡ C# script à¹à¸à¸à¸µà¹ AppController à¸à¸à¹à¸à¸à¸µà¹ Inspector->Add Component->New script à¸à¸±à¹à¸à¸à¸·à¹à¸à¸§à¹à¸² AppController à¸à¸à¸à¸¸à¹à¸¡ Create And Add<br />
 <a href="http://codebee.co.th/labs/wp-content/uploads/2016/01/unity-c-php-mysql-connect-5.png" rel="attachment wp-att-252"><img src="http://codebee.co.th/labs/wp-content/uploads/2016/01/unity-c-php-mysql-connect-5.png" alt="unity-c#-php-mysql-connect-5" width="474" height="522" class="alignnone size-full wp-image-252" data-full="https://codebee.co.th/labs/wp-content/uploads/2016/01/unity-c-php-mysql-connect-5.png" data-full-size="474x522" /></a></p>
<p>7. à¹à¸«à¹à¸ªà¸±à¸à¹à¸à¸à¸¸à¸à¸µà¹à¸ªà¹à¸§à¸à¸à¸à¸à¹à¸à¸ project à¹à¸£à¸²à¸à¸°à¹à¸à¹à¹à¸à¸¥à¹ AppControler.cs มาà¹à¸«à¹à¸à¸±à¸à¹à¸à¸´à¹à¸¥à¸à¸¥à¸´à¸<br />
 ระà¸à¸à¸à¸°à¹à¸à¸´à¸à¹à¸à¸£à¹à¸à¸£à¸¡ MonoDevelop à¸à¸¶à¹à¸à¸¡à¸²à¸à¸£à¸±à¸<br />
 à¹à¸¥à¸°à¸à¹à¸à¸à¸à¸µà¹à¹à¸£à¸²à¸à¸°à¹à¸à¹à¸à¸µà¸¢à¸à¹à¸à¹à¸à¸à¸µà¹à¹à¸à¸¥à¹à¸à¸µà¹ à¹à¸«à¹à¹à¸à¹à¸«à¸¥à¸ LitJson มาà¹à¸§à¹à¹à¸ assets à¸à¹à¸à¸à¸à¸£à¸±à¸<br />
 à¹à¸«à¸¥à¸à¸à¸µà¹ <a target="_blank" href="https://lbv.github.io/litjson/">https://lbv.github.io/litjson/</a><br />
 <a href="http://codebee.co.th/labs/wp-content/uploads/2016/01/unity-c-php-mysql-connect-6.png" rel="attachment wp-att-256"><img src="http://codebee.co.th/labs/wp-content/uploads/2016/01/unity-c-php-mysql-connect-6.png" alt="unity-c#-php-mysql-connect-6" width="198" height="178" class="alignnone size-full wp-image-256" data-full="https://codebee.co.th/labs/wp-content/uploads/2016/01/unity-c-php-mysql-connect-6.png" data-full-size="198x178" /></a></p>
<p>8. à¹à¸ AppController.cs à¹à¸«à¹à¹à¸£à¸²à¸ªà¸£à¹à¸²à¸à¸à¸±à¸§à¹à¸à¸£à¹à¸à¸ public à¸à¸¶à¹à¸à¸¡à¸² à¹à¸à¸·à¹à¸à¹à¸à¸·à¹à¸à¸¡à¹à¸¢à¸à¸à¸±à¸ InputField à¹à¸¥à¸° Button à¸à¸µà¹à¹à¸£à¸²à¸ªà¸£à¹à¸²à¸à¹à¸§à¹à¸à¹à¸à¸à¸«à¸à¹à¸²à¸à¸µà¹</p>
<pre class="lang:c# decode:true " >using UnityEngine; 
using UnityEngine.UI; 
using System.Collections; 
using LitJson; // import json à¹à¸à¹à¸²à¸¡à¸²à¸£à¸à¹à¸§à¹à¹à¸¥à¸¢ 
 
public class AppController : MonoBehaviour { 
 
	public Button btnSubmit; 
	public InputField txtName; 
}</pre>
<p>9. à¹à¸à¸«à¸à¹à¸²à¸à¹à¸²à¸ hierarchy à¹à¸¥à¸·à¸à¸ AppController à¹à¸¥à¹à¸§à¸à¸³à¸à¸²à¸£à¹à¸à¸·à¹à¸à¸¡à¹à¸¢à¸ à¹à¸à¸¢à¸à¸²à¸£à¸¥à¸²à¸ Button à¹à¸¥à¸° InputField à¹à¸à¹à¸à¸à¸à¹à¸²à¸à¸±à¸§à¹à¸à¸£à¸à¸µà¹à¹à¸£à¸²à¹à¸à¸µà¸¢à¸à¹à¸§à¹à¸à¸·à¸ btnSubmit à¹à¸¥à¸° txtName<br />
<a href="http://codebee.co.th/labs/wp-content/uploads/2016/01/unity-c-php-mysql-connect-7.png" rel="attachment wp-att-259"><img src="http://codebee.co.th/labs/wp-content/uploads/2016/01/unity-c-php-mysql-connect-7.png" alt="unity-c#-php-mysql-connect-7" width="474" height="411" class="alignnone size-full wp-image-259" data-full="https://codebee.co.th/labs/wp-content/uploads/2016/01/unity-c-php-mysql-connect-7.png" data-full-size="474x411" /></a></p>
<p>10. à¹à¸à¸´à¸à¹à¸à¸¥à¹ AppController.cs à¸à¸¶à¹à¸à¸¡à¸²à¸à¸£à¸±à¸ à¹à¸¥à¹à¸§à¹à¸à¸µà¸¢à¸à¹à¸à¹à¸ à¹à¸à¸´à¹à¸¡à¸à¸¶à¹à¸à¸¡à¸²à¸à¸£à¸°à¸¡à¸²à¸à¸à¸µà¹à¸à¸£à¸±à¸</p>
<pre class="lang:c# decode:true " >private JsonData userData; 
 
	void Start () { 
		btnSubmit.onClick.AddListener (delegate { 
			Debug.Log("click !"); 
			StartCoroutine(submitMyName()); 
		}); 
	} 
 
	IEnumerator submitMyName () { 
		if (txtName.text.Length <;= 0) { 
			Debug.Log ("please enter name"); 
			return false; 
		} 
		Debug.Log("submit !"); 
		WWWForm form = new WWWForm(); 
		form.AddField("name",txtName.text); 
 
		WWW www = new WWW("http://localhost:8888/saveload.php", form); 
		yield return www; 
 
		userData = JsonMapper.ToObject(www.text); 
 
		int maxUser = userData.Count; 
		for(int i=0;i<;maxUser;i++) 
		{ 
			Debug.Log(userData[i]["name"]); 
		} 
		StopCoroutine (submitMyName()); 
	}</pre>
<p>11. ลà¸à¸à¸à¸à¸à¸¸à¹à¸¡ play à¸à¸à¸ªà¸à¸à¸à¸¹à¸à¸£à¸±à¸ à¸à¸°à¹à¸«à¹à¸à¸à¹à¸à¸¡à¸¹à¸¥à¸à¸µà¹à¹à¸£à¸²à¸à¸£à¸à¸à¹à¸à¸à¸¸à¸ ๠à¸à¸£à¸±à¹à¸ à¸à¸¹à¸à¸à¸±à¸à¸à¸¶à¸à¹à¸¥à¸°à¸£à¸µà¹à¸à¸´à¸à¸à¹à¸²à¸à¸¥à¸±à¸à¸¡à¸²à¸à¸µà¹à¸«à¸à¹à¸²à¸à¹à¸²à¸ Console à¸à¸µà¹à¹à¸«à¸¥à¸·à¸à¸à¹à¸ªà¸¸à¸à¹à¸¥à¹à¸§à¹à¸à¹à¸à¸°à¹à¸à¸²à¸à¹à¸à¸¡à¸¹à¸¥à¹à¸à¸à¸³à¸à¸°à¹à¸£à¸à¸£à¸±à¸<br />
<a href="http://codebee.co.th/labs/wp-content/uploads/2016/01/unity-c-php-mysql-connect-8.png" rel="attachment wp-att-262"><img src="http://codebee.co.th/labs/wp-content/uploads/2016/01/unity-c-php-mysql-connect-8.png" alt="unity-c#-php-mysql-connect-8" width="198" height="263" class="alignnone size-full wp-image-262" data-full="https://codebee.co.th/labs/wp-content/uploads/2016/01/unity-c-php-mysql-connect-8.png" data-full-size="198x263" /></a></p>

Unity C# โหลดและแสดง JSON Data ติดฐานข้อมูล PHP & MySQL
