Login   Register  
PHP Classes
elePHPant
Icontem

File: sample2b1.php

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Tom Schaefer  >  QDataObject  >  sample2b1.php  >  Download  
File: sample2b1.php
Role: Example script
Content type: text/plain
Description: Sample JQuery Data Table
Class: QDataObject
Access MySQL query results as objects
Author: By
Last change: chg
Date: 6 years ago
Size: 2,893 bytes
 

Contents

Class file image Download
<?php

    
if(empty($_SERVER["HTTP_X_REQUESTED_WITH"])=="XMLHttpRequest") {
        
header("Location:sample2b.php");
    }

    include_once(
'config.inc.php');

    
//provide your connection data here
    
$link mysqli_connect(
        
'db_default_host',
        
'db_default_user',
        
'db_default_password',
        
'northwind'
    
) OR die(mysqli_error());


    
$sql "SELECT 
        CustomerID,
        CompanyName,
        ContactName,
        City,
        Country
    FROM customers"

    
// if table column names are written underscored, then they will be automatically
    // converted to camel-case notation for php access
    // the northwind field names are usually written camel-cased.

    
$pageSize = ($_GET["s"]?(int)$_GET["s"]:10);

    
$result mysqli_query($link$sql);

    
$dataObject = new QDataObject::getInstance('mysqli',$result$link);
    
$dataObject->byPage((int)$_GET["p"],$pageSize);

    
$html '<table border="1" cellspacing="2" cellpadding="2" width="100">';
    
$html.='<thead>';
    
$html.='<tr>';
    foreach(
$dataObject->getFieldNames() as $columnName) {
        
$html.='<th>';
        
$html.=$columnName;
        
$html.='</th>';
    }
    
$html.='</tr>';
    
$html.='</thead>';

    
$html.='<tbody>';
    for(
$i=0;$i<$dataObject->getAmountOfRows();$i++) {
        
$html.='<tr class="'.($i%2?'odd':'even').'">';
        foreach(
$dataObject->getFieldNames() as $columnName) {
            
$html.='<td>';
            
$get "get".$columnName;
            
$data $dataObject->$get($i);
            
$html.= empty($data) ? '&nbsp;':$data;
            
$html.='</td>';
        }
        
$html.='</tr>';
    }
    
$html.='</tbody>';
    
$html.='<tfoot>';
    
$html.='<tr>';
    
$html.='<th colspan="'.$dataObject->getNumFields().'">';
    
$html.=$dataObject->getNumRows().' records &nbsp;';
    if(
$dataObject->getActivePage()>1) {
        
$html.='<a href="#" onclick="$.get(\'sample2b1.php?p='.($dataObject->getActivePage()-1).'&s='.$pageSize.'\',function(data){$(\'#select\').html(data);});">&lt;</a>';
    }
    
$html.='<b>'.($dataObject->getActivePage()).'</b>';
    if(
$dataObject->getActivePage() < $dataObject->getNumOfPages()) {
        
$html.='<a href="#" onclick="$.get(\'sample2b1.php?p='.($dataObject->getActivePage()+1).'&s='.$pageSize.'\',function(data){$(\'#select\').html(data);});">&gt;</a>';
    }
    
$html.='</th>';
    
$html.='</tr>';
    
$html.='</tfoot>';

    
$html .= '</table>';
    
$html.='';
    
$html .= "
    <script>
    var np="
.$dataObject->getNumOfPages().";
    var lx=1;
    var ly=1;
    w = $('#select').width();    
    $('.slider').css('width', w+'px');
    $('.slider').Slider(
    {
        accept : '.indicator',
        opacity: 0.8,
        fractions: "
.$dataObject->getNumOfPages().",
        onSlide: function(procx, procy, x, y) {
            $('#indicator1').css('left', x+'px');
            $('#indicator2').css('left', x+'px');
            lx=Math.ceil(("
.$dataObject->getNumOfPages()."/w)*x);
        },
        onChange : function(){
            $.get('sample2b1.php?p='+lx+'&s="
.$pageSize."',function(data){\$('#select').html(data);});
        }    
    });
    </script>
    "
;

    echo 
$html;