PROG 10

10. Write a PHP program to sort the student records which are stored in the database using selection sort. Goto Mysql and then type
create database weblab; 
use weblab; create table student(usnvarchar(10),name varchar(20),address varchar(20));

program10.php

<!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"; $username = "root"; $password = "root"; $dbname = "weblab"; $a=[];   // Create connection
// Opens a new connection to the MySQL server 
$conn = mysqli_connect($servername, $username, $password, $dbname); 
  

if ($conn->connect_error)  die("Connection failed: " . $conn->connect_error);

$sql = "SELECT * FROM student"; // performs a query against the database $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) { // output data of each row and fetches a result row as an associative array while($row = $result->fetch_assoc()){    echo "<tr>";    echo "<td>". $row["usn"]."</td>";    echo "<td>". $row["name"]."</td>";    echo "<td>". $row["addr"]."</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)// output data of each row {       while($row = $result->fetch_assoc()) {    for($i=0;$i<$n;$i++) {      if($row["usn"]== $a[$i]) {       $c[$i]=$row["name"];      $d[$i]=$row["addr"];      }     }    } } 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>

Comments

Post a Comment

Popular posts from this blog

PROG 6

6. Write a PHP program to keep track of the number of visitors visiting the web page and to display this count of visitors, with proper headings. program6.php <?php print "<h3> REFRESH PAGE </h3>"; $name="counter.txt"; $file = fopen($name,"r"); $hits= fscanf($file,"%d"); fclose($file); $hits[0]++; $file = fopen($name,"w"); fprintf($file,"%d",$hits[0]); fclose($file); print "Total number of views: ".$hits[0]; ?>
Read more

PROG 7

7. Write a PHP program to display a digital clock which displays the current time of the server. program7.php <!DOCTYPE HTML> <html> <head> <meta http-equiv="refresh" content="1"/> <style>  p {    color:white;    font-size:90px;    position: absolute;    top: 50%;    left: 50%;    transform: translate(-50%, -50%);   }   body{background-color:black;}  </style>  <p> <?php echo date(" h: i : s  A");?> </p> </head> <html>
Read more

PROG 2

2. Write a JavaScript that calculates the squares and cubes of the numbers from 0 to 10 and outputs HTML text that displays the resulting values in an HTML table format. program2.html <!DOCTYPE HTML> <html> <head> <style> table,tr, td { border: solid black; width: 33%; text-align: center; border-collapse: collapse; background-color:lightblue; } table { margin: auto; } </style> <script> document.write( "<table><tr><th colspan='3'> NUMBERS FROM 0 TO 10 WITH THEIR SQUARES AND CUBES </th></tr>" ); document.write( "<tr><td>Number</td><td>Square</td><td>Cube</td></tr>" ); for(var n=0; n<=10; n++) { document.write( "<tr><td>" + n + "</td><td>" + n*n + "</td><td>" + n*n*n + "</td></tr>" ) ; } document.write( "</table>" ) ...
Read more