Page Menu
Home
c4science
Search
Configure Global Search
Log In
Files
F81331368
getGenes.php
No One
Temporary
Actions
Download File
Edit File
Delete File
View Transforms
Subscribe
Mute Notifications
Award Token
Subscribers
None
File Metadata
Details
File Info
Storage
Attached
Created
Thu, Sep 5, 09:39
Size
799 B
Mime Type
text/x-php
Expires
Sat, Sep 7, 09:39 (2 d)
Engine
blob
Format
Raw Data
Handle
20551921
Attached To
R2664 SHRINE MedCo Fork
getGenes.php
View Options
<?php
// case sensitive % stands for .*
//select *
//from gene_values
//where gene_value LIKE '%A1%' //
//LIMIT 20
// case insensitive with regex
//select *
//from gene_values
//where gene_value ~* '.*a1.*'
//LIMIT 20
include
'sqlConnection.php'
;
// get the row which contains all the values of the passed annotation
$query
=
"SELECT gene_value
FROM gene_values
WHERE gene_value ~* '.*"
.
$_GET
[
"gene"
]
.
".*'
LIMIT "
.
$_GET
[
"limit"
];
$result
=
pg_query
(
$conn
,
$query
);
if
(!
$result
)
{
echo
"An error occurred while querying the database.
\n
"
;
exit
;
}
// In json format return the list of genes
$geneList
=
""
;
while
(
$row
=
pg_fetch_row
(
$result
))
{
$geneList
.=
"
\"
$row[0]
\"
,"
;
}
// drop the last comma and concatenate in json format
echo
"["
.
substr
(
$geneList
,
0
,
-
1
)
.
"]"
;
Event Timeline
Log In to Comment