Location: PHPKode > scripts > SPA Simple Paging Class > spa-simple-paging-class/documentation.htm
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
	<META HTTP-EQUIV="CONTENT-TYPE" CONTENT="text/html; charset=windows-1252">
	<TITLE></TITLE>
	<META NAME="GENERATOR" CONTENT="OpenOffice.org 2.2  (Win32)">
	<META NAME="CREATED" CONTENT="20070809;12292300">
	<META NAME="CHANGED" CONTENT="20070809;21070595">
	<STYLE TYPE="text/css">
	<!--
		@page { size: 8.5in 11in; margin: 0.79in }
		P { margin-bottom: 0.08in }
		TD P { margin-bottom: 0in }
	-->
	</STYLE>
</HEAD>
<BODY LANG="en-US" DIR="LTR">
<FORM NAME="unnamed0" ACTION="https://www.paypal.com/cgi-bin/webscr" METHOD="POST">
	<INPUT TYPE=HIDDEN NAME="cmd" VALUE="_s-xclick">
</FORM>
<DIV TYPE=HEADER>
	<P ALIGN=CENTER STYLE="margin-bottom: 0.2in"><FONT COLOR="#999999"><FONT SIZE=4 STYLE="font-size: 16pt"><B>SPA
	Simple Paging Class </B></FONT></FONT><FONT COLOR="#999999"><FONT SIZE=2 STYLE="font-size: 9pt"><SPAN STYLE="font-weight: medium">by
	spabhat</SPAN></FONT></FONT><FONT COLOR="#999999"><FONT SIZE=4 STYLE="font-size: 16pt"><B>
	-</B></FONT></FONT><FONT SIZE=4 STYLE="font-size: 16pt"><B> </B></FONT><FONT COLOR="#9999cc"><B>Version
	2.0</B></FONT></P>
</DIV>
<P ALIGN=LEFT STYLE="margin-bottom: 0in"><FONT COLOR="#4c4c4c"><FONT SIZE=2 STYLE="font-size: 11pt"><U><B>SPA
Simple Paging Class</B></U></FONT></FONT></P>
<P ALIGN=LEFT STYLE="margin-bottom: 0in"><FONT COLOR="#4c4c4c"><FONT SIZE=2 STYLE="font-size: 11pt"><U><B>License:</B></U></FONT></FONT></P>
<P ALIGN=CENTER STYLE="margin-bottom: 0in; font-weight: medium; text-decoration: none">
<FONT COLOR="#4c4c4c"><FONT SIZE=2 STYLE="font-size: 11pt">The SPA
Simple Paging Class Ships with the </FONT></FONT>
</P>
<P ALIGN=CENTER STYLE="margin-bottom: 0in">GNU GENERAL PUBLIC LICENSE</P>
<PRE STYLE="margin-bottom: 0.2in; text-align: center">Version 3, 29 June 2007</PRE><P ALIGN=JUSTIFY STYLE="margin-bottom: 0in">
<FONT COLOR="#4c4c4c"><FONT SIZE=2 STYLE="font-size: 11pt"><SPAN STYLE="font-weight: medium">	</SPAN><B>W</B><SPAN STYLE="font-weight: medium">ith
the help of </SPAN><B>SPA Simple Paging Class</B> you can easily
implement stylish paging on your site within 30 Seconds!!!.</FONT></FONT></P>
<P ALIGN=JUSTIFY STYLE="margin-bottom: 0in"><FONT COLOR="#4c4c4c"><FONT SIZE=2 STYLE="font-size: 11pt">	<B>I</B>mplementing
the paging class is one of the easiest task, and it does not require
too many customization. It just takes a table name, or a SQL script
as input returns the number of pages. The paging class can be used on
a single table or even with custom simple / complex SQL statements.
ie. it now Supports JOINS, Nested SQL, UNION etc...</FONT></FONT></P>
<P ALIGN=JUSTIFY STYLE="margin-bottom: 0in"><BR>
</P>
<P ALIGN=CENTER STYLE="margin-bottom: 0in"><BR>
</P>
<P ALIGN=CENTER STYLE="margin-bottom: 0in"><BR>
</P>
<P STYLE="margin-bottom: 0in"><FONT COLOR="#4c4c4c"><FONT SIZE=2 STYLE="font-size: 11pt"><U><B>Advantages</B></U></FONT></FONT></P>
<OL>
	<LI><P STYLE="margin-bottom: 0in"><FONT COLOR="#4c4c4c"><FONT SIZE=2 STYLE="font-size: 11pt">Easy
	to use &ndash; with just 4 simple steps.</FONT></FONT></P>
	<LI><P STYLE="margin-bottom: 0in"><FONT COLOR="#4c4c4c"><FONT SIZE=2 STYLE="font-size: 11pt">Supports
	CSS &ndash; That means you have total control on the look and feel.</FONT></FONT></P>
	<LI><P STYLE="margin-bottom: 0in"><FONT COLOR="#4c4c4c"><FONT SIZE=2 STYLE="font-size: 11pt">The
	code generated is 100% compliant with W3C XHTML standards.</FONT></FONT></P>
	<LI><P STYLE="margin-bottom: 0in"><FONT COLOR="#4c4c4c"><FONT SIZE=2 STYLE="font-size: 11pt">Supports
	single table, custom SQL, Nested SQL, Joins, Union.</FONT></FONT></P>
	<LI><P STYLE="margin-bottom: 0in"><FONT COLOR="#4c4c4c"><FONT SIZE=2 STYLE="font-size: 11pt">Built
	in support for English, and French languages.</FONT></FONT></P>
	<LI><P STYLE="margin-bottom: 0in"><FONT COLOR="#4c4c4c"><FONT SIZE=2 STYLE="font-size: 11pt">Ability
	to easily add support for other languages.</FONT></FONT></P>
	<LI><P STYLE="margin-bottom: 0in"><FONT COLOR="#4c4c4c"><FONT SIZE=2 STYLE="font-size: 11pt">Automatically
	includes existing query strings.</FONT></FONT></P>
	<LI><P STYLE="margin-bottom: 0in"><FONT COLOR="#4c4c4c"><FONT SIZE=2 STYLE="font-size: 11pt">Supports
	multiple paging on same page!!!</FONT></FONT></P>
	<P STYLE="margin-bottom: 0in"></P>
