px_retrieve_record(3) [php man page]

PX_RETRIEVE_RECORD(3)													     PX_RETRIEVE_RECORD(3)

px_retrieve_record - Returns record of paradox database

SYNOPSIS

       array px_retrieve_record (resource  $pxdoc, int	$num, [int  $mode])

DESCRIPTION

	This  function	is  very similar to px_get_record(3) but uses internally a different approach to retrieve the data. It relies on pxlib for
       reading each single field value, which usually results in support for more field types.

       Note

	       This function is only available if pxlib >= 0.6.0 is used.

PARAMETERS

	      o $pxdoc
		- Resource identifier of the paradox database as returned by px_new(3).

	      o $num
		- The record number is an artificial number counting records in the order as they are stored in the database. The first record has
		number 0.

	      o $mode
		-  The optional $mode can be PX_KEYTOLOWER or PX_KEYTOUPPER in order to convert the keys into lower or upper case. If $mode is not
		passed or is 0, then the key will be exactly like the field name. The element values will contain the field  values.  NULL  values
		will  be  retained  and are different from 0.0, 0 or the empty string. Fields of type PX_FIELD_TIME will be returned as an integer
		counting the number of milliseconds starting at midnight. A timestamp is a floating point value also counting milliseconds  start-
		ing at the beginning of julian calendar.

RETURN VALUES

	Returns the $num'th record from the paradox database. The record is returned as an associated array with its keys being the field names.

SEE ALSO

       px_get_record(3).

PHP Documentation Group 												     PX_RETRIEVE_RECORD(3)

PX_GET_INFO(3)															    PX_GET_INFO(3)

px_get_info - Return lots of information about a paradox file

SYNOPSIS

       array px_get_info (resource  $pxdoc)

DESCRIPTION

PARAMETERS

	      o $pxdoc
		- Resource identifier of the paradox database as returned by px_new(3).

RETURN VALUES

	Returns an associated array with lots of information about a paradox file. This array is likely to be extended in the future.

	      o fileversion
		-Version of file multiplied by 10, e.g. 70.

	      o tablename
		-Name  of  table  as  stored in the file. If the database was created by pxlib, then this will be the name of the file without the
		extension.

	      o numrecords
		-Number of records in this table.

	      o numfields
		-Number of fields in this table.

	      o headersize
		-Number of bytes used for the header. This is usually 0x800.

	      o recordsize
		-Number of bytes used for each record. This is the sum of all field sizes (available since version 1.4.2).

	      o maxtablesize
		- This value multiplied by 0x400 is the size of a data block in bytes. The maximum number of records in a datablock is the integer
		part of (maxtablesize * 0x400 - 8) / recordsize.

	      o numdatablocks
		- The number of data blocks in the file. Each data block contains a certain number of records which depends on the record size and
		the data block size (maxtablesize). Data blocks may not necessarily be completely filled.

	      o numindexfields
		- Number of fields used for the primary index. The fields do always start with field number 1.

	      o codepage
		- The DOS codepage which was used for encoding fields with character data. If the target encoding is not set with px_set_targeten-
		coding(3)   this  will	be  the  encoding  for	character  fields  when  records  are  being  accessed	with  px_get_record(3)	or
		px_retrieve_record(3).

SEE ALSO

       px_numfields(3), px_numrecords(3).

PHP Documentation Group 													    PX_GET_INFO(3)