cs306db/record_s.php at master · edlcn/cs306db · 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
<?php
include "config.php";
?>

<form action = "record_select.php" method = "GET">
    <b>Record Id:</b>
    <select name = "rid">

        <?php

        $sql_comment = "SELECT DISTINCT rec_id FROM record";
        $myresult = mysqli_query($db,$sql_comment);
        echo "<option value = $rid>" . "any" ."</option>";
        while($id_rows = mysqli_fetch_assoc($myresult)){
            $rid = $id_rows["rec_id"];
            echo "<option value = >" . $rid ."</option>";
        }

        ?>

    </select>
    <br>
    <b>Patient Id:</b>
    <select name = "pid">

        <?php

        $sql_comment = "SELECT DISTINCT p_id FROM record";
        $myresult = mysqli_query($db,$sql_comment);
        echo "<option value = >" . "any" ."</option>";
        while($id_rows = mysqli_fetch_assoc($myresult)){
            $pid = $id_rows["p_id"];
            echo "<option value = $pid>". $pid . "</option>";
        }

        ?>

    </select>
    <br>
    <b>Date:</b>
    <select name = "date">

        <?php

        $sql_comment = "SELECT DISTINCT date FROM record";
        $myresult = mysqli_query($db,$sql_comment);
        echo "<option value = >" . "any" ."</option>";
        while($id_rows = mysqli_fetch_assoc($myresult)){
            $date = $id_rows["date"];
            echo "<option value = $date>". $date . "</option>";
        }

        ?>

    </select>
    <br>
    <button>SELECT</button>
</form>