</OL>
<P STYLE="margin-bottom: 0in"><FONT COLOR="#4c4c4c"><FONT SIZE=2 STYLE="font-size: 11pt"><U><B>Disadvantages
/ Known Issues</B></U></FONT></FONT></P>
<OL>
	<LI><P STYLE="margin-bottom: 0in"><FONT COLOR="#4c4c4c"><FONT SIZE=2 STYLE="font-size: 11pt">Current
	development version support only MySQL database.<BR>Future versions
	are in pipeline to support all known databases.</FONT></FONT></P>
</OL>
<P STYLE="margin-bottom: 0in"><BR>
</P>
<P STYLE="margin-bottom: 0in; page-break-before: always"><FONT COLOR="#4c4c4c"><FONT SIZE=2 STYLE="font-size: 11pt"><U><B>Requirements</B></U></FONT></FONT></P>
<UL>
	<LI><P STYLE="margin-bottom: 0in; font-weight: medium"><FONT COLOR="#4c4c4c"><FONT SIZE=2 STYLE="font-size: 11pt">PHP
	5 </FONT></FONT>
	</P>
	<LI><P STYLE="margin-bottom: 0in; font-weight: medium"><FONT COLOR="#4c4c4c"><FONT SIZE=2 STYLE="font-size: 11pt">MySql
	4 <FONT COLOR="#4c4c4c"><SPAN STYLE="font-weight: medium">and above.</SPAN></FONT></FONT></FONT></P>
	<LI><P STYLE="margin-bottom: 0in; font-weight: medium"><FONT COLOR="#4c4c4c"><FONT SIZE=2 STYLE="font-size: 11pt">Apache
	/ IIS</FONT></FONT></P>
