speciesDatabase-alpha-deprecated/taxonomist.php at master · felipeabranches/speciesDatabase-alpha-deprecated · GitHub

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
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
<?php
include_once 'init.php';
$id = $_GET['id'];
$page_title = 'Taxonomist';

// Species class
require_once $base_dir.'/libraries/species/species.php';
$species = new Species();
// Taxonomists class
require_once $base_dir.'/libraries/species/taxonomists.php';
$taxonomist = new Taxonomists;
$result = mysqli_query($mysqli, $taxonomist->getTaxonomist($id));
$tt = mysqli_fetch_object($result);
?>
<!doctype html>
<html lang="pt">
<head>
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
    <meta name="description" content="">
    <meta name="keywords" content="">
    <meta name="author" content="<?php echo $author; ?>">
	<title><?php echo (!$result->num_rows) ? 'No '.$page_title : $tt->name; ?> - <?php echo $site_name; ?></title>
    <?php include_once 'modules/head.php'; ?>
</head>

<body class="bg-light">
<?php include_once 'modules/menu.php'; ?>
<div class="container-fluid" role="main">
    <div class="toolbar sticky-top row my-2 p-2">
        <div class="col-12">
            <?php if (!$result->num_rows): ?>
            <h4>No entries</h4>
            <?php else: ?>
            <h4 class="float-left"><?php echo $tt->name; ?></h4>
            <span class="float-right">ID#<span class="badge badge-secondary badge-pill"><?php echo $tt->id; ?></span></span>
            <?php endif; ?>
        </div>
    </div>

    <div class="row">
        <div class="col-12 col-md-4">
            <div class="my-3 p-3 bg-white rounded box-shadow">
                <?php if (!$result->num_rows): ?>
                <p>No entries</p>
                <?php else: ?>
                <?php if ($tt->image): ?>
                <figure class="figure">
                    <img src="<?php echo $tt->image; ?>" alt="<?php echo $tt->name; ?>" class="figure-img img-fluid rounded">
                    <figcaption class="figure-caption">Foto: Nome, Ano (arquivo.JPG)</figcaption>
                </figure>
                <?php endif; ?>
                <p class="badge badge-secondary"><?php echo $tt->note; ?></p>
                <?php endif; ?>
            </div>
        </div>

        <div class="col-12 col-md-4">
            <div class="my-3 p-3 bg-white rounded box-shadow">
                <?php if (!$result->num_rows): ?>
                <p>No entries</p>
                <?php else: ?>
                <?php echo $tt->description; ?>
                <?php endif; ?>
                <?php mysqli_free_result($result); ?>
            </div>
        </div>

        <div class="col-12 col-md-4">
            <div class="my-3 p-3 bg-white rounded box-shadow">
                <h5>Species</h5>
                <?php $spResult = mysqli_query($mysqli, $taxonomist->getSpecies($id)); ?>
                <?php if (!$spResult->num_rows): ?>
                <p>No entries</p>
                <?php else: ?>
                <table class="table table-striped table-hover table-sm small">
                    <caption>Species</caption>
                    <thead>
                        <tr>
                            <th scope="col">Species</th>
                            <th scope="col">Year</th>
                        </tr>
                    </thead>
                    <tbody>
                        <?php $spTotal = 0; ?>
                        <?php while ($sp = mysqli_fetch_object($spResult)): ?>
                        <tr scope="row">
                            <td><a href="specie.php?id=<?php echo $sp->spID; ?>" target="_blank"><?php echo $species->getNomenclature($sp->spID); ?></a></td>
                            <td><?php echo $sp->year; ?></td>
                        </tr>
                        <?php $spTotal++; ?>
                        <?php endwhile; ?>
                    </tbody>
                    <tfoot>
                        <tr scope="row">
                            <td colspan="2">Total: <?php echo $spTotal; ?> species</td>
                        </tr>
                    </tfoot>
                </table>
                <?php endif; ?>
                <?php mysqli_free_result($spResult); ?>
            </div>
        </div>
    </div>
</div>
<?php mysqli_close($mysqli); ?>
<?php include_once 'modules/footer.php'; ?>
</body>
</html>