PHP Classes

File: simplepagination.php

Recommend this page to a friend!
  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: 19 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");
*/
?>