Login   Register  
PHP Classes
elePHPant
Icontem

File: data.php

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Usman Didi Khamdani  >  Easy Paging Class  >  data.php  >  Download  
File: data.php
Role: Example script
Content type: text/plain
Description: this example is used to obtain a number of data with display limitation into the pages, with jQuery .load() plus CSS Rules. related with example3.php
Class: Easy Paging Class
Show navigation links for listings split in pages
Author: By
Last change:
Date: 3 years ago
Size: 2,688 bytes
 

Contents

Class file image Download
<?php

/* 
this example is used to obtain a number of data with display limitation into the pages, with jQuery .load() plus CSS Rules. related with example3.php
author: usman didi khamdani
author's email: usmankhamdani@gmail.com
author's phone: +6287883919293
*/ 

if((isset($_GET['auth']) && $_GET['auth']!="")) {

    
// define first, prev, next and last thumbnail
    
define("_FIRST","<img src=\"images/first.png\" alt=\"First\" />");
    
define("_PREV","<img src=\"images/prev.png\" alt=\"Prev\" />");
    
define("_NEXT","<img src=\"images/next.png\" alt=\"Next\" />");
    
define("_LAST","<img src=\"images/last.png\" alt=\"Last\" />");

    include(
"paging.class.php");

    
$host "localhost"// database host name
    
$user "root"// database user name
    
$password ""// database user password
    
$db "test"// database name

    
$host_conn mysql_connect($host,$user,$password); // connect to host
    
if(!$host_conn) {
        die(
mysql_error());
    }
    
$db_conn mysql_select_db($db$host_conn); // connect to database
    
if(!$db_conn) {
        die(
mysql_error());
    }

    
// current page
    
if(isset($_GET['page']) && $_GET['page']!="") {
        
$page = @$_GET['page'];
    } else {
        
$page 1;
    }

    
// setting param
    
$param1 $_GET['auth'];

    
$param "auth=$param1";

    
$query1 "SELECT no FROM book WHERE Author = '$param1'";
    
$check mysql_query($query1);

    if(!
$check) {
        die(
mysql_error());
    }

    
$sum_data mysql_num_rows($check); // sum of data
    
    
$max_row 10// maximum number of rows of data to be displayed in a page
    
$num 5// number of page thumbnails

    
$d = new Paging($page,$max_row,$sum_data);

    
// get limit;
    
$query2 "SELECT * FROM book WHERE Author = '$param1' ORDER BY Category,Title ".$d->limit();
    
// create thumbnail;
    
$thumbnail $d->thumbnail($num,$param);

    echo 
"<div id=\"display_content\"><p>current page = $page<br />number of page = ".ceil($sum_data/$max_row)."<br />maximum number of rows of data to be displayed in a page = $max_row<br />sum of data = $sum_data<br />number of page thumbnails = $num</p><p>mysql_query = <strong>$query2</strong></p>";

    
$display mysql_query($query2);

    if(!
$display) {
        die(
mysql_error());
    }

    echo 
"<hr /><h3>List of Books by $param1</h3><table id=\"content\"><tr><th>No.</th><th>Category</th><th>Title</th><th>Published Year</th></tr>";
    
$no 0;
    while(
$data mysql_fetch_array($display)) {
        
$no++;
        
$n = (($page-1)*$max_row)+$no;
        echo 
"<tr><td style=\"text-align:right\">$n.</td><td>".$data['Category']."</td><td>".$data['Title']."</td><td>".$data['Published_Year']."</td></tr>";
    }

    echo 
"</table></div>$thumbnail";
} else {
    return 
false;
}

?>