Login   Register  
PHP Classes
elePHPant
Icontem

File: read_dbf.php

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Faro K Rasyid  >  DBF Class  >  read_dbf.php  >  Download  
File: read_dbf.php
Role: Example script
Content type: text/plain
Description: Example
Class: DBF Class
Extract information from a DBF database file
Author: By
Last change: Quoted form Nick Vrtis :"I also expanded the sample code, so that you can enter a directory, and also a file name into text boxes. This is not a particularly good idea for a production site, but is useful for testing."
Date: 2005-03-01 20:02
Size: 3,209 bytes
 

Contents

Class file image Download
<?php
echo '<h1>CAUTION: This code should not be used in a production environment.</h1>';
if (isset($_POST['dir'])) {
    $dir=$_POST['dir'];
} elseif (isset($_GET['dir'])) {
    $dir=$_GET['dir'];
} else {
    $dir = "./";
}
echo '<form method="post">';
echo '<table border="2">';
echo '<tr><td>Directory</td><td><input type="text" size="50" name="dir" value="'.$dir.'"></td></tr>';
if (is_dir($dir)) {
    if ($dh = opendir($dir)) {
        while (($file = readdir($dh)) !== false) {
            if(filetype($dir . $file) == 'file' && ereg("\.DBF",strtoupper($file))){
                echo '<tr><td>'.filesize($dir . $file).'</td><td>'
                    .'<a href="'.$PHP_SELF.'?f='.$file.'&dir='.$dir.'">'.$file.'</a></td></tr>';
            }
        }
        closedir($dh);
    }
}
echo '<tr><td>File</td><td><input type="text" size="50" name="f" value=""></td></tr>';
echo '<tr><td>&nbsp;</td><td><input type="submit" name="doit" value="Show file"></td></tr>';
echo '</table>';
echo '</form>';
if ($_GET['f']) {
    $thefile=$_GET['f'];
} elseif ($_POST['f']) {
    $thefile=$_POST['f'];
}
if($thefile){
    include('./dbf_class.php');
    $timer = new timerClass();
    $timer ->start();
    $dbf = new dbf_class($dir.$thefile);
    $num_rec=$dbf->dbf_num_rec;
    $field_num=$dbf->dbf_num_field;
    $endexct = $timer->end();
    //exit("$field_num $num_rec");
    echo("<blockquote>File Name : $f<br>Number of Records : $num_rec<br>Number of Fields : $field_num <br>Executed Time : $endexct</blockquote>");
    echo('<table border=1 cellspacing=0>');
    echo('<tr>');
    echo('<td>No.&nbsp;</td>');    
    for($j=0; $j<$field_num; $j++){
        echo '<td>&nbsp;'.$dbf->dbf_names[$j]['name'];
        if ($dbf->dbf_names[$j]['type']!='M') { //Length is meaningless for a memo field.
            echo '<br>Length='.$dbf->dbf_names[$j]['len'];
        }
        echo '<br>Type='.$dbf->dbf_names[$j]['type'].'</td>';
    }
    echo '</tr>';
    for($i=0; $i<$num_rec; $i++){
        if ($row = $dbf->getRow($i)) {
            echo('<tr>');
            echo('<td align="right">'.str_pad($i+1, 3, "0", STR_PAD_LEFT).'</td>');
            for($j=0; $j<$field_num; $j++){
                if ($dbf->dbf_names[$j]['type']=='N') {
                    echo '<td align="right">';
                } else {
                    echo '<td align="left">';
                }
                  echo htmlentities($row[$j]).'&nbsp;</td>';
            }
            echo '<tr>';
        }
    }
    echo('</table>');
}
class timerClass {
    var $startTime;
    var $started;
    function timerClass($start=true) {
        $this->started = false;
        if ($start)
            $this->start();
    }
    function start() {
        $startMtime = explode(' ',microtime());
        $this->startTime = (double)($startMtime[0])+(double)($startMtime[1]);
        $this->started = true;
    }
    function end($iterations=1) {
        $endMtime = explode(' ',microtime());
        if ($this->started) {
            $endTime = (double)($endMtime[0])+(double)($endMtime[1]);
            $dur = $endTime - $this->startTime;
            $avg = 1000*$dur/$iterations;
            $avg = round(1000*$avg)/1000;
            return "$avg milliseconds";
        } else {
            return "timer not started";
        }
    }
}
?>