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 : gulbargaempdetails.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_oums";

$query  = "select empl.femplcode, empl.femplname, empl.fjoindate, desn.fdesnname, concat (empl.fdeptcode, '- ',dept.fdeptname) as client_name, empl.fbrthdate, empl.femplmobl, empl.femplphot  from {$db}.masempl empl
inner join {$db}.masdesn desn on empl.fdesncode=desn.fdesncode 
inner join {$db}.masdept dept on empl.fdeptcode=dept.fdeptcode where empl.femplstat='T' and empl.fdeptcode='001'";

//var_dump($query);

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

//var_dump($result);

$table = '</center>
    <table style="margin-left:2px;text-align: left;width: 90%;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="3%"><center>Sl. No.</center></th>
			 <th width="3%"><center>Employee Code</center></th>
             <th width="17%"><center>Employee Name</center></th>
             <th width="6%"><center>Date Of Join</center></th>
			 <th width="10%"><center>Designation</center></th>
       <th width="22%"><center>Client Name</center></th>
       <th width="6%"><center>Date Of Birth</center></th>
       <th width="7%"><center>Mobile Number</center></th>
       <th width="5%"><center>Photo</center></th>
       
			</tr>
		</thead>';

$i = 0;

while($row = mysqli_fetch_assoc($result))
    {
        $table .= "<tr bgcolor='#ffffff' >";
        $table .= "<td><center>".++$i."</center></td>";
        $table .= "<td><center>".$row['femplcode']."</center></td>";
        $table .= "<td>".$row['femplname']."</td>";
         $table .= "<td><center>".$row['fjoindate']."</center></td>";
        $table .= "<td><center>".$row['fdesnname']."</center></td>";
        $table .= "<td>".$row['client_name']."</td>";
		$table .= "<td><center>".$row['fbrthdate']."</center></td>";
        $table .= "<td><center>".$row['femplmobl']."</center></td>";
        $table .= "<td><center><img width='55' height='60' src='http://universitysolutions.in/oums/img-empl/".$row['femplphot']." '></center></td>";
        
        
        $table .= "</tr>";
    }

echo $table;

${this.title}

Code Editor : gulbargaempdetails.php