Delicious Bookmark this on Delicious Share on Facebook SlashdotSlashdot It! Digg! Digg



PHP : Function Reference : Paradox File Access : px_insert_record

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

<?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:

2/21/2006 21:42:30
2/21/2006
2/21/2006 20:42:30
2/21/2006

Change Language


Follow Navioo On Twitter
px_close
px_create_fp
px_date2string
px_delete_record
px_delete
px_get_field
px_get_info
px_get_parameter
px_get_record
px_get_schema
px_get_value
px_insert_record
px_new
px_numfields
px_numrecords
px_open_fp
px_put_record
px_retrieve_record
px_set_blob_file
px_set_parameter
px_set_tablename
px_set_targetencoding
px_set_value
px_timestamp2string
px_update_record
eXTReMe Tracker