JSON Array from server to Unity C#
Hello!
I have a simple PHP script that is getting data from MySQL, making a two dimensional array from them and then encoding it to JSON.
$resultArray = array();
while($row = mysqli_fetch_array($result)){
$resultArray[] = array("id"=>$row['id'], "name"=>$row['name'], "description"=>$row['description'], "points"=>$row['points'], );
}
$resultJSON = json_encode($resultArray);
JSON looks like this:
[
{
"id":"9",
"name":"name",
"description":"",
"points":"12"
},
{
"id":"10",
"name":"Namename",
"description":"Description",
"points":"21"
},
{
"id":"12",
"name":"Namenamename",
"description":"p",
"points":"54"
}
]
Now I want to download the JSON string to Unity and convert it to two-dimensional array. This is my code so far:
IEnumerator getArray() {
string query = wwwURL;
WWW array_get = new WWW(query);
yield return array_get;
if(array_get.text != null){
JSON = array_get.text;
}
}
How to do it? Any example?
I was looking on the web, but I didn't understand anything. Is any Unity JSON parser supporting there arrays?
Answer by Danish-gaur · Jul 23, 2016 at 09:41 AM
Hello, Use WWW class to get data from server using web service. Make co routine : Ex:
void Start ()
{
string url = "http://example.com/script.php?var1=value2&var2=value2";
WWW www = new WWW(url);
StartCoroutine(WaitForRequest(www));
}
IEnumerator WaitForRequest(WWW www)
{
yield return www;
// check for errors
if (www.error == null)
{
Debug.Log("WWW Ok!: " + www.data);
} else {
Debug.Log("WWW Error: "+ www.error);
}
}
Yeah, I did it already. But how to convert that data to an array?
It will return you a string. Using String Pladding u can Convert that data into array. Say suppose the array elements are separated by "/" (slash) the you can break that string where you find the slash and store it into the array or list. Use String.Split(); method to split it and this will return you the array of string.
Your answer
Follow this Question
Related Questions
How to call php in unity c#? 0 Answers
GetComponent.sprite is not valide. please help 1 Answer
Decoding JSON string 0 Answers
How to read array json file? 0 Answers
My downloadHander.Text isnt working 0 Answers