<?php
$mysqli = new mysqli($dbconfig['db_server'],$dbconfig['db_username'],$dbconfig['db_password'],$dbconfig['db_name']);
if ($mysqli->connect_errno) {
die( "Failed to connect to MySQL Vtiger: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error);
}
$mysqli->set_charset("utf8");
$query = "SELECT * FROM tbl1 ";
$res = $mysqli->query($query);
?>
<table border=0 cellspacing=1 cellpadding=3 width="100%" class="lvt small">
<tr>
<td class="lvtCol">#</td>
<?php while ($f = $res->fetch_field()) { ?>
<td class="lvtCol"><strong><?php echo $f->table.".".$f->name; ?></strong></td>
<?php } ?>
</tr>
<?php $c=0; while($row = $res->fetch_array(MYSQLI_NUM)){ $c++; ?>
<tr bgcolor=white onMouseOver="this.className='lvtColDataHover'" onMouseOut="this.className='lvtColData'">
<td><?php echo $c; ?></td>
<?php for($i=0; $i < $res->field_count; $i++){ ?>
<td <?php if(is_numeric($row[$i])){ ?> style="text-align:right;" <?php } ?> nowrap="nowrap">
<?php
echo is_numeric($row[$i]) ? number_format($row[$i]) : $row[$i];
if(is_numeric($row[$i])){
$sum[$i] = !isset($sum[$i]) ? $row[$i] : $sum[$i]+$row[$i];
}
?>
</td>
<?php } ?>
</tr>
<?php } ?>
<tr>
<td></td>
<?php for($i=0; $i < $res->field_count; $i++){ ?>
<td style=" text-align:right;"><?php if(isset($sum[$i])){ echo '<strong>'.number_format($sum[$i]).'</strong>'; } ?></td>
<?php } ?>
</tr>
</table>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<title>Icon Font</title>
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/font-awesome/4.5.0/css/font-awesome.min.css">
</head>
<body>
<i class="fa fa-camera-retro fa-lg"></i> fa-lg
<i class="fa fa-camera-retro fa-2x"></i> fa-2x
<i class="fa fa-camera-retro fa-3x"></i> fa-3x
<i class="fa fa-camera-retro fa-4x"></i> fa-4x
<i class="fa fa-camera-retro fa-5x"></i> fa-5x
<div class="list-group">
<a class="list-group-item" href="#"><i class="fa fa-home fa-fw"></i> Home</a>
<a class="list-group-item" href="#"><i class="fa fa-book fa-fw"></i> Library</a>
<a class="list-group-item" href="#"><i class="fa fa-pencil fa-fw"></i> Applications</a>
<a class="list-group-item" href="#"><i class="fa fa-cog fa-fw"></i> Settings</a>
</div>
<i class="fa fa-spinner fa-spin"></i>
<i class="fa fa-circle-o-notch fa-spin"></i>
<i class="fa fa-refresh fa-spin"></i>
<i class="fa fa-cog fa-spin"></i>
<i class="fa fa-spinner fa-pulse"></i>
</body>
</html>
