Shiegege Iseng
Paging Class |
Simple Sample
<? require("paging_class.php"); $paging=new paging(5,5); $paging->db("localhost","username","password","dbname"); $paging->query("Select * FROM paging ORDER BY MY_FIELD ASC"); $page=$paging->print_info(); echo "Data $page[start] - $page[end] of $page[total] [Total $page[total_pages] Pages]<hr>\n"; while ($result=$paging->result_assoc()) { echo "$result[MY_FIELD]<br>\n"; } echo "<hr>".$paging->print_link(); ?>
|
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();
-the end- |