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'} . '"';