Re: can't redirect to Excel

[Paul Lautman]

JRough wrote:

>I have tried this 4 2 weeks and I need some help. There are 3 other
pages referenced on this page but I'm going to start with this page
in case I missed something. It is called current_sightings.php. All
I want to do is redirect to Excel in the case of the External user.
The first if statement creates a form. The elseif redirects the
external user to only his own listings. I want the results for the
Internal user query SELECT_sightings_leasecars.() to go to my
current_sightingsXL.php page. Where/How would I put the redirect? I
think it should be after the switch for external users. The
getTableHeaders() function is the string that gets passed. All the
pages work except I can't redirect the output to Excel.

What do you mean by "redirect the output to Excel"??? Excel isn't a
location, it's a spreadsheet program that some (but not all users) will have
on their machine.

BTW, Location: is supposed to take a fully qualified URL.

[Jeff]

Paul Lautman wrote:

JRough wrote:

>I have tried this 4 2 weeks and I need some help. There are 3 other
pages referenced on this page but I'm going to start with this page
in case I missed something. It is called current_sightings.php. All
I want to do is redirect to Excel in the case of the External user.
The first if statement creates a form. The elseif redirects the
external user to only his own listings. I want the results for the
Internal user query SELECT_sightings_leasecars.() to go to my
current_sightingsXL.php page. Where/How would I put the redirect? I
think it should be after the switch for external users. The
getTableHeaders() function is the string that gets passed. All the
pages work except I can't redirect the output to Excel.

What do you mean by "redirect the output to Excel"??? Excel isn't a
location, it's a spreadsheet program that some (but not all users) will have
on their machine.

BTW, Location: is supposed to take a fully qualified URL.

What is a fully qualified URL? A Google search has left me more confused
than before.

Now, this is of course, fully qualified:

header("Location: http://www.example.com/");

and this presumably isn't:

header("Location: www.example.com/");

But what about this?:

header("Location: /new_page_in_html_root.html");

or:

header("Location: page_in_same_directory.html");

Now, as far as what the op wants, which isn't clear, you can use a
header statement (and have it work) as long as there the is no html
outputted (either echoed or embedded) before the header.
Jeff

>

[Paul Lautman]

Jeff wrote:

Paul Lautman wrote:

>JRough wrote:

>>I have tried this 4 2 weeks and I need some help. There are 3 other
pages referenced on this page but I'm going to start with this page
in case I missed something. It is called current_sightings.php. All I
want to do is redirect to Excel in the case of the External
user. The first if statement creates a form. The elseif
redirects the external user to only his own listings. I want the
results for the Internal user query SELECT_sightings_leasecars.()
to go to my current_sightingsXL.php page. Where/How would I put
the redirect? I think it should be after the switch for external
users. The getTableHeaders() function is the string that gets
passed. All the pages work except I can't redirect the output to
Excel.

What do you mean by "redirect the output to Excel"??? Excel isn't a
location, it's a spreadsheet program that some (but not all users)
will have on their machine.

BTW, Location: is supposed to take a fully qualified URL.

What is a fully qualified URL? A Google search has left me more
confused than before.

Now, this is of course, fully qualified:

header("Location: http://www.example.com/");

and this presumably isn't:

header("Location: www.example.com/");

But what about this?:

header("Location: /new_page_in_html_root.html");

or:

header("Location: page_in_same_directory.html");

From the php manual:
HTTP/1.1 requires an absolute URI as argument to Location: including the
scheme, hostname and absolute path, but some clients accept relative URIs.
You can usually use $_SERVER['HTTP_HOST'], $_SERVER['PHP_SELF'] and
dirname() to make an absolute URI from a relative one yourself:
<?php
header("Location: http://" . $_SERVER['HTTP_HOST']
. rtrim(dirname($_SERVER['PHP_SELF']), '/\\')
. "/" . $relative_url);
?>

Now, as far as what the op wants, which isn't clear, you can use a
header statement (and have it work) as long as there the is no html
outputted (either echoed or embedded) before the header.

I have absolutely no idea what the OP wants since what he described doesn't
exist.

[John Dunlop]

Jeff:

What is a fully qualified URL?

One that is absolute, not relative, I would presume.

A Google search has left me more confused than before.

Likely bitten by the terminology: "fully qualified" collocates with
domain names; "absolute" is a technical term to describe URLs.

Now, this is of course, fully qualified:

header("Location:http://www.example.com/");

and this presumably isn't:

header("Location:www.example.com/");

Indeed.

But what about this?:

header("Location: /new_page_in_html_root.html");

Termed an "absolute-path reference". Not an absolute URL, so violates
RFC 2616.

or:

header("Location: page_in_same_directory.html");

Termed a "relative-path reference". Again, not an absolute URL.

--
Jock

[John Dunlop]

Bill H:

print "Content-type: application/excel\n\n";

application/vnd.ms-excel is the registered MIME type.

then print out the spreadsheet contents (probably in CSV format)

text/csv fits the bill.

application/x-msdownload is one of Internet Explorer's "known" MIME
types, but without wading through Microsoft's *cough* documentation of
this bu^H^Hfeature,* I don't know how Internet Explorer handles it.
Suffice to say, subtypes prefixed with "x-" are discouraged by RFC
2048, even more so when an appropriate type has already been
registered.

* http://msdn.microsoft.com/en-us/library/ms775147.aspx

--
Jock

[JRough]

On Jul 19, 10:54 am, John Dunlop <[e-mail]:

Bill H:

print "Content-type: application/excel\n\n";

application/vnd.ms-excel is the registered MIME type.

then print out the spreadsheet contents (probably in CSV format)

text/csv fits the bill.

application/x-msdownload is one of Internet Explorer's "known" MIME
types, but without wading through Microsoft's *cough* documentation of
this bu^H^Hfeature,* I don't know how Internet Explorer handles it.
Suffice to say, subtypes prefixed with "x-" are discouraged by RFC
2048, even more so when an appropriate type has already been
registered.

