using ob_start, ob_end_flush with db query?

chosun27

I'm having some trouble outputting to a file. using the PHP manual as my guide, I worked up this code to use ob_start, ob_end_flush, etc. My problem is explained below the code.

<?php
$mypath = getcwd();
$getfile="page.php?table=intro&id=1";
//$getfile="static.php";
$getpath="$mypath/$getfile";
$outpath="page1.htm";
ob_start();

require ("$getfile");

$html = ob_get_contents();
ob_end_clean();
// write output to file

$fp = fopen("test/".$outpath, "w");
If ($fp) {
print ("wahoo! we just compiled ".$getfile."!");
}
fwrite($fp, $html);
fclose($fp);

ob_end_flush();

If I send static.php (commented out), a simple php page that uses includes and a few other variables for formatting, the file is created just fine. If I send page.php?table=intro&id=1, a page that queries a postgres db and places the data from a single record in the middle of the page, I get an ugly error message like this:
Fatal error: Failed opening required 'page.php?table=intro&id=1' (include_path='.:/php/includes:/usr/share/php') in /var/www/html/compile.php on line 9

Both files use includes from the same directory and are referenced the same. The only thing I can think of is that the db query is causing this. Advice?

thanks,
/mark

Weedpacket

Originally posted by chosun27
I'm having some trouble outputting to a file. using the PHP manual as my guide, I worked up this code to use ob_start, ob_end_flush, etc. My problem is explained below the code.
$mypath = getcwd();
$getfile="page.php?table=intro&id=1";
//$getfile="static.php";
$getpath="$mypath/$getfile";
$outpath="page1.htm";
ob_start();

require ("$getfile");

$html = ob_get_contents();
ob_end_clean();
// write output to file        

$fp = fopen("test/".$outpath, "w");
If ($fp) {
	print ("wahoo! we just compiled ".$getfile."!");
	}
fwrite($fp, $html); 
fclose($fp);

ob_end_flush();
...
/mark [/B]

The problem has nothing to do with outbut buffering or database queries. The problem is because require is expecting a filename, and you're giving it something that belongs in a URL.

If you want $table to be set to 'intro' and $id to 1 when you include page.php, all you need to do is

$table='intro';
$id=1;
require('page.php');

The contents of page.php will be slapped bodily in place of the 'require' statement virtually untouched. So if you're using $GET['table'] and $GET['id'] you'll be needing to change them back to $table and $id.