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

<form action = "stores_d.php" method = "GET">
    <b>Clerk ID:</b>
    <select name = "ids">

        <?php

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

        ?>

    </select>
    <br>
    <b>Record ID:</b>
    <select name = "pids">

        <?php

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

        ?>

    </select>
    <br>
    <button>DELETE</button>
</form>