$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) { $geneData[$ctr++] = (object) array("geneID" => $row['geneID'], "x" => $row[$x], "y" => $row[$y]); } echo json_encode($geneData); } ?>
<?php include 'database.php'; /* $t1 = "droptable"; $t2 = "ENSG00"; $t3 = "ENSG"; $t4 = "ENSG00000004142"; $t5 = "ENSGR00000004142.1223"; echo "Gene ID matches: <br>"; echo $t1 . ": " . checkInput("$t1") . "<br>"; echo $t2 . ": " . checkInput("$t2") . "<br>"; echo $t3 . ": " . checkInput("$t3") . "<br>"; echo $t4 . ": " . checkInput("$t4") . "<br>"; echo $t5 . ": " . checkInput("$t5") . "<br>"; $c1 = "chr1:13213-42"; $c2 = "chrY:42355-4215' Drop Table"; $c3 = "chrX"; echo "<br><br>Coordinate matches: <br>"; echo $c1 . ": " . checkInput($c1) . "<br>"; echo $c2 . ": " . checkInput($c2) . "<br>"; echo $c3 . ": " . checkInput($c3) . "<br>"; */ $db = new lncRNA_DB(); $success = $db->loadExtension('/home/wespisea/databaseProject/install/sqlite/lib/functions.sqlext'); echo $success;
<script src="js/switch.js" type = "text/javascript"></script> <?php include 'php/database.php'; if (isset($_REQUEST["geneID"]) && checkInput($_REQUEST["geneID"])) { $sKey = $_REQUEST["geneID"]; } else { header('Location: /~wespisea/search.html'); } //Sanitize input //Construct variables for html $geneID = explode(".", $sKey); $geneID = $geneID[0]; $ensemblLink = "http://ensembl.org/Multi/Search/Results?species=all;idk=;q=" . $geneID; /*Construct data for Transcript Expression Chart*/ //Access database $db = new lncRNA_DB(); if (!$db) { echo $db->lastErrorMsg(); } $sql = "SELECT * FROM TransData WHERE geneID LIKE '" . $sKey . "'"; $transData = $db->getAllOrganized($sql); $transIDs = array_keys($transData); unset($transIDs[count($transIDs) - 1]); if (count($transIDs) < 1) { header('Location: /~wespisea/search.html'); } ?> <script> var entropyChart; var transChart;
if ($geneID != "") { $sKey = $geneID; $sql = "SELECT geneID, transID, chromosome, low, high FROM TransData WHERE geneID LIKE '" . $geneID . "%' ORDER BY geneID"; } elseif ($coords != "") { $sKey = $coords; //split chr:low-high input into array $coords = preg_split("(chr|:|-)", $coords, NULL, PREG_SPLIT_NO_EMPTY); $chromosome = $coords[0]; $low = removeComma($coords[1]); $high = removeComma($coords[2]); $sql = "SELECT geneID, transID, chromosome, low, high FROM TransData WHERE chromosome LIKE '" . $chromosome . "' AND " . $low . "<high AND " . $high . ">low ORDER BY (abs(" . $low . "-low)+abs(" . $high . "-high))"; } else { header('Location: /~wespisea/search.html'); } //Access database $db = new lncRNA_DB(); if (!$db) { echo $db->lastErrorMsg(); } if ($clean) { $data = $db->getAll($sql); } ?> <script> var data; //Array to hold all geneID search results var link; //Link beginning for each geneID var dataLength; //Number of search results var loc; //Current location for results navigation var table; //Main search results table var sKey;