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;
}
