Reporte de excel con php y mysql Buenas tardes tengo este reporte en excel que corre perfecto en wampserver y
XAMPP, pero cuando lo monto en el servidor pues no funciona no hace nada ni síntomas de tratar de bajar el excel sera por el excel que esta en el servidor
si por favor le pueden dar una mirada se los agradecería.
<?php
SESSION_START();
if (!empty($_SESSION["user1"]) ){
$nombre=$_SESSION["user1"]
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title></title>
<style type="text/css">
<!--
.excel1 {
padding-top:1px;
padding-right:1px;
padding-left:1px;
color:black;
font-size:11.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Calibri, sans-serif;
text-align:general;
vertical-align:bottom;
border:none;
white-space:nowrap;
}
.excel2 {
padding-top:1px;
padding-right:1px;
padding-left:1px;
color:black;
font-size:11.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Calibri, sans-serif;
text-align:center;
vertical-align:bottom;
border:none;
white-space:nowrap;
}
.excel3 {
padding-top:1px;
padding-right:1px;
padding-left:1px;
color:white;
font-size:14.0pt;
font-weight:700;
font-style:normal;
text-decoration:none;
font-family:Calibri, sans-serif;
text-align:center;
vertical-align:bottom;
border:none;
white-space:nowrap;
background:black;
}
.excel4 {
padding-top:1px;
padding-right:1px;
padding-left:1px;
color:white;
font-size:14.0pt;
font-weight:700;
font-style:normal;
text-decoration:none;
font-family:Calibri, sans-serif;
text-align:general;
vertical-align:bottom;
border:none;
white-space:nowrap;
background:white;
}
.excel5 {
padding-top:1px;
padding-right:1px;
padding-left:1px;
color:white;
font-size:11.0pt;
font-weight:700;
font-style:normal;
text-decoration:none;
font-family:Calibri, sans-serif;
text-align:center;
vertical-align:bottom;
border:none;
white-space:nowrap;
background:black;
}
-->
</style>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta http-equiv="content-type" content="text/html; charset=iso-8859-1" />
</head>
<?php
header('Content-Type: application/vnd.ms-excel');
header('Content-Disposition: attachment;filename="usuarios.xls"');
header('Cache-Control: max-age=0');
$server = "localhost";
$usuario = "root";
$contraseña = "";
$bd = "contabilidad";
$conexion = mysqli_connect($server,$usuario,$contraseña,$bd)
or die ("error en conexión favor verificar la conexión");
?>
<body>
<table cellspacing="0" cellpadding="0" class="excel18">
<col width="24" style="width:18pt;" />
<col width="84" style="width:63pt;" />
<col width="133" style="width:100pt;" />
<col width="127" style="width:95pt;" />
<col width="119" style="width:89pt;" />
<col width="63" style="width:47pt;" />
<col width="115" style="width:86pt;" />
<col width="129" style="width:97pt;" />
<col width="113" style="width:85pt;" />
<col width="121" style="width:91pt;" />
<col width="115" style="width:86pt;" />
<col width="123" style="width:92pt;" />
<col width="25" style="width:19pt;" />
<tr style="height:15.0pt;">
<td colspan="3" rowspan="3" class="excel20" width="241" style="height:45.0pt;width:181pt;"><img src="C:\wamp\www\sistema\sistema\mantenimiento\ima genes/logoempresa.png"" /></td>
<td class="excel19" width="127" style="width:95pt;"></td>
<td class="excel19" width="119" style="width:89pt;"></td>
<td class="excel19" width="63" style="width:47pt;"></td>
<td class="excel19" width="115" style="width:86pt;"></td>
<td class="excel19" width="129" style="width:97pt;"></td>
<td class="excel19" width="113" style="width:85pt;"></td>
<td class="excel19" width="121" style="width:91pt;"></td>
<td class="excel19" width="115" style="width:86pt;"></td>
<td class="excel19" width="123" style="width:92pt;"></td>
<td class="excel19" width="25" style="width:19pt;"></td>
</tr>
<tr style="height:15.0pt;">
<td class="excel19" style="height:15.0pt;"></td>
<td class="excel19"></td>
<td class="excel19"></td>
<td class="excel19"></td>
<td class="excel19"></td>
<td class="excel19"></td>
<td class="excel19"></td>
<td class="excel19"></td>
<td class="excel19"></td>
<td class="excel19"></td>
</tr>
<tr style="height:15.0pt;">
<td class="excel19" style="height:15.0pt;"></td>
<td class="excel19"></td>
<td class="excel19"></td>
<td class="excel19"></td>
<td class="excel19"></td>
<td class="excel19"></td>
<td class="excel19"></td>
<td class="excel19"></td>
<td class="excel19"></td>
<td class="excel19"></td>
</tr>
<tr style="height:15.0pt;">
<td class="excel19" style="height:15.0pt;"></td>
<td class="excel19"></td>
<td class="excel19"></td>
<td class="excel19"></td>
<td class="excel19"></td>
<td class="excel19"></td>
<td class="excel19"></td>
<td class="excel19"></td>
<td class="excel19"></td>
<td class="excel19"></td>
<td class="excel19"></td>
<td class="excel19"></td>
<td class="excel19"></td>
</tr>
<tr style="height:18.75pt;">
<td class="excel19" style="height:18.75pt;"></td>
<td colspan="11" class="excel22">Listado de Usuarios</td>
<td class="excel19"></td>
</tr>
<tr style="height:2.25pt;">
<td class="excel19" style="height:2.25pt;"></td>
<td class="excel19"></td>
<td class="excel19"></td>
<td class="excel19"></td>
<td class="excel19"></td>
<td class="excel19"></td>
<td class="excel19"></td>
<td class="excel19"></td>
<td class="excel19"></td>
<td class="excel19"></td>
<td class="excel19"></td>
<td class="excel19"></td>
<td class="excel19"></td>
</tr>
<tr style="height:15.0pt;">
<td class="excel19" style="height:15.0pt;"></td>
<td class="excel21">Id_usuario</td>
<td class="excel21">Fecha</td>
<td class="excel21">Nombre </td>
<td class="excel21">Apellido </td>
<td class="excel21">Tipo </td>
<td class="excel21">Cedula </td>
<td class="excel21">Usuario </td>
<td class="excel21">Password</td>
<td class="excel21">Actividad </td>
<td class="excel21">Cargo</td>
<td class="excel21">Unidad</td>
<td class="excel19"></td>
</tr>
<?php
$consulta = (mysqli_query($conexion,"SELECT * FROM vistaadministrador ORDER BY id_administrador ASC" ));
while ($extraer = mysqli_fetch_array($consulta))
{
$id_administrador=$extraer['id_administrador'];
$fecha=$extraer['fecha'];
$nombre=$extraer['nombre'];
$apellido=$extraer['apellido'];
$nacionalidad=$extraer['nacionalidad'];
$cedula=$extraer['cedula'];
$user1=$extraer['user1'];
$pass1=$extraer['pass1'];
$tipo=$extraer['tipo'];
$cargo=$extraer['cargo'];
$unidad=$extraer['unidad'];
?>
<tr style="height:15.0pt;">
<td class="excel19" style="height:15.0pt;"></td>
<td class="excel20"><?php echo $id_administrador?></td>
<td class="excel24"><?php echo $fecha?></td>
<td class="excel19"><?php echo $nombre?></td>
<td class="excel19"><?php echo $apellido?></td>
<td class="excel20"><?php echo $nacionalidad?></td>
<td class="excel23"><?php echo $cedula?></td>
<td class="excel19"><?php echo $user1?></td>
<td class="excel23"><?php echo $pass1?></td>
<td class="excel19"><?php echo $tipo?></td>
<td class="excel23"><?php echo $cargo?></td>
<td class="excel23"><?php echo $unidad?></td>
<td class="excel19"></td>
</tr>
<?php
}
?>
</table>
</body>
</html>
<?php
}else{
echo "<br>";echo "<br>";echo "<br>";echo "<br>";echo "<br>";
echo "<center><h3><strong>USTED NO TIENE PERMISO PARA ENTRAR AL SISTEMA</strong></h3</center>";
echo "<center><h3><strong>CONTACTE CON EL ADMINISTRADOR</strong></h3></center>";
echo "<center>";
echo "<br>";
echo "<a href='cerrar.php'><span class='glyphicon glyphicon-log-out'></span> <button type='button' class='btn btn-primary' </button> Cerrar </button></a>";
echo "</ul>";
echo "</div>";
echo "</nav>";
echo "<center>";
}
?>
