Example #1
0
// '<?' or '<?php' tells PHP to start parsing
/*********************************************************************
 * The comments herein are designed to be helpful to someone with    *
 * little or no programming experience.  To that end, many of the    *
 * comments may address things will appear obvious to many coders.   *
 * For the most part I'll place my comments at the end of each line. *
 * Feel free to e-mail any comments or questions to FX@iviking.org.  *
 * Please remember that this code is being released as open source   *
 * under The Artistic License of PERL fame...                        *
 * http://www.opensource.org/licenses/artistic-license.html          *
 *...and is also covered by the FX.php license addendum...           *
 * http://www.iviking.org/downloads/ADDENDUM.txt                     *
 *********************************************************************/
include_once $_SERVER['DOCUMENT_ROOT'] . "/FX/FX.php";
// FX.php contains the class for pulling data
// from FileMaker into PHP -- 'include_once()'
// makes sure the class is only declared once.
include_once $_SERVER['DOCUMENT_ROOT'] . "/FX/server_data.php";
// To make sure that these examples work for you, be sure
// to set the IP address of your server in server_data.php
// IMPORTANT: The leading '$' denotes a variable in PHP
$DatasetQuery = new FX($serverIP, $webCompanionPort, $dataSourceType);
// This line creates an instance of the FX class
$DatasetQuery->SetDBUserPass($webUN, $webPW);
$DatasetQuery->SetDBData('Tester', 'Main_View');
$LayoutData = $DatasetQuery->FMView();
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
<html>
    <head>
Example #2
0
                            $formParams[$value] = implode("\n", $formParams[$value]);
                        }
                        $FXQuery->AddDBParam($value, $formParams[$value]);
                    }
                    $updateResult = $FXQuery->FMEdit();
                    // echo($updateResult['URL']);
                }
            }
            $FXQuery->SetDBData($FXE_currentDatabaseName, $FXE_currentLayoutName, $FXE_groupSize);
            $FXQuery->FMSkipREcords($skip);
            $ReturnedData = $FXQuery->FMFindAll();
            // This demo finds all records in the current database.
            if ($FXE_currentLayoutName != '') {
                $fieldLayout = array();
                $FXQuery->SetDBData($FXE_currentDatabaseName, $FXE_currentLayoutName);
                $viewData = $FXQuery->FMView();
                // If a layout was specified, get the 'View' information for that layout.
                foreach ($viewData['fields'] as $key => $value) {
                    if (!isset($value['valuelist'])) {
                        $value['valuelist'] = '';
                    }
                    $fieldLayout[$value['name']] = array('type' => $value['type'], 'valuelist' => $value['valuelist']);
                }
            }
        } else {
            $errorMessage = 'No valid Layout specified.';
        }
    }
} else {
    $errorMessage = 'Specified port and/or IP are invalid.';
}