Введение

Внимание

Это расширение является ЭКСПЕРИМЕНТАЛЬНЫМ. Поведение этого расширения, включая имена его функций и относящуюся к нему документацию, может измениться в последующих версиях PHP без уведомления. Используйте это расширение на свой страх и риск.

This module allows to read and write Paradox databases, primary index files and blob files. Write support has been proven to be quite reliable, though due to lack of documentation the produced files may not in any case be readable by other applications. Encrypted databases can be read without specifying a password if pxlib >= 0.5.0 is used.

Замечание: This module is also in development and may change, though I don't expect major changes to the API.

Требования

You need at least PHP 5.0.0 and pxlib >= 0.4.4 for the basic set of functions. Some newer functions are only available with pxlib >= 0.6.0. Reading and writing of encrypted databases requires at least pxlib >= 0.5.0. The paradox library (pxlib) is available at http://pxlib.sourceforge.net.

Установка

A short installation note: just type
$ pear install paradox
in your console. Make sure you have pxlib installed before. If you install pxlib from an rpm or debian package, do not forget to install the development package as well.

Настройка во время выполнения

Данное расширение не определяет никакие директивы конфигурации в php.ini.

Object oriented API

The paradox extension provides also an object oriented API. It consists of only one class called paradox_db. Its methods only differ from the functions in its name and of course the missing first parameter. The following table will list all methods and its equivalent functions.

Таблица 1. Methods of class paradox_db

Name of method	Equivalent function
Constructor	px_new()
Destructor	px_delete()
open_fp()	px_open_fp()
create_fp()	px_create_fp()
close()	px_close()
numrecords()	px_numrecords()
numfields()	px_numfields()
get_record()	px_get_record()
put_record()	px_put_record()
retrieve_record()	px_retrieve_record()
delete_record()	px_delete_record()
insert_record()	px_insert_record()
update_record()	px_update_record()
get_field()	px_get_field()
get_schema()	px_get_schema()
get_info()	px_get_info()
set_parameter()	px_set_parameter()
get_parameter()	px_get_parameter()
set_value()	px_set_value()
get_value()	px_get_value()
get_info()	px_get_info()
set_targetencoding()	px_set_targetencoding()
set_tablename()	px_set_tablename()
set_blob_file()	px_set_blob_file()
date2string()	px_date2string()
timestamp2string()	px_timestamp2string()

Предопределенные константы

Перечисленные ниже константы определены данным расширением и могут быть доступны только в том случае, если PHP был собран с поддержкой этого расширения или же в том случае, если данное расширение подгружается во время выполнения.

The following two tables lists all constants defined by the paradox extension.

Таблица 2. Contants for field types

Name	Meaning
PX_FIELD_ALPHA	Character data with fixed length
PX_FIELD_DATE	Date, number of days since 1.1.0000
PX_FIELD_SHORT	Short integer (2 Bytes)
PX_FIELD_LONG	Long integer (4 Bytes)
PX_FIELD_CURRENCY	same as PX_FIELD_NUMBER
PX_FIELD_NUMBER	Double
PX_FIELD_LOGICAL	Boolean
PX_FIELD_MEMOBLOB	Binary large object
PX_FIELD_BLOB	Binary large object (not supported)
PX_FIELD_FMTMEMOBLOB	Binary large object
PX_FIELD_OLE	OLE object (basically a blob, not supported)
PX_FIELD_GRAPHIC	Graphic (basically a blob, not supported)
PX_FIELD_TIME	time, number of milli seconds since midnight
PX_FIELD_TIMESTAMP	timestamp, number of milli seconds since 1.1.0000
PX_FIELD_AUTOINC	Auto incrementing interger (like PX_FIELD_LONG)
PX_FIELD_BCD	Decimal number stored in bcd format (not supported)
PX_FIELD_BYTES	Array of Bytes with not more than 255 bytes (not supported)
PX_KEYTOLOWER	Turn all field names into lower case
PX_KEYTOUPPER	Turn all field names into upper case

Таблица 3. Contants for file types

Name	Meaning
PX_FILE_INDEX_DB	Indexed database
PX_FILE_PRIM_INDEX	Primary index
PX_FILE_NON_INDEX_DB	None indexed database
PX_FILE_NON_INC_SEC_INDEX	None incremental secondary index
PX_FILE_SEC_INDEX	Secondary index
PX_FILE_INC_SEC_INDEX	Incremental secondary index
PX_FILE_NON_INC_SEC_INDEX_G	Non incremental secondary index
PX_FILE_SEC_INDEX_G	Secondary index
PX_FILE_INC_SEC_INDEX_G	Non incremental secondary index

Содержание
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