global $tableName_ws_connect; global $pdo; $tName_ws = "workingState" . $num; $ws_sum = 0; $sql = "SELECT * FROM " . $tName_ws . " ORDER BY id DESC LIMIT 0,5"; $stmt = $pdo->prepare($sql); $stmt->execute(); foreach ($stmt as $row) { $ws_sum += $row['ws']; } return $ws_sum; } $ws_sum_user1 = floor(getWorkingState(1) / 5); $ws_sum_user2 = floor(getWorkingState(2) / 5); $ws_sum_user3 = floor(getWorkingState(3) / 5); $ws_sum_user4 = floor(getWorkingState(4) / 5); //Arduino1に相手の作業度を渡す $jsonArr = array("user_1" => $ws_sum_user1, "user_2" => $ws_sum_user2, "user_3" => $ws_sum_user3, "user_4" => $ws_sum_user4); echo json_encode($jsonArr); /*--------------------------------データベースとの接続を切る--------------------------------*/ $pdo = null; /*------------------------------以下はcalcWorkingState()のためのメソッド------------------------------*/ //先ほど格納した最新のセンサデータその時のrandIDを取得する function getNewData() { global $pdo; global $tableName; $stmt = $pdo->prepare("SELECT * FROM " . $tableName . " ORDER BY id DESC LIMIT 1"); $hoge = $stmt->execute(); foreach ($stmt as $row) { $arr = array($row['sensorData1'], $row['sensorData2'], $row['sensorData3'], $row['sensorData4'], $row['sensorData5'], $row['sensorData6'], $row['randID']);
{ $ws_sum = 0; if ($num == 1) { $sql = sprintf("SELECT * FROM workingState1 ORDER BY id DESC LIMIT 0,10"); } else { /*-------つながる相手によってテーブル名を変える必要あり------*/ $sql = sprintf("SELECT * FROM workingState2 ORDER BY id DESC LIMIT 0,10"); } $result = mysql_query($sql); while ($row = mysql_fetch_assoc($result)) { $ws_sum += $row['ws']; } return $ws_sum; } $ws_sum_self = getWorkingState(1); $ws_sum_partner = getWorkingState(2); //Arduino1に相手の作業度を渡す echo '^'; echo $ws_sum_self, ','; //自分の作業度 echo $ws_sum_partner, ','; //相手の作業度 /*--------------------------------データベースとの接続を切る--------------------------------*/ mysql_close($link); /*------------------------------以下はcalcWorkingState()のためのメソッド------------------------------*/ //先ほど格納した最新のセンサデータその時のrandIDを取得する function getNewData() { $sql = sprintf("SELECT * FROM ArduinoInfo1_6sensors ORDER BY id DESC LIMIT 1"); $result = mysql_query($sql); $row = mysql_fetch_assoc($result);