page break

[chyan]

i display some data with php from database, and i want to perform page break in middle of my looping so the rest of data display in next page
anyone can help?

[planetsim]

Take a look for pagination

[PHPMagician]

<?php
// Count the number of records which exist in the database
$count='SELECT count(*) FROM database';
$count=do_query($count);
list($count) = db_fetch_array($count);

// Devide number by the number of records to be on each page

// $amt is the amout per page
$amt=20;
// This is the amount of pages which will exist
$pages=ceil($count/$amt);

if ($_GET['page'] <= $pages && $_GET['page'] > 0)
{
    $offset=$page*$amt;
}
else
{
    $offset=0;
}

// Your query
$query="SELECT * FROM db LIMIT $offset, ". ($offset+$amt);
do_query($query);

for($i=0; $i < $pages; $i++)
{
    $x=$i+1;
    echo "<a href=" . $_SERVER['PHP_SELF'] ."?page=" . $x . ">". $x . "</a>";
}

That is example code (not working). That is a simple logic which should work. Not very cleanly code, mainly because it is a quick example to help you derive you own solution and I typed it directly into the textarea.

If you have questions or I have misunderstood the problem, tell me.

[chyan]

i got it working now 🙂
i'm using css style to perform page break

echo "<style type='text/css'>";
echo "div.breakhere{page-break-before:always}";
echo "</style>";

[PHPMagician]

Opps, I misunderstood the problem. When you say 'next page', you meant in as scrolling down a bit to see it? I though you meant like a new page altogether. It wouldn't really be possible in PHP would it, because you would need to know the size of the client.

[chyan]

yes, what i mean by page break isnt to break it on screen but its for
printing purpose, i have looping a data that consist of logo header and
vary of data thats why i need to break it because i dont know how much the data
will take place in paper, so if all the data had fetched, i need to break in order
to print the header logo in the new page not in the same page with data from the item before