px_get_record(3) [php man page]

PX_GET_RECORD(3)														  PX_GET_RECORD(3)

px_get_record - Returns record of paradox database

SYNOPSIS

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

DESCRIPTION

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 of the returned array 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 ( PX_FIELD_TIMESTAMP) and date (
		PX_FIELD_DATE) are floating point respectively int values counting milliseconds respectively days starting  at	the  beginning	of
		julian calendar. Use the functions px-timestamp2string(3) and px-date2string(3) to convert them into a character representation.

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_retrieve_record(3).

PHP Documentation Group 													  PX_GET_RECORD(3)

PX_DATE2STRING(3)														 PX_DATE2STRING(3)

px_date2string - Converts a date into a string.

SYNOPSIS

       string px_date2string (resource	$pxdoc, int  $value, string  $format)

DESCRIPTION

	Turns  a date as it stored in the paradox file into human readable format. Paradox dates are the number of days since 1.1.0000. This func-
       tion is just for convenience. It can be easily replaced by some math and the calendar functions as demonstrated in the example below.

PARAMETERS

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

	      o $value
		- Value as stored in paradox database field of type PX_FIELD_DATE.

	      o $format
		- String format similar to the format used by date(3). The placeholders support by this function is a subset of those supported by
		date(3) (Y, y, m, n, d, j, L).

RETURN VALUES

	Returns TRUE on success or FALSE on failure.

EXAMPLES

       Example #1

	      Turn a paradox date into a human readable form

	      <?php
	      $px = px_new();

	      /* make up a date as it could be stored in */
	      /* a date field of a paradox db. */
	      /* 700000 days since 1.1.0000. */
	      $days = 700000;

	      /* Use the calendar functions to print a */
	      /* human readable format of the date */
	      echo jdtogregorian($days+1721425)."
";
	      /* px_date2string() outputs the same */
	      echo px_date2string($px, $days, "n/d/Y")."
";

	      px_delete($px);
	      ?>

	      The above example will output:

	      7/15/1917
	      7/15/1917

SEE ALSO

       px_timestamp2string(3), jdtogregorian(3).

PHP Documentation Group 													 PX_DATE2STRING(3)