unity www php,使用C#调用php脚本(Unity)

我对Unity和PHP都还不是很陌生,并且我目前正在一个项目中,可以使用PHP将数据从MySQL数据库解析到Unity.

最初,我想尝试启用一种方法,使用户可以更改php脚本并使其选择不同的数据表,但是我被告知最好列出php脚本中的所有变量并从中调用它可能更安全.相应地团结；

Display.php的

$table = mysql_real_escape_string($_GET['table'], $db);

if ($table == "shoes") {

$query = "SELECT * FROM `shoes` ORDER by `price` ASC LIMIT 10";

elseif ($table == "sneakers") {

$query = "SELECT * FROM `sneakers` ORDER by `price` ASC LIMIT 10";

$result = mysql_query($query) or die('Query failed: ' . mysql_error());

$num_results = mysql_num_rows($result);

for($i = 0; $i < $num_results; $i++)

{

$row = mysql_fetch_array($result);

echo $row['shopname'] . "" . $row['price'] . "

";

}

我在调用php并选择要选择的表时遇到了麻烦,对此我还很陌生,因此,如果这对您来说似乎完全不合适,我深表歉意.

这是我的Unity脚本；

HSController.cs

void Start()

{

StartCoroutine(GetScores());

}

// remember to use StartCoroutine when calling this function!

IEnumerator PostScores(string name, int score)

{

string hash = Md5Sum(name + score + secretKey);

string post_url = addScoreURL + "name=" + WWW.EscapeURL(name) + "&score=" + score + "&hash=" + hash;

WWW hs_post = new WWW(post_url);

yield return hs_post; // Wait until the download is done

if (hs_post.error != null)

{

print("There was an error posting the high score: " + hs_post.error);

}

}

IEnumerator GetScores()

{

gameObject.guiText.text = "Loading...";

WWW hs_get = new WWW(highscoreURL);

yield return hs_get;

if (hs_get.error != null)

{

print("There was an error getting the high score: " + hs_get.error);

}

else

{

gameObject.guiText.text = hs_get.text; // this is a GUIText that will display the scores in game.

}

}

任何帮助或朝着正确方向发展的观点都将非常棒！

亲切的问候