Paradox File Access

简介
安装／配置
预定义常量
Paradox 函数
- px_close — Closes a paradox database
- px_create_fp — Create a new paradox database
- px_date2string — Converts a date into a string
- px_delete_record — Deletes record from paradox database
- px_delete — Deletes resource of paradox database
- px_get_field — Returns the specification of a single field
- px_get_info — Return lots of information about a paradox file
- px_get_parameter — Gets a parameter
- px_get_record — Returns record of paradox database
- px_get_schema — Returns the database schema
- px_get_value — Gets a value
- px_insert_record — Inserts record into paradox database
- px_new — Create a new paradox object
- px_numfields — Returns number of fields in a database
- px_numrecords — Returns number of records in a database
- px_open_fp — Open paradox database
- px_put_record — Stores record into paradox database
- px_retrieve_record — Returns record of paradox database
- px_set_blob_file — Sets the file where blobs are read from
- px_set_parameter — Sets a parameter
- px_set_tablename — Sets the name of a table (deprecated)
- px_set_targetencoding — Sets the encoding for character fields (deprecated)
- px_set_value — Sets a value
- px_timestamp2string — Converts the timestamp into a string
- px_update_record — Updates record in paradox database

add a note

User Contributed Notes 2 notes

down

wilson dot p dot pereira at itelefonica dot com dot br ¶

10 years ago


<?php



/*

Implement class to use paradox functions

*/



class cParadox

{ 

    //members

    var $m_pxdoc = NULL;

    var $m_fp     = NULL;

    var $m_rs     = NULL;

    var $m_default_field_value = "";

    var $m_use_field_slashes = false;    

    var $m_use_field_trim      = false;    

     

    function Open($filename)

    {

        $this->m_pxdoc = px_new();

        if( !$this->m_pxdoc)

        {

            die ("cParadox Error: px_new() failed.");

        }

    

        $this->m_fp = fopen($filename, "r");

    

        if(!$this->m_fp)

        {

            px_delete($this->m_pxdoc);

            die ("cParadox Error: fopen failed.Filename:$filename");

        }

    

        if(!px_open_fp($this->m_pxdoc ,$this->m_fp) )

        {

            px_delete($this->m_pxdoc);

            fclose( $this->m_fp );

            die ("cParadox Erro: px_open_fp failed.");

        }

    

        return true;    

    }

    

    function Close()

    {

        if ( $this->m_pxdoc )

        {

            px_close($this->m_pxdoc);

            px_delete($this->m_pxdoc);

        }

        

        if( $this->m_fp )

        {

            fclose( $this->m_fp );

        }

    }

    

    function GetNumRecords()

    {

        return px_numrecords($this->m_pxdoc);

    }

    

        function GetRecord($rec)

    {

        $this->m_rs = px_get_record($this->m_pxdoc ,$rec ,PX_KEYTOUPPER);

        return $this->m_rs;

    }

        

    function GetField($field ,$type=0, $format=0)

    {

        if ( !$this->m_rs )

        {

            return false;      

        }

        

        $value = isset($this->m_rs[$field])? $this->m_rs[$field] : "";

        

        if ( $this->m_use_field_slashes )

        {

            $value = addslashes($value);

        }



        if ( $this->m_use_field_trim )

        {

            $value = trim($value);

        }

        



        return $value;

    }

};



usage example:

error_reporting(E_ERROR);

require_once("cparadox.inc");



$pdx = new cParadox();

$pdx->m_default_field_value = "?";//" ";



if ( $pdx->Open("USERS.DB") )

{

     $tot_rec = $pdx->GetNumRecords();

    if ( $tot_rec )

     {

        echo "<table border=1>\n";

        for($rec=0; $rec<$tot_rec; $rec++)

        {

             $pdx->GetRecord($rec);

    

            echo "<tr>";



            echo "<td>" . $rec;

            echo "<td>" . $pdx->GetField(CODE);

            echo "<td>" . $pdx->GetField(NAME);

        }

    }



    $pdx->Close();  

}

?>

down

-1

qwexak ¶

