$mysqli = mysqli_connect(ini_get("mysqli.default_host"), 'updatescriptuser', 'NOT_THE_REAL_PASSWORD'); $mysqli->select_db('system_genomics'); $probes = array(); $probeIDQuery = "SELECT ID FROM probeTest;"; $probeResult = $mysqli->query($probeIDQuery); if ($probeResult == null) { echo "Query failed near line " . __LINE__ . ": {$probeIDQuery}"; echo "<br />Error is " . $mysqli->error; exit; } while ($row = $probeResult->fetch_assoc()) { $probes[] = $row["ID"]; } $numProbes = count($probes); echo "Number of probes is {$numProbes}.\n"; $correlationEngine = new CorrelationEngine(); 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();
if ($row = $lastProbeResult->fetch_assoc()) { $lastProbe = $row["staticCorrelationProbeID"]; } $probeIDQuery = "SELECT p.ID FROM probe p WHERE p.ID > {$lastProbe};"; $probeResult = $mysqli->query($probeIDQuery); if ($probeResult == null) { echo "Query failed near line " . __LINE__ . ": {$probeIDQuery}"; echo "<br />Error is " . $mysqli->error; exit; } while ($row = $probeResult->fetch_assoc()) { $probes[] = $row["ID"]; } $numProbes = count($probes) + $lastProbe; echo "Number of probes is {$numProbes}.\n"; $correlationEngine = new CorrelationEngine(); for ($i = $lastProbe + 1; $i <= $numProbes; $i++) { echo "probeID is {$i}\n"; // Truncate the correlation memory table $truncateCorrelationMemQuery = "TRUNCATE TABLE staticCorrelation_MEM;"; $truncateResult = $mysqli->query($truncateCorrelationMemQuery); if ($truncateResult == null || $mysqli->error) { echo "Query failed near line " . __LINE__ . ": {$truncateCorrelationMemQuery}"; echo "<br />Error is " . $mysqli->error; exit; } $set1 = array(); $set1Query = "SELECT effect FROM individualEffect_MEM WHERE probeID = {$i} ORDER BY individualID"; $set1Result = $mysqli->query($set1Query); if ($set1Result == null) { echo "Query failed near line " . __LINE__ . ": {$set1Query}";
$mysqli = mysqli_connect(ini_get("mysqli.default_host"), 'updatescriptuser', 'NOT_THE_REAL_PASSWORD'); $mysqli->select_db('system_genomics'); $probes = array(); $probeIDQuery = "SELECT ID, indMean, indSSMeanDevn FROM probeTest;"; $probeResult = $mysqli->query($probeIDQuery); if ($probeResult == null) { echo "Query failed near line " . __LINE__ . ": {$probeIDQuery}"; echo "<br />Error is " . $mysqli->error; exit; } while ($row = $probeResult->fetch_assoc()) { $probes[] = $row; } $numProbes = count($probes); echo "Number of probes is {$numProbes}.\n"; $correlationEngine = new CorrelationEngine(); for ($i = 0; $i < $numProbes; $i++) { echo "probeID " . $probes[$i]['ID'] . "\n"; $set1 = array(); $set1Query = "SELECT effect FROM individualEffect WHERE probeID = '" . $probes[$i]['ID'] . "' 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']; } $updateCorrelationQuery = "UPDATE staticCorrelationTest SET correlation = 1 WHERE probe1ID = " . $probes[$i]['ID'] . " AND probe2ID = " . $probes[$i]['ID'] . ";"; $updateResult = $mysqli->query($updateCorrelationQuery);