query($sql);
// var_dump($result);
if($FUNIVCODE == '003')
{
$Databasename[] = 'logisys3_kus';
$Databasename[] = 'logisys3_kusd';
$Databasename[] = 'logisys3_uet';
}else if($FUNIVCODE == '027')
{
$Databasename[] = "logisys3_rcu";
}else if($FUNIVCODE == '008')
{
$Databasename[] = "logisys3_kswu";
}
else if($FUNIVCODE == '026')
{
$Databasename[] = "logisys3_vku";
}
else if($FUNIVCODE == '001')
{
$Databasename[] = "logisys3_gug";
}
else if($FUNIVCODE == '041')
{
$Databasename[] = "logisys3_bcu";
}
$table = '
Sl No. |
File Name |
Size |
Last Modified |
Action |
';
$i = 1;
$files = glob($db."/backup/*.zip");
// sort files by last modified date
usort($files, function($x, $y) {
return filemtime($x) < filemtime($y);
});
foreach ($files as $filename)
{
// var_dump($filename);
$del = basename($filename);
$table .='';
$table .=''.$i.' | ';
$table .=''.basename($filename).' | ';
$table .=''.formatSizeUnits(filesize($filename)).' | ';
$table .=''.date_default_timezone_set("Asia/Kolkata").' '.date("d/m/Y h:i A", filemtime($filename)).' | ';
$table .=' Download Delete | ';
$table .='
';
$i++;
}
$table .='';
$table .='
';
// var_dump($table);
$arr['database'] = $Databasename;
$arr['table'] = $table;
echo json_encode($arr);
}
function formatSizeUnits($bytes)
{
if ($bytes >= 1073741824)
{
$bytes = number_format($bytes / 1073741824, 2) . ' GB';
}
elseif ($bytes >= 1048576)
{
$bytes = number_format($bytes / 1048576, 2) . ' MB';
}
elseif ($bytes >= 1024)
{
$bytes = number_format($bytes / 1024, 2) . ' KB';
}
elseif ($bytes > 1)
{
$bytes = $bytes . ' bytes';
}
elseif ($bytes == 1)
{
$bytes = $bytes . ' byte';
}
else
{
$bytes = '0 bytes';
}
return $bytes;
}
?>