*http://msdn.microsoft.com/en-us/library/ms775147.aspx

--
Jock

Thanks for the link.

That is interesting. First I have been using Firefox but I am sure
that the users are using IE. So I will try it in IE on Monday. There
is no IE on the Mac.
This by the way seemed to works in my browser at leaset not saying it
is the right way or it works in IE.

>print "$header\n$data";
print "Content-type: application/excel\n\n"

How would you add the csv extension? Something like this?
print "$header\n$data"."csv";
print "Content-type: application/vnd.ms-excel\n\n"

I'll see if I can figure out where to put the redirect on the first
page :-(

[Bill H]

On Jul 19, 3:13*pm, JRough <[e-mail]:

On Jul 19, 10:54 am, John Dunlop <[e-mail]:

Bill H:

print "Content-type: application/excel\n\n";

application/vnd.ms-excel is the registered MIME type.

then print out the spreadsheet contents (probably in CSV format)

text/csv fits the bill.

application/x-msdownload is one of Internet Explorer's "known" MIME
types, but without wading through Microsoft's *cough* documentation of
this bu^H^Hfeature,* I don't know how Internet Explorer handles it.
Suffice to say, subtypes prefixed with "x-" are discouraged by RFC
2048, even more so when an appropriate type has already been
registered.

*http://msdn.microsoft.com/en-us/library/ms775147.aspx

--
Jock

Thanks for the link.

That is interesting. *First I have been using Firefox but I am sure
that the users are using IE. *So I will try it in IE on Monday. *There
is no IE on the Mac.
This by the way seemed to works in my browser *at leaset not saying it
is the right way or it works in IE.

print "$header\n$data";
print "Content-type: application/excel\n\n"

How would you add the csv extension? *Something like this?
print "$header\n$data"."csv";
print "Content-type: *application/vnd.ms-excel\n\n"

I'll see if I can figure out where to put the redirect on the first
page :-(- Hide quoted text -

- Show quoted text -

I think (and I could be wrong) that with php you are used to using
print $header to get a header for an html page, but with perl we roll
our own header. In this case the header is:

print "Content-type: text/csv\n\n" (thanks John Dunlop)

For example (please excuse the use of perl code, I am learning php but
have been using perl for 10 years) if I wanted to send a simple CSV
(comma seperated value) spread sheet that contained a multiplication
table when they clicked on a link I would use the following code as
the address of the link they clicked:

#!/usr/bin/perl

print "content-type: text/csv\n\n";
print qq~"","1","2","3","4","5","6","7","8","9","10"\n~ ;
for($row = 1;$row < 11;$row++)
{
print qq~"$row"~;
for($col = 1;$col < 11;$col++)
{
$t = $row * $col;
print qq~,"$t"~;
}
print "\n";
}
exit;

Bill H

[JRough]

On Jul 19, 12:57 pm, Bill H <[e-mail]:

On Jul 19, 3:13 pm, JRough <[e-mail]:

On Jul 19, 10:54 am, John Dunlop <[e-mail]:

Bill H:

print "Content-type: application/excel\n\n";

application/vnd.ms-excel is the registered MIME type.

then print out the spreadsheet contents (probably in CSV format)

text/csv fits the bill.

application/x-msdownload is one of Internet Explorer's "known" MIME
types, but without wading through Microsoft's *cough* documentation of
this bu^H^Hfeature,* I don't know how Internet Explorer handles it.
Suffice to say, subtypes prefixed with "x-" are discouraged by RFC
2048, even more so when an appropriate type has already been
registered.

*http://msdn.microsoft.com/en-us/library/ms775147.aspx

--
Jock

Thanks for the link.

That is interesting. First I have been using Firefox but I am sure
that the users are using IE. So I will try it in IE on Monday. There
is no IE on the Mac.
This by the way seemed to works in my browser at leaset not saying it
is the right way or it works in IE.

>print "$header\n$data";
>print "Content-type: application/excel\n\n"

How would you add the csv extension? Something like this?
print "$header\n$data"."csv";
print "Content-type: application/vnd.ms-excel\n\n"

I'll see if I can figure out where to put the redirect on the first
page :-(- Hide quoted text -

- Show quoted text -

I think (and I could be wrong) that with php you are used to using
print $header to get a header for an html page, but with perl we roll
our own header. In this case the header is:

print "Content-type: text/csv\n\n" (thanks John Dunlop)

For example (please excuse the use of perl code, I am learning php but
have been using perl for 10 years) if I wanted to send a simple CSV
(comma seperated value) spread sheet that contained a multiplication
table when they clicked on a link I would use the following code as
the address of the link they clicked:

#!/usr/bin/perl

print "content-type: text/csv\n\n";
print qq~"","1","2","3","4","5","6","7","8","9","10"\n~ ;
for($row = 1;$row < 11;$row++)
{
print qq~"$row"~;
for($col = 1;$col < 11;$col++)
{
$t = $row * $col;
print qq~,"$t"~;
}
print "\n";}

exit;

Bill H

Actually this will work, because I have a others of these to do. I
have some pages with URL links that when the user clicks it he gets
his list. Thanks very much. That would be the External User on this
page. I will try your example since I can't get the INTERNAL user
form output to redirect over to the Excel page.

I'm needing some help with that. For example, I put in the else/if
after the creation of the form before the redirection of the external
user. There is another page the External user sees and I will try
your code with that one.
Here is my page with the else/if

# * 10.22.2007
# * current_sightings.php
# * PROVIDES THE LAST CLM FOR EACH CAR IN WHATEVER PARAMETER IS
PASSED: (lease, managed group, pool, etc)
# * modified by jrough
# * 7/15/2008
# * modified to add Excel button, see note

include './includes/config.inc.php';
include $include_path.'dates.inc.php';
include $include_path."LMS_functions.inc.php";

################################################
//Is the user logged in?
Validate_login("current_sightings.php");

if(empty($id)&&($_SESSION["LMS_USER_DESC"]=='internal')){
# THIS IS id INSTEAD OF lease_id B/C ONE DAY WE MIGHT HAVE CUSTOMER
SUB GROUPS OR MANAGED CARS
$destroyed = GetDestroyed_lease_id();
$result = SELECT_leasesCLM();
$TPL_ids = "<SELECT name='id' class=box size=8>\n";
$trbg = "";

while($row = mysql_fetch_assoc($result)){
$id = $row['lease_id'];
$lnum = $row['lease_num'];
$comp = $row['comp_name'];

$trbg = GetTRBG($trbg);

$TPL_ids.=" <OPTION VALUE='".$id;
$TPL_ids.="' ".$trbg.">".$lnum." - ".$comp."</OPTION>\n";
}

$TPL_ids.="</SELECT>\n";
include "header.php";
include $template_path."current_sightings_php.html";

}elseif($_POST['assign']=='Open in Excel'){
Header("Location: http://www.MyWebSite.com/fakerockridge/current_sightingsXL.php?param=".$_Post['id']."&id=".$_id);

}elseif($_POST['redirect']&&$_POST['redirect']!=$_SERVER['PHP_SELF']){
Header("Location: ".$_POST['redirect'].".php?id=".$_POST['id']);
exit;
}else{

# DETERMINE PAGE ACCORDING TO USER TYPE
switch ($_SESSION["LMS_USER_DESC"]){
case "customer":
$id = $_SESSION["LMS_LOGGED_IN"];
$MSG_carlist = "CURRENT SIGHTINGS";
$result = SELECT_sightings_customercars($id,CLM_order_by($or der_by));
break;
case "internal":
$MSG_carlist = "CURRENT SIGHTINGS FOR ".SELECT_lease_num($id)."
".SELECT_comp_name($id);
$result = SELECT_sightings_leasecars($id,CLM_order_by($order _by));
break;
#case "internal_ltd":
# break;
}
$TPL_carnumbers = GetTableHeaders($id);
while ($row = mysql_fetch_assoc($result)){
$TPL_carnumbers.=MakeSighting($row);
}

$TPL_carnumbers.="</table>";

include "header.php";
include $template_path."template_carlist.html";

}
include "footer.php";

the error I am getting is not intelligible to me:

arning: session_start() [function.session-start]: Cannot send session
cache limiter - headers already sent (output started at /home/dhandler/
public_html/fakerockridge/current_sightingsXL.php:2) in /home/dhandler/
public_html/fakerockridge/includes/config.inc.php on line 18

Warning: Cannot modify header information - headers already sent by
(output started at /home/dhandler/public_html/fakerockridge/
current_sightingsXL.php:2) in /home/dhandler/public_html/fakerockridge/
current_sightingsXL.php on line 20

thanks,

[JRough]

On Jul 19, 12:57 pm, Bill H <[e-mail]:

On Jul 19, 3:13 pm, JRough <[e-mail]:

On Jul 19, 10:54 am, John Dunlop <[e-mail]:

Bill H:

print "Content-type: application/excel\n\n";

application/vnd.ms-excel is the registered MIME type.

then print out the spreadsheet contents (probably in CSV format)

text/csv fits the bill.

application/x-msdownload is one of Internet Explorer's "known" MIME
types, but without wading through Microsoft's *cough* documentation of
this bu^H^Hfeature,* I don't know how Internet Explorer handles it.
Suffice to say, subtypes prefixed with "x-" are discouraged by RFC
2048, even more so when an appropriate type has already been
registered.

Actually this will work, because I have a others of these to do. I
have some pages with URL links that when the user clicks it he gets
his list. Thanks very much. That would be the External User on this
page. I will try your example since I can't get the INTERNAL user
form output to redirect over to the Excel page.

[JRough]

>
What do you mean by "redirect the output to Excel"??? Excel isn't a
location, it's a spreadsheet program that some (but not all users) will have
on their machine.

I posted the current_sightingsXL.php page earlier

BTW, Location: is supposed to take a fully qualified URL.

I have a fully qualified url and it still doesn't work.

include './includes/config.inc.php';
include $include_path.'dates.inc.php';
include $include_path."LMS_functions.inc.php";

################################################
//Is the user logged in?
Validate_login("current_sightings.php");

if(empty($id)&&($_SESSION["LMS_USER_DESC"]=='internal')){
# THIS IS id INSTEAD OF lease_id B/C ONE DAY WE MIGHT HAVE CUSTOMER
SUB GROUPS OR MANAGED CARS
$destroyed = GetDestroyed_lease_id();
$result = SELECT_leasesCLM();
$TPL_ids = "<SELECT name='id' class=box size=8>\n";
$trbg = "";

while($row = mysql_fetch_assoc($result)){
$id = $row['lease_id'];
$lnum = $row['lease_num'];
$comp = $row['comp_name'];

$trbg = GetTRBG($trbg);

$TPL_ids.=" <OPTION VALUE='".$id;
$TPL_ids.="' ".$trbg.">".$lnum." - ".$comp."</OPTION>\n";

}

$TPL_ids.="</SELECT>\n";
include "header.php";
include $template_path."current_sightings_php.html";

}elseif($_POST['assign']=='Open in Excel'){

Header("Location:
http://www.MyWebSite.com/fakerockridge/current_sightingsXL.php?param=".$_Post['id']."&id=".$_id);

}elseif($_POST['redirect']&&$_POST['redirect']!=$_SERVER['PHP_SELF']){

Header("Location: ".$_POST['redirect'].".php?id=".$_POST['id']);
exit;

}else{

# DETERMINE PAGE ACCORDING TO USER TYPE
switch ($_SESSION["LMS_USER_DESC"]){
case "customer":
$id = $_SESSION["LMS_LOGGED_IN"];
$MSG_carlist = "CURRENT SIGHTINGS";
$result = SELECT_sightings_customercars($id,CLM_order_by($or der_by));
break;
case "internal":
$MSG_carlist = "CURRENT SIGHTINGS FOR ".SELECT_lease_num($id)."
".SELECT_comp_name($id);
$result = SELECT_sightings_leasecars($id,CLM_order_by($order _by));
break;
#case "internal_ltd":
# break;
}

$TPL_carnumbers = GetTableHeaders($id);
while ($row = mysql_fetch_assoc($result)){
$TPL_carnumbers.=MakeSighting($row);

}

$TPL_carnumbers.="</table>";

include "header.php";
include $template_path."template_carlist.html";

}

include "footer.php";

The error I am getting is not making sense to me Can you tell me if I
should put the if/else somewhere else so I can get the output to the
Excel page to test it there?
THANKS,
arning: session_start() [function.session-start]: Cannot send session
cache limiter - headers already sent (output started at /home/
dhandler/
public_html/fakerockridge/current_sightingsXL.php:2) in /home/
dhandler/
public_html/fakerockridge/includes/config.inc.php on line 18

Warning: Cannot modify header information - headers already sent by
(output started at /home/dhandler/public_html/fakerockridge/
current_sightingsXL.php:2) in /home/dhandler/public_html/
fakerockridge/
current_sightingsXL.php on line 20

Janis

[Jerry Stuckle]

JRough wrote:

On Jul 19, 12:41 am, "Paul Lautman" <[e-mail]>
wrote:

>JRough wrote:

>>I have tried this 4 2 weeks and I need some help. There are 3 other
pages referenced on this page but I'm going to start with this page
in case I missed something. It is called current_sightings.php. All
I want to do is redirect to Excel in the case of the External user.
The first if statement creates a form. The elseif redirects the
external user to only his own listings. I want the results for the
Internal user query SELECT_sightings_leasecars.() to go to my
current_sightingsXL.php page. Where/How would I put the redirect? I
think it should be after the switch for external users. The
getTableHeaders() function is the string that gets passed. All the
pages work except I can't redirect the output to Excel.

What do you mean by "redirect the output to Excel"??? Excel isn't a
location, it's a spreadsheet program that some (but not all users) will have
on their machine.

I have a fully qualified url and it still doesn't work. I'm not sure
I put the if/else redirect to the Excel output right? It is going to
the Excel page but I get this message. These users will have Excel
since it is their cars and they want it in Excel. Do I have the if/
else in the right place?
Warning: session_start() [function.session-start]: Cannot send session
cache limiter - headers already sent (output started at /home/dhandler/
public_html/fakerockridge/current_sightingsXL.php:2) in /home/dhandler/
public_html/fakerockridge/includes/config.inc.php on line 18

Warning: Cannot modify header information - headers already sent by
(output started at /home/dhandler/public_html/fakerockridge/
current_sightingsXL.php:2) in /home/dhandler/public_html/fakerockridge/
current_sightingsXL.php on line 20

<code snipped>

The first message indicates you have output something to the client
before the call to session_start() (you can't do it before calling
header(), either).

The second message indicates the file and line in that file where the
output was sent.

This can be anything which is sent to the browser - including white
space, i.e. a nl character after the ?>. Or anything else.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================

[JRough]

On Jul 19, 5:30 pm, Jerry Stuckle <[e-mail]:

JRough wrote:

On Jul 19, 12:41 am, "Paul Lautman" <[e-mail]>
wrote:

JRough wrote:
I have tried this 4 2 weeks and I need some help. There are 3 other
pages referenced on this page but I'm going to start with this page
in case I missed something. It is called current_sightings.php. All
I want to do is redirect to Excel in the case of the External user.
The first if statement creates a form. The elseif redirects the
external user to only his own listings. I want the results for the
Internal user query SELECT_sightings_leasecars.() to go to my
current_sightingsXL.php page. Where/How would I put the redirect? I
think it should be after the switch for external users. The
getTableHeaders() function is the string that gets passed. All the
pages work except I can't redirect the output to Excel.
What do you mean by "redirect the output to Excel"??? Excel isn't a
location, it's a spreadsheet program that some (but not all users) will have
on their machine.

I have a fully qualified url and it still doesn't work. I'm not sure
I put the if/else redirect to the Excel output right? It is going to
the Excel page but I get this message. These users will have Excel
since it is their cars and they want it in Excel. Do I have the if/
else in the right place?

Warning: session_start() [function.session-start]: Cannot send session
cache limiter - headers already sent (output started at /home/dhandler/
public_html/fakerockridge/current_sightingsXL.php:2) in /home/dhandler/
public_html/fakerockridge/includes/config.inc.php on line 18

Warning: Cannot modify header information - headers already sent by
(output started at /home/dhandler/public_html/fakerockridge/
current_sightingsXL.php:2) in /home/dhandler/public_html/fakerockridge/
current_sightingsXL.php on line 20

<code snipped>

The first message indicates you have output something to the client
before the call to session_start() (you can't do it before calling
header(), either).

The second message indicates the file and line in that file where the
output was sent.

This can be anything which is sent to the browser - including white
space, i.e. a nl character after the ?>. Or anything else.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
[e-mail]
==================

Thanks,
Yes I discovered that. I ended up taking the else if out and I am
back where I started this morning. I don't know where to put the
redirect to Excel :-)
I think it is because it has to get the output first from the string
and the header. I don't know. I blocked it out. It probably goes at
the end after the header but I may be missing something else like the
string to output.
Janis

<?
include './includes/config.inc.php';
include $include_path.'dates.inc.php';
include $include_path."LMS_functions.inc.php";

################################################
//Is the user logged in?
Validate_login("current_sightings.php");

if(empty($id)&&($_SESSION["LMS_USER_DESC"]=='internal')){
# THIS IS id INSTEAD OF lease_id B/C ONE DAY WE MIGHT HAVE CUSTOMER
SUB GROUPS OR MANAGED CARS
$destroyed = GetDestroyed_lease_id();
$result = SELECT_leasesCLM();
$TPL_ids = "<SELECT name='id' class=box size=8>\n";
$trbg = "";

while($row = mysql_fetch_assoc($result)){
$id = $row['lease_id'];
$lnum = $row['lease_num'];
$comp = $row['comp_name'];

$trbg = GetTRBG($trbg);

$TPL_ids.=" <OPTION VALUE='".$id;
$TPL_ids.="' ".$trbg.">".$lnum." - ".$comp."</OPTION>\n";
}

$TPL_ids.="</SELECT>\n";
include "header.php";
include $template_path."current_sightings_php.html";
include "footer.php";
}elseif($_POST['redirect']&&$_POST['redirect']!=$_SERVER['PHP_SELF']){
Header("Location: ".$_POST['redirect'].".php?id=".$_POST['id']);
exit;

/*}elseif($_POST['assign']=='Open in Excel'){
Header("Location: current_sightingsXL.php?param=".
$_Post['lease_id']."&lease_id=".$_lease_id);*/

}else{

# DETERMINE PAGE ACCORDING TO USER TYPE
switch ($_SESSION["LMS_USER_DESC"]){
case "customer":
$id = $_SESSION["LMS_LOGGED_IN"];
$MSG_carlist = "CURRENT SIGHTINGS";
$result = SELECT_sightings_customercars($id,CLM_order_by($or der_by));

break;
case "internal":
$MSG_carlist = "CURRENT SIGHTINGS FOR ".SELECT_lease_num($id)."
".SELECT_comp_name($id);
$result = SELECT_sightings_leasecars($id,CLM_order_by($order _by));

break;
#case "internal_ltd":
# break;
}

$TPL_carnumbers = GetTableHeaders($id);
while ($row = mysql_fetch_assoc($result)){
$TPL_carnumbers.=MakeSighting($row);
}

$TPL_carnumbers.="</table>";
include "header.php";
include $template_path."template_carlist.html";
}

include "footer.php";

[Jerry Stuckle]

JRough wrote:

On Jul 19, 5:30 pm, Jerry Stuckle <[e-mail]:

>JRough wrote:

>>On Jul 19, 12:41 am, "Paul Lautman" <[e-mail]>
wrote:
JRough wrote:
I have tried this 4 2 weeks and I need some help. There are 3 other
pages referenced on this page but I'm going to start with this page
in case I missed something. It is called current_sightings.php. All
I want to do is redirect to Excel in the case of the External user.
The first if statement creates a form. The elseif redirects the
external user to only his own listings. I want the results for the
Internal user query SELECT_sightings_leasecars.() to go to my
current_sightingsXL.php page. Where/How would I put the redirect? I
think it should be after the switch for external users. The
getTableHeaders() function is the string that gets passed. All the
pages work except I can't redirect the output to Excel.
What do you mean by "redirect the output to Excel"??? Excel isn't a
location, it's a spreadsheet program that some (but not all users) will have
on their machine.
I have a fully qualified url and it still doesn't work. I'm not sure
I put the if/else redirect to the Excel output right? It is going to
the Excel page but I get this message. These users will have Excel
since it is their cars and they want it in Excel. Do I have the if/
else in the right place?
Warning: session_start() [function.session-start]: Cannot send session
cache limiter - headers already sent (output started at /home/dhandler/
public_html/fakerockridge/current_sightingsXL.php:2) in /home/dhandler/
public_html/fakerockridge/includes/config.inc.php on line 18
Warning: Cannot modify header information - headers already sent by
(output started at /home/dhandler/public_html/fakerockridge/
current_sightingsXL.php:2) in /home/dhandler/public_html/fakerockridge/
current_sightingsXL.php on line 20

<code snipped>

The first message indicates you have output something to the client
before the call to session_start() (you can't do it before calling
header(), either).

The second message indicates the file and line in that file where the
output was sent.

This can be anything which is sent to the browser - including white
space, i.e. a nl character after the ?>. Or anything else.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
[e-mail]
==================

Thanks,
Yes I discovered that. I ended up taking the else if out and I am
back where I started this morning. I don't know where to put the
redirect to Excel :-)
I think it is because it has to get the output first from the string
and the header. I don't know. I blocked it out. It probably goes at
the end after the header but I may be missing something else like the
string to output.
Janis

<?

It had nothing to do with the else if. It had to do with sending output
when you shouldn't.

Did you look at the file and line? What are you outputting there?
That's your problem with the messages.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================

[JRough]

On Jul 19, 6:13 pm, Jerry Stuckle <[e-mail]:

JRough wrote:

On Jul 19, 5:30 pm, Jerry Stuckle <[e-mail]:

JRough wrote:
On Jul 19, 12:41 am, "Paul Lautman" <[e-mail]>
wrote:
JRough wrote:
I have tried this 4 2 weeks and I need some help. There are 3 other
pages referenced on this page but I'm going to start with this page
in case I missed something. It is called current_sightings.php. All
I want to do is redirect to Excel in the case of the External user.
The first if statement creates a form. The elseif redirects the
external user to only his own listings. I want the results for the
Internal user query SELECT_sightings_leasecars.() to go to my
current_sightingsXL.php page. Where/How would I put the redirect? I
think it should be after the switch for external users. The
getTableHeaders() function is the string that gets passed. All the
pages work except I can't redirect the output to Excel.
What do you mean by "redirect the output to Excel"??? Excel isn't a
location, it's a spreadsheet program that some (but not all users) will have
on their machine.
I have a fully qualified url and it still doesn't work. I'm not sure
I put the if/else redirect to the Excel output right? It is going to
the Excel page but I get this message. These users will have Excel
since it is their cars and they want it in Excel. Do I have the if/
else in the right place?
Warning: session_start() [function.session-start]: Cannot send session
cache limiter - headers already sent (output started at /home/dhandler/
public_html/fakerockridge/current_sightingsXL.php:2) in /home/dhandler/
public_html/fakerockridge/includes/config.inc.php on line 18
Warning: Cannot modify header information - headers already sent by
(output started at /home/dhandler/public_html/fakerockridge/
current_sightingsXL.php:2) in /home/dhandler/public_html/fakerockridge/
current_sightingsXL.php on line 20
<code snipped>

The first message indicates you have output something to the client
before the call to session_start() (you can't do it before calling
header(), either).

The second message indicates the file and line in that file where the
output was sent.

This can be anything which is sent to the browser - including white
space, i.e. a nl character after the ?>. Or anything else.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
[e-mail]
==================

Thanks,
Yes I discovered that. I ended up taking the else if out and I am
back where I started this morning. I don't know where to put the
redirect to Excel :-)
I think it is because it has to get the output first from the string
and the header. I don't know. I blocked it out. It probably goes at
the end after the header but I may be missing something else like the
string to output.
Janis

<?

It had nothing to do with the else if. It had to do with sending output
when you shouldn't.

Did you look at the file and line? What are you outputting there?
That's your problem with the messages.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
[e-mail]
==================

have the else/if blocked.
So I still need to know where to put it, however, I do believe there
is somehting missing regarding the output string.
The $data
thanks,

[JRough]

On Jul 19, 6:13 pm, Jerry Stuckle <[e-mail]:

JRough wrote:

On Jul 19, 5:30 pm, Jerry Stuckle <[e-mail]:

JRough wrote:
On Jul 19, 12:41 am, "Paul Lautman" <[e-mail]>
wrote:
JRough wrote:
I have tried this 4 2 weeks and I need some help. There are 3 other
pages referenced on this page but I'm going to start with this page
in case I missed something. It is called current_sightings.php. All
I want to do is redirect to Excel in the case of the External user.
The first if statement creates a form. The elseif redirects the
external user to only his own listings. I want the results for the
Internal user query SELECT_sightings_leasecars.() to go to my
current_sightingsXL.php page. Where/How would I put the redirect? I
think it should be after the switch for external users. The
getTableHeaders() function is the string that gets passed. All the
pages work except I can't redirect the output to Excel.
What do you mean by "redirect the output to Excel"??? Excel isn't a
location, it's a spreadsheet program that some (but not all users) will have
on their machine.
I have a fully qualified url and it still doesn't work. I'm not sure
I put the if/else redirect to the Excel output right? It is going to
the Excel page but I get this message. These users will have Excel
since it is their cars and they want it in Excel. Do I have the if/
else in the right place?
Warning: session_start() [function.session-start]: Cannot send session
cache limiter - headers already sent (output started at /home/dhandler/
public_html/fakerockridge/current_sightingsXL.php:2) in /home/dhandler/
public_html/fakerockridge/includes/config.inc.php on line 18
Warning: Cannot modify header information - headers already sent by
(output started at /home/dhandler/public_html/fakerockridge/
current_sightingsXL.php:2) in /home/dhandler/public_html/fakerockridge/
current_sightingsXL.php on line 20
<code snipped>

The first message indicates you have output something to the client
before the call to session_start() (you can't do it before calling
header(), either).

The second message indicates the file and line in that file where the
output was sent.

This can be anything which is sent to the browser - including white
space, i.e. a nl character after the ?>. Or anything else.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
[e-mail]
==================

Thanks,
Yes I discovered that. I ended up taking the else if out and I am
back where I started this morning. I don't know where to put the
redirect to Excel :-)
I think it is because it has to get the output first from the string
and the header. I don't know. I blocked it out. It probably goes at
the end after the header but I may be missing something else like the
string to output.
Janis

