doulin6761 2016-06-04 07:05
浏览 60

Coroutines或Php脚本不适用于移动设备

Hi this is my first query using stack overflow so lets get to it. i am making an android game that uses database that is on a server of a site i am using phpmyadmin to manage mysql and here is how i retrieve data

public class Dataretrieve : MonoBehaviour {
WWW sitedata;
public string[] users;
public static string[] Usernames;
public static string[] Emails;
public static string[] Passwords;
public static string[] Icons;
// Use this for initialization
public  void Start(){
    StartCoroutine_Auto(StartGettingData);
}

public IEnumerator StartGettingData () {
    Debug.Log ("Starting to get values");
    sitedata = new WWW ("mysite/database.php");
    yield return sitedata;

    string sitedatatext = sitedata.text;
    users = sitedatatext.Split (';');

    Usernames=new string[users.Length-1];
    Emails=new string[users.Length-1];
    Passwords=new string[users.Length-1];
    Icons=new string[users.Length-1];

    for (int i=0; i<users.Length-1; i++) 
    {
        Usernames[i]=GetData(users[i],"Username:");
        Emails[i]=GetData(users[i],"Email:");
        Passwords[i]=GetData(users[i],"Password:");
        Icons[i]=GetData(users[i],"Icon:");
    }
    Debug.Log ("All Data Retrieved");
    StopCoroutine ("StartGettingData");
}
    string GetData(string data,string index)
{
    string value = data.Substring (data.IndexOf (index) + index.Length);
    if (value.Contains ("|"))
        value = value.Remove (value.IndexOf ("|"));
    return value;
}

public void values()
{
    Debug.Log ("Start getting values again");
    StartCoroutine_Auto(StartGettingData());
    StopCoroutine ("StartGettingData");
    Debug.Log ("Values Updated again");
}

}

The problem is it works fine on unity editor but when i run it on built it doesn't get users data

here's php code

$conn=new mysqli($servername,$username,$password,$dbName);
if(!$conn)
{
    die("Connection Failled".mysqli_connect_error() );
}

$sql="SELECT ID, Email, Password, Username, Icon FROM  Login_Variables";
$result = mysqli_query($conn ,$sql);


if(mysqli_num_rows($result) > 0)
    while(  $row =mysqli_fetch_assoc($result))
    {
        echo("ID:".$row['ID']."|Email:".$row['Email']."|Password:".$row['Password']."|Username:".$row['Username']."|Icon:".$row['Icon'].";");
    }

</div>
  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥20 求一个html代码,有偿
    • ¥100 关于使用MATLAB中copularnd函数的问题
    • ¥20 在虚拟机的pycharm上
    • ¥15 jupyterthemes 设置完毕后没有效果
    • ¥15 matlab图像高斯低通滤波
    • ¥15 针对曲面部件的制孔路径规划,大家有什么思路吗
    • ¥15 钢筋实图交点识别,机器视觉代码
    • ¥15 如何在Linux系统中,但是在window系统上idea里面可以正常运行?(相关搜索:jar包)
    • ¥50 400g qsfp 光模块iphy方案
    • ¥15 两块ADC0804用proteus仿真时,出现异常