</UL>
<P STYLE="margin-bottom: 0in"><BR>
</P>
<P STYLE="margin-bottom: 0in"><FONT COLOR="#4c4c4c"><FONT SIZE=2 STYLE="font-size: 11pt"><U><B>Quick
Usage code:</B></U></FONT></FONT></P>
<P STYLE="margin-bottom: 0in"><FONT COLOR="#4c4c4c"><FONT SIZE=2 STYLE="font-size: 11pt"><B>	NOTE:
</B><SPAN STYLE="font-weight: medium">Kindly refer to the
&ldquo;paging.php&rdquo; file, which contains sample code for
implementing the paging class using four different CSS styles.</SPAN></FONT></FONT></P>
<P STYLE="margin-bottom: 0in; font-weight: medium"><BR>
</P>
<P STYLE="margin-bottom: 0in; font-weight: medium"><FONT COLOR="#4c4c4c"><FONT SIZE=2 STYLE="font-size: 11pt">&lt;!DOCTYPE
html PUBLIC &quot;-//W3C//DTD XHTML 1.0 Transitional//EN&quot;
&quot;http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd&quot;&gt;</FONT></FONT></P>
<P STYLE="margin-bottom: 0in; font-weight: medium"><FONT COLOR="#4c4c4c"><FONT SIZE=2 STYLE="font-size: 11pt">&lt;html
xmlns=&quot;http://www.w3.org/1999/xhtml&quot;&gt;</FONT></FONT></P>
<P STYLE="margin-bottom: 0in; font-weight: medium"><FONT COLOR="#4c4c4c"><FONT SIZE=2 STYLE="font-size: 11pt">&lt;head&gt;</FONT></FONT></P>
<P STYLE="margin-bottom: 0in; font-weight: medium"><FONT COLOR="#4c4c4c"><FONT SIZE=2 STYLE="font-size: 11pt">&lt;meta
http-equiv=&quot;Content-Type&quot; content=&quot;text/html;
charset=iso-8859-1&quot; /&gt;</FONT></FONT></P>
<P STYLE="margin-bottom: 0in; font-weight: medium"><FONT COLOR="#4c4c4c"><FONT SIZE=2 STYLE="font-size: 11pt">&lt;title&gt;SPA
Paging Style&lt;/title&gt;</FONT></FONT></P>
<P STYLE="margin-bottom: 0in; font-weight: medium"><FONT COLOR="#4c4c4c"><FONT SIZE=2 STYLE="font-size: 11pt">&lt;link
type=&quot;text/css&quot; href=&quot;paging.css&quot;
rel=&quot;stylesheet&quot; media=&quot;screen&quot; /&gt;</FONT></FONT></P>
<P STYLE="margin-bottom: 0in; font-weight: medium"><FONT COLOR="#4c4c4c"><FONT SIZE=2 STYLE="font-size: 11pt">&lt;/head&gt;</FONT></FONT></P>
<P STYLE="margin-bottom: 0in; font-weight: medium"><FONT COLOR="#4c4c4c"><FONT SIZE=2 STYLE="font-size: 11pt">&lt;body&gt;</FONT></FONT></P>
<P STYLE="margin-bottom: 0in; font-weight: medium; text-decoration: none">
<FONT COLOR="#4c4c4c"><FONT SIZE=2 STYLE="font-size: 11pt">&lt;p&gt;Default
Paging Style: &lt;/p&gt;</FONT></FONT></P>
<P STYLE="margin-bottom: 0in; font-weight: medium; text-decoration: none">
<FONT COLOR="#4c4c4c"><FONT SIZE=2 STYLE="font-size: 11pt">&lt;?php</FONT></FONT></P>
<P STYLE="margin-bottom: 0in; font-weight: medium; text-decoration: none">
<FONT COLOR="#4c4c4c"><FONT SIZE=2 STYLE="font-size: 11pt">include_once(&quot;paging.class.php&quot;);
// include the paging class</FONT></FONT></P>
<P STYLE="margin-bottom: 0in; font-weight: medium; text-decoration: none">
<BR>
</P>
<P STYLE="margin-bottom: 0in; font-weight: medium; text-decoration: none">
<FONT COLOR="#4c4c4c"><FONT SIZE=2 STYLE="font-size: 11pt">/*
database connectivity */</FONT></FONT></P>
<P STYLE="margin-bottom: 0in; font-weight: medium; text-decoration: none">
<FONT COLOR="#4c4c4c"><FONT SIZE=2 STYLE="font-size: 11pt">mysql_connect(&quot;localhost&quot;,&quot;root&quot;,&quot;&quot;);
//you need to modify the connection settings</FONT></FONT></P>
<P STYLE="margin-bottom: 0in; font-weight: medium; text-decoration: none">
<FONT COLOR="#4c4c4c"><FONT SIZE=2 STYLE="font-size: 11pt">mysql_select_db(&quot;db_wikitime&quot;);
//you need to change the database name</FONT></FONT></P>
<P STYLE="margin-bottom: 0in; font-weight: medium; text-decoration: none">
<BR>
</P>
<P STYLE="margin-bottom: 0in; font-weight: medium; text-decoration: none">
<FONT COLOR="#4c4c4c"><FONT SIZE=2 STYLE="font-size: 11pt">$sql =
&quot;select * from comments&quot;; //your custom sql statement</FONT></FONT></P>
<P STYLE="margin-bottom: 0in; font-weight: medium; text-decoration: none">
<BR>
</P>
<P STYLE="margin-bottom: 0in; font-weight: medium; text-decoration: none">
<FONT COLOR="#4c4c4c"><FONT SIZE=2 STYLE="font-size: 11pt">$<FONT COLOR="#4c4c4c"><SPAN STYLE="font-weight: medium">spPage</SPAN></FONT>
= new spa_paging; //create an instance of paging class</FONT></FONT></P>
<P STYLE="margin-bottom: 0in; font-weight: medium; text-decoration: none">
<FONT COLOR="#4c4c4c"><FONT SIZE=2 STYLE="font-size: 11pt">$sql =
$<FONT COLOR="#4c4c4c"><SPAN STYLE="font-weight: medium">spPage</SPAN></FONT>-&gt;pagingSql($sql);
//parse the sql thru paging class</FONT></FONT></P>
<P STYLE="margin-bottom: 0in; font-weight: medium; text-decoration: none">
<BR>
</P>
<P STYLE="margin-bottom: 0in; font-weight: medium; text-decoration: none">
<FONT COLOR="#4c4c4c"><FONT SIZE=2 STYLE="font-size: 11pt">echo
$<FONT COLOR="#4c4c4c"><SPAN STYLE="font-weight: medium">spPage</SPAN></FONT>-&gt;getInfo();
//dispaly paging using the default style</FONT></FONT></P>
<P STYLE="margin-bottom: 0in; font-weight: medium; text-decoration: none">
<FONT COLOR="#4c4c4c"><FONT SIZE=2 STYLE="font-size: 11pt">?&gt;</FONT></FONT></P>
<P STYLE="margin-bottom: 0in; font-weight: medium; text-decoration: none">
<FONT COLOR="#4c4c4c"><FONT SIZE=2 STYLE="font-size: 11pt">&lt;h3&gt;Implementing
the paging with your SQL query:&lt;/h3&gt;</FONT></FONT></P>
<P STYLE="margin-bottom: 0in; font-weight: medium; text-decoration: none">
<FONT COLOR="#4c4c4c"><FONT SIZE=2 STYLE="font-size: 11pt">&lt;?php</FONT></FONT></P>
<P STYLE="margin-bottom: 0in; font-weight: medium; text-decoration: none">
<FONT COLOR="#4c4c4c"><FONT SIZE=2 STYLE="font-size: 11pt">//specify
your SQL statement here, and append it with paging SQL</FONT></FONT></P>
<P STYLE="margin-bottom: 0in; font-weight: medium; text-decoration: none">
<BR>
</P>
<P STYLE="margin-bottom: 0in; font-weight: medium; text-decoration: none">
<FONT COLOR="#4c4c4c"><FONT SIZE=2 STYLE="font-size: 11pt">$resultRes
= mysql_query($sql);</FONT></FONT></P>
<P STYLE="margin-bottom: 0in; font-weight: medium; text-decoration: none">
<FONT COLOR="#4c4c4c"><FONT SIZE=2 STYLE="font-size: 11pt">while($row
= mysql_fetch_assoc($resultRes) )</FONT></FONT></P>
<P STYLE="margin-bottom: 0in; font-weight: medium; text-decoration: none">
<FONT COLOR="#4c4c4c"><FONT SIZE=2 STYLE="font-size: 11pt">{</FONT></FONT></P>
<P STYLE="margin-bottom: 0in; font-weight: medium; text-decoration: none">
<FONT COLOR="#4c4c4c"><FONT SIZE=2 STYLE="font-size: 11pt">	echo ++$i
. &quot; ) &quot; . $row['commentText'] . &quot;&lt;br /&gt;&quot;;</FONT></FONT></P>
<P STYLE="margin-bottom: 0in; font-weight: medium; text-decoration: none">
<FONT COLOR="#4c4c4c"><FONT SIZE=2 STYLE="font-size: 11pt">}</FONT></FONT></P>
<P STYLE="margin-bottom: 0in; font-weight: medium; text-decoration: none">
<FONT COLOR="#4c4c4c"><FONT SIZE=2 STYLE="font-size: 11pt">?&gt;</FONT></FONT></P>
<P STYLE="margin-bottom: 0in; font-weight: medium; text-decoration: none">
<FONT COLOR="#4c4c4c"><FONT SIZE=2 STYLE="font-size: 11pt">&lt;/body&gt;</FONT></FONT></P>
<P STYLE="margin-bottom: 0in; font-weight: medium"><FONT COLOR="#4c4c4c"><FONT SIZE=2 STYLE="font-size: 11pt"><U>&lt;/html&gt;</U></FONT></FONT></P>
<P STYLE="margin-bottom: 0in; page-break-before: always"><FONT COLOR="#4c4c4c"><FONT SIZE=2 STYLE="font-size: 11pt"><U><B>Implementation
steps in detail</B></U></FONT></FONT></P>
<P STYLE="margin-bottom: 0in"><FONT COLOR="#4c4c4c"><FONT SIZE=2 STYLE="font-size: 11pt"><B>	F</B><SPAN STYLE="font-weight: medium">ollow
these 4 simple steps and display paging in 30 seconds:<BR></SPAN></FONT></FONT><BR>
</P>
<OL>
	<LI><P STYLE="margin-bottom: 0in"><FONT COLOR="#4c4c4c"><FONT SIZE=2 STYLE="font-size: 11pt"><SPAN STYLE="font-weight: medium">Copy
	the two required files to the root folder</SPAN><FONT COLOR="#4c4c4c"><SPAN STYLE="font-weight: medium">
	and give a link to the style sheet and paging class.</SPAN></FONT></FONT></FONT></P>
	<LI><P STYLE="margin-bottom: 0in; font-weight: medium"><FONT COLOR="#4c4c4c"><FONT SIZE=2 STYLE="font-size: 11pt">Write
	PHP code to create an instance of paging class, and assign the table
	name to it.</FONT></FONT></P>
	<LI><P STYLE="margin-bottom: 0in; font-weight: medium"><FONT COLOR="#4c4c4c"><FONT SIZE=2 STYLE="font-size: 11pt">Parse
	your custom SQL query to Paging class.</FONT></FONT></P>
	<LI><P STYLE="margin-bottom: 0in; font-weight: medium"><FONT COLOR="#4c4c4c"><FONT SIZE=2 STYLE="font-size: 11pt">Display
	the paging information at required location.</FONT></FONT></P>
