Paging problem in php

Sat Oct 18, 2008 7:48 am

PHP Paging Code Example:

Code:: <? //* ?> <!doctype html public "-//w3c//dtd html 3.2//en"> <html> <head> <title>Codemiles.com paging script in PHP</title> <meta name="GENERATOR" content="Arachnophilia 4.0"> <meta name="FORMATTER" content="Arachnophilia 4.0"> </head> <body bgcolor="#ffffff" text="#000000" link="#0000ff" vlink="#800080" alink="#ff0000"> <? require "config.php"; // All database details will be included here $page_name="php_paging.php"; // If you use this code with a different page ( or file ) name then change this $start=$_GET['start']; // To take care global variable if OFF if(!($start > 0)) { // This variable is set to zero for the first page $start = 0; } $eu = ($start -0); $limit = 2; // No of records to be shown per page. $this1 = $eu + $limit; $back = $eu - $limit; $next = $eu + $limit; //WE have to find out the number of records in our table. We will use this to break the pages/////// $query2=" SELECT * FROM student_adv "; $result2=mysql_query($query2); echo mysql_error(); $nume=mysql_num_rows($result2); /////// The variable nume above will store the total number of records in the table//// /////////// Now let us print the table headers //////////////// $bgcolor="#f1f1f1"; echo "<TABLE width=50% align=center cellpadding=0 cellspacing=0> <tr>"; echo "<td bgcolor='dfdfdf' > ID</td>"; echo "<td bgcolor='dfdfdf' > Name</td>"; echo "<td bgcolor='dfdfdf' > Class</td>"; echo "<td bgcolor='dfdfdf'> Mark</td></tr>"; // Now let us start executing the query with variables $eu and $limit set at the top of the page $query=" SELECT * FROM student_adv limit $eu, $limit "; $result=mysql_query($query); echo mysql_error(); // Now we will display the returned records in side the rows of the table while($noticia = mysql_fetch_array($result)) { if($bgcolor=='#f1f1f1'){$bgcolor='#ffffff';} else{$bgcolor='#f1f1f1';} echo "<tr >"; echo "<td align=left bgcolor=$bgcolor id='title'> $noticia[id]</td>"; echo "<td align=left bgcolor=$bgcolor id='title'> $noticia[name]</td>"; echo "<td align=left bgcolor=$bgcolor id='title'> $noticia[class]</td>"; echo "<td align=left bgcolor=$bgcolor id='title'> $noticia[mark]</td>"; echo "</tr>"; } echo "</table>"; // End of displaying the table with records /// Variables set for advance paging/////////// $p_limit=8; // This should be more than $limit and set to a value for whick links to be breaked $p_f=$_GET['p_f']; // To take care global variable if OFF if(!($p_f > 0)) { // This variable is set to zero for the first page $p_f = 0; } $p_fwd=$p_f+$p_limit; $p_back=$p_f-$p_limit; /// End of variables for advance paging // Start the buttom links with Prev and next link with page numbers ///////////////// echo "<table align = 'center' width='50%'><tr><td align='left' width='20%'>"; if($p_f<>0){print "<a href='$page_name?start=$p_back&p_f=$p_back'>PREV $p_limit</a>"; } echo "</td><td align='left' width='10%'>"; // if our variable $back is equal to 0 or more then only we will display the link to move back //////// if($back >=0 and ($back >=$p_f)) { print "<a href='$page_name?start=$back&p_f=$p_f'>PREV</a>"; } // Let us display the page links at center. We will not display the current page as a link // echo "</td><td align=center width='30%'>"; for($i=$p_f;$i < $nume and $i<($p_f+$p_limit);$i=$i+$limit){ if($i <> $eu){ $i2=$i+$p_f; echo " <a href='$page_name?start=$i&p_f=$p_f'>$i</a> "; } else { echo "$i";} /// Current page is not displayed as link and given font color red } echo "</td><td align='right' width='10%'>"; ///////////// If we are not in the last page then Next link will be displayed. Here we check that ///// if($this1 < $nume and $this1 <($p_f+$p_limit)) { print "<a href='$page_name?start=$next&p_f=$p_f'>NEXT</a>";} echo "</td><td align='right' width='20%'>"; if($p_fwd < $nume){ print "<a href='$page_name?start=$p_fwd&p_f=$p_fwd'>NEXT $p_limit</a>"; } echo "</td></tr></table>"; ?> <center><a href='http://www.Codemiles.com'>PHP Paging link page</a></center> </body> </html>

Sun Oct 19, 2008 10:27 am

here is a code for paging in php ,

Attachments

advance_php_paging.zip: code for paging in php; (3.73 KiB) Downloaded 1079 times

Paging problem in php

Paging problem in php

Re: Paging problem in php

Topic Tags