質問編集履歴

コードの修正

2019/01/11 05:55

投稿

zenobread

スコア44

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -62,6 +62,8 @@
 localhostは実機では正しいアドレスを記入しています
+```c#
 using System.Collections;
 using System.Collections.Generic;
@@ -232,10 +234,14 @@
+```
 Unityからデータを受け取るphp
+```php
 <?php
  require "API_prd_cp.php";
@@ -272,12 +278,16 @@
  ?>
+```
 phpからphpにデータを受け取りデータを返すphp
 hostやパスにはphpmyadminにログインした時のものを使っております
+```php
 function main($name,$name2,$hol){
       try{
@@ -541,3 +551,5 @@
         }
       }
+```

該当コードの記載

2019/01/11 05:55

投稿

zenobread

スコア44

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -47,3 +47,497 @@
 全く間違いと思われる部分に心当たりがないため開示すべき情報についてもどうかご教授お願いします。
+追記1
+以下に該当の見ていただきたいコードを載せます。
+ただパスワードなどは＊で隠しております。ご了承ください。
+送受信する側のUNITYC#ファイル
+localhostは実機では正しいアドレスを記入しています
+using System.Collections;
+using System.Collections.Generic;
+using UnityEngine;
+using UnityEngine.UI;
+using UnityEngine.Networking;
+public class PHPTEST : MonoBehaviour
+{
+    public Text ResultText_;
+    public GameObject Drop_1;
+    public GameObject Drop_2;
+    Dropdown_1 drop;
+    Dropdown_2 drop2;
+    private string time;
+    public int callory_time;
+    private string ServerAddress = "http://localhost/php/API_req.php";
+    // Use this for initialization
+    void Start()
+    {
+        drop = Drop_1.GetComponent<Dropdown_1>();
+        drop2 = Drop_2.GetComponent<Dropdown_2>();
+    }
+    public void SendSignal_Button_Push()
+    {
+        if(drop.rel==null||drop2.rel2==null){
+          Debug.Log("値が入力されていません");
+            ResultText_.GetComponent<Text>().text = "値が入力されていません";
+          return;
+        }
+        StartCoroutine("Access");
+        Debug.Log(drop.rel);
+        Debug.Log(drop2.rel2);
+    }
+    private IEnumerator Access()
+    {
+        Dictionary<string, string> dic = new Dictionary<string, string>
+        {
+            { "id_1", drop.rel},
+            { "id_2", drop2.rel2 }
+        };
+        Debug.Log(dic["id_1"]);
+        Debug.Log(dic["id_2"]);
+        StartCoroutine(Post(ServerAddress, dic));
+        yield return 0;
+    }
+    private IEnumerator Post(string url, Dictionary<string, string> post)
+    {
+        WWWForm form = new WWWForm();
+        foreach (KeyValuePair<string, string> post_arg in post)
+        {
+            form.AddField(post_arg.Key, post_arg.Value);
+        }
+        UnityWebRequest www = UnityWebRequest.Post(ServerAddress,form);
+        www.timeout = 30;
+        yield return www.SendWebRequest();
+        if (www.error != null)
+        {
+            ResultText_.GetComponent<Text>().text = www.error;
+            Debug.Log("HttpPost NG:" + www.error);
+        }
+        else if (www.isDone)
+        {
+            Debug.Log(www.downloadHandler.text);
+            time = www.downloadHandler.text;
+            ResultText_.GetComponent<Text>().text =time;
+            callory_time = int.Parse(time);
+            www=null;
+        }
+    }
+    // Update is called once per frame
+    void Update()
+    {
+    }
+}
+Unityからデータを受け取るphp
+<?php
+ require "API_prd_cp.php";
+$url="http://s-proj.com/utils/checkHoliday.php?kind=h";
+$holiday_check=file_get_contents($url);
+$id_1=$_POST["id_1"];
+$id_2=$_POST["id_2"];
+$res=$id_1.$id_2;
+ if($holiday_check=="holiday"){
+   $holiday=1;
+   $res=main($id_1,$id_2,$holiday);
+ }else if($holiday_check=="else"){
+   $holiday=0;
+   $res=main($id_1,$id_2,$holiday);
+ }
+echo $res;
+ ?>
+phpからphpにデータを受け取りデータを返すphp
+hostやパスにはphpmyadminにログインした時のものを使っております
+function main($name,$name2,$hol){
+      try{
+        $db=new PDO('mysql:dbname=＊;host=＊;charset=utf8','＊','＊');
+        if($hol==1){
+          $result_from=$db->prepare("SELECT * FROM API_about WHERE TIME(station_time)>=NOW() AND station_name LIKE '%$name%' AND day_sp LIKE '%SaturdayHoliday%' AND looping LIKE '%Inner%' ORDER BY TIME(station_time) LIMIT 1");
+          $result_from2=$db->prepare("SELECT * FROM API_about WHERE TIME(station_time)>=NOW() AND station_name LIKE'%$name%' AND day_sp LIKE '%SaturdayHoliday%' AND looping LIKE '%Inner%' ORDER BY TIME(station_time) LIMIT 1");
+          $result_from->execute();
+          $result_from2->execute();
+          $result_from->setFetchMode(PDO::FETCH_ASSOC);
+          $result_from2->setFetchMode(PDO::FETCH_ASSOC);
+          $row_from=$result_from->fetch();
+          $row_from2=$result_from2->fetch();
+          $num=(string)$row_from['station_number'];
+          $num2=(string)$row_from2['station_number'];
+          $day=$row_from['day_sp'];
+          $day2=$row_from2['day_sp'];
+          $result_to=$db->prepare("SELECT*FROM API_about WHERE station_name LIKE '%$name2%' AND station_number='$num'  LIMIT 1 ");
+          $result_to2=$db->prepare("SELECT*FROM API_about WHERE station_name LIKE '%$name2%' AND station_number='$num2'  LIMIT 1 ");
+          $result_to->execute();
+          $result_to2->execute();
+  $result_to->setFetchMode(PDO::FETCH_ASSOC);
+          $result_to2->setFetchMode(PDO::FETCH_ASSOC);
+          $row_to=$result_to->fetch();
+          $row_to2=$result_to2->fetch();
+          $time_from=strtotime($row_from['station_time']);
+          $time_from2=strtotime($row_from2['station_time']);
+          $time_to=strtotime($row_to['station_time']);
+          $time_to2=strtotime($row_to2['station_time']);
+          if($time_from>$time_to){
+            $time_cal_result=$time_from-$time_to;
+          }else{
+            $time_cal_result=$time_to-$time_from;
+          }
+          if($time_from2>$time_to2){
+            $time_cal_result2=$time_from2-$time_to2;
+          }else{
+            $time_cal_result2=$time_to2-$time_from2;
+          }
+          if($time_cal_result==null||$time_cal_result2==null)echo "MISS4";
+          if($time_cal_result>$time_cal_result2)
+          {
+            echo date("i",$time_cal_result2);
+          }else{
+            echo date("i",$time_cal_result);
+          }
+          //echo date("i",$time_cal_result)."Inner";
+          //echo date("i",$time_cal_result2)."Outer";
+        }else if($hol==0){
+        $result_from=$db->prepare("SELECT * FROM API_about WHERE TIME(station_time)>=NOW() AND station_name LIKE '%$name%' AND day_sp LIKE '%SaturdayHoliday%' AND looping LIKE '%Inner%'  ORDER BY TIME(station_time) LIMIT 1");
+        $result_from2=$db->prepare("SELECT * FROM API_about WHERE TIME(station_time)>=NOW() AND station_name LIKE'%$name%' AND day_sp LIKE '%SaturdayHoliday%' AND looping LIKE '%Outer%'  ORDER BY TIME(station_time) LIMIT 1");
+        $result_from->execute();
+        $result_from2->execute();
+        $result_from->setFetchMode(PDO::FETCH_ASSOC);
+        $result_from2->setFetchMode(PDO::FETCH_ASSOC);
+        $row_from=$result_from->fetch();
+        $row_from2=$result_from2->fetch();
+        $num=(string)$row_from['station_number'];
+        $num2=(string)$row_from2['station_number'];
+        $day=$row_from['day_sp'];
+        $day2=$row_from2['day_sp'];
+        $result_to=$db->prepare("SELECT*FROM API_about WHERE station_name LIKE '%$name2%' AND station_number='$num' AND day_sp LIKE '%SaturdayHoliday%' AND looping LIKE '%Inner%' LIMIT 1 ");
+        $result_to2=$db->prepare("SELECT*FROM API_about WHERE station_name LIKE '%$name2%' AND station_number='$num2' AND day_sp LIKE '%SaturdayHoliday%' AND looping LIKE '%Outer%'  LIMIT 1 ");
+        $result_to->execute();
+        $result_to2->execute();
+        $result_to->setFetchMode(PDO::FETCH_ASSOC);
+        $result_to2->setFetchMode(PDO::FETCH_ASSOC);
+        $row_to=$result_to->fetch();
+        $row_to2=$result_to2->fetch();
+        /*echo $row_from['station_time'];
+        echo "<br/>";
+        echo $row_from2['station_time'];
+        echo "<br/>";
+        echo $row_to['station_time'];
+        echo "<br/>";
+        echo $row_to2['station_time'];
+        echo "<br/>";*/
+        $time_from=strtotime($row_from['station_time']);
+        $time_from2=strtotime($row_from2['station_time']);
+        $time_to=strtotime($row_to['station_time']);
+        $time_to2=strtotime($row_to2['station_time']);
+        /*echo $time_from;
+        echo "<br/>";
+        echo $time_from;
+        echo "<br/>";
+        echo $time_to;
+        echo "<br/>";
+        echo $time_to2;
+        echo "<br/>";*/
+        if($time_from>$time_to){
+          $time_cal_result=$time_from-$time_to;
+        }else{
+          $time_cal_result=$time_to-$time_from;
+        }
+        if($time_from2>$time_to2){
+          $time_cal_result2=$time_from2-$time_to2;
+        }else{
+          $time_cal_result2=$time_to2-$time_from2;
+        }
+        if($time_cal_result==null||$time_cal_result2==null)echo "MISS4";
+        if($time_cal_result>$time_cal_result2)
+        {
+          echo date("i",$time_cal_result2);
+        }else{
+          echo date("i",$time_cal_result);
+        }
+        /*echo date("i",$time_cal_result)."Inner";
+        echo date("i",$time_cal_result2)."Outer";*/
+      }
+        /*if($time_cal_result>$time_cal_result2){
+          echo date("H:i",$time_cal_result2)."Inner".$row_to2['station_number'];
+        }else{
+          echo date("H:i",$time_cal_result)."Outer";
+        }*/
+        $db=null;
+        }catch(PDOException $e){
+          echo 'DB接続エラー:'.$e->getMessage();
+        }
+      }