Pass through Excel file with curl, IE problem

[Jochen Daum]

Hi,
I'd like to pass through an Excel file from one server, (one secret
password) to a user (different passwords). I thought I had duplicated
the headers:

$ch = curl_init();
curl_setopt($ch , CURLOPT_URL,$ur l);
curl_setopt($ch , CURLOPT_USERAGE NT, $user_agent);
curl_setopt($ch , CURLOPT_HEADER, 1);
curl_setopt($ch , CURLOPT_RETURNT RANSFER,1);
curl_setopt($ch , CURLOPT_SSL_VER IFYPEER, FALSE);
curl_setopt($ch , CURLOPT_TIMEOUT , 100);

$result=curl_ex ec ($ch);
curl_close ($ch);

$headerend = 0;
while (!$headerend){
$x = strpos($result, "\r\n");
if ($x == 0){
$headerend = 1;
}else{
header (substr($result , 0, $x+1));
$result = substr($result, $x+2);
}
}
print substr($result, 2);
die();
but I always have Excel opening and saying: Could not open file
http://mydomain/file/php?p1=x&p2=y

Goes fine with Firefox 0.8 at least, so I assume IE is also taking the
..php ending into account.

Any ideas?

Jochen
--
Jochen Daum - Cabletalk Group Ltd.
PHP DB Edit Toolkit -- PHP scripts for building
database editing interfaces.
http://sourceforge.net/projects/phpdbedittk/

[R. Rajesh Jeba Anbiah]

Jochen Daum <jo*********@ca bletalk.co.nz> wrote in message news:<gd******* *************** **********@4ax. com>...

Hi,
I'd like to pass through an Excel file from one server, (one secret
password) to a user (different passwords). I thought I had duplicated
the headers:

$ch = curl_init();
curl_setopt($ch , CURLOPT_URL,$ur l);
curl_setopt($ch , CURLOPT_USERAGE NT, $user_agent);
curl_setopt($ch , CURLOPT_HEADER, 1);
curl_setopt($ch , CURLOPT_RETURNT RANSFER,1);
curl_setopt($ch , CURLOPT_SSL_VER IFYPEER, FALSE);
curl_setopt($ch , CURLOPT_TIMEOUT , 100);

$result=curl_ex ec ($ch);
curl_close ($ch);

$headerend = 0;
while (!$headerend){
$x = strpos($result, "\r\n");
if ($x == 0){
$headerend = 1;
}else{
header (substr($result , 0, $x+1));
$result = substr($result, $x+2);
}
}
print substr($result, 2);
die();
Unfortunately, I couldn't understand what you mean.

Perhaps you should add bit more debug codes like:

curl_setopt($ch , CURLOPT_RETURNT RANSFER, 1);
curl_setopt($ch , CURLOPT_FOLLOWL OCATION, 1);

$fp_err = fopen('verbose_ file.txt', 'ab+');
fwrite($fp_err, date('Y-m-d H:i:s')."\n\n") ; //add timestamp to the verbose log
curl_setopt($ch , CURLOPT_VERBOSE , 1);
curl_setopt($ch , CURLOPT_FAILONE RROR, true);
curl_setopt($ch , CURLOPT_STDERR, $fp_err);

$result = curl_exec($ch);
//debug..
print_r(curl_ge tinfo($ch));

but I always have Excel opening and saying: Could not open file
http://mydomain/file/php?p1=x&p2=y

Goes fine with Firefox 0.8 at least, so I assume IE is also taking the
.php ending into account.

Do you mean adding user agent string?

--
| Just another PHP saint |
Email: rrjanbiah-at-Y!com

[Jochen Daum]

Hi,

Good to read you.

I actually have solved it myself.

On 6 May 2004 23:10:43 -0700, ng**********@re diffmail.com (R. Rajesh
Jeba Anbiah) wrote:

Jochen Daum <jo*********@ca bletalk.co.nz> wrote in message news:<gd******* *************** **********@4ax. com>...

Hi,
I'd like to pass through an Excel file from one server, (one secret
password) to a user (different passwords). I thought I had duplicated
the headers:

$ch = curl_init();
curl_setopt($ch , CURLOPT_URL,$ur l);
curl_setopt($ch , CURLOPT_USERAGE NT, $user_agent);
curl_setopt($ch , CURLOPT_HEADER, 1);
curl_setopt($ch , CURLOPT_RETURNT RANSFER,1);
curl_setopt($ch , CURLOPT_SSL_VER IFYPEER, FALSE);
curl_setopt($ch , CURLOPT_TIMEOUT , 100);

$result=curl_ex ec ($ch);
curl_close ($ch);

$headerend = 0;
while (!$headerend){
$x = strpos($result, "\r\n");
if ($x == 0){
$headerend = 1;
}else{
header (substr($result , 0, $x+1));
$result = substr($result, $x+2);
}
}
print substr($result, 2);
die();
Unfortunately, I couldn't understand what you mean.

Perhaps you should add bit more debug codes like:

curl_setopt($c h, CURLOPT_RETURNT RANSFER, 1);
curl_setopt($c h, CURLOPT_FOLLOWL OCATION, 1);

$fp_err = fopen('verbose_ file.txt', 'ab+');
fwrite($fp_err , date('Y-m-d H:i:s')."\n\n") ; //add timestamp to the verbose log
curl_setopt($c h, CURLOPT_VERBOSE , 1);
curl_setopt($c h, CURLOPT_FAILONE RROR, true);
curl_setopt($c h, CURLOPT_STDERR, $fp_err);

$result = curl_exec($ch);
//debug..
print_r(curl_g etinfo($ch));

Thanks, I didn't know of all that. Actually, curl worked fine, my
problem was to replay the headers accordingly from the server I get
the file from. I wanted to just replay them, because then I assume
people will get as many problems as they have with the current server
(there are none I know of).

but I always have Excel opening and saying: Could not open file
http://mydomain/file/php?p1=x&p2=y

Goes fine with Firefox 0.8 at least, so I assume IE is also taking the
.php ending into account.

Do you mean adding user agent string?

Ah, no. You know when you click on a URL to an Excel file, it opens in
the browser. It didn't do that, instead I got the error message. The
problem was the curl'd server used "Transfer Encoding: chunked",
whereas mine doesn't. So I had to "block" this header.

Thansk for the help,

Jochen
--
Jochen Daum - Cabletalk Group Ltd.
PHP DB Edit Toolkit -- PHP scripts for building
database editing interfaces.
http://sourceforge.net/projects/phpdbedittk/