printing to excel

20/07/2007, 21h07

I'm beginning to think I'm the queen of it worked before ... I used
this exact same page on another website I did. It worked
beautifully. On my site, it doesn't work. Instead of opening in
excel I get:

All of my data and ...

Warning: Cannot modify header information - headers already sent by
(output started at /home/smith/public_html/addressbook/ab_print.php:6)
in /home/smith/public_html/addressbook/ab_print.php on line 70

Warning: Cannot modify header information - headers already sent by
(output started at /home/smith/public_html/addressbook/ab_print.php:6)
in /home/smith/public_html/addressbook/ab_print.php on line 71

Warning: Cannot modify header information - headers already sent by
(output started at /home/smith/public_html/addressbook/ab_print.php:6)
in /home/smith/public_html/addressbook/ab_print.php on line 72

Warning: Cannot modify header information - headers already sent by
(output started at /home/smith/public_html/addressbook/ab_print.php:6)
in /home/smith/public_html/addressbook/ab_print.php on line 73

<HTML>
<HEAD>
</HEAD>
<BODY>

<?PHP include("../includes/connect.txt"); ?>
<?PHP
$sql = "SELECT * FROM $db_table4 ORDER BY category ASC, business ASC,
lastName ASC, firstName ASC";
$result = mysql_query ($sql, $connect) or die ('Query failed:
' .mysql_error());
echo "<TABLE CELLSPACING='2' CELLPADDING='2' BORDER='1'>";
echo "<TR>";
echo "<TD CLASS='title'>Category</TD>";
echo "<TD CLASS='title'>Business</TD>";
echo "<TD CLASS='title'>Name</TD>";
echo "<TD CLASS='title'>Address</TD>";
echo "<TD CLASS='title'>Address</TD>";
echo "<TD CLASS='title'>City</TD>";
echo "<TD CLASS='title'>State</TD>";
echo "<TD CLASS='title'>Zip</TD>";
echo "<TD CLASS='title'>Phone</TD>";
echo "<TD CLASS='title'>Cell</TD>";
echo "<TD CLASS='title'>Email</TD>";
echo "<TD CLASS='title'>Alternate Email</TD>";
echo "<TD CLASS='title'>AIM</TD>";
echo "<TD CLASS='title'>Notes</TD>";
echo "</TR>";
while ($row = mysql_fetch_array ($result))
{
echo "<TR>";
$business = $row['business'];
$lastName = $row['lastName'];
$firstName = $row['firstName'];
$category = $row['category'];
$telephone = $row['telephone'];
$area = substr($telephone,0,3);
$exchange = substr($telephone,3,3);
$rest = substr($telephone,6,4);
$cellphone = $row['cellphone'];
$areac = substr($cellphone,0,3);
$exchangec = substr($cellphone,3,3);
$restc = substr($cellphone,6,4);
$address1 = $row['address1'];
$address2 = $row['address2'];
$city = $row['city'];
$state = $row['state'];
$zip = $row['zipcode'];
$email1 = $row['email1'];
$$email2 = $row['$email2'];
$aimid = $row['aimid'];
$url = $row['url'];
$notes = $row['notes'];

echo "<TD>$category</TD>";
echo "<TD>$business</TD>";
echo "<TD>$lastName, $firstName</TD>";
echo "<TD>$address1</TD>";
echo "<TD>$address2</TD>";
echo "<TD>$city</TD>";
echo "<TD>$state</TD>";
echo "<TD>$zip</TD>";
echo "<TD>($area) $exchange-$rest</TD>";
echo "<TD>($areac) $exchangec-$restc</TD>";
echo "<TD>$email1</TD>";
echo "<TD>$email2</TD>";
echo "<TD>$aimid</TD>";
echo "<TD>$notes</TD>";
echo "</TR>";
}
echo "</TABLE>";
header("Content-type: application/octet-stream");
header("Content-Disposition: attachment; filename=addressbook.xls");
header("Pragma: no-cache");
header("Expires: 0");
?>

</BODY>
</HTML>

20/07/2007, 21h20

On Fri, 20 Jul 2007 22:07:25 +0200, gagal <lynettesmith@gmail.com> wrote:

> I'm beginning to think I'm the queen of it worked before ... I used
> this exact same page on another website I did. It worked
> beautifully. On my site, it doesn't work. Instead of opening in
> excel I get:
> Warning: Cannot modify header information - headers already sent by
> (output started at /home/smith/public_html/addressbook/ab_print.php:6)
> in /home/smith/public_html/addressbook/ab_print.php on line 70
>
> <?PHP include("../includes/connect.txt"); ?>
> <?PHP
> $sql = "SELECT * FROM $db_table4 ORDER BY category ASC, business ASC,
..........
> echo "</TABLE>";
> header("Content-type: application/octet-stream");
> header("Content-Disposition: attachment; filename=addressbook.xls");
> header("Pragma: no-cache");
> header("Expires: 0");
> ?>

Well, on the other server there's obviously some outbut buffering on. Just
move all of your header() statements up and run them first before all
other output or content.
--
Rik Wasmus

20/07/2007, 22h48

On Jul 20, 4:20 pm, Rik <luiheidsgoe...@hotmail.com> wrote:
> On Fri, 20 Jul 2007 22:07:25 +0200, gagal <lynettesm...@gmail.com> wrote:
> > I'm beginning to think I'm the queen of it worked before ... I used
> > this exact same page on another website I did. It worked
> > beautifully. On my site, it doesn't work. Instead of opening in
> > excel I get:
> > Warning: Cannot modify header information - headers already sent by
> > (output started at /home/smith/public_html/addressbook/ab_print.php:6)
> > in /home/smith/public_html/addressbook/ab_print.php on line 70
>
> > <?PHP include("../includes/connect.txt"); ?>
> > <?PHP
> > $sql = "SELECT * FROM $db_table4 ORDER BY category ASC, business ASC,
> .........
> > echo "</TABLE>";
> > header("Content-type: application/octet-stream");
> > header("Content-Disposition: attachment; filename=addressbook.xls");
> > header("Pragma: no-cache");
> > header("Expires: 0");
> > ?>
>
> Well, on the other server there's obviously some outbut buffering on. Just
> move all of your header() statements up and run them first before all
> other output or content.
> --
> Rik Wasmus

The problem could also be that display_errors is disabled on the
server.

In any event, Rik's solution should work.

20/07/2007, 21h07	#1
gagal Messages: n/a Hébergeur:	printing to excel I'm beginning to think I'm the queen of it worked before ... I used this exact same page on another website I did. It worked beautifully. On my site, it doesn't work. Instead of opening in excel I get: All of my data and ... Warning: Cannot modify header information - headers already sent by (output started at /home/smith/public_html/addressbook/ab_print.php:6) in /home/smith/public_html/addressbook/ab_print.php on line 70 Warning: Cannot modify header information - headers already sent by (output started at /home/smith/public_html/addressbook/ab_print.php:6) in /home/smith/public_html/addressbook/ab_print.php on line 71 Warning: Cannot modify header information - headers already sent by (output started at /home/smith/public_html/addressbook/ab_print.php:6) in /home/smith/public_html/addressbook/ab_print.php on line 72 Warning: Cannot modify header information - headers already sent by (output started at /home/smith/public_html/addressbook/ab_print.php:6) in /home/smith/public_html/addressbook/ab_print.php on line 73 <HTML> <HEAD> </HEAD> <BODY> <?PHP include("../includes/connect.txt"); ?> <?PHP $sql = "SELECT * FROM $db_table4 ORDER BY category ASC, business ASC, lastName ASC, firstName ASC"; $result = mysql_query ($sql, $connect) or die ('Query failed: ' .mysql_error()); echo "<TABLE CELLSPACING='2' CELLPADDING='2' BORDER='1'>"; echo "<TR>"; echo "<TD CLASS='title'>Category</TD>"; echo "<TD CLASS='title'>Business</TD>"; echo "<TD CLASS='title'>Name</TD>"; echo "<TD CLASS='title'>Address</TD>"; echo "<TD CLASS='title'>Address</TD>"; echo "<TD CLASS='title'>City</TD>"; echo "<TD CLASS='title'>State</TD>"; echo "<TD CLASS='title'>Zip</TD>"; echo "<TD CLASS='title'>Phone</TD>"; echo "<TD CLASS='title'>Cell</TD>"; echo "<TD CLASS='title'>Email</TD>"; echo "<TD CLASS='title'>Alternate Email</TD>"; echo "<TD CLASS='title'>AIM</TD>"; echo "<TD CLASS='title'>Notes</TD>"; echo "</TR>"; while ($row = mysql_fetch_array ($result)) { echo "<TR>"; $business = $row['business']; $lastName = $row['lastName']; $firstName = $row['firstName']; $category = $row['category']; $telephone = $row['telephone']; $area = substr($telephone,0,3); $exchange = substr($telephone,3,3); $rest = substr($telephone,6,4); $cellphone = $row['cellphone']; $areac = substr($cellphone,0,3); $exchangec = substr($cellphone,3,3); $restc = substr($cellphone,6,4); $address1 = $row['address1']; $address2 = $row['address2']; $city = $row['city']; $state = $row['state']; $zip = $row['zipcode']; $email1 = $row['email1']; $$email2 = $row['$email2']; $aimid = $row['aimid']; $url = $row['url']; $notes = $row['notes']; echo "<TD>$category</TD>"; echo "<TD>$business</TD>"; echo "<TD>$lastName, $firstName</TD>"; echo "<TD>$address1</TD>"; echo "<TD>$address2</TD>"; echo "<TD>$city</TD>"; echo "<TD>$state</TD>"; echo "<TD>$zip</TD>"; echo "<TD>($area) $exchange-$rest</TD>"; echo "<TD>($areac) $exchangec-$restc</TD>"; echo "<TD>$email1</TD>"; echo "<TD>$email2</TD>"; echo "<TD>$aimid</TD>"; echo "<TD>$notes</TD>"; echo "</TR>"; } echo "</TABLE>"; header("Content-type: application/octet-stream"); header("Content-Disposition: attachment; filename=addressbook.xls"); header("Pragma: no-cache"); header("Expires: 0"); ?> </BODY> </HTML>

20/07/2007, 21h20	#2
Rik Messages: n/a Hébergeur:	Re: printing to excel On Fri, 20 Jul 2007 22:07:25 +0200, gagal <lynettesmith@gmail.com> wrote: > I'm beginning to think I'm the queen of it worked before ... I used > this exact same page on another website I did. It worked > beautifully. On my site, it doesn't work. Instead of opening in > excel I get: > Warning: Cannot modify header information - headers already sent by > (output started at /home/smith/public_html/addressbook/ab_print.php:6) > in /home/smith/public_html/addressbook/ab_print.php on line 70 > > <?PHP include("../includes/connect.txt"); ?> > <?PHP > $sql = "SELECT * FROM $db_table4 ORDER BY category ASC, business ASC, .......... > echo "</TABLE>"; > header("Content-type: application/octet-stream"); > header("Content-Disposition: attachment; filename=addressbook.xls"); > header("Pragma: no-cache"); > header("Expires: 0"); > ?> Well, on the other server there's obviously some outbut buffering on. Just move all of your header() statements up and run them first before all other output or content. -- Rik Wasmus

20/07/2007, 22h48	#3
ZeldorBlat Messages: n/a Hébergeur:	Re: printing to excel On Jul 20, 4:20 pm, Rik <luiheidsgoe...@hotmail.com> wrote: > On Fri, 20 Jul 2007 22:07:25 +0200, gagal <lynettesm...@gmail.com> wrote: > > I'm beginning to think I'm the queen of it worked before ... I used > > this exact same page on another website I did. It worked > > beautifully. On my site, it doesn't work. Instead of opening in > > excel I get: > > Warning: Cannot modify header information - headers already sent by > > (output started at /home/smith/public_html/addressbook/ab_print.php:6) > > in /home/smith/public_html/addressbook/ab_print.php on line 70 > > > <?PHP include("../includes/connect.txt"); ?> > > <?PHP > > $sql = "SELECT * FROM $db_table4 ORDER BY category ASC, business ASC, > ......... > > echo "</TABLE>"; > > header("Content-type: application/octet-stream"); > > header("Content-Disposition: attachment; filename=addressbook.xls"); > > header("Pragma: no-cache"); > > header("Expires: 0"); > > ?> > > Well, on the other server there's obviously some outbut buffering on. Just > move all of your header() statements up and run them first before all > other output or content. > -- > Rik Wasmus The problem could also be that display_errors is disabled on the server. In any event, Rik's solution should work.

Outils de la discussion
Afficher une version imprimable Envoyer un lien vers cette page par email