<?

It had nothing to do with the else if. It had to do with sending output
when you shouldn't.

Did you look at the file and line? What are you outputting there?
That's your problem with the messages.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
[e-mail]
==================

No I am wrong. The output is in the current_sightingsXL.php page.

$data
is the output string.
I still just need to direct it to that page but capture the radio
button clicked.
janis

[Jerry Stuckle]

JRough wrote:

On Jul 19, 6:13 pm, Jerry Stuckle <[e-mail]:

>JRough wrote:

>>On Jul 19, 5:30 pm, Jerry Stuckle <[e-mail]:
JRough wrote:
On Jul 19, 12:41 am, "Paul Lautman" <[e-mail]>
wrote:
>JRough wrote:
>>I have tried this 4 2 weeks and I need some help. There are 3 other
>>pages referenced on this page but I'm going to start with this page
>>in case I missed something. It is called current_sightings.php. All
>>I want to do is redirect to Excel in the case of the External user.
>>The first if statement creates a form. The elseif redirects the
>>external user to only his own listings. I want the results for the
>>Internal user query SELECT_sightings_leasecars.() to go to my
>>current_sightingsXL.php page. Where/How would I put the redirect? I
>>think it should be after the switch for external users. The
>>getTableHeaders() function is the string that gets passed. All the
>>pages work except I can't redirect the output to Excel.
>What do you mean by "redirect the output to Excel"??? Excel isn't a
>location, it's a spreadsheet program that some (but not all users) will have
>on their machine.
I have a fully qualified url and it still doesn't work. I'm not sure
I put the if/else redirect to the Excel output right? It is going to
the Excel page but I get this message. These users will have Excel
since it is their cars and they want it in Excel. Do I have the if/
else in the right place?
Warning: session_start() [function.session-start]: Cannot send session
cache limiter - headers already sent (output started at /home/dhandler/
public_html/fakerockridge/current_sightingsXL.php:2) in /home/dhandler/
public_html/fakerockridge/includes/config.inc.php on line 18
Warning: Cannot modify header information - headers already sent by
(output started at /home/dhandler/public_html/fakerockridge/
current_sightingsXL.php:2) in /home/dhandler/public_html/fakerockridge/
current_sightingsXL.php on line 20
<code snipped>
The first message indicates you have output something to the client
before the call to session_start() (you can't do it before calling
header(), either).
The second message indicates the file and line in that file where the
output was sent.
This can be anything which is sent to the browser - including white
space, i.e. a nl character after the ?>. Or anything else.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
[e-mail]
==================
Thanks,
Yes I discovered that. I ended up taking the else if out and I am
back where I started this morning. I don't know where to put the
redirect to Excel :-)
I think it is because it has to get the output first from the string
and the header. I don't know. I blocked it out. It probably goes at
the end after the header but I may be missing something else like the
string to output.
Janis
<?