</OL>
<P STYLE="margin-bottom: 0in; font-weight: medium"><BR>
</P>
<OL>
	<LI><P STYLE="margin-bottom: 0in; font-weight: medium"><FONT COLOR="#4c4c4c"><FONT SIZE=2 STYLE="font-size: 11pt">Copy
	the two required files to the root folder and give a link to the
	style sheet and paging class.</FONT></FONT></P>
</OL>
<P STYLE="margin-left: 0.49in; margin-bottom: 0in; font-weight: medium">
<FONT COLOR="#4c4c4c"><FONT SIZE=2 STYLE="font-size: 11pt">Copy the
following two files to the root folder.</FONT></FONT></P>
<UL>
	<LI><P STYLE="margin-bottom: 0in; font-weight: medium"><FONT COLOR="#4c4c4c"><FONT SIZE=2 STYLE="font-size: 11pt">paging.class.php</FONT></FONT></P>
	<LI><P STYLE="margin-bottom: 0in; font-weight: medium"><FONT COLOR="#4c4c4c"><FONT SIZE=2 STYLE="font-size: 11pt">paging.css<BR></FONT></FONT><BR>
	</P>
	<P STYLE="margin-bottom: 0in"><FONT COLOR="#4c4c4c"><FONT SIZE=2 STYLE="font-size: 11pt"><FONT COLOR="#4c4c4c"><SPAN STYLE="font-weight: medium">Give
	link to the style sheet by putting the following code in between the
	&lt;head&gt; tag of the page:<BR></SPAN></FONT><FONT COLOR="#4c4c4c"><B>&lt;link
	type=&quot;text/css&quot; href=&quot;paging.css&quot;
	rel=&quot;stylesheet&quot; media=&quot;screen&quot; /&gt;</B></FONT><FONT COLOR="#4c4c4c"><SPAN STYLE="font-weight: medium"><BR><BR>Give
	link to the paging class using the following code:<BR>
	<BR></SPAN></FONT><FONT COLOR="#4c4c4c"><I><B>include_once(&quot;paging.class.php&quot;);</B></I></FONT><FONT COLOR="#4c4c4c"><SPAN STYLE="font-weight: medium"><BR></SPAN></FONT></FONT></FONT><BR>
	</P>
