Login   Register  
PHP Classes
elePHPant
Icontem

File: paging.php

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Ahmed  >  MySQL DB Management Class  >  paging.php  >  Download  
File: paging.php
Role: Example script
Content type: text/plain
Description: example to use paging method
Class: MySQL DB Management Class
Execute MySQL queries and show paginated results
Author: By
Last change:
Date: 2008-11-27 09:08
Size: 1,206 bytes
 

Contents

Class file image Download
<?php

/**
 * @package Mysql DB Management Examples
 * @author Ahmed Elbshry(bondo2@bondo2.info)
 * @copyright 2008
 * @access public
 */

try{
    require './db.class.php';
    //الاتصال بقاعدة البيانات مع واخذ نسخه من الكلاس فى خطوة واحده
    $db = new DB('localhost','root','');
    
    //اختيار قاعدة البيانات التى سنتعامل معها
    $db->UseDB('information_schema');
    
    //كيفية الاستعلام وعمل تحديد للسجلات بكل صفحة
    $rsAssoc = $db->SelAssoc("SELECT * FROM CHARACTER_SETS",false,true,10,PAGING_NEXT_PREV_NUM); // you can use SelArr instead 
    //print_r($rsAssoc);
    echo "<html><head><meta http-equiv=\"Content-Type\" content=\"text/html; charset=windows-1256\"><link href=\"pagingstyle.css\" rel=\"stylesheet\" type=\"text/css\" /></head><body>";
    echo "<table><tr><th colspan='4'><center>Using Pagination</center></th></tr>";
    for($i=0;$i<count($rsAssoc);$i++) {
        echo "<tr><td>".$rsAssoc[$i]['CHARACTER_SET_NAME']."</td><td>".$rsAssoc[$i]['DEFAULT_COLLATE_NAME']."</td><td>".$rsAssoc[$i]['DESCRIPTION']."</td><td>".$rsAssoc[$i]['MAXLEN']."</td></tr>";
    }
    echo "</table>";
    echo $db->pager;
    echo "</body></html>";
    
    $db->Close();
}
catch(exception $e) {
    echo $e->getMessage();
}
?>