It had nothing to do with the else if. It had to do with sending output
when you shouldn't.

Did you look at the file and line? What are you outputting there?
That's your problem with the messages.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
[e-mail]
==================

have the else/if blocked.
So I still need to know where to put it, however, I do believe there
is somehting missing regarding the output string.
The $data
thanks,

What's missing as far as the output string? Not knowing what you have
in current_sightingsXL.php, I wouldn't know.

But that's not your problem. Read my previous entry. Until you fix the
REAL problem, you'll have trouble no matter where you place your
header() calls.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================

[JRough]

On Jul 19, 7:25 pm, Jerry Stuckle <[e-mail]:

JRough wrote:

On Jul 19, 6:13 pm, Jerry Stuckle <[e-mail]:

JRough wrote:
On Jul 19, 5:30 pm, Jerry Stuckle <[e-mail]:
JRough wrote:
On Jul 19, 12:41 am, "Paul Lautman" <[e-mail]>
wrote:
JRough wrote:
>I have tried this 4 2 weeks and I need some help. There are 3 other
>pages referenced on this page but I'm going to start with this page
>in case I missed something. It is called current_sightings.php. All
>I want to do is redirect to Excel in the case of the External user.
>The first if statement creates a form. The elseif redirects the
>external user to only his own listings. I want the results for the
>Internal user query SELECT_sightings_leasecars.() to go to my
>current_sightingsXL.php page. Where/How would I put the redirect? I
>think it should be after the switch for external users. The
>getTableHeaders() function is the string that gets passed. All the
>pages work except I can't redirect the output to Excel.
What do you mean by "redirect the output to Excel"??? Excel isn't a
location, it's a spreadsheet program that some (but not all users) will have
on their machine.
I have a fully qualified url and it still doesn't work. I'm not sure
I put the if/else redirect to the Excel output right? It is going to
the Excel page but I get this message. These users will have Excel
since it is their cars and they want it in Excel. Do I have the if/
else in the right place?
Warning: session_start() [function.session-start]: Cannot send session
cache limiter - headers already sent (output started at /home/dhandler/
public_html/fakerockridge/current_sightingsXL.php:2) in /home/dhandler/
public_html/fakerockridge/includes/config.inc.php on line 18
Warning: Cannot modify header information - headers already sent by
(output started at /home/dhandler/public_html/fakerockridge/
current_sightingsXL.php:2) in /home/dhandler/public_html/fakerockridge/
current_sightingsXL.php on line 20
<code snipped>
The first message indicates you have output something to the client
before the call to session_start() (you can't do it before calling
header(), either).
The second message indicates the file and line in that file where the
output was sent.
This can be anything which is sent to the browser - including white
space, i.e. a nl character after the ?>. Or anything else.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
[e-mail]
==================
Thanks,
Yes I discovered that. I ended up taking the else if out and I am
back where I started this morning. I don't know where to put the
redirect to Excel :-)
I think it is because it has to get the output first from the string
and the header. I don't know. I blocked it out. It probably goes at
the end after the header but I may be missing something else like the
string to output.
Janis
<?
It had nothing to do with the else if. It had to do with sending output
when you shouldn't.

