function search_infoTable($chemicals)
{
if (!database_connect()) {
return "DB_CONNECT_FAILURE";
}
if (empty($chemicals)) {
return "NO_SEARCH";
}
# Set up parameters of a basic chemicalSGA search
$search = "chemicalConditions.*, chemicals.structure_pic";
$table = "chemicalConditions, chemicals";
#Build the where statement
$andQueryArray = array();
if (!empty($chemicals)) {
array_push($andQueryArray, "chemicalConditions.chemical_name IN " . build_IN_LIST($chemicals));
}
//array_push($andQueryArray, build_OR($chemicals, "chemicalConditions.chemical_name='", "'"));}
array_push($andQueryArray, 'chemicalConditions.chemical_name = chemicals.name');
$where = build_AND($andQueryArray);
//echo($where);
//print $where;
#Do the search
$result = database_select_distinct_search($search, $table, $where);
# Throw the results into an array
$resultArray = array();
while ($row = mysql_fetch_assoc($result)) {
array_push($resultArray, $row);
}
#database dc
database_disconnect();
#return the results array
if (count($resultArray) == 0) {
return "EMPTY";
}
# Is the array empty?
return $resultArray;
}
function search_info_GO_terms($GO_terms)
{
if (!database_connect()) {
return "DB_CONNECT_FAILURE";
}
if (empty($GO_terms)) {
return array();
}
# Set up parameters
$search = "*";
$table = $GLOBALS['TABLE_GO_NAMES'];
#Build the where statement
$where = "0 = 1";
if (!empty($GO_terms)) {
$where = "pid IN " . build_IN_LIST($GO_terms);
}
#Do the search
$result = database_select_distinct_search($search, $table, $where);
# Throw the results into an array
$resultArray = array();
while ($row = mysql_fetch_assoc($result)) {
$row["searchType"] = "GO";
array_push($resultArray, $row);
}
#database dc
database_disconnect();
#return the results array
if (count($resultArray) == 0) {
return "EMPTY";
}
# Is the array empty?
return $resultArray;
}
function getGeneOntologyDatabaseIDs($terms)
{
#Connect to the database
if (!database_connect()) {
echo "DB_CONNECT_FAILURE";
return false;
}
if (empty($terms)) {
return array();
}
$search = "pid";
$table = $GLOBALS['TABLE_GO_NAMES'];
#Build the where statement
$orQueryArray = array();
if (!empty($terms)) {
array_push($orQueryArray, "GO_name IN " . build_IN_LIST($terms));
}
if (!empty($terms)) {
array_push($orQueryArray, "GO_desc IN " . build_IN_LIST($terms));
}
$where = build_OR($orQueryArray);
#Do the search
$result = database_select_distinct_search($search, $table, $where);
# Throw the results into an array
$resultArray = array();
while ($row = mysql_fetch_assoc($result)) {
array_push($resultArray, $row["pid"]);
}
#database dc
database_disconnect();
#return the results array
#if(count($resultArray) == 0){return "EMPTY";} # Is the array empty?
return $resultArray;
}
