$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); $pcnt25data1 = round(calc_percentile($spark1, 25), 1); $pcnt25data2 = round(calc_percentile($spark2, 25), 1); $pcnt75data1 = round(calc_percentile($spark1, 75), 1); $pcnt75data2 = round(calc_percentile($spark2, 75), 1); } else { }
$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})); ${'max' . $i} = round(max(${'spark' . $i}), 1); ${'min' . $i} = round(min(${'spark' . $i}), 1); ${'avg' . $i} = round(average(${'spark' . $i}), 1); ${'pcnt25data' . $i} = round(calc_percentile(${'spark' . $i}, 25), 1); ${'pcnt75data' . $i} = round(calc_percentile(${'spark' . $i}, 75), 1); $i = $i + 1; } }