PHP Classes
elePHPant
Icontem

File: index.php

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Narong  >  DS Pager  >  index.php  >  Download  
File: index.php
Role: Example script
Content type: text/plain
Description: test pager
Class: DS Pager
Show links to browse listings split in pages
Author: By
Last change: start connect
Date: 5 years ago
Size: 2,851 bytes
 

Contents

Class file image Download
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
<style type="text/css">
body { font:13px Tahoma, Geneva, sans-serif; }
.css-pager a { text-decoration:none; color:#666; background:#F4F4F4; border:1px solid #e0e0e0;
                                 padding:2px 5px; margin:2px; font-weight:700; font-size:11px; }
.css-pager a:hover { text-decoration:none; color:#fff; background:#0A85CB; border:1px solid #3af;
                                         padding:2px 5px; margin:2px; }
.current_page { background-color:#0A85CB; border:1px solid #3af; padding:2px 5px; margin:2px; color:#fff; font-weight:700; font-size:11px; }
</style>
</head>
<body>
<?php
   
require_once ('start_connect.inc.php');
    require_once (
'class_pager.php');
   
   
/**
     * string query
     */
   
$command = 'SELECT * FROM test_table';
   
   
/**
     * get object result from database
     */
   
$result = mysql_query($command);
   
   
/*
     * Configuration pager
     */
   
$config['url_page'] = 'index.php?page=';
   
$config['all_recs'] = mysql_num_rows($result); // all row of data
   
$config['scr_page'] = 10; // scroll page
   
$config['per_page'] = 5; // per pager
   
$config['cur_page'] = ($_GET['page']) ? $_GET['page'] : 1; // current page
   
$config['act_page'] = 'class="current_page"'; // class css current page
   
$config['css_page'] = 'class="css-pager"'; // clss css area split page
   
$config['first'] = '&laquo; First'; // first page
   
$config['previous'] = '&lsaquo; Prev'; // previous page
   
$config['next'] = 'Next &rsaquo;'; // next page
   
$config['last'] = 'Last &raquo;'; // last page
   
    /**
     * create pager instance
     */
   
$pager = new Pager($config);
   
   
/**
     * display pager up data
     */
   
try {
       
$pager->createPager();
    }
    catch(
Exception $e) { echo $e->getMessage(); }
   
   
/**
     * display data
     */
   
$result = mysql_query($command." ORDER BY id ASC LIMIT ".$pager->limitStart().", ".$config['per_page']) or die (mysql_error());
    echo
' <span>ID.</span>';
    echo
' &nbsp;&nbsp; <span>Name</span>&nbsp;&nbsp; ';
    echo
' &nbsp;&nbsp; <span>Surname</span>&nbsp;&nbsp; ';
    echo
' &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Email';
    echo
'<br />';
    if(
$result) {
        while(
$rs = mysql_fetch_assoc($result)) {
                echo
'&nbsp;<span>'.$rs['id'].'</span>&nbsp;&nbsp;&nbsp;&nbsp; ';
                echo
'<span>'.$rs['name'].'</span>&nbsp;&nbsp; ';
                echo
'<span>'.$rs['surname'].'</span>&nbsp;&nbsp; ';
                echo
'<a href="mailto:ranarong@live.com">'.$rs['email'].'</a>';
                echo
'<br />';
        }
    }
   
   
/**
     * display pager down data
     */
   
try {
       
$pager->createPager();
    }
    catch(
Exception $e) { echo $e->getMessage(); }
   
?>
</body>
</html>