DNA Bank Network - Publications/Amplifications
Logout
.
>>> Help <<<
Mit dem Suchformular können Sie bestehende Verbindungen zwischen Amplikationen und Publikationen verwalten.
Title:
or show all datasets:
>
Author:
Journal:
Book:
DNA Extraction Number:
Amplification Date from:
to:
Gen Bank Acc. Number:
Please select a dataset!"; } else { foreach ($_POST['x'] as $index => $check) { if(isset($check)) { $IDPubAmpTest = $_POST['IDPubAmp'][$index]; $result1 = "DELETE FROM tablepublications_amplifications WHERE ID_Pub_Amp = '$IDPubAmpTest'"; $sql1 = mysql_query($result1); #######################################Error 1############################################################### if(!$sql1) { $msg = $result1."\n"; $msg .= "####Error 1####"; trigger_error($msg, E_USER_ERROR); } ############################################################################################################# } } if($sql1) { echo "
Selected datasets have been deleted!
"; } }} if($formSubmitSearch or $formSubmitDelete) { include("date.php"); $tr = "="; $no = "!="; $lk = "like"; $bt = ">="; $st = "<="; $parr = $_POST; array($parr); foreach ($parr as $var) { $i ++; if(!empty($var) and $var!="dd.mm.yyyy" and $var!="Search") { switch (key($parr)) { case 'formSearchTitle': $str = "tablepublications_amplifications.Paper_Cache ".$lk."'%".$var."%' AND "; $description = " Title = "; $value = $formSearchTitle; break; case 'formAuthor': $str = "tablepublications_amplifications.Paper_Cache ".$lk."'%".$var."%' AND "; $description = " Author = "; $value = $formAuthor; break; case 'formJournal': $str = "tablepublications_amplifications.Paper_Cache ".$lk."'%".$var."%' AND "; $description = " Journal = "; $value = $formJournal; break; case 'formSearchBook': $str = "tablepublications_amplifications.Paper_Cache ".$lk."'%".$var."%' AND "; $description = " Book = "; $value = $formSearchBook; break; case 'formDnaBankNumber': $str = "tablednabanknumbers.Dna_Bank_Number ".$tr."'".$var."' AND "; $description = " DNA Extraction Numer = "; $value = $formDnaBankNumber; break; case 'formAmplificationDateFrom': if ($AmplificationDateFrom!="") { $str = "tableamplifications.Amplification_Date ".$bt."'".$AmplificationDateFrom."' AND "; $description = " Amplification Date >= "; if($_POST['formAmplificationDateFrom']) {$value = $formAmplificationDateFrom;} } break; case 'formAmplificationDateTo': if ($AmplificationDateTo!="") { $str = "tableamplifications.Amplification_Date ".$st."'".$AmplificationDateTo."' AND "; $description = " Amplification Date <= "; if($_POST['formAmplificationDateTo']) {$value = $formAmplificationDateTo;} } break; case 'formGenBankNumber': $str = "tableamplifications.GenBankNumber ".$lk."'%".$var."%' AND "; $description = " Gen Bank Number = "; $value = $formGenBankNumber; break; } $where[$i] = $str; $descriptionall[$i] = $description; $valueall[$i] = $value; } next($parr); } if(empty($str) and !isset($formShowAll)) { echo "
No search key entered.
"; } if(!empty($str) and isset($formShowAll)) { echo "
Please either enter a search key or select the checkbox!
"; } else { foreach($where AS $a) $string .= $a; $l=strlen ($string); $max = $l-4; $where_str = substr($string, 0, $max); $wherestr = ' WHERE ' . $where_str; $result = "SELECT tablepublications_amplifications.ID_Pub_Amp, " . "tablepublications_amplifications.Paper_Cache, " . "tablepublications_amplifications.Fragment, " . "tablednabanknumbers.Dna_Bank_Number, " . "tableamplifications.Amplification_Date, " . "tableamplifications.Amplification_Success, " . "tableamplifications.GenBankNumber " . "FROM tablepublications_amplifications LEFT JOIN tablednabanknumbers ON tablepublications_amplifications.ID_DNA = tablednabanknumbers.ID_DNA LEFT JOIN tableamplifications ON tablepublications_amplifications.ID_Amplification = tableamplifications.ID_Amplification"; if(!empty($str)) {$result .= $wherestr.$sqllimit; } $sql = mysql_query($result) or die($result.'
'.mysql_error()); $gesamt = mysql_num_rows($sql); if(!mysql_num_rows($sql)) { echo "
No hits found.
"; } else { echo "
Select
Publication
DNA Extraction No
Gen Bank No
Fragment
Amplification Success
Amplification Date
"; for ($i=1; $i<=$gesamt; $i++) { $row=mysql_fetch_array($sql); $Publication = $row['Paper_Cache']; $DnaBankNumber = $row['Dna_Bank_Number']; $GenBankNumber = $row['GenBankNumber']; $Fragment = $row['Fragment']; $Amplification_Success = $row['Amplification_Success']; $Amplification_Date = $row['Amplification_Date']; $ID_Pub_Amp = $row['ID_Pub_Amp']; echo "
".$Publication."
".$DnaBankNumber."
".$GenBankNumber."
".$Fragment."
"; echo "
".$Amplification_Success."
".DatumsWandler($Amplification_Date)."
"; } echo "
"; echo "
"; ?>
