質問編集履歴

コードの誤りの部分の修正

2016/11/28 02:33

投稿

north

スコア8

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -244,13 +244,57 @@
     }
+}
+```
+```ここに言語を入力
+php
+$name = $_REQUEST['name'];
+$score = $_REQUEST['score'];
+$screen = $_REQUEST['screen'];
+print($screen);
+$sql = "INSERT INTO Score(name, score, screen) VALUES('$name', '$score', 'screen')";
+$result_flag = mysql_query($sql);
-    /*IEnumerator GetScore()
+//クエリ文の実行
+if(!$result_flag)
-    {
+{
+	die('INSERTクエリーが失敗しました。'.mysql_error());
+}
+```
+```ここに言語を入力
+受信部分
+ IEnumerator GetScore()
+    {
-        WWW result = new WWW(m_url2);
+        WWW result = new WWW(url);
         yield return result;
@@ -260,7 +304,7 @@
         {
-            JSONObject rdbUserGet = new JSONObject(result.text);
+            rdbUserGet = new JSONObject(result.text);
             for (int ii = 0; ii < rdbUserGet.Count; ii++)
@@ -272,11 +316,49 @@
                 JSONObject jsonScore = jsonPos.GetField("score");
-                string name = jsonName.str;
+                PlayerName = jsonName.str;
-                string score = jsonScore.str;
+                Score = jsonScore.str;
+                if (PlayerName == "" || Score == "")
+                    continue;
+                top = new GameObject("name_" + ii);
+                score = new GameObject("score_" + ii);
+                GUIText Text = top.AddComponent<GUIText>();
+                GUIText Text2 = score.AddComponent<GUIText>();
+                Text.fontSize = 20;
+                Text2.fontSize = 20;
+                Text.text = Rank + ":" + PlayerName;
+                Text2.text = Score;
+                top.transform.position = new Vector3(0.1f, 0.6f + move, 0);
+                score.transform.position = new Vector3(0.5f, 0.6f + move, 0);
+                a = top.GetComponent<GUIText>().color;
+                a.a = 0.0f;
+                top.GetComponent<GUIText>().color = a;
+                score.GetComponent<GUIText>().color = a;
+                move -= 0.05f;
+                Rank += 1;
-                Debug.Log("名前:" + name + "スコア:" + score);
+                Debug.Log("名前:" + PlayerName + "スコア:" + Score);
             }
@@ -292,236 +374,82 @@
         }
+    }
-    }*/
+```
+```
+php
+$query = "SELECT name, score FROM Score Order by score desc";
-    /*public byte[] readingPngFiles(string path)
+if($result = mysql_query($query))
-    {
+{
+	$user = array();
+	// 結果をオブジェク形式で出力.
-        using (FileStream fileStream = new FileStream(path, FileMode.Open, FileAccess.Read))
+	while($row = mysql_fetch_assoc($result))
-        {
+	{
-            BinaryReader bin = new BinaryReader(fileStream);
+		//print($row['name']);
-            byte[] values = bin.ReadBytes((int)bin.BaseStream.Length);
+		//print($row['score']);
-            bin.Close();
+		//$user[] = array('name'=> $row->name, 'score'=> $row->score);
-            return values;
+		$user[] = $row;
+		//var_dump($user);
-        }
+	}
+	// 出力結果が空の時は、nullを出し、JSON形式で変換.
+	if(empty($user))
+	{
+		$user = null;
+		echo json_encode( $user );
+	}
+	else
+	{
+		echo json_encode( $user );
+	}
-    }*/
+	// 結果を解放
+	//$result->close();
 }
 ```
-```ここに言語を入力
-php
-$name = $_REQUEST['name'];
-$score = $_REQUEST['score'];
-$screen = $_REQUEST['screen'];
-print($screen);
-$sql = "INSERT INTO Score(name, score, screen) VALUES('$name', '$score', 'screen')";
-$result_flag = mysql_query($sql);
-//クエリ文の実行
-if(!$result_flag)
-{
-	die('INSERTクエリーが失敗しました。'.mysql_error());
-}
-```
-```ここに言語を入力
-受信部分
- IEnumerator GetScore()
-    {
-        WWW result = new WWW(url);
-        yield return result;
-        if (result.error == null)
-        {
-            rdbUserGet = new JSONObject(result.text);
-            for (int ii = 0; ii < rdbUserGet.Count; ii++)
-            {
-                JSONObject jsonPos = rdbUserGet[ii];
-                JSONObject jsonName = jsonPos.GetField("name");
-                JSONObject jsonScore = jsonPos.GetField("score");
-                PlayerName = jsonName.str;
-                Score = jsonScore.str;
-                if (PlayerName == "" || Score == "")
-                    continue;
-                top = new GameObject("name_" + ii);
-                score = new GameObject("score_" + ii);
-                GUIText Text = top.AddComponent<GUIText>();
-                GUIText Text2 = score.AddComponent<GUIText>();
-                Text.fontSize = 20;
-                Text2.fontSize = 20;
-                Text.text = Rank + ":" + PlayerName;
-                Text2.text = Score;
-                top.transform.position = new Vector3(0.1f, 0.6f + move, 0);
-                score.transform.position = new Vector3(0.5f, 0.6f + move, 0);
-                a = top.GetComponent<GUIText>().color;
-                a.a = 0.0f;
-                top.GetComponent<GUIText>().color = a;
-                score.GetComponent<GUIText>().color = a;
-                move -= 0.05f;
-                Rank += 1;
-                Debug.Log("名前:" + PlayerName + "スコア:" + Score);
-            }
-        }
-        else
-        {
-            string error = result.error;
-            Debug.LogError("www Error:" + result.error);
-        }
-    }
-```
-```
-php
-$query = "SELECT name, score FROM Score Order by score desc";
-if($result = mysql_query($query))
-{
-	$user = array();
-	// 結果をオブジェク形式で出力.
-	while($row = mysql_fetch_assoc($result))
-	{
-		//print($row['name']);
-		//print($row['score']);
-		//$user[] = array('name'=> $row->name, 'score'=> $row->score);
-		$user[] = $row;
-		//var_dump($user);
-	}
-	// 出力結果が空の時は、nullを出し、JSON形式で変換.
-	if(empty($user))
-	{
-		$user = null;
-		echo json_encode( $user );
-	}
-	else
-	{
-		echo json_encode( $user );
-	}
-	// 結果を解放
-	//$result->close();
-}
-```
 ###補足情報(言語/FW/ツール等のバージョンなど)