px_timestamp2string(3) [php man page]

PX_TIMESTAMP2STRING(3)													    PX_TIMESTAMP2STRING(3)

px_timestamp2string - Converts the timestamp into a string.

SYNOPSIS

       string px_timestamp2string (resource  $pxdoc, float  $value, string  $format)

DESCRIPTION

	Turns  a  timestamp  as  it  stored in the paradox file into human readable format. Paradox timestamps are the number of miliseconds since
       0001-01-02. This function is just for convenience. It can be easily replaced by some math and the calendar functions as demonstrated in the
       following example.

PARAMETERS

	      o $pxdoc
		- Resource identifier of the paradox database.

	      o $value
		- Value as stored in paradox database field of type PX_FIELD_TIME, or PX_FIELD_TIMESTAMP.

	      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, H, h, G, g, i, s, A, a, L).

RETURN VALUES

	Returns TRUE on success or FALSE on failure.

EXAMPLES

       Example #1

	      Turn a paradox timestamp 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)."
";

	      /* Turn it into a timestamp as it stored in a paradox database */
	      /* Timestamps are stored in miliseconds since 0001-01-02 */
	      $stamp = $days * 86400.0 * 1000.0;
	      /* Add one hour */
	      $stamp += 3600000.0;
	      /* The following will output '7/15/1917 01:00:00'. */
	      echo px_timestamp2string($px, $stamp, "n/d/Y H:i:s")."
";

	      px_delete($px);
	      ?>

	      The above example will output:

	      7/15/1917
	      7/15/1917 01:00:00

	The Julian day count as passed to jdtogregorian(3) has a different base of 1.1.4714 b.c.  and  must  therefore	be  calculated	by  adding
       1721425	to the day count used in the paradox file. Turning the day count into a timestamp is easily done by multiplying with 86400000.0 to
       obtain miliseconds.

SEE ALSO

       px_date2string(3), jdtogregorian(3).

PHP Documentation Group 												    PX_TIMESTAMP2STRING(3)

PX_CREATE_FP(3) 														   PX_CREATE_FP(3)

px_create_fp - Create a new paradox database

SYNOPSIS

       bool px_create_fp (resource  $pxdoc, resource  $file, array  $fielddesc)

DESCRIPTION

	Create a new paradox database file. The actual file has to be opened before with fopen(3). Make sure the file is writable.

       Note

	      Calling this functions issues a warning about an empty tablename which can be safely ignored. Just set the tablename afterwards with
	      px_set_parameter(3).

       Note

	      This function is highly experimental, due to insufficient documentation of the paradox file format. Database files created with this
	      function can be opened by px_open_fp(3) and has been successfully opened by the Paradox software, but your milage may vary.

PARAMETERS

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

	      o $file
		-File handle as returned by fopen(3).

	      o $fielddesc
		-  fielddesc is an array containing one element for each field specification. A field specification is an array itself with either
		two or three elements.The first element is always a string value used as the name of the field. It may	not  be  larger  than  ten
		characters.  The  second  element  contains  the  field type which is one of the constants listed in the table Constants for field
		types. In the case of a character field or bcd field, you will have to provide a third element specifying the length  respectively
		the  precesion of the field. If your field specification contains blob fields, you will have to make sure to either make the field
		large enough for all field values to fit or specify a blob file with px_set_blob_file(3) for storing the blobs.  If  this  is  not
		done the field data is truncated.

RETURN VALUES

	Returns TRUE on success or FALSE on failure.

EXAMPLES

       Example #1

	      Creating a Paradox database with two fields

	      <?php
	      if(!$pxdoc = px_new()) {
		/* Error handling */
	      }
	      $fp = fopen("test.db", "w+");
	      $fields = array(array("col1", "S"), array("col2", "I"));
	      if(!px_create_fp($pxdoc, $fp, $fields)) {
		/* Error handling */
	      }
	      px_set_parameter($pxdoc, "tablename", "testtable");
	      for($i=-50; $i<50; $i++) {
		$rec = array($i, -$i);
		px_put_record($pxdoc, $rec);
	      }
	      px_close($pxdoc);
	      px_delete($pxdoc);
	      fclose($fp);
	      ?>

SEE ALSO

       px_new(3), px_put_record(3), fopen(3).

PHP Documentation Group 													   PX_CREATE_FP(3)