<?php
$link = $mysqli_connect(
'localhost',
'user',
'password',
'database'
);
if (!$link){
die("DB connect error: ".mysqli_connect_error());
}
$query = 'SELECT * FROM tabla';
$result = mysqli_query($link,$query);
if(mysqli_num_rows($result)==0){
echo 'No hay informacion para la consulta';
}else{
$i=0;
$list=mysqli_fetch_fields($result);
while ($i<count(mysqli_fetch_fields($result))){
$field[]=$list[$i]->name;
$i++;
}
$i=0;
while ($row = mysqli_fetch_assoc($result)){
$ii=0;
while ($ii<count($fields)){
$dbrow[$i][$fields[$ii]] = $row[$field[$ii]];
$ii++;
}
$i++;
}
$i=0;
$th='<table><tr>';
while ($i<count($field)){
$th.='<th>'.$field[$i].'</th>';
$i++;
}
$th.='</tr></table>';
$i=0;
$td='<tr>';
while ($i<count($field)){
$td.='<td>'.$dbrow[$i].'</td>';
$i++;
}
$td.='</tr>';
echo $th;
echo $td;
}
?>