task
task 1:<?php //Complete sorting functionality without using any inbuilt sorting related functions $arr = [50,20,35,15,45]; echo "Before Sorting <br/>"; print_r($arr); //sorting logic start //write your code here //sorting logic end echo "After Sorting <br/>" print_r($arr); ?>
task:2
With out using limit in query, display 2nd highest rank person
task
programm
<?php
$arr = [50, 20, 35, 15, 45];
echo "Before Sorting <br/>";
print_r($arr);
// sorting logic start
$length = count($arr);
for ($i = 0; $i < $length - 1; $i++) {
for ($j = 0; $j < $length - $i - 1; $j++) {
if ($arr[$j] > $arr[$j + 1]) {
// swap elements
$temp = $arr[$j];
$arr[$j] = $arr[$j + 1];
$arr[$j + 1] = $temp;
}
}
}
// sorting logic end
echo "After Sorting <br/>";
print_r($arr);
?>
<!-- With out using limit in query, display 2nd highest rank person -->
<!-- SELECT Rank
FROM Persons
WHERE Rank < (SELECT MAX(Rank) FROM Persons)
ORDER BY Rank DESC -->
No comments:
Post a Comment