<!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 – 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 – 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
“paging.php” 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"><!DOCTYPE
html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"></FONT></FONT></P>
<P STYLE="margin-bottom: 0in; font-weight: medium"><FONT COLOR="#4c4c4c"><FONT SIZE=2 STYLE="font-size: 11pt"><html
xmlns="http://www.w3.org/1999/xhtml"></FONT></FONT></P>
<P STYLE="margin-bottom: 0in; font-weight: medium"><FONT COLOR="#4c4c4c"><FONT SIZE=2 STYLE="font-size: 11pt"><head></FONT></FONT></P>
<P STYLE="margin-bottom: 0in; font-weight: medium"><FONT COLOR="#4c4c4c"><FONT SIZE=2 STYLE="font-size: 11pt"><meta
http-equiv="Content-Type" content="text/html;
charset=iso-8859-1" /></FONT></FONT></P>
<P STYLE="margin-bottom: 0in; font-weight: medium"><FONT COLOR="#4c4c4c"><FONT SIZE=2 STYLE="font-size: 11pt"><title>SPA
Paging Style</title></FONT></FONT></P>
<P STYLE="margin-bottom: 0in; font-weight: medium"><FONT COLOR="#4c4c4c"><FONT SIZE=2 STYLE="font-size: 11pt"><link
type="text/css" href="paging.css"
rel="stylesheet" media="screen" /></FONT></FONT></P>
<P STYLE="margin-bottom: 0in; font-weight: medium"><FONT COLOR="#4c4c4c"><FONT SIZE=2 STYLE="font-size: 11pt"></head></FONT></FONT></P>
<P STYLE="margin-bottom: 0in; font-weight: medium"><FONT COLOR="#4c4c4c"><FONT SIZE=2 STYLE="font-size: 11pt"><body></FONT></FONT></P>
<P STYLE="margin-bottom: 0in; font-weight: medium; text-decoration: none">
<FONT COLOR="#4c4c4c"><FONT SIZE=2 STYLE="font-size: 11pt"><p>Default
Paging Style: </p></FONT></FONT></P>
<P STYLE="margin-bottom: 0in; font-weight: medium; text-decoration: none">
<FONT COLOR="#4c4c4c"><FONT SIZE=2 STYLE="font-size: 11pt"><?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("paging.class.php");
// 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("localhost","root","");
//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("db_wikitime");
//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 =
"select * from comments"; //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>->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>->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">?></FONT></FONT></P>
<P STYLE="margin-bottom: 0in; font-weight: medium; text-decoration: none">
<FONT COLOR="#4c4c4c"><FONT SIZE=2 STYLE="font-size: 11pt"><h3>Implementing
the paging with your SQL query:</h3></FONT></FONT></P>
<P STYLE="margin-bottom: 0in; font-weight: medium; text-decoration: none">
<FONT COLOR="#4c4c4c"><FONT SIZE=2 STYLE="font-size: 11pt"><?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
. " ) " . $row['commentText'] . "<br />";</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">?></FONT></FONT></P>
<P STYLE="margin-bottom: 0in; font-weight: medium; text-decoration: none">
<FONT COLOR="#4c4c4c"><FONT SIZE=2 STYLE="font-size: 11pt"></body></FONT></FONT></P>
<P STYLE="margin-bottom: 0in; font-weight: medium"><FONT COLOR="#4c4c4c"><FONT SIZE=2 STYLE="font-size: 11pt"><U></html></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
<head> tag of the page:<BR></SPAN></FONT><FONT COLOR="#4c4c4c"><B><link
type="text/css" href="paging.css"
rel="stylesheet" media="screen" /></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("paging.class.php");</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 =
"select * from comments";<BR></B></I>$sql =
$spPage->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->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 . " ) " . $row['commentText'] ;<BR> echo
</SPAN><FONT COLOR="#4c4c4c"><SPAN STYLE="font-weight: medium">"<br
/>";</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>– 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 “<B>spPage</B><SPAN STYLE="font-weight: medium">”.</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->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->language
= “fr”; //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 “</SPAN></FONT><FONT COLOR="#4c4c4c"><B>spPage</B></FONT><FONT COLOR="#4c4c4c"><SPAN STYLE="font-weight: medium">”.<BR></SPAN></FONT><FONT COLOR="#4c4c4c"><B>$pg2->pageVar
= "page";</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=<required
page number></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?<custVarName>=<required
page number></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->tableName
= "comments";</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->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->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&business=hide@address.com&no_shipping=0&no_note=1&tax=0&currency_code=USD&lc=IN&bn=PP-DonationsBF&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>