PEAR Manual
PrevNext

px_create_fp

px_create_fp -- Create a new paradox database

Description

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

Create a new paradox database file. The actual file has to be opened before with fopen(). The first parameter is the return value of px_new(). fielddesc is an array containing one element for each field containing is specification. Each field specification is an array itself with either two or three elements. The first element is always a string values used as the name of field. It may not be larger than ten characters. The second element contains the field type which is one of the constants listed in table Constants for field types. In the case of a character field, you will have to provide a third element specifying the length of the field.

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() but probably cannot be opened by the Paradox software.

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, $fields, $fp)) {
  /* Error handling */
}
px_set_tablename($pxdoc, "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(), fopen(), px_put_record().

PrevHomeNext
px_open_fpUppx_close