Paradox Module Example

Paradox Module »php_paradox« by Uwe Steinmann

Reading and writing a paradox database

Database info:

Array
(
    [fileversion] => 70
    [tablename] => test.db
    [numrecords] => 1
    [numfields] => 1
    [headersize] => 2048
    [recordsize] => 2
    [maxtablesize] => 2
    [numdatablocks] => 1
    [numindexfields] => 0
    [codepage] => 1252
)

Number of fields: 1
Number of records: 1
Database schema:

Array
(
    [col1] => Array
        (
            [type] => 3
            [size] => 2
        )

)

Further information to Paradox databases in WikiPedia.

Source code

<?php
	 $lang=@file_get_contents("../../lang.tmp");
 @include("../../lang/languages.php");
 @include("../../lang/en.php");
 @include("../../lang/$lang.php");
 if($lang=="zh")
 {
 header("Content-Type: text/html; charset=gb2312");
 }
 else if($lang=="jp")
 {
 header("Content-Type: text/html; charset=shift-jis");
 }
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
	"http://www.w3.org/TR/html4/loose.dtd">
<html>
	<head>
		<meta name="author" content="Kai Oswald Seidler, Kay Vogelgesang, Carsten Wiedmann">
		<link href="../../xampp.css" rel="stylesheet" type="text/css">
		<title></title>
	</head>

<?=$TEXT['paradox-text1']?>
		
			
			<?=$TEXT['paradox-text2']?>
<?php
$dirname = dirname($_SERVER["SCRIPT_FILENAME"]);
$pxdoc = px_new();
$fp = fopen($dirname."/simpletest.db", "r");
px_open_fp($pxdoc, $fp);
$info = px_get_info($pxdoc);

if ( getenv('REMOTE_ADDR') == "127.0.0.1") {
 echo "Database: ".$dirname."/simpletest.db ";
 }
echo "Database info: <pre>";
print_r($info);
echo "</pre> Number of fields: ".px_numfields($pxdoc)." \n";
echo "Number of records: ".px_numrecords($pxdoc)." \n";
echo "Database schema: <pre>\n";
print_r(px_get_schema($pxdoc));
echo "</pre>\n";
px_close($pxdoc);
fclose($fp);
px_delete($pxdoc);
?>

<?php
if ( getenv('REMOTE_ADDR') == "127.0.0.1") {
 echo $TEXT['paradox-text3'].$dirname.". ";
 }
?>
			<?=$TEXT['paradox-text4']?>
		
	 <?php include("../../showcode.php"); ?>
	</body>
</html>