column heading on multiple pages

dopedope

Recently I was asked to develop a web based report that would collect data from a database, format it in an HTML page and then print on each page with a column header on each new page.

i have no problem with a single page, but when the result returned is more then a page length, the second page result will be display with no column header, and the user is having problem reading it.

my question is whether how can i put column header in every page before the results? or is there any tutorial on this topic?

planetsim

Im not quite sure on what you are trying to accomplish could you display some code you have?

hot_ice83

Hi,

I'm not sure whether this is what u meant but from my understanding u wanted to display a dynamic title depending on the # of pages of results is that correct?

If this is the case, I would suggest reading the Pagination section in the Database Forums (its excellent!). Then at your page results you can just change the title to echo $page
Not sure if you understood that. This is what i meant.

<html>
<head>
<title>Results <?php echo $page; ?> of <?php echo $pagenum; ?></title>
</head>
.....
.....
</html>

This bit should show up as something like
Results 2 of 7
in the title bar of your browser.

u can either do it hardcoded that way OR u can use javascript to change ur title on the fly. if i remember correctly the code should be document.title but please research on it first cos i'm not too sure.

hope this helps.:bemused:

dopedope

thanks for the reply, its not the page header i need.

i performed a query and returned a bunch of results, says 200 results with 5 columns each returned. so for the first page, i'll display the column header on each column, then start the while loop to retrieve the results and display them into multiple pages, now the problem is the column header only display in the first page, the rest of it will be only results with no header, so the reader having problem after they print the results out.

hot_ice83

aaah i'm sorry about that.

Well if its the column headers then i think u'll need to use the pagination script to split ur results into different pages. Let's say u have a search query that returns 200 results and u show 50 results in each page separated into 4 pages then u'll be able to make a simple template to show the results including headers, format of columns etc.

The pagination explanation is relevant for this so please read it in the FAQ of the Database Forum.

U can also have a drop down list to let users choose the # of results they want to display in each page. Along with javascript u can use that to reload the page. To be able to print it all tho, u'd have to play around with print scripts imo because if u use the pagination scripts u'd have to go to each one and print the result page 1 at a time thru the browser.

Hope this helps.
If you can, please post some code to clarify it. But try to implement the pagination script first. Its useful for queries that returns a lot of results.

dopedope

i have done the pagination, but i'm not very sure how to insert the column header into the second page.

here's the code i wrote

//PAGINATION STARTS HERE

$allpages = ceil($countNosearchedRecord / $perpage);

if( isset($_POST['pageno']))
        {
  	$pageno = intval( $_POST['pageno'] );
        }

echo "No of Record Found : $countNosearchedRecord<br>";
echo "Current page number = $pageno of $allpages";


$offset = ($pageno -1)* $perpage;

$searchRecord = ibase_query($connSearch, "SELECT FIRST($perpage) SKIP($offset) column01, column02, column03 FROM TABLENAME WHERE  EI='X'");

if(!$searchRecord)
       {
       echo "Query Failed, Please reselect";
       }

//START DISPLAYING RESULT

echo "<table width='100%'  border='0' cellspacing='1' cellpadding='2' class='std_black'>

<tr>
<td colspan='7' bgcolor='#cccccc' style='border-bottom:1px solid #999999;'>RESULT</td>
</tr>";

echo "<tr>
<td width='75' bgcolor='#cccccc' style='border-bottom:1px solid #999999;'>Column01</td>
<td width='150' bgcolor='#cccccc' style='border-bottom:1px solid #999999;'>Column02</td>
<td width='75' bgcolor='#cccccc' style='border-bottom:1px solid #999999;'>Column03</td>
</tr>";

//this is where i want to control the number of results display per page, if the results returned is more than the number i assigned, it should start a new page with the column01,column02,column03's header.

while ($row = ibase_fetch_row($searchRecord))

     {
echo "<tr>";
            echo "<td width='75'>$row[0]</td>
                      <td width='150'>$row[1]</td>
                       <td width='75'>$row[2]</td>			echo "</tr>";
      }

echo "<tr><td colspan='7' style='border-top:1px solid #999999;'>&nbsp;</td></tr>";

echo "</table>";
		}}

dopedope

btw i'm using php4 & borland interbase

thanks

hot_ice83

Hi,

I'm not really sure about borland interbase so I'm sorry but I can't help u with the queries.

However, I think its correct already.

echo "<table width='100%'  border='0' cellspacing='1' cellpadding='2' class='std_black'> 

<tr> 
<td colspan='7' bgcolor='#cccccc' style='border-bottom:1px solid #999999;'>RESULT</td> 
</tr>"; 

echo "<tr> 
<td width='75' bgcolor='#cccccc' style='border-bottom:1px solid #999999;'>Column01</td> 
<td width='150' bgcolor='#cccccc' style='border-bottom:1px solid #999999;'>Column02</td> 
<td width='75' bgcolor='#cccccc' style='border-bottom:1px solid #999999;'>Column03</td> 
</tr>";

From these lines, it means that the column headers would then print at every page from then on and then show the results.

Have u tested it with a browser?
How does it look? Hopefully it works.

Btw, its not in the code that u pasted but I just wanted to remind u to set a variable to $countNosearchedRecord and $perpage at the beginning to prevent errors.

And also for $POST['pageno'] i think its better if u passed it thru the URL like www.mysite.com/results.php?page=1 because from my understanding $POST['pageno'] will be null when u reload the page. U'd have to set a default value for $pageno as well in the if statement. Maybe just add a

else {
$pageno = 1;
}

after the if statement to prevent $pageno from being NULL.

Also include a next/previous/page numbers at the bottom I think thats quite important so that u can actually view the rest of the results. From there u can pass the page numbers in the URL like the above example.

Thats all I can see from this segment of the code.

Hope it helps 😃