<?php 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)) {