test.php
1.85 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
<?php
exit;
/**
* ----------------------------------------------------------------
* XBase
* test.php
*
* Developer : Erwin Kooi
* released at : Nov 2005
* last modified by : Erwin Kooi
* date modified : Jan 2005
*
* Info? Mail to info@cyane.nl
*
* --------------------------------------------------------------
*
* Basic demonstration
* download the sample tables from:
* http://www.cyane.nl/phpxbase.zip
*
**/
/* load the required classes */
require_once "Column.class.php";
require_once "Record.class.php";
require_once "Table.class.php";
/* create a table object and open it */
$table = new XBaseTable("test/bond.DBF");
$table->open();
/* print some header info */
echo "version: ".$table->version."<br />";
echo "foxpro: ".($table->foxpro?"yes":"no")."<br />";
echo "modifyDate: ".date("r",$table->modifyDate)."<br />";
echo "recordCount: ".$table->recordCount."<br />";
echo "headerLength: ".$table->headerLength."<br />";
echo "recordByteLength: ".$table->recordByteLength."<br />";
echo "inTransaction: ".($table->inTransaction?"yes":"no")."<br />";
echo "encrypted: ".($table->encrypted?"yes":"no")."<br />";
echo "mdxFlag: ".ord($table->mdxFlag)."<br />";
echo "languageCode: ".ord($table->languageCode)."<br />";
/* html output */
echo "<br /><table border=1>";
/* print column names */
echo "<tr>";
foreach ($table->getColumns() as $i=>$c) {
echo "<td>".$c->getName()." (".$c->getType()." ".$c->getLength().")</td>";
}
echo "</tr>";
/* print records */
while ($record=$table->nextRecord()) {
echo "<tr>";
foreach ($table->getColumns() as $i=>$c) {
echo "<td>".$record->getString($c)."</td>";
}
echo "</tr>";
}
echo "</table>";
/* close the table */
$table->close();
?>