3 years ago


A bit updated version of wilson's class

<?php

class Paradox {
    var $doc = NULL;
    var $file = NULL;
    var $row = NULL;
    var $field_default_value = "";
    var $field_slashes = false;
    var $field_trim = false;

    function Open($filename) {
        $this->doc = px_new();
        if (!$this->doc) {
            die("Paradox Error: px_new() failed.");
        }
        $this->file = fopen($filename, "r");
        if (!$this->file) {
            px_delete($this->doc);
            die("Paradox Error: fopen failed. Filename:$filename");
        }
        if (!px_open_fp($this->doc, $this->file)) {
            px_delete($this->doc);
            fclose($this->file);
            die("Paradox Erro: px_open_fp failed.");
        }
        return true;
    }

    function Close() {
        if ($this->doc) {
            px_close($this->doc);
            px_delete($this->doc);
        }
        if ($this->file) {
            fclose($this->file);
        }
    }

    function GetNumRows() {
        return px_numrecords($this->doc);
    }

    function GetRow($id) {
        try {
            $this->row = px_get_record($this->doc, $id);
            throw new Exception('no record');
        } catch (Exception $e) {
            return "Exception: " . $e->getMessage() . "\n";
        }
        return $this->row;
    }

    function GetRows($num = 0) {
        if (function_exists(px_retrieve_record)) {
            return px_retrieve_record($this->doc, $num);
        } else {
            return "Unsupported function (px_retrieve_record) in paradox ext.";
        }
    }

    function GetSchema() {
        return px_get_schema($this->doc);
    }

    function GetInfo() {
        return px_get_info($this->doc);
    }

    function GetStringfromDate($date, $format = "d.m.Y") {
        return px_date2string($this->doc, $date, $format);
    }

    function GetStringfromTimestamp($date, $format = "d.m.Y H:i:s") {
        return px_timestamp2string($this->doc, $date, $format);
    }

    function GetField($field, $trim = 0, $slash = 0) {
        if (!$this->row) {
            return false;
        }
        $value = isset($this->row[$field]) ? $this->row[$field] : $this->field_default_value;
        if ($this->field_slashes or $slash) {
            $value = addslashes($value);
        }
        if ($this->field_trim or $trim) {
            $value = trim($value);
        }
        return $value;
    }

    function GetFieldInfo($id = 0) {
        return px_get_field($this->doc, $id);
    }
}
?>

add a note

官方地址：https://www.php.net/manual/en/book.paradox.php

有任何技术问题请点击这里网站运营推广招聘

IT PHP 编程语言 Linux 科技开发编程 Elasticsearch HTML/CSS/XML 网络 JAVA NoSQL C/C++ 面试 Golang 数据库 Git 算法正则表达式操作系统 Redis 互联网 MySql JavaScript 运维软件架构设计 Mac OS TCP/IP 国际 Excel Vim Windows Socket Oracle VR MongoDB 运营 Python MemCache 商业硬件电子设计 nginx 娱乐摄影游戏 WordPress HTTP 团建数码电器

php7 安装fileinfo扩展 preg_split — 通过一个正则表达式分隔字符串 [PHP] inet_pton/inet_ntop IP地址转换函数 php位值,解决 PHP 中 usort 在值相同时改变原始位置的问题 PHPMailer设置utf8 PHPMailer字符集CharSet 如何在Composer中为GitLab实例设置访问令牌 array_multisort() 多字段排序 laravel框架查看sql语句方式 [原创]诡异的php-fpm超时问题 PHP获取指定函数定义在哪个文件中及行号 php设置cookie为httponly防止xss攻击利用php soap实现web service PHP5 扩展SOAP 调用 webservice PHP-FPM进程数的设定纯php实现DES以及TripleDES加密算法利用PHP SOAP实现WEB SERVICE PHPstorm 里面Terminal 不能使用 esc键吗退出编辑模式吗 PHP7添加redis扩展 PHP注释规范 Composer的Packagist资源

略微加速

PHP官方手册 - 互联网笔记

Paradox File Access

User Contributed Notes 2 notes