Future Vision BIE
ONE STOP FOR ALL STUDY MATERIALS & LAB PROGRAMS
×
Note
Login Made Mandatory to Access the Free Study Materials
-ADMIN
Page Loading! Please Wait
WEB TECHNOLOGY LABORATORY WITH MINI PROJECT
17CSL77
15CSL77
[As per Choice Based Credit System (CBCS) scheme]
CREDITS – 02
Subject Code - 17CSL77
SEMESTER - VII
Advertisement
WEB TECHNOLOGY LABORATORY WITH MINI PROJECT
17CSL77
Program - 10
Write a PHP program to sort the student records which are stored in the database
using selection sort.
Authentication Successful But Step-2 is Pending. Complete Step-2 to Access Study Materials
Or Logout & Login with an Another Account
You have not logged in to the Future Vision BIE.
Sorry to inform you, Your Account Has been Blocked. By the Admin.
Your User ID: ID
Advertisement
You Have Successfully Logged in.
Welcome,User
Your User ID: ID
PROGRAM 10
Write a PHP program to sort the student records which are stored in the database
using selection sort.
File Name: pro10.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
68 | <?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "weblab";
$conn = mysqli_connect($servername, $username, $password, $dbname);
if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}
$sql = "SELECT * FROM student";
$result = $conn->query($sql);
$usn = array() ;
echo "<table border='2'><caption>Before Sorting </caption><br>";
echo "<tr><th>USN</th><th>NAME</th><th>Marks</th></tr>";
if ($result->num_rows > 0)
{
while($row = $result->fetch_assoc())
{
echo "<tr><td>". $row["usn"]."</td>";
echo "<td>". $row["name"]."</td>";
echo "<td>". $row["marks"]."</td></tr>";
$usn[] = $row["usn"] ;
}
}
$n = sizeof($usn) ;
for($i = 0 ; $i < $n-1 ; $i++ )
{
$pos = $i ;
for($j = $i + 1 ; $j < $n ; $j++ )
{
if( $usn[$pos] < $usn[$j])
{
$pos = $j ;
}
}
if( $pos != $i)
{
$temp = $usn[$i] ;
$usn[$i] = $usn[$pos] ;
$usn[$pos] = $temp ;
}
}
$name = [] ;
$marks = [] ;
$result = $conn->query($sql);
if ($result->num_rows> 0)
{
while($row = $result->fetch_assoc())
{
for($i=0;$i<$n;$i++)
{
if($row["usn"] == $usn[$i])
{
$name[$i]=$row["name"];
$marks[$i]=$row["marks"];
}
}
}
}
echo "<br><table border='2'><caption>After Sorting </caption><br>";
echo "<tr><th>USN</th><th>NAME</th><th>Marks</th></tr>";
for($i = 0 ; $i < sizeof($usn) ; $i++)
{
echo "<tr><td>". $usn[$i]."</td>";
echo "<td>". $name[$i]."</td>";
echo "<td>". $marks[$i]."</td></tr>";
}
?>
|
Output
Advertisement
×
Note
Page Number is specified to navigate between Pages...
SYS = Syllabus
P = Program
-ADMIN
×
Note
ANY PROBLEM IN Login or Downloading, YOU ARE FREE TO CONTACT US...
-ADMIN
Advertisement
lIKE OUR CONTENT SUPPORT US BY FOLLOWING US ON INSTAGRAM : @futurevisionbie
More Materials will BE UPLOADED "AS SOON AS POSSIBLE"
For immediate Notification Join the Telegram Channel
7th Core Subject
▣ 17CS71 - Web Technology and its applications - WTA
▣ 17CS72 - Advanced Computer Architectures - ACA
▣ 17CS73 - Machine Learning - ML
7th Professional Elective - 3
▣ 17CS741 - Natural Language Processing - NLP
▣ 17CS742 - Cloud Computing and its Applications - CCA
▣ 17CS743 - Information and Network Security - INS
▣ 17CS744 - Unix System Programming - USP
7thProfessional Elective - 4
▣17CS751 - Soft and Evolutionary Computing - SEC
▣17CS752 - Computer Vision and Robotics - CVR
▣ 17CS753 - Digital Image Processing - DIP
▣17CS754 - Storage Area Networks - SAN
7th Lab & Project
▣17CSL76 - Machine Learning Laboratory - ML Lab
▣17CSL77 - Web Technology Laboratory with mini project -
WTA Lab
▣17CSP78 - Project Work Phase–I + Project work Seminar -
Project
