ho trovato in rete un piccolo script che dovrebbe consentire l'esportazione dei dati in formato excel.
Così il codice:
Risultato: una pagina vuota!Codice PHP:<?
$filename="allievi.xls";
header ("Content-Type: application/vnd.ms-excel");
header ("Content-Disposition: inline; filename=$filename");
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html lang=it><head>
<title></title></head>
<body>
<? require "config.php";
$link = mysql_connect($host, $dbuser, $dbpass)
or die("Impossibile connettersi al database");
mysql_select_db($dbname)
or die("Impossibile selezionare il database");
$id = $_GET["id"];
$result = mysql_query("SELECT * FROM `utenti` WHERE identita='$qlf' AND userid='$id'");
while ($row = mysql_fetch_array($result)) {
echo "<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\"><tr>";
echo "<td width=\"47%\" height=\"20\" align=\"right\" valign=\"middle\">";
echo "<font size=\"2\" face=\"Verdana, Arial, Helvetica, sans-serif\">[b]Nome[/b]</font></td>";
echo "<td width=\"6%\"></td><td align=\"left\" valign=\"middle\">";
echo $row["nome"];
echo "</td></tr><tr>";
echo "<td height=\"20\" align=\"right\" valign=\"middle\"><font size=\"2\" face=\"Verdana, Arial, Helvetica, sans-serif\">";
echo "[b]Cognome[/b]</font></td><td width=\"6%\"></td>";
echo "<td align=\"left\" valign=\"middle\">";
echo $row["cognome"];
echo "</td></tr><tr>";
echo "<td height=\"20\" align=\"right\" valign=\"middle\"><font size=\"2\" face=\"Verdana, Arial, Helvetica, sans-serif\">";
echo "[b]Data di nascita[/b]</font></td><td width=\"6%\"></td>";
echo "<td align=\"left\" valign=\"middle\">";
echo $row["datanascita"];
echo "</td></tr><tr>";
echo "<td height=\"20\" align=\"right\" valign=\"middle\"><font size=\"2\" face=\"Verdana, Arial, Helvetica, sans-serif\">";
echo "[b]Indirizzo[/b]</font></td><td width=\"6%\"></td>";
echo "<td align=\"left\" valign=\"middle\">";
echo $row["indirizzo"];
echo "</td></tr><tr>";
echo "<td height=\"20\" align=\"right\" valign=\"middle\"><font size=\"2\" face=\"Verdana, Arial, Helvetica, sans-serif\">";
echo "[b]Città[/b]</font></td><td></td>";
echo "<td align=\"left\" valign=\"middle\">";
echo $row["citta"];
echo "</td></tr><tr>";
echo "<td height=\"20\" align=\"right\" valign=\"middle\"><font size=\"2\" face=\"Verdana, Arial, Helvetica, sans-serif\">";
echo "[b]Provincia[/b]</font></td><td></td>";
echo "<td align=\"left\" valign=\"middle\">";
echo $row["provincia"];
echo "</td></tr><tr>";
echo "<td height=\"20\" align=\"right\" valign=\"middle\"><fAi?i?A ont size=\"2\" face=\"Verdana, Arial, Helvetica, sans-serif\">";
echo "[b]UserID[/b]</font></td><td width=\"6%\"></td>";
echo "<td align=\"left\" valign=\"middle\">";
echo $row["userid"];
echo "</td></tr><tr>";
echo "<td height=\"20\" align=\"right\" valign=\"middle\"><font size=\"2\" face=\"Verdana, Arial, Helvetica, sans-serif\">";
echo "[b]Password[/b]</font></td><td width=\"6%\"></td>";
echo "<td align=\"left\" valign=\"middle\">";
echo $row["password"];
echo "</td></tr><tr>";
echo "<td align=\"right\" valign=\"middle\"><hr></td><td width=\"6%\"><hr></td><td align=\"left\" valign=\"middle\"><hr></td></tr>";
}
?></table></body></html>
Rispondi quotando
