Server : Apache System : Linux profile 3.10.0-1160.88.1.el7.x86_64 #1 SMP Tue Mar 7 15:41:52 UTC 2023 x86_64 User : apache ( 48) PHP Version : 8.0.28 Disable Function : NONE Directory :  /var/www/html/venkat/army1/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

<?php
include("inde.php");
include("db1.php");
include("session.php");
echo("<div align = 'center'>");
        $sql = $conn->prepare("SELECT post FROM armypost order by desiorder");
        $sql->execute();
        $row = $sql->rowCount();
        while ($row = $sql->fetch()) {
                $desi = $row['post'];

   echo('<table style="float: left" border = "1">');
    echo('<tr> <td colspan = 4><center>'.$desi.'</center> </td> </tr>');
    echo('<tr><td> SL. NO. </td><td> ARMY ID </td> <td>NAME </td> <td> TYPE </td> </tr>');
        $sql1 = $conn->prepare("SELECT name,army_id,type FROM armyleave where designation = :desi");
                        $sql1->bindValue(':desi',$desi);
                        $sql1->execute();
                        $row = $sql1->rowCount();
			$i = 1;
                        while ($row = $sql1->fetch()) {
                                $name = $row['name'];
                                $army_id = $row['army_id'];
                                $type = $row['type'];
                                echo "<tr> <td>".$i++."</td><td>".$army_id."</td><td>".$name."</td><td>".$type."</td></tr>";
                        }
    echo "</table>";
   }
    echo "</div>";
?>