}
//Connect to database
$db = new lncRNA_DB();
if (!$db) {
echo $db->lastErrorMsg();
}
$sql = "SELECT geneID FROM TransData WHERE geneID LIKE '" . $geneID . "%'";
$ret = $db->query($sql);
$row = $ret->fetchArray(SQLITE_ASSOC);
//Get first 5 search results
for ($ctr = 0; $ctr < 5 && $row; $row = $ret->fetchArray(SQLITE_ASSOC)) {
if (!in_array($row["geneID"], $matches)) {
$matches[$ctr++] = $row["geneID"];
}
}
$db->close();
echo json_encode($matches);
}
$x = $_POST["x"];
$y = $_POST["y"];
//Axes change on PCA Data Chart
if (isset($x) && isset($y)) {
//Connect to database
$db = new lncRNA_DB();
//Get only columns gene_id, x-axis, and y-axis
$sql = "SELECT geneID, [" . $x . "], [" . $y . "] FROM PCAData";
$data = $db->getAll($sql);
$geneData;
$ctr = 0;
//Return all data point objects
foreach ($data as $row) {