</UL>
<OL START=2>
	<LI><P STYLE="margin-bottom: 0in; font-weight: medium"><FONT COLOR="#4c4c4c"><FONT SIZE=2 STYLE="font-size: 11pt"><FONT COLOR="#4c4c4c"><SPAN STYLE="font-weight: medium">Create
	an instance of the paging class as shown below:<BR><BR></SPAN></FONT><FONT COLOR="#4c4c4c"><I><B>$spPage
	= new spa_paging;</B></I></FONT><BR></FONT></FONT><BR>
	</P>
	<LI><P STYLE="margin-bottom: 0in; font-weight: medium"><FONT COLOR="#4c4c4c"><FONT SIZE=2 STYLE="font-size: 11pt">Parse
	your query through the pagingSql() method:<BR><BR><I><B>$sql =
	&quot;select * from comments&quot;;<BR></B></I>$sql =
	$spPage-&gt;pagingSql($sql);<SPAN STYLE="font-weight: medium"><BR></SPAN></FONT></FONT><BR>
	</P>
	<LI><P STYLE="margin-bottom: 0in; font-weight: medium"><FONT COLOR="#4c4c4c"><FONT SIZE=2 STYLE="font-size: 11pt"><FONT COLOR="#4c4c4c"><SPAN STYLE="font-weight: medium">Locate
	the place where you would like to display the paging and write the
	following code </SPAN></FONT><SPAN STYLE="font-weight: medium"><BR><BR></SPAN><FONT COLOR="#4c4c4c"><B>echo
	$spPage-&gt;getInfo();</B></FONT><FONT COLOR="#4c4c4c"><SPAN STYLE="font-weight: medium"><BR><BR>//
	Now you just need to display the records on your page using the
	following code:<BR></SPAN></FONT><SPAN STYLE="font-weight: medium"><BR>$resultRes
	= mysql_query($sql);<BR>while($row = mysql_fetch_assoc($resultRes)
	)<BR>{<BR>	echo ++$i . &quot; ) &quot; . $row['commentText'] ;<BR>	echo
	</SPAN><FONT COLOR="#4c4c4c"><SPAN STYLE="font-weight: medium">&quot;&lt;br
	/&gt;&quot;;</SPAN></FONT><SPAN STYLE="font-weight: medium"><BR>}</SPAN></FONT></FONT></P>
