-
Notifications
You must be signed in to change notification settings - Fork 4
/
Find_CalibrationsByTips.php
72 lines (59 loc) · 3.68 KB
/
Find_CalibrationsByTips.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
<?php
// open and load site variables
require('../config.php');
// open and print header template
require('header.php');
?>
<?php
// connect to mySQL server and select the Fossil Calibration database
$connection=mysql_connect($SITEINFO['servername'],$SITEINFO['UserName'], $SITEINFO['password']) or die ('Unable to connect!');
mysql_select_db('FossilCalibration') or die ('Unable to select database!');
$key=array_keys($_GET);
$value=array_values($_GET);
//retrieve calibrations when Taxon B is entered
if($_GET['TaxonB']) {
$query='SELECT DISTINCT C.* FROM View_CalibrationPair V JOIN View_Calibrations C ON V.CalibrationID=C.CalibrationID
WHERE (V.TaxonA LIKE "%'. mysql_real_escape_string($_GET['TaxonA']) .'%" AND V.TaxonB LIKE "%'. mysql_real_escape_string($_GET['TaxonB']) .'%")
OR (V.TaxonB LIKE "%'. mysql_real_escape_string($_GET['TaxonA']) .'%" AND V.TaxonA LIKE "%'. mysql_real_escape_string($_GET['TaxonB']) .'%")
OR (V.ACommonName LIKE "%'. mysql_real_escape_string($_GET['TaxonA']) .'%" AND V.BCommonName LIKE "%'. mysql_real_escape_string($_GET['TaxonB']) .'%")
OR (V.BCommonName LIKE "%'. mysql_real_escape_string($_GET['TaxonA']) .'%" AND V.ACommonName LIKE "%'. mysql_real_escape_string($_GET['TaxonB']) .'%")';
$calibration_list=mysql_query($query) or die ('Error in query: '.$query.'|'. mysql_error());
echo '<h1>'. mysql_num_rows($calibration_list) .' calibration'. (mysql_num_rows($calibration_list) == 1 ? '' : 's') .' with tip taxa "'.$_GET['TaxonA'].'" and "'.$_GET['TaxonB'].'"</h1>';
echo '<p>Click on "Show calibration" to view full calibration information. Click on node name or publication name to find related calibrations.</p>';
} else {
$query='SELECT Distinct C.* FROM View_CalibrationPair V JOIN View_Calibrations C ON V.CalibrationID=C.CalibrationID
WHERE V.TaxonA LIKE "%'. mysql_real_escape_string($_GET['TaxonA']) .'%"
OR V.TaxonB LIKE "%'. mysql_real_escape_string($_GET['TaxonA']) .'%"
OR V.ACommonName LIKE "%'. mysql_real_escape_string($_GET['TaxonA']) .'%"
OR V.BCommonName LIKE "%'. mysql_real_escape_string($_GET['TaxonA']) .'%"';
$calibration_list=mysql_query($query) or die ('Error in query: '.$query.'|'. mysql_error());
echo '<h1>'. mysql_num_rows($calibration_list) .' calibration'. (mysql_num_rows($calibration_list) == 1 ? '' : 's') .' with tip taxon "'.$_GET['TaxonA'].'" </h1>';
echo '<p>Click on "Show calibration" to view full calibration information. Click on node name or publication name to find related calibrations.</p>';
}
?>
<table width="100%" border="0">
<tr>
<td width="10%" align="center" valign="middle" class="small_orange"><strong>Info</strong></td>
<td width="5%" align="center" valign="middle" class="small_orange"><strong>CalibrationID</strong></td>
<td width="15%" align="center" valign="middle" class="small_orange"><strong>Node Name</strong></td>
<td width="5%" align="center" valign="middle" class="small_orange"><strong>Min Age</strong></td>
<td width="5%" align="center" valign="middle" class="small_orange"><strong>Max Age</strong></td>
<td width="15%" align="center" valign="middle" class="small_orange"><strong>Publication</strong></td>
</tr>
<?php
while ($row = mysql_fetch_array($calibration_list)) {
?>
<tr align="center" valign="top">
<td><a href="Show_Calibration.php?CalibrationID=<?=$row['CalibrationID']?>">Show calibration</a></td>
<td><?=$row['CalibrationID']?></td>
<td><a href="#" onclick="alert('Related calibrations COMING SOON...'); return false;"><?=$row['NodeName']?></a></td>
<td><?=$row['MinAge']?></td>
<td><?=$row['MaxAge']?></td>
<td><?=$row['ShortName']?></td>
</tr>
<?php } ?>
</table>
<?php
//open and print page footer template
require('footer.php');
?>