include 'database.php';
$geneID = $_POST["geneID"];
//Search bar autocomplete for gene ID
if (isset($geneID)) {
$matches = array();
if (!checkInput($geneID)) {
return;
}
//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