</OL>
<P STYLE="margin-bottom: 0in; page-break-before: always"><FONT COLOR="#4c4c4c"><FONT SIZE=2 STYLE="font-size: 11pt"><U><B>Customizing
the paging class:</B></U></FONT></FONT></P>
<P STYLE="margin-bottom: 0in; font-weight: medium"><FONT COLOR="#4c4c4c"><FONT SIZE=2 STYLE="font-size: 11pt">	The
paging class has various customization available, such as:</FONT></FONT></P>
<UL>
	<LI><P STYLE="margin-bottom: 0in; font-weight: medium"><FONT COLOR="#4c4c4c"><FONT SIZE=2 STYLE="font-size: 11pt"><FONT COLOR="#4c4c4c"><SPAN STYLE="font-weight: medium">Specifying
	the page size: </SPAN></FONT>&ndash; i.e. Number of rows per page.</FONT></FONT></P>
	<LI><P STYLE="margin-bottom: 0in; font-weight: medium"><FONT COLOR="#4c4c4c">
	<FONT SIZE=2 STYLE="font-size: 11pt">(Default English, and it even
	supports French)</FONT></FONT></P>
	<LI><P STYLE="margin-bottom: 0in; font-weight: medium"><FONT COLOR="#4c4c4c"><FONT SIZE=2 STYLE="font-size: 11pt">Specify
	custom  variable name instead of &ldquo;<B>spPage</B><SPAN STYLE="font-weight: medium">&rdquo;.</SPAN></FONT></FONT></P>
	<LI><P STYLE="margin-bottom: 0in; font-weight: medium"><FONT COLOR="#4c4c4c"><FONT SIZE=2 STYLE="font-size: 11pt">Specifying
	a start page- Allows you to directly display a page of your choice.</FONT></FONT></P>
	<LI><P STYLE="margin-bottom: 0in; font-weight: medium"><FONT COLOR="#4c4c4c"><FONT SIZE=2 STYLE="font-size: 11pt">Directly
	specify a table name instead of SQL script.</FONT></FONT></P>
</UL>
<P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium"><BR>
</P>
<OL>
	<LI><P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium"><FONT COLOR="#4c4c4c"><FONT SIZE=2 STYLE="font-size: 11pt">Specifying
	the page size:<BR><FONT COLOR="#4c4c4c"><B>$pg2-&gt;pageSize = 4;<BR></B></FONT></FONT></FONT><BR>
	</P>
	<LI><P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium"><FONT COLOR="#4c4c4c"><FONT SIZE=2 STYLE="font-size: 11pt"><FONT COLOR="#4c4c4c"><SPAN STYLE="font-weight: medium">Specifying
	the language:<BR></SPAN></FONT><FONT COLOR="#4c4c4c"><B>$pg2-&gt;language
	= &ldquo;fr&rdquo;; //to use French</B></FONT><FONT COLOR="#4c4c4c"><SPAN STYLE="font-weight: medium"><BR></SPAN></FONT></FONT></FONT><BR>
	</P>
	<LI><P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium"><FONT COLOR="#4c4c4c"><FONT SIZE=2 STYLE="font-size: 11pt"><FONT COLOR="#4c4c4c"><SPAN STYLE="font-weight: medium">Specifying
	custom  variable name instead of &ldquo;</SPAN></FONT><FONT COLOR="#4c4c4c"><B>spPage</B></FONT><FONT COLOR="#4c4c4c"><SPAN STYLE="font-weight: medium">&rdquo;.<BR></SPAN></FONT><FONT COLOR="#4c4c4c"><B>$pg2-&gt;pageVar
	= &quot;page&quot;;</B></FONT><FONT COLOR="#4c4c4c"><SPAN STYLE="font-weight: medium"><BR></SPAN></FONT></FONT></FONT><BR>
	</P>
	<LI><P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium"><FONT COLOR="#4c4c4c"><FONT SIZE=2 STYLE="font-size: 11pt"><FONT COLOR="#4c4c4c"><SPAN STYLE="font-weight: medium">Specifying
	a start page:<BR>If you are using default setting you just need to
	add the following to the url:<BR></SPAN></FONT><FONT COLOR="#4c4c4c"><B>http://url?spPage=&lt;required
	page number&gt;</B></FONT><FONT COLOR="#4c4c4c"><SPAN STYLE="font-weight: medium"><BR>ex:
	<BR> http://localhost/paging.php?spPage=4<BR>
	http://localhost/paging.php?spPage=10<BR><BR>If you are using a
	custom variable name instead of spPage
	then:<BR></SPAN></FONT><FONT COLOR="#4c4c4c"><B>http://url?&lt;custVarName&gt;=&lt;required
	page number&gt;</B></FONT><FONT COLOR="#4c4c4c"><SPAN STYLE="font-weight: medium"><BR><BR>ex:
	(consider variable name is mpage) <BR>
	http://localhost/paging.php?mpage=4<BR>
	http://localhost/paging.php?mpage=10<BR></SPAN></FONT></FONT></FONT><BR>
	</P>
	<LI><P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium"><FONT COLOR="#4c4c4c"><FONT SIZE=2 STYLE="font-size: 11pt">Directly
	specifying a table name instead of SQL script.<BR><BR><FONT COLOR="#4c4c4c"><B>$pg2
	= new spa_paging;</B></FONT><FONT COLOR="#4c4c4c"><SPAN STYLE="font-weight: medium">
	//create an instance of paging class with a different
	name<BR><BR></SPAN></FONT><FONT COLOR="#4c4c4c"><B>$pg2-&gt;tableName
	= &quot;comments&quot;;</B></FONT><FONT COLOR="#4c4c4c"><SPAN STYLE="font-weight: medium">
	//note the use of tale name instead of SQL query<BR><BR></SPAN></FONT><FONT COLOR="#4c4c4c"><B>$sql
	= $pg2-&gt;pagingSql();</B></FONT><FONT COLOR="#4c4c4c"><SPAN STYLE="font-weight: medium">
	//get the required SQL from paging class<BR></SPAN></FONT><FONT COLOR="#4c4c4c"><B>echo
	$pg2-&gt;getInfo();</B></FONT><FONT COLOR="#4c4c4c"><SPAN STYLE="font-weight: medium"><BR><BR></SPAN></FONT><FONT COLOR="#4c4c4c"><B>$resultRes
	= mysql_query($sql);</B></FONT><FONT COLOR="#4c4c4c"><SPAN STYLE="font-weight: medium">
	//executing the query</SPAN></FONT></FONT></FONT></P>
