Final-Database-Project/athlete.php at master · DubinosTech/Final-Database-Project · 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
<?php

    include_once "inc/prelude.php";
?>

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>COJO OLYMPIC GAMES PROJECT  :: Athlètes
    </title>
    <style>
        body {
            background-image: url(" r/olympic1.jpg");
        } </style>
    <?php include "inc/resources.php" ?>
</head>
<body>
    <div class="wrapper ">

        <header>
            <h1>COJO OLYMPIC GAMES PROJECT</h1>
            <?php breadcrumb("Athletes") ?>
        </header>

        <a href="newAthleteView.php" class="new">New</a>

        <?php
            connectDB();
            $sql = <<<EOF
            select d.id, d.pprenom, d.pnomDeFamille, d.pAdressePermanente, d.pAdresseVillage, d.aPays, d.aMedaille,s.name
            from cojoDatabase.Athlete d join
            (select id, id || ': ' || pprenom || ' ' || pnomDeFamille as name from cojoDatabase.Officiel) s
            on d.officiel = s.id;
EOF;
            $ret = pg_query($db, $sql);
            closeDB();

            if(!$ret) {
                echo pg_last_error($db);
            }
            else {
                datatable(["ID", "Prenom", "Nom", "Address Permanante", "Adresse Village", "Pays", "Medaille", "Superviseur"]);

                while ($row = pg_fetch_row($ret)) {
                    echo "<tr>";
                    for ($i = 0; $i < 8; $i++) {
                        echo "<td>", $row[$i], "</td>";
                    }
                    if(isset ($_SESSION['loggedin']) && $_SESSION['loggedin'])
                    {
                        editCell("Athlete", $row[0]);
                        deleteCell("Athlete", $row[0]);
                    }

                    echo "</tr>";
                }

                endDatatable();
            }
        ?>
    </div>
</body>
</html>