Home | Contact us | Browse | Quick Search by UniProtKB ID, Keyword, PDBID

"; echo ""; echo ""; $i=1; while($data = mysql_fetch_array($result)) { echo ""; echo ""; echo ""; $i++; } mysql_free_result($result); mysql_close($link); echo "

#	".$dis_db_type." Disease	Number of S-nitrosylated Proteins
".$i."	".$data[0]."	".$data[1]."

"; } $dis_db_type = $_GET['dis_db_type']; $disease = $_GET['disease']; if($disease != "" && $dis_db_type != "HPRD") { $link = mysql_connect("140.138.144.145", "dbsno", "dbsno") or die("Could not connect : " . mysql_error()); mysql_select_db("dbSNO") or die("Could not select database"); $sql = "select ID,Entry_ID,disease from disease_human_".$dis_db_type." where disease_shot like '".$disease."'"; $result = mysql_query($sql) or die("Query failed omim or kegg: " . mysql_error()); echo ""; echo ""; echo ""; $i=1; while($data = mysql_fetch_array($result)) { echo ""; echo ""; switch($dis_db_type) { case "OMIM": echo ""; break; case "KEGG": echo ""; break; } echo ""; $i++; } mysql_free_result($result); mysql_close($link); echo "

#	UniprotKB ID	Database Entry	Disease Information
".$i."	".$data[0]."	".$data[1]."	".$data[1]."	".$data[2]."

"; } elseif($dis_db_type == "HPRD") { $link = mysql_connect("140.138.144.145", "dbsno", "dbsno") or die("Could not connect : " . mysql_error()); mysql_select_db("dbSNO") or die("Could not select database"); $sql = "select ID,HPRD_ID,disease from disease_human_".$dis_db_type." where disease_shot like '".$disease."'"; $result = mysql_query($sql) or die("Query failed HPRD: " . mysql_error()); echo ""; echo ""; echo ""; $i=1; while($data = mysql_fetch_array($result)) { echo ""; echo ""; echo ""; echo ""; $i++; } mysql_free_result($result); mysql_close($link); echo "

#	UniprotKB ID	Database Entry	Disease Information
".$i."	".$data[0]."	".$data[1]."	".$data[2]."

"; } ?>

 

Copyright © Yuan Ze University and Academic Sinica. (Sep. 15, 2014).