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 agus hariyanto  >  VSFlexGrid  >  example  >  Download  
File: example
Role: Example script
Content type: text/plain
Description: example app
Class: VSFlexGrid
Compose and output an HTML table
Author: By
Last change:
Date: 10 years ago
Size: 1,367 bytes
 

Contents

Class file image Download
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Untitled Document</title>
<link rel="stylesheet" type="text/css" href="main.css"/>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body>
<?php

include('adodb/adodb.inc.php');
include(
'vsflexgrid.php');
    
$db =&NewADOConnection('ado_mssql');
   
//$db =&ADONewConnection('ado_mssql');
   
$dsn = "Driver={SQL Server};Server=localhost;Database=stekpi;";

$i=0;

   
$db->PConnect($dsn,'sa','mbakyul');

$grid=new vsflexgrid();
   
$rs = $db->Execute('select * from t_dosen');
   
   
$arr='';
    if (!
$rs)
        print
$db->ErrorMsg();
    else
   
$grid->cols(4);
   
$grid->fixedalignment("L");
   
$grid->_border=1;
   
$grid->_cellspacing=1;
   
$grid->_bordercolor="red";
   
$grid->_colorheader="red";
   
$grid->_data_font_color="orange";
   
//$grid->_header_font_color="red";
   
$grid->_tablewidth="20%";
   
//$grid->colhidden(0);
   
$grid->colhidden(1);
   
//$grid->colhidden(2);
   
$z=0;
   
$grid->headers("No,Kode,Nama Dosen, Matakuliah");
    while (!
$rs->EOF) {
       
$z++;
       
$grid->textmatrix($z,$i,0);
       
$grid->textmatrix($rs->fields[1],$i,1);
       
$grid->textmatrix($rs->fields[2],$i,2);
       
$grid->textmatrix($rs->fields[3],$i,3);
       
$rs->MoveNext();
       
$i++;
       
    }
   
   
$grid->display();
   
?>
</body>
</html>