Did you look at the file and line? What are you outputting there?
That's your problem with the messages.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
[e-mail]
==================

have the else/if blocked.
So I still need to know where to put it, however, I do believe there
is somehting missing regarding the output string.
The $data
thanks,

What's missing as far as the output string? Not knowing what you have
in current_sightingsXL.php, I wouldn't know.

But that's not your problem. Read my previous entry. Until you fix the
REAL problem, you'll have trouble no matter where you place your
header() calls.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
[e-mail]
==================

Hi Jerry:
I am sorry but I don't which line you mean and I do appreciate your
response.
Is it the $result? or is it in the case internal line? I am looking
for the output for the internal users. I guess I'm not entirely clear
what the output is. Select_sighting_leasecars is the right query. I
have that on the current_sightingsXL.php page as well. hmmm

case "internal":
$MSG_carlist = "CURRENT SIGHTINGS FOR ".SELECT_lease_num($id)."
".SELECT_comp_name($id);
$result = SELECT_sightings_leasecars($id,CLM_order_by($order _by));

break;

[JRough]

On Jul 19, 7:25 pm, Jerry Stuckle <[e-mail]:

JRough wrote:

On Jul 19, 6:13 pm, Jerry Stuckle <[e-mail]:

JRough wrote:
On Jul 19, 5:30 pm, Jerry Stuckle <[e-mail]:
JRough wrote:
On Jul 19, 12:41 am, "Paul Lautman" <[e-mail]>
wrote:
JRough wrote:
>I have tried this 4 2 weeks and I need some help. There are 3 other
>pages referenced on this page but I'm going to start with this page
>in case I missed something. It is called current_sightings.php. All
>I want to do is redirect to Excel in the case of the External user.
>The first if statement creates a form. The elseif redirects the
>external user to only his own listings. I want the results for the
>Internal user query SELECT_sightings_leasecars.() to go to my
>current_sightingsXL.php page. Where/How would I put the redirect? I
>think it should be after the switch for external users. The
>getTableHeaders() function is the string that gets passed. All the
>pages work except I can't redirect the output to Excel.
What do you mean by "redirect the output to Excel"??? Excel isn't a
location, it's a spreadsheet program that some (but not all users) will have
on their machine.
I have a fully qualified url and it still doesn't work. I'm not sure
I put the if/else redirect to the Excel output right? It is going to
the Excel page but I get this message. These users will have Excel
since it is their cars and they want it in Excel. Do I have the if/
else in the right place?
Warning: session_start() [function.session-start]: Cannot send session
cache limiter - headers already sent (output started at /home/dhandler/
public_html/fakerockridge/current_sightingsXL.php:2) in /home/dhandler/
public_html/fakerockridge/includes/config.inc.php on line 18
Warning: Cannot modify header information - headers already sent by
(output started at /home/dhandler/public_html/fakerockridge/
current_sightingsXL.php:2) in /home/dhandler/public_html/fakerockridge/
current_sightingsXL.php on line 20
<code snipped>
The first message indicates you have output something to the client
before the call to session_start() (you can't do it before calling
header(), either).
The second message indicates the file and line in that file where the
output was sent.
This can be anything which is sent to the browser - including white
space, i.e. a nl character after the ?>. Or anything else.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
[e-mail]
==================
Thanks,
Yes I discovered that. I ended up taking the else if out and I am
back where I started this morning. I don't know where to put the
redirect to Excel :-)
I think it is because it has to get the output first from the string
and the header. I don't know. I blocked it out. It probably goes at
the end after the header but I may be missing something else like the
string to output.
Janis
<?
It had nothing to do with the else if. It had to do with sending output
when you shouldn't.

