Save a query output into a file attachmate.

xxman

Hi coders ,
i've written some line of code for save a query output into a file attachmate :

if ($action=="export_uar") {

  header("Content-disposition: attachment;filename=report.txt");
  header("Content-type: application/octet-stream");
  header("Pragma: no-cache");
  header("Expires: 0");

 $report_db=$DB_site->query("SELECT a.userid, a.username, a.joindate, a.lastvisit, a.lastpost, b.userid, b.field1, b.field8, b.field10, b.field11, b.field12 from user a,userfield b where a.userid=b.userid ");
 while ($newarray=$DB_site->fetch_array($report_db))
//echo $newarray['userid'],$newarray['username'],"<br />\n"; 
print ("userid : $newarray[userid] - username : $newarray[username]\n");
}

It's work but not correctly fine , in the file saved the script add a html contens not wanted at the header and at the bottom :

<html><head>
<meta content="text/html; charset=windows-1252" http-equiv="Content-Type">
<meta http-equiv="MSThemeCompatible" content="Yes">
<link rel="stylesheet" href="../cp.css">
</head>
<body leftmargin="10" topmargin="10" marginwidth="10" marginheight="10">

userid : 645 - username : cow
userid : 639 - username : sgamo
userid : 643 - username : stargate75
userid : 584 - username : Aquilotto
userid : 585 - username : mikelin17
userid : 635 - username : Morph
userid : 632 - username : zeroccol
userid : 947 - username : Rtano

</BODY></HTML>

.. I need only this in the output :


userid : 645 - username : cow
userid : 639 - username : sgamo
userid : 643 - username : stargate75
userid : 584 - username : Aquilotto
userid : 585 - username : mikelin17
userid : 635 - username : Morph
userid : 632 - username : zeroccol
userid : 947 - username : Rtano

How I can obtain it ?
Please help me know !

Best regards.

planetsim

Look into the output buffering functions, are the moment the HTML contents arent being buffered and are just being put into the first bit of output.

http://au.php.net/manual/en/ref.outcontrol.php

xxman

..reading../.. learning..

I tryed to add ob_start() and ob_end_flush()
functions :

if ($action=="export_uar") {

  header("Content-disposition: attachment;filename=report.txt");
  header("Content-type: unknown/unknown");
  //header("Content-type: application/octet-stream");
  header("Pragma: no-cache");
  header("Expires: 0");
ob_start ();
 $report_db=$DB_site->query("SELECT a.userid, a.username, a.joindate, a.lastvisit, a.lastpost, b.userid, b.field1, b.field8, b.field10, b.field11, b.field12 from user a,userfield b where a.userid=b.userid ");
 while ($newarray=$DB_site->fetch_array($report_db))
//echo $newarray['userid'],$newarray['username'],"<br />\n"; 
print ("userid : $newarray[userid] - username : $newarray[username]\n");
ob_end_flush();
}

.. still doesent work .. Any suggestion/sample ?

P.s. i'vent directly access to the php.ini to enable the output_buffering directive , i use a hosting service.

xxman

.. anyone ? .. :queasy:

sidney

i use these headers and check for msie

  $agent = getenv("HTTP_USER_AGENT"); 
		if (preg_match("/MSIE/i", "$agent")) 
			{
			Header("Cache-control: private"."\r\n");
			Header("Content-Type: application/force-download"."\r\n");
			Header('Content-Disposition: inline; filename="productcode.txt"'."\r\n");
			}
		else 
			{
			Header("Content-type: text/plain"."\r\n");
			Header('Content-Disposition: attachment; filename="productcode.txt"'."\r\n");
			}

these work is ie,netscapeand firefox untested in rest

rehfeld

well, basically your script is outputing some html. stop doing that.

im guessing your script looks something like this

<html><head>
<meta content="text/html; charset=windows-1252" http-equiv="Content-Type">
<meta http-equiv="MSThemeCompatible" content="Yes">
<link rel="stylesheet" href="../cp.css">
</head>
<body leftmargin="10" topmargin="10" marginwidth="10" marginheight="10">
<?php

if ($action=="export_uar") {

  header("Content-disposition: attachment;filename=report.txt");
  header("Content-type: application/octet-stream");
  header("Pragma: no-cache");
  header("Expires: 0");

 $report_db=$DB_site->query("SELECT a.userid, a.username, a.joindate, a.lastvisit, a.lastpost, b.userid, b.field1, b.field8, b.field10, b.field11, b.field12 from user a,userfield b where a.userid=b.userid ");
 while ($newarray=$DB_site->fetch_array($report_db))
//echo $newarray['userid'],$newarray['username'],"<br />\n";
print ("userid : $newarray[userid] - username : $newarray[username]\n");
}

?>
</BODY></HTML>

you could use output buffering to get around it, but its really a band aid way to fix a poor design in this case.

why not just make a seperate script for this, and just dont have any html involved at all?

xxman

Thanks for your support rehfeld but it's not this the case.

This script (backup.php) it's a integral part of a management bulletin board software (the same that we use on phpbuilder forum - Vbulletin). In this particular script there is not any reference to header and footer that are inherited instead by another script i think , global.php.

And now ?