filepro_retrieve

Example 296. Traverse an entire database and display the results in a formatted text table

<pre>
<?php
$fp_db = 'c:\fp\filepro\fpcust';

// Select the FilePro database
@ filepro ($fp_db)
    or die ("The '$fp_db' directory does not seem to contain a FilePro database map file.
        Please check the directory path, along with the directory and file permissions.");

$field_count = filepro_fieldcount ();
$row_count   = filepro_rowcount ();

// Print the top of the table
$line .= '| ';
for ($field_offset=0; $field_offset < $field_count; $field_offset++) {
    $width = filepro_fieldwidth ($field_offset);
    $name  = filepro_fieldname ($field_offset);

    $line .= sprintf ('<b>%-'.$width.'s</b> | ', $name);
    
    // Handle cases where the length of the field name is greater than the field length
    $field_width[$field_offset] = ($width < strlen ($name) ? strlen ($name) : $width);
}

// Make a separator for the table header
$separator = str_repeat ('-', strlen (strip_tags ($line)) - 1);

echo $separator, "\n", $line, "\n", $separator;

// Show all the records in the database
for ($row_offset=0; $row_offset < $row_count; $row_offset++) {
    print "\n| ";
    for ($field_offset=0; $field_offset < $field_count; $field_offset++) {
        printf ('%'.$field_width[$field_offset].'s | ', filepro_retrieve ($row_offset, $field_offset));
    }
}

echo "\n", $separator;
?>
</pre>