while (isset($_GET["s{$i}"])) {
${'v' . $i} = mysql_real_escape_string($_GET["s{$i}"]);
// ${'v' . $i . '_label'} = '"'.$jsarr[${'v' . $i}].'"';
// ${'v' . $i . '_label'} = '"'.$keyarr[${'v' . $i}][0]." (".$keyarr[${'v' . $i}][1].")".'"';
$selectstring = $selectstring . ",{${'v' . $i}}";
$i = $i + 1;
}
// Get data for session
$sessionqry = mysql_query("SELECT {$selectstring} FROM {$db_table} WHERE session={$session_id} ORDER BY time DESC;") or die(mysql_error());
while ($row = mysql_fetch_assoc($sessionqry)) {
$i = 1;
while (isset(${'v' . $i})) {
if (substri_count($keyarr[${'v' . $i}][0], "Speed") > 0) {
$x = intval($row[${'v' . $i}]) * $speed_factor;
${'v' . $i . '_measurand'} = $speed_measurand;
} elseif (substri_count($keyarr[${'v' . $i}][0], "Temp") > 0) {
$x = $temp_func(floatval($row[${'v' . $i}]));
${'v' . $i . '_measurand'} = $temp_measurand;
} else {
$x = intval($row[${'v' . $i}]);
${'v' . $i . '_measurand'} = ' (' . $keyarr[${'v' . $i}][1] . ')';
}
${'d' . $i}[] = array($row['time'], $x);
${'spark' . $i}[] = $x;
$i = $i + 1;
}
}
$i = 1;
while (isset(${'v' . $i})) {
${'v' . $i . '_label'} = '"' . $keyarr[${'v' . $i}][0] . ${'v' . $i . '_measurand'} . '"';
${'sparkdata' . $i} = implode(",", array_reverse(${'spark' . $i}));
// TODO: Use the userDefault fields to do these conversions dynamically
while ($row = mysql_fetch_assoc($sessionqry)) {
// data column #1
if (substri_count($jsarr[$v1], "Speed") > 0) {
$x = intval($row[$v1]) * 0.621371;
} elseif (substri_count($jsarr[$v1], "Temp") > 0) {
$x = floatval($row[$v1]) * 9 / 5 + 32;
} else {
$x = intval($row[$v1]);
}
$d1[] = array($row['time'], $x);
$spark1[] = $x;
// data column #2
if (substri_count($jsarr[$v2], "Speed") > 0) {
$x = intval($row[$v2]) * 0.621371;
} elseif (substri_count($jsarr[$v2], "Temp") > 0) {
$x = floatval($row[$v2]) * 9 / 5 + 32;
} else {
$x = intval($row[$v2]);
}
$d2[] = array($row['time'], $x);
$spark2[] = $x;
}
$sparkdata1 = implode(",", array_reverse($spark1));
$sparkdata2 = implode(",", array_reverse($spark2));
$max1 = round(max($spark1), 1);
$max2 = round(max($spark2), 1);
$min1 = round(min($spark1), 1);
$min2 = round(min($spark2), 1);
$avg1 = round(average($spark1), 1);
$avg2 = round(average($spark2), 1);
while (isset($_GET["s{$i}"])) {
${'v' . $i} = $mysqli->real_escape_string($_GET["s{$i}"]);
// ${'v' . $i . '_label'} = '"'.$jsarr[${'v' . $i}].'"';
// ${'v' . $i . '_label'} = '"'.$keyarr[${'v' . $i}][0]." (".$keyarr[${'v' . $i}][1].")".'"';
$selectstring = $selectstring . ",{${'v' . $i}}";
$i = $i + 1;
}
// Get data for session
$session_result = $mysqli->query("SELECT {$selectstring} FROM {$db_table} WHERE session={$session_id} ORDER BY time DESC;") or die("ERROR: {$mysqli->error}");
while ($row = $session_result->fetch_assoc()) {
$i = 1;
while (isset(${'v' . $i})) {
if (substri_count($keyarr[${'v' . $i}][0], 'Speed') > 0) {
$x = intval($row[${'v' . $i}]) * $speed_factor;
${'v' . $i . '_measurand'} = $speed_measurand;
} elseif (substri_count($keyarr[${'v' . $i}][0], 'Temp') > 0) {
$x = $temp_func(floatval($row[${'v' . $i}]));
${'v' . $i . '_measurand'} = $temp_measurand;
} else {
$x = intval($row[${'v' . $i}]);
${'v' . $i . '_measurand'} = ' (' . $keyarr[${'v' . $i}][1] . ')';
}
${'d' . $i}[] = array($row['time'], $x);
${'spark' . $i}[] = $x;
$i = $i + 1;
}
}
$session_result->close();
$i = 1;
while (isset(${'v' . $i})) {
${'v' . $i . '_label'} = '"' . $keyarr[${'v' . $i}][0] . ${'v' . $i . '_measurand'} . '"';
