// If you use version 6 pro/unlimited, modify to 'FMPro5/6' from 'FMPro7'. //$BookQuery->SetCharacterEncoding('utf8'); // Added by msyk 2004/3/23 // These lines pass the character set information to FX class. //$BookQuery->SetDataParamsEncoding('SJIS'); // If you use version 6 pro/unlimited, you need this statement. //If you want to use UTF-8 only, you don't need to abve methods for FX_charset class. $BookQuery->SetDBData("Book_List.fp7", "Detail_View"); // The '->' indicates that SetDBData is part of the FX instance we just created. $arrayName = 'HTTP_' . $HTTP_SERVER_VARS["REQUEST_METHOD"] . '_VARS'; // Note the '$$' a couple of lines down. I'm using a variable // whose name is the contents of another variable. VERY handy. // **** Added by msyk 2004/3/23 **** To make a new record in DB. if (${$arrayName}['currentQuery'] == 'New Record') { foreach ($HTTP_POST_VARS as $key => $value) { if ($key != 'currentQuery' && $key != 'currentSort') { $BookQuery->AddDBParam($key, stripslashes($value)); } } $BookQuery->FMNew(); } //$BookQuery->SetDBData("Book_List.fp7", "Book_List"); // The extension in the file name omited for multi version compatibility(msyk) if (${$arrayName}['currentSort'] != '') { // If sorting has been requested, this adds it to the query. $BookQuery->AddSortParam($HTTP_GET_VARS['currentSort']); } if (${$arrayName}['currentQuery'] == 'Search Book List!') { // Check if this page is being accessed by a search foreach (${$arrayName} as $key => $value) { // 'foreach()' is a VERY handy function. It steps // through an array and stores the data in temporary
* under The Artistic License of PERL fame: * * http://www.opensource.org/licenses/artistic-license.html * *********************************************************************/ /* Modified by Masayuki Nii (2004/8/13), for adding Japanese field name support. */ header('Content-Type: text/html;charset=EUC-JP'); // Added by msyk 2004/8/13 // For avoiding MOJI-BAKE( invalid character ), please saving this file by EUC chacter set. // このファイルはEUCで保存して利用してください。 include_once 'FX_charset.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_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 $BookQuery = new FX_charset($serverIP, $webCompanionPort, 'FMPro7'); // This line creates an instance of the FX class // If you use version 6 pro/unlimited, modify to 'FMPro5/6' from 'FMPro7'. $BookQuery->SetCharacterEncoding('EUC-JP'); // Added by msyk 2004/8/13 $BookQuery->SetDataParamsEncoding('UTF-8'); $BookQuery->SetDBData("Book_List", "Detail_View"); // The '->' indicates that SetDBData is part of the FX instance we just created. $BookQuery->AddDBParam('-recid', $HTTP_GET_VARS['ID']); // '-recid' is a reference to the unique ID that FileMaker // creates for each record. You'll also note that PHP // recognizes the parameters passed from the last page ('ID'). $query = $HTTP_GET_VARS['query']; $BookData = $BookQuery->FMFind(); $currentKey = key($BookData['data']);