Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission
PDF	[ DIR ]	drwxrwxr-x
images	[ DIR ]	drwxrwxr-x
simplehtmldom	[ DIR ]	drwxrwxr-x
export.php	1.6 KB	-rwxr-xr-x
gul.php	2.93 KB	-rwxr-xr-x
gulbargabed.php	2.51 KB	-rwxr-xr-x
gulbargabped.php	2.5 KB	-rwxr-xr-x
gulbargaempdetails.php	2.47 KB	-rwxr-xr-x
gulbargapg.php	2.98 KB	-rwxr-xr-x
gulbargaug.php	2.61 KB	-rwxr-xr-x
gulbargauniv.html	2.2 KB	-rwxr-xr-x
index.html	5.12 KB	-rwxr-xr-x

Code Editor : gulbargaug.php

<?php

$servername = "logisys.cluster-cv9maxyrxjgg.ap-south-1.rds.amazonaws.com";
$username   = "admin";
$password  = "Logisys2104";

$conn = new  mysqli($servername,$username,$password);
if(!$conn) 
{
    die("Connection failed: " . mysqli_connect_error());
}

$db = "logisys3_gug";

$query  = "select distinct fdegree, fdescpn from {$db}.degree where fdeggrp='UG'";

//var_dump($query);

$result = mysqli_query($conn, $query);
$count = mysqli_num_rows($result);

$query1 = "select funivname, date_format(now(), '%d/%m/%Y %r') as fdate from {$db}.control"; 
// var_dump(expression)
$result1 = mysqli_query($conn, $query1);
$row1 = mysqli_fetch_assoc($result1);

$table = '<center><h1>'.$row1['funivname'].'</h1>
    </center>
    <table id="myTable1" style="height: 40px;" border="1" align="center">
            <tbody>
             </tr>
              <tr style="height: 40px; background-color:#ffeb3b94;">
                <td style="width: 450px; text-align: center; height: 40px;font-size: 20px;">
                 <b>UG Course Regulation</b>
                </td>
                <td style="width: 150px; height: 40px; text-align: center;font-size: 20px;">
                <a href="https://bcu.ac.in/Regulations/PDF/008_%20kswu%20uniREGULATIONS_UG_NON-CBCS_2016.pdf
                    " target="_blank"<b>Download</b></a></td>
                </tr>
              </tbody>
            </table>
          <br><br>

<table style="margin-left:2px;text-align: left;width: 60%;font-size:14px;margin: auto;" align-self="middle" cellspacing="1" cellpadding="5" border="0" align="center" bgcolor="#505151">
            <thead> 
            <tr style = "background-color:#8acc51">
            <th width="5%"><center>Sl. No.</center></th>
             <th width="10%"><center>Degree Code</center></th>
             <th width="35%"><center>Degree Name</center></th>
             <th width="10%"><center>Subjects Download</center></th>
            </tr>
        </thead>';  
$i = 0;

if($count > 0)
{
    while($row = mysqli_fetch_assoc($result))
    {
        $table .= "<tr bgcolor='#ffffff' >";
        $table .= "<td><center>".++$i."</center></td>";
        $table .= "<td><center>".$row['fdegree']."</center></td>";
        $table .= "<td>".$row['fdescpn']."</td>";
        $table .= "<td><a href='gul.php?fdegree=$row[fdegree]&val1=$db'>Download </a></td>";
        $table .= "</tr>";
    }
}
else
{
    $table .= "<tr bgcolor='#ffffff' >";
    $table .= "<td colspan='4'><center>Subjects not found</center></td>";
}

echo $table;

${this.title}

Code Editor : gulbargaug.php