Printing Headers and Footers

Anon

I am trying to print a long database report that will be split into a few pages. But at the start of each page I want to add a header, and at the bottom of the pages (not the last) I want to add "<----continued---->". Any ideas? Any kind of help would be appreciated. If possible, I will want to add these features, the header and footer to be invisible on the monitor, they only appear on the printed document.

Thanks

saltwater

just include your header and footer file, thats how i do it, its actually a very basic template system

Anon

Well, true but the problem is I want to have a the footer and sometimes the header file to be a variable, like it's gonna be "finished" on the last page instead of "continued" on the bottom of other pages. Anyways, I'm completely new to the print function, I dont even know how to do it from inside the coding, so it might help me a lot if you could give me a short example of printing a document using a header and footer file. I cant seem to find this function in my reference book.
thanks

saltwater

well, if you want to, first tell me what your exact purpose is, you want to create a report from a database, but you want to split it in different pages. Do I understand you correctly? Well, first you must query your database for the total count of results

$query="SELECT <primary_key> FROM <table>";

mysql_num_rows will give you the count of results, then you query the database for the result of the current page, $page is the current $page, the first is 0, the second 1, etc..

$rowsperpage=20;

"SELECT <fields> FROM <table> LIMIT ".($page*$rowsperpage).", $rowsperpage";

if you want to order your results on a specific field, just add ORDER BY <field> ASC/DESC,<field2> ASC/SEC,etc..

you can also make links to the previous en next page:

<a href="<? echo $PHP_SELF.'&page='.($page-1); ?>">previous</a>
<a href="<? echo $PHP_SELF.'&page='.($page+1); ?>">next</a>

you could also check if you are on the first page, then don't echo the previous link and if you are on the last page, don't echo the next link..

Hope I understand you correctly and this helps you..

Regards Bruno

Anon

I think you have misunderstood what I meant by print. What I meant by print is not printing the results on the screen, but on paper.
I got the details of all the results of a database search on the screen, for instance, 100//page as the user specified it. And then when he wants to print it out on PAPER it will print the header and footer (which is invisible on the screen, for instance, the footer on the last page would be "finished", on the other pages it will be "continued".

So what I really need to know now is to pass on this info to the printer, and tell the printer to print it out.

saltwater

hmmz, you could use the title tag to print a title on paper, most browsers do this, but with my system you would have to print every page manualy, that's true, you could 'echo' everything on one single webpage, but then you would have to know the exact distance in lines in the used font for a page on the printer, then in your loop, check the following thing:

execute your query without LIMIT (because you want it al in one page so you can print it, I assume)

<?
$query="SELECT your,stuff FROM your_table";
$querydone=mysql_query($query,$connectionid);

//i asume you have 20 items per page, this you will have to figure out yourself because its variable to the fontsize, fontfamily, etc..

$itemsperpage=20;
if ($i%$itemsperpage==0) {
if (mysql_num_rows($<yourquerydone>)<$i+$itemsperpage) {echo "finished";}
else {echo "continued";"}
}
?>

I hope this helps more :o)

saltwater

$<yourquerydone> should have been $querydone :o)

and
else {echo "continued";"}
should be
else {echo "continued";}

:o)
I type to fast :p