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条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 求差集那个函数有问题,有无佬可以解决
    • ¥15 【提问】基于Invest的水源涵养
    • ¥20 微信网友居然可以通过vx号找到我绑的手机号
    • ¥15 寻一个支付宝扫码远程授权登录的软件助手app
    • ¥15 解riccati方程组
    • ¥15 display:none;样式在嵌套结构中的已设置了display样式的元素上不起作用?
    • ¥15 使用rabbitMQ 消息队列作为url源进行多线程爬取时,总有几个url没有处理的问题。
    • ¥15 Ubuntu在安装序列比对软件STAR时出现报错如何解决
    • ¥50 树莓派安卓APK系统签名
    • ¥65 汇编语言除法溢出问题