Web Development Tutorials, Programming Tutorial, Ajax Tutroials, PHP Codes, Ajax Resources

Ajax Tutorials, PHP Tutorials, Javascript Tutorials, Visual Basic.Net Training, XHTML tutorials, php script library, PHP Codes, Programming tutorials, web development tutorials

Programming Articles

  PHP articles
  MySql articles
  Visual Basic.Net articles
  Java articles
  ASP articles
  ASP.Net articles
  Visual Basic articles
  CSS articles

Programming Tutorials

  PHP tutorials
  MySql tutorials
  Visual Basic.Net tutorials
  Java tutorials
  ASP tutorials
  ASP.Net tutorials
  Visual Basic tutorials
  HTML tutorials
  CSS tutorials

Programming Source Codes

  PHP scripts
  Visual Basic.Net scripts
  JavaScript scripts
  ASP scripts
  ASP.Net scripts
  Visual Basic scripts

Paging in PHP/MYSQL

Author :

Date: 2006-02-27

Demo: N/A

Description : Paging in PHP/MYSQL

<?
include("dbconfig.php");


if(!isset($start)) {                         // This variable is set to zero for the first page
$start = 0;
}

$eu = ($start - 0); 
$limit = 15;                                 // No of records to be shown per page.
$this = $eu + $limit; 
$back = $eu - $limit; 
$next = $eu + $limit; 


$sql_query2=" SELECT * FROM students";
$sql_result2=mysql_query($sql_query2);
echo mysql_error();
$nume=mysql_num_rows($sql_result2);

$query="SELECT * FROM students limit $eu, $limit ";

$result=mysql_query($query);
print "<table class=dotted align=center cellpadding=0 cellspacing=0 width=95%>";
print "<tr>";
print "<td>";

print "<table border=0 align=center width=100%>";
print "<tr bgcolor=#D9E3EE>";
	print "<td width=350>Name</td>";
	print "<td width=85 valign=top>Class</td>";
	print "<td valign=top class=title1>Date</td>";
	print "<td valign=top class=title1>Fee</td>";

print "</tr>";
//////////////// Now we will display the returned records in side the rows of the table/////////
while($rows = mysql_fetch_array($result))
{

print "<tr>";
	print "<td width=350>".$rows['name']."</td>";


	print "<td valign=top class=text2>".$rows['class]."</td>";
	print "<td valign=top class=text2>".$rows['join_date']."</td>";
	print "<td valign=top class=text2>".$rows['fee']."</td>";
	
print "</tr>";


}

print "</table>";



////////////////////////////// End of displaying the table with records ////////////////////////

/////////////// Start the buttom links with Prev and next link with page numbers /////////////////
echo "<table align=center border='0' cellpadding='3' cellspacing='3' style='border-collapse: collapse' bordercolor='#111111' width='600.6' id='AutoNumber4'>";
echo "</td><td  align='center'>";
//// if our variable $back is equal to 0 or more then only we will display the link to move back ////////
if($back >=0) { 
print "<a href='students.php?start=$back'><font face='Arial' size='2'>PREV</font></a>"; 
}
else{

//print "<font face='Arial' size='2'>PREV</font>"; 

} 
//////////////// Let us display the page links at  center. We will not display the current page as a link ///////////
print "    ";

if($this < $nume) { 
	print "<a href='students.php?start=$next'><font face='Arial' size='2'>NEXT</font></a>";
} 
else{
	//print "<font face='Arial' size='2'>NEXT</font>";

}

echo "</td></tr></table>";
echo "</td></tr></table>";
echo "<br>";

?>

Copyright Programming Tutorials, Web Development Tutorials, Source codes © All Rights are Reserved.
Powered By Evernew Solutions

Credit Card Consolidation - Credit Counseling - Remortgage - Vegas Hotel

Programming Articles

Programming Tutorials

Programming Source Codes

Our Partners

Paging in PHP/MYSQL

Add Comment: