Login   Register  
PHP Classes
elePHPant
Icontem

File: simplepagination.php

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Huda M Elmatsani  >  Data Displayer  >  simplepagination.php  >  Download  
File: simplepagination.php
Role: Example script
Content type: text/plain
Description: example: pagination
Class: Data Displayer
Display MySQL query result data in various formats
Author: By
Last change:
Date: 10 years ago
Size: 1,958 bytes
 

Contents

Class file image Download
<?php
include("datadisplayer.php");

$datatable = new datadisplayer;
$datatable->set_db              ("localhost","user","password","eproshop");
$datatable->set_rs              ("SELECT prodID,prodtitle,proddesc FROM products");
$datatable->set_page            ($_REQUEST[page],5);
$datatable->set_data();

$datatable->set_tbl             ("catalogue",array("border"=>"0","cellspacing"=>"0","cellpadding"=>"5","width"=>"500"));
//$datatable->set_tbl_noheader  ();
$datatable->set_tbl_header      (array("bgcolor"=>"#CCCCCC","height"=>"30","style"=>"font-family: Arial, Helvetica; text-decoration:none;font-size:12"));
$datatable->set_tbl_rows        (array("valign"=>"top","style"=>"font-family: Arial, Helvetica; text-decoration:none;font-size:11"));
$datatable->set_tbl_rowshade    (array("#D0D0E8","#DEDEEF"));
$datatable->set_tbl_rowfade     (array("#DDF0FF"));
$datatable->set_tbl_liner        (array("bgcolor"=>"#999999","height"=>"2"));

$datatable->set_page_link       ("?page=");
$datatable->set_style            ("pagelink","font-size:11;text-decoration:none");
$datatable->set_style            ("pagecurrent","font-size:11;text-decoration:underline overline;");

$datatable->set_page_nav(array("prev"=>"PREV","first"=>"FIRST"),"pagelink");
$datatable->set_page_nav(array("next"=>"NEXT","last"=>"LAST"),"pagelink");
$datatable->set_page_num("current","%d","pagecurrent");
$datatable->set_page_num("other","%d","pagelink");

//echo $datatable->get_navigation();
//echo $datatable->get_num_records();

echo $datatable->get_record_status("Record %d to %d of %d.","pagelink");
echo 
"<br>";

$page $datatable->get_page();
$nop  $datatable->get_nop();
echo 
$datatable->get_custom_status("Page %d/%d",array($page,$nop),"pagelink");
echo 
$datatable->get_result();
echo 
$datatable->get_navigation();

/*echo $datatable->get_nav("prev"); 
echo $datatable->get_nav_num();
echo $datatable->get_nav("next");
echo $datatable->get_nav("last");
*/
?>