-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathstudentdisplay.php
67 lines (54 loc) · 1.68 KB
/
studentdisplay.php
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
<?php
require 'dbconfig/config.php';
?>
<!DOCTYPE html>
<html>
<!DOCTYPE html>
<html>
<head>
<title>
Student Display</title>
<link href="https://fonts.googleapis.com/icon?family=Material+Icons" rel="stylesheet">
<!--Import materialize.css-->
<link type="text/css" rel="stylesheet" href="/materialize/css/materialize.min.css" media="screen,projection"/>
<!--Let browser know website is optimized for mobile-->
<meta name="viewport" content="width=device-width, initial-scale=1.0"/>
<meta name="viewport" content="width=device-width, initial-scale=1">
<link rel="stylesheet" href="https://www.w3schools.com/w3css/4/w3.css">
<link rel="stylesheet" href="CSS/style.css">
</head>
<body>
<table class="responsive-table striped">
<thead>
<tr>
<td>USN</td>
<td>Name</td>
<td>Email</td>
<td>Contact</td>
<td>Semester</td>
<td>Subject</td>
<td>Action</td>
</tr>
</thead>
<?php
$query="CALL display()";
$query_run=mysqli_query($con,$query);
//echo $mysqli_fetch_assoc($query_run);
while($row=mysqli_fetch_assoc($query_run)){
echo "<tr>";
echo "<td>".$row['usn']."</td>";
echo "<td>".$row['name']."</td>";
echo "<td>".$row['email']."</td>";
echo "<td>".$row['contact']."</td>";
echo "<td>".$row['semester']."</td>";
echo "<td>".$row['subject']."</td>";
echo "<td><u><a href='updatestudent.php?u= ".$row['usn']." '>Update</a></u></td>";
echo "</tr>";
}
?>
</table>
<!--Import jQuery before materialize.js-->
<script type="text/javascript" src="https://code.jquery.com/jquery-3.2.1.min.js"></script>
<script type="text/javascript" src="/materialize/js/materialize.min.js"></script>
</body>
</html>