Final-Database-Project/editAthleteView.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
<?php
    include_once "inc/prelude.php";

    connectDB();

    $sql = "select * from cojoDatabase.Athlete where id = $1";
    $ret = pg_query_params($db, $sql, [$_GET["id"]]);
    closeDB();
    if (!$ret) {
        setFlash("This isn't the athlete you're looking for.");
        header("Location: doctors.php");
        exit;
    }
?>

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>COJO OLYMPIC GAMES PROJECT :: Modifier Athlete</title>
    <?php include "inc/resources.php" ?>
</head>
<body>
    <div class="wrapper">
        <header>
            <h1>COJO OLYMPIC GAMES PROJECT</h1>
            <?php breadcrumb("Modifier Athlete") ?>
        </header>

        <?php
            $r = pg_fetch_row($ret);

            ?><form action="doEditAthlete.php" method="POST">
                <input type="hidden" name="id" value="<?php echo $r[0] ?>"><br />
                Prenom: <input type="text" name="pprenom" value="<?php echo $r[1] ?>"><br />
                Nom: <input type="text" name="pnomDeFamille" value="<?php echo $r[2] ?>"><br />
                Adresse Permanante: <input type="text" name="pAdressePermanente" value="<?php echo $r[3] ?>"><br />
                Adresse Village: <input type="text" name="pAdresseVillage" value="<?php echo $r[4] ?>"><br />
                Pays: <input type="text" name="aPays" value="<?php echo $r[5] ?>"><br />
                Medaille: <input type="text" name="aMedaille" value="<?php echo $r[6] ?>"><br />
                Superviseur: <?php secretarySelect($r[7]); ?>
                <input type="submit" value="Submit">
            </form> <?php
        ?>

    </div>
</body>
</html>