function get_allDevice_data() { $j = 0; $datas = array(); $sql = "select * from device "; $res = mysql_query($sql); while ($row = mysql_fetch_assoc($res)) { $temp_arr = explode("_", $row["表名"]); $datas[$j]['device_name'] = $temp_arr[1]; $delimiters = array(',', ','); $field_arr = multipleExplode($delimiters, $row['字段名']); $field_arr = array_unique($field_arr); $field_arr[] = "时间"; $field_arr[] = "坐标X"; $field_arr[] = "坐标Y"; foreach ($field_arr as $r) { $sql1 = "select `{$r}`" . " from " . $row["表名"] . " order by 时间 desc limit 5"; // echo($sql1); $res1 = mysql_query($sql1); while ($dev = mysql_fetch_array($res1)) { $datas[$j][$r][] = $dev[$r]; } } $j++; } mysql_free_result($res); return $datas; }
function readIdentifiers($str) { $returnMe = array(); if (count(isset($str))) { @($ev = evaluateSeparators($str)); if ($ev["SEMICOLON"] == 0 && $ev["COMMA"] == 0 && $ev["ALL"] == 0 && $ev["COLON"] == 0) { if (isset($str) && $str != "") { @($returnMe[] = $str); } } else { if ($ev["SEMICOLON"] == 1 && $ev["COMMA"] == 0 && $ev["ALL"] == 0 && $ev["COLON"] == 0) { if ($pos = strpos($str, ";")) { $dirty = substr($str, 0, $pos); $returnMe[] = $dirty; } } else { if ($ev["SEMICOLON"] == 0 && $ev["COMMA"] > 0 && $ev["COLON"] == 0) { $returnMe = explode(",", $str); } else { if ($ev["SEMICOLON"] == 1 && $ev["COMMA"] == 0 && $ev["COLON"] == 1) { if ($pos = strpos($str, ";")) { $dirty = substr($str, 0, $pos); $a = explode(":", $dirty); $returnMe[] = $a[1]; } } else { if ($ev["SEMICOLON"] > 1 && $ev["COMMA"] == 0 && $ev["ALL"] > 1 && $ev["COLON"] == 0) { $tmp = explode(";", $str); //remove any empty elements $tmp = removeEmptyElements($tmp); //remove things before the : foreach ($tmp as $x) { $a = explode(":", $x); if (count($a) == 2) { $returnMe[] = $a[1]; } else { $returnMe[] = $x; } } } else { if ($ev["SEMICOLON"] > 1 && $ev["COMMA"] == 0 && $ev["ALL"] > 1 && $ev["COLON"] > 1) { $tmp = explode(";", $str); //remove any empty elements $tmp = removeEmptyElements($tmp); //remove things before the : foreach ($tmp as $x) { $a = explode(":", $x); if (count($a) == 2) { $returnMe[] = $a[1]; } else { $returnMe[] = $x; } } } else { if ($ev["SEMICOLON"] > 1 && $ev["COMMA"] > 1 && $ev["BOTH"] > 1 && $ev["COLON"] > 1) { //use multiple explode $delims = array(",", ";"); $tmp = multipleExplode($delims, $str); //remove any empty elements $tmp = removeEmptyElements($tmp); $tmp2 = array(); foreach ($tmp as $x) { $a = explode(":", $x); if (count($a) == 2) { $tmp2[] = $a[1]; } else { $tmp2[] = $x; } } $returnMe = array_merge($returnMe, $tmp2); } } } } } } } } return $returnMe; }