hackathon/viewfaculty.php at main · theziya/hackathon · 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
<html>
    <head>
        <meta charset="UTF-8">
        <link rel="stylesheet" href="style.css">
        <meta name="viewport" content="width=device-width, initial-scale=1">
        <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css">
        <link href="https://fonts.googleapis.com/css2?family=STIX+Two+Math&display=swap" rel="stylesheet">
        <link href="http://fonts.cdnfonts.com/css/anurati" rel="stylesheet">

        <title></title>
    </head>
    <body>
        <div class="navbar1">
            <img src="images/smplogo.png" alt="logo" class="logo"/>
            <ul>
                <li><a href="index.php">HOME</a></li>
                <li><a href="addstudent.php">ADD STUDENT</a></li>
                <li><a href="addfaculty.php">ADD FACULTY</a></li>
                <li><a href="viewstudent.php">VIEW STUDENT</a></li>
                <li><a href="logout.php">LOGOUT</a></li>
            </ul>
        </div>
    <center><span class="h1">FACULTY LIST</span></center><br/><br/>
    <div class="table">
        <table class="table table-striped">
            <thead>
                <tr>
                    <th scope="col">#</th>
                    <th scope="col">FACULTY NAME</th>
                    <th scope="col">COURSE</th>
                    <th scope="col">SUBJECT</th>
                    <th scope="col">USERNAME</th>
                    <th scope="col">PASSWORD</th>

                </tr>
            </thead>
            <tbody>
                <?php
                include 'dbconfigg.php';
                $records = mysqli_query($conn, "select * from facultydetails"); // fetch data from database
                $i = 0;
                while ($data = mysqli_fetch_array($records)) {
                    $i = $i + 1;
                    $id = $data['id'];
                    ?>
                    <tr>
                        <th scope = "row"><?php echo "$i"; ?></th>
                        <td><?php echo $data['name'] ?></td>
                        <td><?php echo $data['course'] ?></td>
                        <td><?php echo $data['subject'] ?></td>
                        <td><?php echo $data['username'] ?></td>
                        <td><?php echo $data['pswd'] ?></td>
                        <td><a href="delfaculty.php?id=<?php echo $id ?>">delete</a></td>
                    </tr>
                    <?php
                }
                ?>
            </tbody>
        </table>
    </div>
     <div id="footer">
            <p>Copyright &copy; SMP | <a href="#">SAGAR</a> | <a href="#">2021</a> </p>
        </div>
</body>
</html>