PHP Classes
elePHPant
Icontem

File: example

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Dyego Fernandes  >  Data Table  >  example  >  Download  
File: example
Role: Example script
Content type: text/plain
Description: dataTable creator
Class: Data Table
Show Microsoft SQL query results in an HTML table
Author: By
Last change:
Date: 10 years ago
Size: 665 bytes
 

Contents

Class file image Download
<?
#######################################################################
########### Instanciando a classe dataTable
#######################################################################
include('dataTable.class.php');
$sql = "
select top 100 *
 from myTable MT
 inner join anOtherTable OT on
    MP.anField = OT.otherField
 where MP.anField is not null
 order by TP.thirdField
"
;

$config = array(
               
'host'=>'192.000.000.***',
               
'usr'=>'*********',
               
'pass'=>'*******',
               
'db'=>'MyDataBase',
               
'sql'=>$sql,
               
'errorPage'=>'',
               
'clLine_pair'=>'#EEEEEE',
               
'clLine_odd'=>'#CCCCCC'
               
);

$dt = new dataTable($config);
?>