</OL>
<P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium"><BR>
</P>
<P ALIGN=LEFT STYLE="margin-bottom: 0in; page-break-before: always"><FONT COLOR="#4c4c4c"><FONT SIZE=2 STYLE="font-size: 11pt"><U><B>About
me</B></U></FONT></FONT></P>
<P ALIGN=LEFT STYLE="margin-bottom: 0in"><BR>
</P>
<TABLE WIDTH=665 BORDER=0 CELLPADDING=0 CELLSPACING=0>
	<COL WIDTH=160>
	<COL WIDTH=505>
	<TR VALIGN=TOP>
		<TD WIDTH=160 HEIGHT=119>
			<P ALIGN=CENTER><BR>
			</P>
		</TD>
		<TD WIDTH=505>
			<TABLE WIDTH=100% BORDER=0 CELLPADDING=0 CELLSPACING=0>
				<COL WIDTH=50*>
				<COL WIDTH=206*>
				<TR VALIGN=TOP>
					<TD WIDTH=19% HEIGHT=37>
						<P ALIGN=LEFT><FONT SIZE=2>Name: </FONT>
						</P>
					</TD>
					<TD WIDTH=81%>
						<P ALIGN=LEFT><FONT SIZE=2>Prakash A Bhat</FONT></P>
					</TD>
				</TR>
				<TR VALIGN=TOP>
					<TD WIDTH=19% HEIGHT=37>
						<P ALIGN=LEFT><FONT SIZE=2>Location: </FONT>
						</P>
					</TD>
					<TD WIDTH=81%>
						<P ALIGN=LEFT><FONT SIZE=2>Bangalore, India</FONT></P>
					</TD>
				</TR>
				<TR VALIGN=TOP>
					<TD WIDTH=19% HEIGHT=37>
						<P ALIGN=LEFT><FONT SIZE=2>Designation: </FONT>
						</P>
					</TD>
					<TD WIDTH=81%>
						<P ALIGN=LEFT><FONT SIZE=2>Software Developer</FONT></P>
					</TD>
				</TR>
				<TR VALIGN=TOP>
					<TD WIDTH=19% HEIGHT=37>
						<P ALIGN=LEFT><FONT SIZE=2>Software Skills: </FONT>
						</P>
					</TD>
					<TD WIDTH=81%>
						<P ALIGN=LEFT><FONT SIZE=2><B>Microsoft Technologies</B></FONT></P>
						<P ALIGN=LEFT><FONT SIZE=2>	ASP.NET, VB.NET, ASP, VB6</FONT></P>
						<P ALIGN=LEFT><FONT SIZE=2><BR><B>Web Developent Technologies</B></FONT></P>
						<P ALIGN=LEFT><FONT SIZE=2>	ASP, ASP.Net, PHP, </FONT>
						</P>
						<P ALIGN=LEFT><FONT SIZE=2>	AJAX, JavaScript, VBScript, </FONT>
						</P>
						<P ALIGN=LEFT><FONT SIZE=2>	HTML, DHTML, <BR>	Cascading Style
						Sheets (CSS)</FONT></P>
						<P ALIGN=LEFT><FONT SIZE=2><BR><B>XML based development</B></FONT></P>
						<P ALIGN=LEFT><FONT SIZE=2>	 XML, XSL, XSLT</FONT></P>
						<P ALIGN=LEFT><FONT SIZE=2><BR><B>Others:</B></FONT></P>
						<P ALIGN=LEFT><FONT SIZE=2>	DOM, COM, DCOM, ActiveX<BR><BR></FONT><BR>
						</P>
					</TD>
				</TR>
				<TR VALIGN=TOP>
					<TD WIDTH=19% HEIGHT=37>
						<P ALIGN=LEFT><FONT SIZE=2>E-mail: </FONT>
						</P>
					</TD>
					<TD WIDTH=81%>
						<P ALIGN=LEFT><FONT SIZE=2><A HREF="mailto:hide@address.com"></A><A HREF="mailto:hide@address.com"></A><A HREF="mailto:hide@address.com"><FONT SIZE=2>hide@address.com</FONT></A><A HREF="mailto:hide@address.com"></A><A HREF="mailto:hide@address.com"></A><FONT SIZE=2>
						/ </FONT><A HREF="mailto:hide@address.com"></A><A HREF="mailto:hide@address.com"></A><A HREF="mailto:hide@address.com"><FONT SIZE=2>hide@address.com</FONT></A><A HREF="mailto:hide@address.com"></A><A HREF="mailto:hide@address.com"></A></FONT></P>
					</TD>
				</TR>
				<TR VALIGN=TOP>
					<TD WIDTH=19% HEIGHT=37>
						<P ALIGN=LEFT><BR>
						</P>
					</TD>
					<TD WIDTH=81%>
						<P ALIGN=LEFT><FONT SIZE=2 STYLE="font-size: 11pt"><FONT SIZE=2 STYLE="font-size: 11pt">Contact
						me for a complete PDF documentation.</FONT></FONT></P>
					</TD>
				</TR>
				<TR VALIGN=TOP>
					<TD WIDTH=19% HEIGHT=37>
						<P ALIGN=LEFT><BR>
						</P>
					</TD>
					<TD WIDTH=81%>
						<P ALIGN=LEFT STYLE="margin-bottom: 0in"><FONT SIZE=2 STYLE="font-size: 11pt">You
						may support this open source software<FONT SIZE=2 STYLE="font-size: 11pt">
						by donating.</FONT></FONT></P>
						<P ALIGN=LEFT> <FONT SIZE=2 STYLE="font-size: 11pt">Click on
						the <B>Donate</B> link below to donate me through Paypal.</FONT></P>
						<P ALIGN=LEFT><FONT SIZE=2 STYLE="font-size: 11pt"><A HREF="https://www.paypal.com/cgi-bin/webscr?cmd=_xclick&amp;business=hide@address.com&amp;no_shipping=0&amp;no_note=1&amp;tax=0&amp;currency_code=USD&amp;lc=IN&amp;bn=PP-DonationsBF&amp;charset=UTF-8">Donate</A></FONT></P>
					</TD>
				</TR>
			</TABLE>
			<P ALIGN=LEFT><BR>
			</P>
		</TD>
	</TR>
