koobas.hobune.stream
WWW class doesn't work well.
I have a MySQL database and I want to insert a data into it by using php. Here are my php codes:
<?php
$db = mysql_connect('host', 'user', 'pass') or die('Could not connect: ' . mysql_error());
mysql_select_db('dbname') or die('Could not select database');
$ThreeNumber = $_GET["tn"];
$Number = $_GET["n"];
$Counter = $_GET["c"];
$UserId = $_GET["u"];
$hash = $_GET['hash'];
$secretKey="mySecretKey";
$real_hash = md5( $ThreeNumber . $Number . $Counter . $UserId . $secretKey);
if($real_hash == $hash) {
$query ="INSERT INTO chapter (threeNum, num , count,user) VALUES ('$ThreeNumber','$Number','$Counter','$UserId')";
$result = mysql_query($query) or die('Query failed: ' . mysql_error());
}
else
{
die('HASH ERROR');
}
?>
Here are my C# codes:
public void startPostScores()
{
StartCoroutine(SendScore(_three, _num, _count, _user));
}
IEnumerator SendScore(int three, int num, int count, string user)
{
string hash = Md5Sum(three.ToString() + num.ToString() + count.ToString() + user + secretKey);
string post_url = "http://mywebsite.com/postScore.php?" + "tn=" + three +
"&n=" + num +
"&c=" + count +
"&u=" + WWW.EscapeURL(user) +
"&hash=" + hash;
Debug.Log(post_url);
WWW www = new WWW(post_url);
yield return www;
if (!string.IsNullOrEmpty(www.error))
{
Debug.Log("There was an error posting to the SQL: " + www.error);
}
}
When my post_url is localhost , it works, the data is inserted, but when it is another domain name, it doesn't work. In addition, when I paste the full URL into a browser it works, too.
Best Answer
SOLVED!!
My code was like that:
public void startPostScores()
{
StartCoroutine(SendScore(_three, _num, _count, _user));
SceneManager.LoadScene(0);
}
The problem is this line:
SceneManager.LoadScene(0);
When I Send a request by WWW, the scene changes immidiately so time doesn't enough for request. I removed the line and it works.
Thanks.
