コード例 #1
0
ファイル: search.php プロジェクト: ryys1122/lncRNAdbProject
    $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);
}
?>

コード例 #2
0
ファイル: test.php プロジェクト: ryys1122/lncRNAdbProject
<?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;
コード例 #3
0
ファイル: data.php プロジェクト: ryys1122/lncRNAdbProject
<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;
コード例 #4
0
ファイル: results.php プロジェクト: ryys1122/lncRNAdbProject
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;