function goDeeper($parent, $key, $value, $link, $result) { global $db_prefix; if (!is_object($value) && !is_array($value) && $key != "status") { $sql = 'INSERT INTO `' . $db_prefix . 'twitter_usermetadata` (`twitter_user_id`, `field_key`, `field_value`)VALUES("' . $result->id_str . '", "' . $parent . $key . '", "' . str_replace('"', "'", $value) . '")'; $insert = query_mysql($sql, $link); } else { if ((is_object($value) || is_array($value)) && $key != "status") { foreach ($value as $inner_key => $inner_value) { goDeeper($key . " ", $inner_key, $inner_value, $link, $result); } } } }
<?php /* example-6.php Square-Heatmat With Dots underneath */ require_once "../config.php"; $geojson_webmer = array(); //If you want to show all points add the number of points you want to show here: $db_max = 20000; $sql = 'SELECT `' . $db_lat . '`, `' . $db_lng . '`, `x`, `y` FROM `' . $db_table . '` WHERE `validconversion` = 1 ORDER BY `' . $db_id . '` ASC LIMIT ' . $db_max; $result = query_mysql($sql, $link); if ($result) { while ($row = mysql_fetch_assoc($result)) { array_push($geojson_webmer, array($row["x"], $row["y"])); } } mysql_free_result($result); ?> <!DOCTYPE html> <html> <head> <meta charset="utf-8" /> <style> body,html{margin:0;padding:0;width:100%;height:100%;} #map{width:100%;height:100%;} </style> <link rel="stylesheet" href="http://cdn.leafletjs.com/leaflet-0.7.1/leaflet.css" /> </head> <body>
echo json_encode($pert_collection_count); break; case 'fda_collections': // number of FDA approved drugs in collections $query = "SELECT pert_collection, COUNT(*) FROM drugs_lincs INNER JOIN drugs_drugbank ON drugs_lincs.pubchem_cid=drugs_drugbank.pubchem_cid OR drugs_lincs.pert_iname=drugs_drugbank.name GROUP BY pert_collection"; $rs = query_mysql($query, $conn); $conn->close(); $fda_approved_drug_count = array(); foreach ($rs as $key => $line) { if (is_null($line['pert_collection'])) { $fda_approved_drug_count['NA'] = (int) $line['COUNT(*)']; } else { $fda_approved_drug_count[$line['pert_collection']] = (int) $line['COUNT(*)']; } } echo json_encode($fda_approved_drug_count); break; case 'summary_count': $arr = array(); // container for all the output $tables = array('side_effects', 'drugs_lincs'); foreach ($tables as $table) { $query = "SELECT COUNT(*) FROM {$table}"; // get SE count and drug count $count = query_mysql($query, $conn); $arr[$table] = $count[0]['COUNT(*)']; } $conn->close(); echo json_encode($arr); } }
function get_four_defs($connection, $correct_word, $num_headwords, $max_def_length = 256, $min_def_length = 0) { $correct_def = get_def($connection, $correct_word); $correct_headword_id = $correct_word['headword_id']; $def1; $def2; $def3; // $def_arr = array($correct_def); $pos = $correct_word['pos']; $regex_pos; if ($pos == 'sm' || $pos == 'sf' || $pos == 'smf') { $regex_pos = " AND pos REGEXP 'sm|sf'"; } else { if ($pos == 'vt' || $pos == 'vi' || $pos == 'vp' || $pos == 'vti') { $regex_pos = " AND pos REGEXP 'v'"; } else { if ($pos == 'adj') { $regex_pos = " AND pos REGEXP 'adj'"; } else { $regex_pos = ""; } } } $defs_query = "SELECT * FROM hms_defs \n" . "LEFT JOIN hms_headword ON headword_id=fk_defs_headword_id\n" . "WHERE CHAR_LENGTH(def) < {$max_def_length} AND CHAR_LENGTH(def) > {$min_def_length} {$regex_pos}"; $defs_results = query_mysql($connection, $defs_query); $num_rows = mysqli_num_rows($defs_results); //$num_headwords in argument may not be necessary $random1 = unique_random($num_rows); $random2 = unique_random($num_rows, $random1); $random3 = unique_random($num_rows, $random1, $random2); mysqli_data_seek($defs_results, $random1); $row = mysqli_fetch_row($defs_results); $def1 = $row[2]; //index 2 gets the definition $def1_headword_id = $row[1]; //index 1 gets the headword_id mysqli_data_seek($defs_results, $random2); $row = mysqli_fetch_row($defs_results); $def2 = $row[2]; $def2_headword_id = $row[1]; mysqli_data_seek($defs_results, $random3); $row = mysqli_fetch_row($defs_results); $def3 = $row[2]; $def3_headword_id = $row[1]; $correct_def_str = $correct_def['def']; $headword = $correct_word['headword']; $pos = $correct_word['pos']; // $def_arr = array("correct" => "$correct_def_str", "headword"=> $headword, "pos"=> $pos, "def1" => $def1, "def2" => $def2, "def3" => $def3); $def_arr = array("correct" => "{$correct_def_str}", "headword" => $headword, "pos" => $pos, "correct_headword_id" => $correct_headword_id, "def1" => $def1, "def2" => $def2, "def3" => $def3, "def1_headword_id" => "{$def1_headword_id}", "def2_headword_id" => "{$def2_headword_id}", "def3_headword_id" => "{$def3_headword_id}"); // print_r($def_arr); return $def_arr; }
foreach ($known_drugs as $key => $line) { $id = $line['drug_id']; array_push($known_drug_ids, $id); } $arr_out = array(); for ($i = 0; $i < count($drugs); $i++) { $drug_id = $drugs[$i]['drug_id']; $write_this = True; // whether to write this drug out if (in_array($drug_id, $known_drug_ids) && $filter) { $write_this = False; } if ($write_this) { $query = "SELECT pert_id,pert_iname FROM drugs_lincs WHERE id='{$drug_id}'"; //to get names of pert_ids $drug_meta = query_mysql($query, $conn); $arr_out[$i]['name'] = $drug_meta[0]['pert_iname']; $arr_out[$i]['pert_id'] = $drug_meta[0]['pert_id']; $p_val = $drugs[$i]['p_val']; $arr_out[$i]['p_val'] = sprintf('%0.2f', $p_val); if (!$filter) { if (in_array($drug_id, $known_drug_ids)) { $arr_out[$i]['sider'] = 'yes'; } else { $arr_out[$i]['sider'] = 'no'; } } } } $conn->close(); $json = json_encode($arr_out);
<?php header('Content-type: text/plain;charset=utf8'); require_once '../config.php'; require_once '../lib/db.php'; $results = query_mysql('SELECT id FROM ' . $db_prefix . 'twitter_requests WHERE request = "' . $_GET["request"] . '"', $link); while ($row = mysql_fetch_assoc($results)) { $id = $row["id"]; } $results = query_mysql('SELECT field_value FROM ' . $db_prefix . 'twitter_tweetmetadata WHERE request_id = "' . $id . '" AND field_key = "created_at" ORDER BY twitter_tweet_id ASC LIMIT 0, 1', $link); while ($row = mysql_fetch_assoc($results)) { $d1 = new DateTime($row["field_value"]); } $results = query_mysql('SELECT field_value FROM ' . $db_prefix . 'twitter_tweetmetadata WHERE request_id = "' . $id . '" AND field_key = "created_at" ORDER BY twitter_tweet_id DESC LIMIT 0, 1', $link); while ($row = mysql_fetch_assoc($results)) { $d2 = new DateTime($row["field_value"]); } $diff = $d1->diff($d2); echo $diff->d . ' days' . "\n"; echo $diff->h . ' hours' . "\n"; echo $diff->i . ' minutes' . "\n"; echo $diff->s . ' seconds' . "\n" . "\n"; $results = query_mysql('SELECT * FROM ' . $db_prefix . 'twitter_tweets', $link); echo mysql_num_rows($results) . ' tweets' . "\n" . "\n"; $results = query_mysql('SELECT * FROM ' . $db_prefix . 'twitter_users', $link); echo mysql_num_rows($results) . ' users' . "\n\n\n"; ?>
<?php // API for legends require_once 'login.php'; include 'functions.php'; $conn = new mysqli($db_hostname, $db_username, $db_password, $db_database); if ($conn->connect_error) { trigger_error('Database connection failed: ' . $conn->connect_error, E_USER_ERROR); } if (isset($_GET['type'])) { $type = $_GET['type']; if ($type == 'side_effect_network.json') { $query = "SELECT name,CONCAT('#',color) AS color FROM soc"; } else { $query = "SELECT pert_icollection FROM drugs_lincs GROUP BY pert_icollection"; } } $result = query_mysql($query, $conn); $conn->close(); $json = json_encode($result); echo $json;
<?php require_once 'login.php'; include 'functions.php'; $conn = new mysqli($db_hostname, $db_username, $db_password, $db_database); if ($conn->connect_error) { trigger_error('Database connection failed: ' . $conn->connect_error, E_USER_ERROR); } $query = "SELECT umls_id,name,synonyms FROM side_effects WHERE umls_id IS NOT NULL AND auroc IS NOT NULL"; $rs_arr = query_mysql($query, $conn); $conn->close(); $num_rows = count($rs_arr); $out_arr = array(); foreach ($rs_arr as $row) { $synonyms = explode("|", $row["synonyms"]); $row["synonyms"] = $synonyms; array_push($out_arr, $row); } $json = json_encode($out_arr); echo $json;
<?php include "config.php"; require_once 'lib/codebird.php'; include "lib/db.php"; \Codebird\Codebird::setConsumerKey($key, $secret); $cb = \Codebird\Codebird::getInstance(); session_start(); if (!isset($_GET['oauth_verifier'])) { $reply = $cb->oauth_requestToken(array('oauth_callback' => $url . '1-create_tokens.php')); $cb->setToken($reply->oauth_token, $reply->oauth_token_secret); $_SESSION['oauth_token'] = $reply->oauth_token; $_SESSION['oauth_token_secret'] = $reply->oauth_token_secret; $auth_url = $cb->oauth_authorize(); header('Location: ' . $auth_url); die; } elseif (isset($_GET['oauth_verifier'])) { $cb->setToken($_SESSION['oauth_token'], $_SESSION['oauth_token_secret']); $reply = $cb->oauth_accessToken(array('oauth_verifier' => $_GET['oauth_verifier'])); $sql = 'INSERT INTO `' . $db_prefix . 'twitter_token` (`token`, `secret`)VALUES("' . $reply->oauth_token . '", "' . $reply->oauth_token_secret . '")'; $insert = query_mysql($sql, $link); } ?> <html><head><meta http-equiv="Content-Type" content="text/html;charset=UTF-8"></head><body> <?php echo 'Twitter Token Creation completed. <a href="2-create_request.php">Continue</a>'; ?> </body></html>
function getCount($query, $conn) { $result = query_mysql($query, $conn); return $result[0]['COUNT(*)']; }
# all the predicted se_ids of the drug // get SE associated with this drug in SIDER $query = "SELECT se_id FROM sider_connections INNER JOIN drugs_lincs ON sider_connections.drug_id = drugs_lincs.id WHERE pert_id='{$pert_id}'"; $known_side_effects = query_mysql($query, $conn); $known_side_effect_ids = array(); // se_id of known connections foreach ($known_side_effects as $key => $line) { $id = $line['se_id']; array_push($known_side_effect_ids, $id); } $arr_out = array(); for ($i = 0; $i < count($side_effects); $i++) { $se_id = $side_effects[$i]['se_id']; $query = "SELECT umls_id,name FROM side_effects WHERE id='{$se_id}'"; //to get names of side effects $se_meta = query_mysql($query, $conn); if ($se_meta[0]['umls_id']) { // filter out se without umls_id $arr_out[$i]['name'] = $se_meta[0]['name']; $arr_out[$i]['umls_id'] = $se_meta[0]['umls_id']; $p_val = $side_effects[$i]['p_val']; $arr_out[$i]['p_val'] = sprintf('%0.2f', $p_val); if (in_array($se_id, $known_side_effect_ids)) { $arr_out[$i]['sider'] = 'yes'; } else { $arr_out[$i]['sider'] = 'no'; } } } $conn->close(); $json = json_encode($arr_out);
<?php require_once 'login.php'; include 'functions.php'; $pert_id = $_GET['pert_id']; $conn = new mysqli($db_hostname, $db_username, $db_password, $db_database); if ($conn->connect_error) { trigger_error('Database connection failed: ' . $conn->connect_error, E_USER_ERROR); } $query = "SELECT * FROM drugs_lincs WHERE pert_id='{$pert_id}'"; $rs_lincs = query_mysql($query, $conn); $drug_meta['drugs_lincs'] = $rs_lincs[0]; // to store info for the drug $pcid = $rs_lincs[0]['pubchem_cid']; // don't want to show info from drugbank and stitch // if (!is_null($pcid)) { // $tables = array("drugs_drugbank", "drugs_stitch"); // foreach ($tables as $table) { // $query = "SELECT * FROM $table WHERE pubchem_cid='$pcid'"; // $rs_arr = query_mysql($query, $conn); // if(count($rs_arr) == 1) { // $drug_meta[$table] = $rs_arr[0]; // } // } // } $conn->close(); $json = json_encode($drug_meta); echo $json;
<?php require_once 'login.php'; include 'functions.php'; $conn = new mysqli($db_hostname, $db_username, $db_password, $db_database); if ($conn->connect_error) { trigger_error('Database connection failed: ' . $conn->connect_error, E_USER_ERROR); } if (isset($_GET['term'])) { $searchq = $_GET["term"]; $searchq = preg_replace("#[^0-9a-z-]#i", "", $searchq); $searchq = "%" . $searchq . "%"; $query1 = "SELECT pert_id, pert_iname, alt_name FROM drugs_lincs WHERE pert_id LIKE '{$searchq}' OR pert_iname LIKE '{$searchq}' OR alt_name LIKE '{$searchq}'"; $query2 = "SELECT umls_id, name, synonyms FROM side_effects WHERE umls_id LIKE '{$searchq}' OR name LIKE '{$searchq}' OR synonyms LIKE '{$searchq}'"; $rs_arr1 = query_mysql($query1, $conn); $rs_arr2 = query_mysql($query2, $conn); $count = count($rs_arr1) + count($rs_arr2); if ($count == 0) { $output = 'NULL'; } else { $rs_arr = array("drugs" => $rs_arr1, "se" => $rs_arr2); $output = $rs_arr; } $json = json_encode($output); echo $json; }
<?php require_once 'login.php'; include 'functions.php'; $umls_id = $_GET['umls_id']; $conn = new mysqli($db_hostname, $db_username, $db_password, $db_database); if ($conn->connect_error) { trigger_error('Database connection failed: ' . $conn->connect_error, E_USER_ERROR); } // $query = "SELECT * FROM umls_ids INNER JOIN side_effects ON side_effects.umls_id=umls_ids.umls_id WHERE umls_ids.umls_id='$umls_id'"; $query = "SELECT * FROM side_effects WHERE umls_id='{$umls_id}'"; $rs_se = query_mysql($query, $conn); $rs_se[0]['synonyms'] = explode("|", $rs_se[0]["synonyms"]); $conn->close(); $json = json_encode($rs_se[0]); echo $json;