PHP : Function Reference : Paradox File Access : px_insert_record PHP Examples Tutorials References

Example 1703. Set the date/time fields in a paradox database to the current date/time

<?php

$px = px_new();
$fp = fopen("test.db", "w+");
px_create_fp($px, $fp, array(array("timestamp", "@"), array("time", "T"), array("date", "D")));

$curdate = getdate();
$jd = gregoriantojd($curdate["mon"], $curdate["mday"], $curdate["year"]);
$days = $jd - 1721425; /* Number of days between 1.1.4714 b.c. and 1.1.0000 */
$secs = $curdate["hours"]*3600 + $curdate["minutes"]*60 + $curdate["seconds"];
px_insert_record($px, array($days*86400000.0 + $secs*1000.0, $secs*1000.0, $days));

$curtimestamp = microtime(true);
$days = (int) ($curtimestamp/86400);
$secs = $curtimestamp - ($days * 86400.0);
$days += 2440588; /* Number of days between 1.1.4714 b.c. and 1.1.1970 */
$days -= 1721425; /* Number of days between 1.1.4714 b.c. and 1.1.0000 */
px_insert_record($px, array($days*86400000.0 + $secs*1000.0, $secs*1000.0, $days));

for($i=0; $i<2; $i++) {

    $rec = px_retrieve_record($px, $i);

    echo px_timestamp2string($px, $rec["timestamp"], "n/d/Y H:i:s")."\n";

    echo px_date2string($px, $rec["date"], "n/d/Y")."\n";

}
px_close($px);
px_delete($px);
?>

The above example will output:

copy to clipboard

2/21/2006 21:42:30

2/21/2006

2/21/2006 20:42:30

2/21/2006

px_insert_record

Inserts record into paradox database (PECL paradox:1.4.0-1.4.1)
int px_insert_record ( resource pxdoc, array data )

Example 1703. Set the date/time fields in a paradox database to the current date/time

Change Language

px_insert_record

Inserts record into paradox database (PECL paradox:1.4.0-1.4.1) int px_insert_record ( resource pxdoc, array data )

Example 1703. Set the date/time fields in a paradox database to the current date/time

Change Language

Inserts record into paradox database (PECL paradox:1.4.0-1.4.1)
int px_insert_record ( resource pxdoc, array data )