college-management-php/Student_MOP3.php at main · PawanCodeCrafts/college-management-php · 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
<?php
include("connect.php");
?>
<!DOCTYPE html>
<html>

<head>
    <meta charset="utf-8">
    <title>adminview_student</title>

    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css" rel="stylesheet" integrity="sha384-9ndCyUaIbzAi2FUVXJi0CjmCapSmO7SnpJef0486qhLnuZ2cdeRhO02iuK6FUUVM" crossorigin="anonymous">
    <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/js/bootstrap.bundle.min.js" integrity="sha384-geWF76RCwLtnZ8qwWowPQNguL3RmwHVBC9FhGdlKrxdiJJigb/j/68SIy3Te4Bkz" crossorigin="anonymous"></script>
    <link rel="icon" href="favicon.png" type="image/icon">
    <link href="fontawesome-free-6.4.0-web/css/all.css" rel="stylesheet">

    <style>
        * {
            background-color: #000000;
            color: #ffffff;
            margin-top: 20px;
        }

        .link {
            border: 1px solid #3ff7f1d7;
            border-radius: 3px;
            padding: 10px 27px;
            background-color: #3ff7f1d7;
            width: 200px;
            height: 30px;
            margin-left: 20px;
            text-decoration: none;
            font-size: 19px;
            font-weight: 550;
            color: #000000;
        }

        h2 {
            font-family: algerian;

        }

        .link:hover {
            background-color: #0ef9f1;
        }

        table {
            width: 100%;
            justify-content: center;
            align-items: center;
        }

        table th {
            height: 50px;
            font-size: 20px;
            width: 45px;
        }

        table td {
            height: 40px;
            font-size: 20px;
            width: 45px;
        }
    </style>
</head>

<body>
    <div class="form">
        <div>
            <a class="link" href="add_student.php">Add new Student</a>
        </div>
        <center>
            <h1 style="font-family:algerian;">View Student Record</h1>
        </center>
        <table width="100%" border="1" style="border-collapse:collapse;">
            <thead>
                <tr align="center">
                    <th><strong>S No.</strong></th>
                    <!-- <th><strong>student_id</strong></th> -->
                    <th><strong>Registration Id</strong></th>
                    <th><strong>Name</strong></th>
                    <th><strong>Department</strong></th>
                    <th><strong>Semester</strong></th>
                    <th><strong>Number</strong></th>
                    <th><strong>Whatsapp</strong></th>
                    <th><strong>Dial</strong></th>
                </tr>
            </thead>
            <tbody>
                <?php
                $count = 1;
                $sel_query = "Select * from student_contact Where department='mop' AND semester BETWEEN 5 AND 6 ORDER BY student_id ;";
                $result = mysqli_query($con, $sel_query);
                while ($row = mysqli_fetch_assoc($result)) { ?>
                    <tr>
                        <td align="center"><?php echo $count; ?></td>
                        <!-- <td align="center"><?php echo $row["student_id"]; ?></td> -->
                        <td align="center"><?php echo $row["registration_id"]; ?></td>
                        <td align="center"><?php echo $row["name"]; ?></td>
                        <td align="center"><?php echo $row["department"]; ?></td>
                        <td align="center"><?php echo $row["semester"]; ?></td>
                        <td align="center"><?php echo $row["number"]; ?></td>

                        <td align="center">
                            <a href="https://api.whatsapp.com/send?phone=<?php echo $row["number"]; ?>'&text=Hey" target="_blank">
        <i class="fab fa-whatsapp-square  whatsapp-icon" style="color: #11b632;"></i> </a>
                        </td>

                        <td align="center">

                        <a href="tel:+91 <?php echo $row["number"]; ?>" target="_blank">
    <i class="fa-solid fa-phone mobile-icon" style="color: #ffffff;"></i>
    </a>
                        </td>

                        <!-- <td align="center">
                            <a href="edit_student.php?student_id=<?php echo $row["student_id"]; ?>">Edit</a>
                        </td>
                        <td align="center">
                            <a href="delete_course.php?student_id=<?php echo $row["student_id"]; ?>">Delete</a>
                        </td> -->
                    </tr>
                <?php $count++;
                } ?>
            </tbody>
        </table>
    </div>
</body>

</html>