<?php |
<?php |
|
|
/*// most interesting |
/*// most interesting |
SELECT sum(heuristic_value) as sum, CNID |
SELECT sum(heuristic_value) as sum, CNID |
FROM heuristic_results group by CNID order by sum DESC limit 30 |
FROM heuristic_results group by CNID order by sum DESC limit 30 |
|
|
// spread of values |
// spread of values |
select floor(sum) as val,count(*) from (SELECT sum(heuristic_value) |
select floor(sum) as val,count(*) from (SELECT sum(heuristic_value) |
as sum FROM heuristic_results group by CNID) as a group by val*/ |
as sum FROM heuristic_results group by "CNID") as a group by val*/ |
|
|
$series = Array(); |
$series = Array(); |
|
|
include_once("../lib/common.inc.php"); |
include_once("../lib/common.inc.php"); |
$query = "select heuristic_name, floor(heuristic_value) as val,count(*) from heuristic_results group by heuristic_name, val"; |
$query = "select heuristic_name, floor(heuristic_value) as val,count(*) from heuristic_results group by heuristic_name, val"; |
$result = $conn->query($query); |
$result = $conn->query($query); |
foreach ($result->fetchAll() as $r) { |
foreach ($result->fetchAll() as $r) { |
$series[$r["heuristic_name"]][$r["val"]] = $r[2]; |
$series[$r["heuristic_name"]][$r["val"]] = $r[2]; |
} |
} |
|
|
|
$labels = Array(); |
|
foreach ($series as $value) { |
|
$labels = $labels+array_keys($value); |
|
} |
|
$labels = Array(0,1,2,3,4,5); |
|
foreach ($series as $seriesName => $seriesEntry) { |
|
$data; |
|
foreach ($labels as $label) { |
|
$data[$label] = ($seriesEntry[$label] ? $seriesEntry[$label] : 0); |
|
} |
|
} |
|
print_r($labels); |
|
print_r($data); |
?> |
?> |