Simple Sample

Download
Download All [here]
List All [here]

Demo
- sample1.php (simple)
- sample2.php (simple search)
- sample3.php (search demo)
- sample4.php (simple table result)

Step 1
Include paging class

require("paging_class.php");

Step 2
Generate new paging
Format: $classVar=paging( line , prev/next , "string prev" , "string next" , "%%number%%")
Note : 
string prev, default = "[prev]"
string next, default = "[next]"
%%number%% , default = "[%%number%%]"

//create 10 lines, and 5 next/prev
$paging=new paging(10,5);

//create 10 lines, and 5 next/prev, and will generate link |prev| {[1]} {[2]} {[3]} |next|
$paging=new paging( 10 , 5 , "|prev|" , "|next|" , "{[%%number%%]}");

Step 3 [Optional]
Connect to MySQL
Format: $classVar->db("host","username","password","dbname")
If you already connected to MySQL, ignore this line

$paging->db("localhost","username","password","dbname");

Step 4
MySQL query
Format: $classVar->query("mysql query")

$paging->query("select * from paging order by MY_FIELD desc");
$paging->query("select * from paging where username='kentung' order by MY_FIELD desc");

Step 5 [OPTIONAL]
Page Information
Format: $classVar->print_info()
Information about data result (start, end, total, total_pages, keyword)

$page=$paging->print_info();
/* generated :
$page[start]
$page[end]
$page[total]
$page[total_pages]
$page[keyword]
*/
echo "Data $page[start] - $page[end] of $page[total] [Total $page[total_pages] Pages]<br>\n";

Step 6
Fetch a result row as an object
Format: $classVar->result()
Place inside while looping

Fetch a result row as an associative array
Format: $classVar->result_assoc()
Place inside while looping

Random color [Optional]
Format: $classVar->print_color("color1","color2")
Place inside while looping

Generate number [Optional]
Format: $classVar->print_no()
Place inside while looping

while ($result=$paging->result())
{
    $color=$paging->print_color("yellow","#FFCCCC")
    ?>
        <tr>
            <td width="3%" bgcolor="<?=$color?>"><?=$paging->print_no()?></td>
            <td width="98%" bgcolor="<?=$color?>"><?=$result->MY_FIELD?></td>
        </tr>
    <?
}

Step 7
Print next/prev
Format: $classVar->print_link()

echo $paging->print_link();