</TABLE>
<P ALIGN=LEFT STYLE="margin-bottom: 0in"><BR>
</P>
<DIV TYPE=FOOTER>
	<P ALIGN=LEFT STYLE="margin-top: 0.2in; margin-bottom: 0in"><FONT COLOR="#9999cc"><B><FONT SIZE=2>Developer:
	</FONT></B><FONT SIZE=2><SPAN STYLE="font-weight: medium">Prakash A
	Bhat (</SPAN></FONT><A HREF="mailto:hide@address.com"></A><A HREF="mailto:hide@address.com"></A><A HREF="mailto:hide@address.com"><FONT COLOR="#000080"><FONT SIZE=2><SPAN STYLE="font-weight: medium">hide@address.com</SPAN></FONT></FONT></A><A HREF="mailto:hide@address.com"></A><A HREF="mailto:hide@address.com"></A><A HREF="mailto:hide@address.com"></A><A HREF="mailto:hide@address.com"></A><A HREF="mailto:hide@address.com"><FONT COLOR="#000080"><FONT SIZE=2><SPAN STYLE="font-weight: medium">,
	</SPAN></FONT></FONT></A><A HREF="mailto:hide@address.com"></A><A HREF="mailto:hide@address.com"></A><A HREF="mailto:hide@address.com"></A><A HREF="mailto:hide@address.com"></A><A HREF="mailto:hide@address.com"><FONT COLOR="#000080"><FONT SIZE=2><SPAN STYLE="font-weight: medium">hide@address.com</SPAN></FONT></FONT></A><A HREF="mailto:hide@address.com"></A><A HREF="mailto:hide@address.com"></A><A HREF="mailto:hide@address.com"></A><A HREF="mailto:hide@address.com"></A><A HREF="mailto:hide@address.com"><FONT COLOR="#000080"><FONT SIZE=2><SPAN STYLE="font-weight: medium">)
	</SPAN></FONT></FONT></A><A HREF="mailto:hide@address.com"></A><A HREF="mailto:hide@address.com"></A></FONT>
	</P>
	<P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium"><FONT COLOR="#9999cc">
	<FONT SIZE=2>Skype id: spabhat </FONT></FONT>
	</P>
</DIV>
</BODY>
</HTML>
Return current item: SPA Simple Paging Class