EPALM/admin.php at main · avats101/EPALM · 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
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
<?php
    require_once('dbconfig.php');
    $db = new operations();
    $result1 = $db->view_student_record();
    $result2 = $db->view_payment_record();
?>
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="utf-8">
  <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
  <title>EPALM ADMIN</title>
  <link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Roboto|Varela+Round">
  <link rel="stylesheet" href="https://fonts.googleapis.com/icon?family=Material+Icons">
  <script src="https://kit.fontawesome.com/3b4f2ecc11.js" crossorigin="anonymous"></script>
  <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.4.1/css/bootstrap.min.css" integrity="sha384-Vkoo8x4CGsO3+Hhxv8T/Q5PaXtkKtu6ug5TOeNV6gBiFeWPGFN9MuhOf23Q9Ifjh" crossorigin="anonymous">
  <script src="https://code.jquery.com/jquery-3.2.1.min.js"></script>
  <script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.11.0/umd/popper.min.js"
    integrity="sha384-b/U6ypiBEHpOf/4+1nzFpr53nxSS+GLCkfwBdFNTxtclqqenISfwAzpKaMNFNmj4" crossorigin="anonymous">
  </script>
  <script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0-beta/js/bootstrap.min.js"
    integrity="sha384-h0AbiXch4ZDo7tp9hKZ4TsHbi047NrKGLO3SEJAg45jXxnGIfYzk4Si90RDIqNm1" crossorigin="anonymous">
  </script>
    <link rel="stylesheet" href="css/style.css">
</head>
<body class="bg-dark">
<nav class="nav" id="topbar">
    <div class="logo">
      <a href="index.html"><img src="img/EPALM.png" style="width:80px;height:80px;" ></a>
    </div>
    <div id="mainListDiv" class="main_list">
      <ul class="navlinks">
        <li> <a href="admin.php">Administrator View</a></li>
        <li> <a href="index.html">Home</a></li>
      </ul>
    </div>
</nav>

<br><br><br>

    <div class="container">
        <div class="row">
            <div class="col">
                <div class="card mt-5">
                    <div class="card-header">
                        <h2 class="text-center text-dark">Student details </h2>
                    </div>
                    <div class="card-body">
                        <?php
                          //    $db->display_message();
                        //      $db->display_message();
                        ?>
                        <table class="table table-bordered">
                            <tr>
                                <td style="width: 20%"> Registration No. </td>
                                <td style="width: 20%"> First Name</td>
                                <td style="width: 10%"> Middle Name</td>
                                <td style="width: 15%"> Last Name</td>
                                <td style="width: 20%"> Mobile No.</td>
                                <td style="width: 20%"> Email</td>
                                <td style="width: 20%"> Password</td>
                                <td style="width: 20" colspan="2">Operations</td>
                            </tr>
                            <tr>
                                <?php

                                    while($data = mysqli_fetch_assoc($result1))
                                    {
                                ?>
                                    <td><?php echo $data['reg_num'] ?></td>
                                    <td><?php echo $data['firstName'] ?></td>
                                    <td><?php echo $data['middleName'] ?></td>
                                    <td><?php echo $data['lastName'] ?></td>
                                    <td><?php echo $data['mobile'] ?></td>
                                    <td><?php echo $data['Email'] ?></td>
                                    <td><?php echo $data['Password'] ?></td>
                                    <td><a href="register_edit.php?U_ID=<?php echo $data['reg_num'] ?>" class="btn btn-success">Edit</a></td>
                                    <td><a href="register_del.php?D_ID=<?php echo $data['reg_num'] ?>" class="btn btn-danger">Del</a></td>
                            </tr>
                            <?php
                                    }
                                ?>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>

    <div class="container">
        <div class="row">
            <div class="col">
                <div class="card mt-5">
                    <div class="card-header">
                        <h2 class="text-center text-dark"> Card details </h2>
                    </div>
                    <div class="card-body">
                        <?php
                             // $db->display_message();
                              //$db->display_message();
                        ?>
                        <table class="table table-bordered">
                            <tr>
                                <td style="width: 20%"> Card Number </td>
                                <td style="width: 20%"> Name on Card </td>
                                <td style="width: 10%"> CVV </td>
                                <td style="width: 15%"> Expiry Date </td>
                                <td style="width: 20%"> Mobile Number </td>
                                <td style="width: 20" colspan="2">Operations</td>
                            </tr>
                            <tr>
                                <?php

                                    while($data = mysqli_fetch_assoc($result2))
                                    {
                                ?>

                                    <td><?php echo $data['Card_Number'] ?></td>
                                    <td><?php echo $data['Name_on_Card'] ?></td>
                                    <td><?php echo $data['CVV'] ?></td>
                                    <td><?php echo $data['Expiry_Date'] ?></td>
                                    <td><?php echo $data['Registered_ph_no'] ?></td>

                                    <td><a href="cardedit.php?U_ID=<?php echo $data['Card_Number'] ?>" class="btn btn-success">Edit</a></td>
                                    <td><a href="carddel.php?D_ID=<?php echo $data['Card_Number'] ?>" class="btn btn-danger">Delete</a></td>
                            </tr>
                            <?php
                                    }
                                ?>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>

    <footer class="my-5 pt-5 text-light text-center text-small">
      <p class="mb-1">EPALM</p>
      <p class="mb-1">Made with <i class="fas fa-heart"></i> by</p>
      <ul class="list-inline">
        <li class="list-inline-item">Aryan Vats</li>
        <li class="list-inline-item">Arohan Mishra</li>
        <li class="list-inline-item">Aditya Joshi</li>
      </ul>
    </footer>

</body>
</html>