Login   Register  
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: 2005-07-22 07:04
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);
?>