Did you look at the file and line? What are you outputting there?
That's your problem with the messages.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
[e-mail]
==================

have the else/if blocked.
So I still need to know where to put it, however, I do believe there
is somehting missing regarding the output string.
The $data
thanks,

What's missing as far as the output string? Not knowing what you have
in current_sightingsXL.php, I wouldn't know.

But that's not your problem. Read my previous entry. Until you fix the
REAL problem, you'll have trouble no matter where you place your
header() calls.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
[e-mail]
==================

I think the string gets input in the current_sightings.php page and it
gets parsed in the current_sightingsXL.php page

[Jerry Stuckle]

JRough wrote:

On Jul 19, 7:25 pm, Jerry Stuckle <[e-mail]:

>JRough wrote:

>>On Jul 19, 6:13 pm, Jerry Stuckle <[e-mail]:
JRough wrote:
On Jul 19, 5:30 pm, Jerry Stuckle <[e-mail]:
>JRough wrote:
>>On Jul 19, 12:41 am, "Paul Lautman" <[e-mail]>
>>wrote:
>>>JRough wrote:
>>>>I have tried this 4 2 weeks and I need some help. There are 3 other
>>>>pages referenced on this page but I'm going to start with this page
>>>>in case I missed something. It is called current_sightings.php. All
>>>>I want to do is redirect to Excel in the case of the External user.
>>>>The first if statement creates a form. The elseif redirects the
>>>>external user to only his own listings. I want the results for the
>>>>Internal user query SELECT_sightings_leasecars.() to go to my
>>>>current_sightingsXL.php page. Where/How would I put the redirect? I
>>>>think it should be after the switch for external users. The
>>>>getTableHeaders() function is the string that gets passed. All the
>>>>pages work except I can't redirect the output to Excel.
>>>What do you mean by "redirect the output to Excel"??? Excel isn't a
>>>location, it's a spreadsheet program that some (but not all users) will have
>>>on their machine.
>>I have a fully qualified url and it still doesn't work. I'm not sure
>>I put the if/else redirect to the Excel output right? It is going to
>>the Excel page but I get this message. These users will have Excel
>>since it is their cars and they want it in Excel. Do I have the if/
>>else in the right place?
>>Warning: session_start() [function.session-start]: Cannot send session
>>cache limiter - headers already sent (output started at /home/dhandler/
>>public_html/fakerockridge/current_sightingsXL.php:2) in /home/dhandler/
>>public_html/fakerockridge/includes/config.inc.php on line 18
>>Warning: Cannot modify header information - headers already sent by
>>(output started at /home/dhandler/public_html/fakerockridge/
>>current_sightingsXL.php:2) in /home/dhandler/public_html/fakerockridge/
>>current_sightingsXL.php on line 20
><code snipped>
>The first message indicates you have output something to the client
>before the call to session_start() (you can't do it before calling
>header(), either).
>The second message indicates the file and line in that file where the
>output was sent.
>This can be anything which is sent to the browser - including white
>space, i.e. a nl character after the ?>. Or anything else.
>--
>==================
>Remove the "x" from my email address
>Jerry Stuckle
>JDS Computer Training Corp.
>[e-mail]
>==================
Thanks,
Yes I discovered that. I ended up taking the else if out and I am
back where I started this morning. I don't know where to put the
redirect to Excel :-)
I think it is because it has to get the output first from the string
and the header. I don't know. I blocked it out. It probably goes at
the end after the header but I may be missing something else like the
string to output.
Janis
<?
It had nothing to do with the else if. It had to do with sending output
when you shouldn't.
Did you look at the file and line? What are you outputting there?
That's your problem with the messages.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
[e-mail]
==================
have the else/if blocked.
So I still need to know where to put it, however, I do believe there
is somehting missing regarding the output string.
The $data
thanks,

What's missing as far as the output string? Not knowing what you have
in current_sightingsXL.php, I wouldn't know.

But that's not your problem. Read my previous entry. Until you fix the
REAL problem, you'll have trouble no matter where you place your
header() calls.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
[e-mail]
==================

Hi Jerry:
I am sorry but I don't which line you mean and I do appreciate your
response.
Is it the $result? or is it in the case internal line? I am looking
for the output for the internal users. I guess I'm not entirely clear
what the output is. Select_sighting_leasecars is the right query. I
have that on the current_sightingsXL.php page as well. hmmm

case "internal":
$MSG_carlist = "CURRENT SIGHTINGS FOR ".SELECT_lease_num($id)."
".SELECT_comp_name($id);
$result = SELECT_sightings_leasecars($id,CLM_order_by($order _by));

break;

The line identified in your error message:

Warning: Cannot modify header information - headers already sent by
(output started at /home/dhandler/public_html/fakerockridge/
current_sightingsXL.php:2) in /home/dhandler/public_html/fakerockridge/
current_sightingsXL.php on line 20

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================