for ($i = 0; $i < $numProbes; $i++) {
echo "probeID " . $probes[$i] . "\n";
$set1 = array();
$set1Query = "SELECT effect FROM individualEffect WHERE probeID = '" . $probes[$i] . "' ORDER BY individualID";
$set1Result = $mysqli->query($set1Query);
if ($set1Result == null) {
echo "Query failed near line " . __LINE__ . ": {$set1Query}";
echo "<br />Error is " . $mysqli->error;
exit;
}
while ($row = $set1Result->fetch_assoc()) {
$set1[] = $row['effect'];
}
// $set1 = $set1Result->fetch_array(MYSQLI_NUM);
// echo "<pre>"; print_r($set1); echo "</pre>"; die();
// Quick and dirty way to initialise the object - all we need here is the sum of squares and the average
$correlation = $correlationEngine->Correlation($set1, $set1);
$sumSquareMeanDeviation = $correlationEngine->SumSquareMeanDeviation(0);
$indAverage = $correlationEngine->arraySets[0]->average;
if ($indAverage != NULL) {
// echo "<pre>"; print_r($set1); echo "</pre>\n<pre>"; print_r($set2); echo "</pre>\ncorrelation is $correlation"; die();
$updateProbeSSQuery = "UPDATE probeTest SET indSumSquareMeanDeviation = {$sumSquareMeanDeviation}, indAverage = {$indAverage} WHERE ID = " . $probes[$i] . ";";
$updateResult = $mysqli->query($updateProbeSSQuery);
if ($updateResult == null || $mysqli->error) {
echo "Query failed near line " . __LINE__ . ": {$updateProbeSSQuery}";
echo "<br />Error is " . $mysqli->error;
exit;
}
}
}
echo " --- finished ---";