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 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: 2004-04-20 21:44
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>