-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathprogram10.php
98 lines (92 loc) · 2.11 KB
/
program10.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
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
#open mysql
#create database weblab;
#use weblab;
#create table student with usn, name and address as attributes
#insert values to student table
#write & execute the PHP code
<!DOCTYPE HTML>
<html>
<body>
<style>
table,td,th
{
border:1px solid black;
width:33%;
text-align:center;
border-collapse:collapse;
background-color:lightblue;
}
table{margin:auto;}
</style>
<?php
$servername="localhost"; #host or server name
$username="root"; #username of the mysql
$password="123"; #password of the mysql
$dbname="weblab"; #database name
$a=[];
$conn=mysqli_connect($servername,$username,$password,$dbname);
if($conn->connect_error)
die("connection failed:".$conn->connect_error);
$sql="SELECT *FROM student";
$result=$conn->query($sql);
echo"<br>";
echo"<center>BEFORE SORTING</CENTER>";
echo"<table border='2'>";
echo"<tr>";
echo"<th>USN</th><th>NAME</th><th>ADDRESS</th></tr>";
if($result->num_rows>0)
{ while($row=$result->fetch_assoc())
{ echo"<tr>";
echo"<td>".$row["USN"]."</td>";
echo"<td>".$row["NAME"]."</td>";
echo"<td>".$row["ADDRESS"]."</td></tr>";
array_push($a,$row["USN"]);
}
}
else
echo"Table is Empty";
echo"</table>";
$n=count($a);
$b=$a;
for($i=0;$i<($n-1);$i++)
{ $pos=$i;
for($j=$i+1;$j<$n;$j++)
{ if($a[$pos]>$a[$j])
$pos=$j;
}
if($pos!=$i)
{ $temp=$a[$i];
$a[$i]=$a[$pos];
$a[$pos]=$temp;
}
}
$c=[];
$d=[];
$result=$conn->query($sql);
if($result->num_rows>0)
{ while($row=$result->fetch_assoc())
{ for($i=0;$i<$n;$i++)
{ if($row["USN"]==$a[$i])
{
$c[$i]=$row["NAME"];
$d[$i]=$row["ADDRESS"];
}
}
}
}
echo"<br>";
echo"<center>AFTER SORTING</center>";
echo"<table border='2'>";
echo"<tr>";
echo"<th>USN</th><th>NAME</th><th>ADDRESS</th></tr>";
for($i=0;$i<$n;$i++)
{ echo"<tr>";
echo"<td>".$a[$i]."</td>";
echo"<td>".$c[$i]."</td>";
echo"<td>".$d[$i]."</td></tr>";
}
echo"</table>";
$conn->close();
?>
</body>
</html>