FileMaker Server 13 Web with PHP
2007-2013 FileMaker, Inc. All Rights Reserved. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMaker Bento FileMaker, Inc. FileMaker WebDirect Bento FileMaker, Inc. FileMaker FileMaker, Inc. FileMaker E URL E URL Acknowledgements URL FileMaker, Inc. http://www.filemaker.co.jp 01
6 6 1 Web 7 Web 8 Web 8 Web with PHP 9 Web with XML 9 PHP XML 9 PHP 9 XML 10 2 Web with PHP 11 Web with PHP 11 Web 11 Web 11 Web Web 12 12 FileMaker API for PHP 13 14 3 Web 15 Web with PHP 15 Web with PHP 15 16 16 Web 18 18 19 19 Web 21 FileMaker Web 22 22 Web 23 Web 24
4 4 Web with PHP 25 Web PHP 25 Web with PHP 25 5 FileMaker API for PHP 27 27 FileMaker API for PHP 27 FileMaker API for PHP 28 FileMaker API for PHP 28 FileMaker 28 FileMaker 28 FileMaker 29 FileMaker 29 30 30 30 30 31 FileMaker 31 31 FileMaker 31 32 32 32 32 FileMaker 33 33 33 34 34 34 34 34 35 35 35 35 36 36 37 Find All 37 Find Any 37 Find 38 Compound Find 38 40 40
5 41 42 42 43 43 45 6 46 Web 46 Web 47 47 Web 47 Web 48 Web 49 Tomcat 49 50 A Web with PHP 51 FileMaker 51 PHP 58 59
PHPWeb FileMaker Pro FileMaker Pro FileMaker Pro FileMaker Server Web with PHP 1 PHP Web 1 PHP 1 Web Web 1 FileMaker Server FileMaker API for PHP FileMaker www.filemaker.co.jp Web FileMaker Server FileMaker Server Web FileMaker Pro FileMaker Pro Advanced Web with PHP Web with XML ODBC JDBC ODBC JDBC FileMaker SQL FileMaker Server FileMaker Server FileMaker WebDirect FileMaker Server Web with PHP FileMaker Server Web with XML FileMaker ODBC JDBC FileMaker SQL
1 Web FileMaker Server FileMaker FileMaker WebDirect : FileMaker WebDirect Web Web Web FileMaker WebDirect FileMaker WebDirect FileMaker Server FileMaker Pro Web Web FileMaker Pro FileMaker WebDirect : FileMaker Pro Web Web HTML Web Web FileMaker WebDirect Web FileMaker Pro Web : FileMaker Web FileMaker Server Web FileMaker Server Web FileMaker Pro Web 1 Web 1 1 Web FileMaker Server Web 1 Web with PHP: FileMaker Pro PHP FileMaker API for PHP FileMaker PHP Web PHP Web 1 Web with XML: XML FileMaker Web FileMaker HTTP URL FileMaker Server XML XML
1 Web 8 Web FileMaker WebDirect Web FileMaker Server FileMaker Server Web Web Web Web FileMaker Server Web with XML: Web Web HREF Web FileMaker URL Uniform Resource LocatorWeb XML Web with PHP: Web Web FileMaker Server PHP Web FileMaker API for PHP Web FileMaker Server Web 1 2 3.fmp12.fmp12 Web Web Web FM API PHP Web Web 6 5 4 Web 1. Web Web 2. Web FileMaker Web Web 3. Web 4. FileMaker Server FileMaker Web 5. Web FileMaker 1 PHP Web API 1 XML Web Web XML 6. Web Web Web FileMaker Pro PDF www.filemaker.co.jp
1 Web 9 Web with PHP FileMaker API for PHP FileMaker PHP FileMaker API for PHP FileMaker Pro Web API FileMaker Pro PHP Web PHP PHP Web with XML XML FileMaker Web FileMaker Server FileMaker Pro HTTP FileMaker XML XML PHP XML PHP 1 PHP 1 FileMaker API for PHP FileMaker Pro Web 1 PHP 1 PHP 1 PHP Web 1 PHP http://php.net 1 PHP
1 Web 10 XML 1 FileMaker XML 1 XML W3C 1 XML Unicode 1 XML 1 Web XML FileMaker Pro XML FMPXMLRESULT Web with XML FileMaker Server Web with XML
2 Web with PHP Web with PHP PHP FileMaker Web Web with PHP FileMaker API for PHP FileMaker PHP FileMaker Server PHP FileMaker Server Web Web PHP Web with PHP 1 PHP Web FileMaker Server PHP 5 PHP 5 PHP 13 FileMaker API for PHP 1 FileMaker Server FileMaker Server FileMaker Pro Web 1 FileMaker PHP 1 PHP FileMaker Pro Web 16 1 PHP FileMaker 65 Web 22 FileMaker Web 1 PHP Web PHP Web Web Web Web Web Web with PHP 1 FileMaker Server 1 Microsoft IISWindows ApacheOS X Web FileMaker Web Web 1 FileMaker Web 1 FileMaker
2 Web with PHP 12 1 Web PHPFileMaker Server PHP 5 OS X PHP PHP 5.3.15 Windows PHP PHP 5.3.27 PHP http://php.net Web PHP curl URL curl http://php.net/curl FileMaker Server PHP 5 OS X Server Admin OS X Server Admin PHP FileMaker Server PHP 5 PHP 1 FileMaker Server FileMaker Pro 1 Web IP 1 Web Web Web FileMaker Server Web Web Web Web with PHP 1 Web 1 Web 1 Web IP FileMaker Server 1 Web Web 1 FileMaker Server Web IP ISP IP IP IP ISP
2 Web with PHP 13 FileMaker API for PHP FileMaker Server FileMaker PHPPHP 5 PHP FileMaker API for PHP FileMaker API for PHP PHP FileMaker PHP PHP 1 php.ini curl 1 php.ini include_path FileMaker API for PHP 1 PEAR Date http://pear.php.net/package/date/ FileMaker Server OS X 10.8 PHP 5.3.15OS X 10.9 PHP 5.4.17 Windows PHP 5.3.27 PHP FileMaker API for PHP PHP FileMaker Server FileMaker API for PHP.zip 1 IISWindows: [ ]:Program FilesFileMakerFileMaker ServerWeb PublishingFM_API_for_PHP_Standalone.zip [ ] FileMaker Server Web 1 ApacheOS X: / /FileMaker Server/Web Publishing/FM_API_for_PHP_Standalone.zip FM_API_for_PHP_Standalone.zip FileMaker.php FileMaker FileMaker.php FileMaker 1 PHP 1 HTTP HTTPS IISWindows: [ ]:Program FilesFileMakerFileMaker ServerHTTPServerConf [ ] FileMaker Server Web 1 HTTP ApacheOS X: / /FileMaker Server/HTTPServer/htdocs 1 HTTPS ApacheOS X: / /FileMaker Server/HTTPServer/htdocs/httpsRoot 1 PHP include_path OS X /usr/lib/php
2 Web with PHP 14 Web 1 Web FileMaker Server Admin Console FileMaker Server FileMaker Server 1 FileMaker FileMaker Pro Web 15 Web with PHP 1 FileMaker API for PHP FileMaker 5 FileMaker API for PHP
3 Web Web Web with PHP Web with PHP Web FileMaker Server Web Web Web 1. FileMaker Pro [ ] [ ] 2. 1 fmphp Web with PHP 3. Web Admin Web ASCII a za Z 0 9!% :FileMaker Pro 4. FileMaker Server Admin Console FileMaker Server FileMaker Server Web with PHP FileMaker Pro ODBC PHP SQL Web with PHP Web with PHP FileMaker Pro Web with PHP PHP 1 PHP 1 PHP 1 Web
3 Web 16 Web with PHP 1 Web with PHP 1 Web with PHP 1 Web with PHP fmphp FileMaker Pro 1 FileMaker Server Admin Console Web Web Web FileMaker Server FileMaker Server 1 Web IP Web 192.168.100.101 IP Web IP Web FileMaker Server 1 FileMaker Pro Advanced FileMaker FileMaker Pro FileMaker Server FileMaker Pro 1 FileMaker Server Admin Console CLIFileMaker Server FileMaker 1 FileMaker FileMaker Server FileMaker FileMaker Server 1 Web Web SSLSecure Sockets LayerSSL SSL HTTPS SSL Web FileMaker Pro PDF http://www.filemaker.co.jp/documentation Web with PHP PHP Web PHP FileMaker API for PHP fmphp FileMaker API for PHP PHP
3 Web 17 FileMaker API for PHP setproperty() 28 FileMaker API for PHP Web 1 Web PHP 1 PHP PHP Web PHP fmphp 1 fmphp : 1 PHP Web Web 1 FileMaker Pro 1 PHP [ ] FileMaker Pro PHP PHP Web Web [ ] Web FileMaker Pro
3 Web 18 Web FileMaker PHP 1 FileMaker API for PHP ($fm) $fm = new FileMaker(); $fm->setproperty('database', $databasename); $fm->setproperty('username', $username); $fm->setproperty('password', $password); 1 HTML Web HTML URL <IMG src="img.php?-url=<?php echo urlencode($record->getfield('cover Image'));?>"> 1 getcontainerdata() echo $fm->getcontainerdata($_get['-url']); FileMaker API for PHP 28 FileMaker API for PHP 1 Web (.mp3) (.mov.mp4.avi ) PDF Web Web PDF [Web ] 1 FileMaker Server FileMaker Server 1 FileMaker 1 FileMaker Server FileMaker ProFileMaker Go Web FileMaker Server 2 1 FileMaker Server FileMaker Server FileMaker
3 Web 19 PHP getcontainerdata() getcontainerdataurl() URL Web 1. FileMaker ProWeb 2. FileMaker Pro [ ] 3. WebWeb 1 HTTP HTTPS IISWindows : [ ]:Program FilesFileMakerFileMaker ServerHTTPServerConf [ ] FileMaker Server Web 1 HTTP ApacheOS X : / /FileMaker Server/HTTPServer/htdocs 1 HTTP ApacheOS X : / /FileMaker Server/HTTPServer/htdocs/httpsRoot 1 MIME Multipurpose Internet Mail Extensions Web MIME Web Web Web MIME Web 1 QuickTime [ ] PHP getcontainerdataurl() URL FileMaker API for PHP getcontainerdataurl()
3 Web 20 HTML img $fm=new FileMaker($database, $hostspec, $user, $password); $findcommand = $fm->newfindcommand($layout); $findcommand->addfindcriterion('type', 'png'); $result = $findcommand->execute(); $records = $result->getrecords(); foreach ($records as $record) { echo $record->getfield('container').'<br>'; // For images, use the HTML img tag echo '<img src="'.$fm-> getcontainerdataurl($record->getfield('container')).'">'; break; } HTML embed $fm=new FileMaker($database, $hostspec, $user, $password); $findcommand = $fm->newfindcommand($layout); $findcommand->addfindcriterion('type', 'pdf'); $result = $findcommand->execute(); $records = $result->getrecords(); foreach ($records as $record) { echo $record->getfield('container').'<br>'; // For movies and PDF files, use the HTML embed tag //echo '<embed src="'.$fm-> getcontainerdataurl($record->getfield('container')).'">'; break; } FileMaker Server FileMaker Pro FileMaker Server FileMaker Server FileMaker Pro Web : 1. FileMaker Server FileMaker Pro WindowsOS X 1 Windows: [ ]:Program FilesFileMakerFileMaker ServerDataDatabases [ ] 1 OS X: / /FileMaker Server/Data/Databases/
3 Web 21 2. RC_Data_FMS 3. RC_Data_FMS Customers Customers FileMaker Server 4. OS X fmsadmin FileMaker Server 1 Web (.mp3) (.mov.mp4.avi ) PDF Web Web PDF [Web ] 1 FileMaker Server FileMaker Server 1 FileMaker 1 FileMaker Server FileMaker ProFileMaker Go Web FileMaker Server 2 1 FileMaker Server FileMaker Server FileMaker Web Web 1 Web Web 1 Web
3 Web 22 FileMaker Web FileMaker Pro Web Web FileMaker FileMaker [ ] Web FileMaker 65 Web FileMaker Pro [ ] [ ] [ Web ] Web FileMaker Pro Web 23 Web Web 1 Web Web Web 1 Web [ ] 1 [ ] [ ] 1 Web [ ] 1 [ ] 1 [ ] 1 1 FileMaker Pro [ / ] Web Web
3 Web 23 1 [ / ] [ ][ ] [ ] [ / ] Web [ / ] 1 Get ( ) Web Publishing Engine Web FileMaker Pro 1 Web [ ] [ ] [Web ] Web Web Web FileMaker Pro FileMaker Pro / URL / Web FileMaker Server Web Web Web 22 Web Web Web Web Web Web Web [ ] Web [ ] Web [ / ]
3 Web 24 Web FileMaker Pro Web Web OnObjectEnter OnObjectEnter FileMaker Pro OnFirstWindowOpen OnLastWindowClose
4 Web with PHP FileMaker API for PHP FileMaker PHP PHP FileMaker Server Web FileMaker API for PHP 5 FileMaker API for PHP Web PHP FileMaker Server Web Web FileMaker Server FileMaker Server PHP PHP Web PHP 1 Web PHP Web PHP PHP 1 PHP FileMaker API for PHP Web 1 Web 1 Web 1 Web API Web PHP 1 PHP Web Web with PHP Web with PHP 1. Admin Console PHP FileMaker Server 2. Admin Console [ ] FileMaker Web with PHP fmphp FileMaker Pro Web 3 Web PHP FileMaker FileMaker 3. PHP FileMaker API PHP FileMaker PHP 5 FileMaker API for PHP
4 Web with PHP 26 4. Web 1 HTTP HTTPS IISWindows: [ ]:Program FilesFileMakerFileMaker Server HTTPServerConf [ ] FileMaker Server Web 1 HTTP ApacheOS X: / /FileMaker Server/HTTPServer/htdocs 1 HTTPS ApacheOS X: / /FileMaker Server/HTTPServer/htdocs/httpsRoot 5. FileMaker Pro Web Web 18 Web 6. 7. Web 8. Web URL http://< >/< > 1 < > FileMaker Server 1 < > 4 Web 192.168.123.101 c:inetpub wwwrootcustomersindex.php Web Web URL http://192.168.123.101/customers/index.php PHP 5 Latin-1 (ISO-8859-1) FileMaker Server Unicode (UTF-8) FileMaker Server Admin Console PHP UTF-8 ISO-8859-1 UTF-8 PHP <HEAD> charset PHP 6
5 FileMaker API for PHP FileMaker API for PHP FileMaker PHP FileMaker FileMaker API for PHP FileMaker Pro Web FileMaker API for PHP FileMaker Pro PHP 1 1 1 1 1 FileMaker 1 1 FileMaker PHP FileMaker API for PHP FileMaker API for PHP PHP FileMaker API for PHP 13 FileMaker API for PHP FileMaker API for PHP FileMaker API for PHP FileMaker Server Web 1 IISWindows: [ ]:Program FilesFileMakerFileMaker ServerDocumentationPHP API Documentationindex.html [ ] FileMaker Server Web 1 ApacheOS X: / /FileMaker Server/Documentation/PHP API Documentation/index.html
5 FileMaker API for PHP 28 FileMaker API for PHP FileMaker API for PHP FileMaker Server Web 1 IISWindows: [ ]:Program FilesFileMakerFileMaker ServerExamplesPHPTutorial [ ] FileMaker Server Web 1 ApacheOS X: / /FileMaker Server/Examples/PHP/Tutorial PHP Web FileMaker API for PHP FileMaker API for PHP FileMaker Server Web 1 IISWindows: [ ]:Program FilesFileMakerFileMaker ServerExamplesPHPAPI Examples [ ] FileMaker Server Web 1 ApacheOS X: / /FileMaker Server/Examples/PHP/API Examples API Web FileMaker PHP FileMaker PHP require_once ('FileMaker.php'); FileMaker FileMaker FileMaker Pro FileMaker FileMaker Pro FileMaker API for PHP
5 FileMaker API for PHP 29 FileMaker FileMaker execute() FileMaker 1 Add 1 Compound Find 1 Delete 1 Duplicate 1 Edit 1 Find Find All Find Any 1 Find Request Compound Find 1 Perform Script 1 30 1 31 FileMaker 1 37 FileMaker FileMaker setproperty() : $fm = new FileMaker(); $databases = $fm->listdatabases(); : $fm = new FileMaker(); $fm->setproperty('database', 'questionnaire'); $fm->setproperty('hostspec', 'http://192.168.100.110'); $fm->setproperty('username', 'web'); $fm->setproperty('password', 'web'); hostspec http://localhost PHP FileMaker Server Web hostspec PHP hostspec FileMaker Server Web
5 FileMaker API for PHP 30 FileMaker FileMaker Pro 1 AddDeleteDuplicate Edit FindFind AllFind Any Compound Find 2 1 createrecord() createrecord() commit() : $rec = $fm->createrecord('form View', $values); $result = $rec->commit(); 1 Add newaddcommand() FileMaker_Command_Add execute() : $newadd =& $fm->newaddcommand('respondent', $respondent_data); $result = $newadd->execute(); Duplicate newduplicatecommand() ID FileMaker_Command_Duplicate execute() $newduplicate = $fm->newduplicatecommand('respondent', $rec_id); $result = $newduplicate->execute(); 1 Edit neweditcommand() IDFileMaker_Command_Edit execute() : $newedit =& $fm->neweditcommand('respondent', $rec_id, $respondent_data); $result = $newedit->execute();
5 FileMaker API for PHP 31 1 commit() : $rec = $fm->getrecordbyid('form View', $rec_id); $rec->setfield('name', $nameentered); $result = $rec->commit(); 1 delete() : $rec = $fm->getrecordbyid('form View', $rec_id); $rec->delete(); 1 Delete newdeletecommand() ID FileMaker_Command_Delete execute() : $newdelete =& $fm->newdeletecommand('respondent', $rec_id); $result = $newdelete->execute(); FileMaker FileMaker FileMaker FileMaker Pro FileMaker Web Web 22 FileMaker Web listscripts() listscripts() 29 FileMaker $scripts = $fm->listscripts(); FileMaker newperformscriptcommand() FileMaker_Command_PerformScript execute()
5 FileMaker API for PHP 32 $newperformscript =& $fm->newperformscriptcommand('order Summary', 'ComputeTotal'); $result = $newperformscript->execute(); setprecommandscript() setprecommandscript() $findcommand =& $fm->newfindcommand('students'); $findcommand->addfindcriterion('gpa', $searchvalue); $findcommand->setprecommandscript('updategpa'); $result = $findcommand->execute(); setpresortscript() 38 Find $findcommand =& $fm->newfindcommand('students'); $findcommand->setpresortscript('removeexpelled'); setscript() 38 Find $findcommand =& $fm->newfindcommand('students'); $findcommand->setscript('myscript','param1 param2 param3'); setprecommandscript()setpresortscript() setscript() setresultlayout() addsortrule() FileMaker Server Web 1. setprecommandscript() 2. 3. setpresortscript() 4. addsortrule() 5. setresultlayout()
5 FileMaker API for PHP 33 6. setscript() 7. addsortrule() 102 FileMaker FileMaker FileMaker Pro FileMaker 1 listlayouts() 1 getlayout() 1 getname() 1 listfields() 1 getfields() FileMaker_Field 1 listvaluelists() 1 listrelatedsets() 1 getdatabase() 1 getlayout() 1 getlayout() 1 setresultlayout() FileMaker FileMaker Pro listrelatedsets() $tablenames = $currentlayout->listrelatedsets();
5 FileMaker API for PHP 34 FileMaker_Result getrelatedsets() $relatedsetsnames = $result->getrelatedsets(); getrelatedsets() FileMaker_RelatedSet FileMaker_RelatedSet $relatedsetsarray = $currentlayout->getrelatedsets(); getrelatedset() FileMaker_RelatedSet $relatedset = $currentlayout->getrelatedset('customers'); getname() $tablename = $relatedset->getname(); getrelatedset() $relatedrecordsarray = $currentrecord->getrelatedset('customers');
5 FileMaker API for PHP 35 newrelatedrecord() commit() //create a new portal row in the 'customer' portal $new_row = $currentrecord->newrelatedrecord('customer'); //set the field values in the new portal row $new_row->setfield('customer::name', $newname); $new_row->setfield('customer::company', $newcompany); $result = $new_row->commit(); delete() $relatedset = $currentrecord->getrelatedset('customers'); /* Runs through each of the portal rows */ foreach ($relatedset as $nextrow) { } $namefield = $nextrow->getfield('customer::name') if ($namefield == $badname ) { $result = $newrow->delete(); } FileMaker FileMaker Pro listvaluelists() $valuelistnames = $currentlayout->listvaluelists();
5 FileMaker API for PHP 36 getvalueliststwofields() $valuelistsarray = $currentlayout->getvalueliststwofields(); getvaluelists() FileMaker API for PHP getvalueliststwofields() getvaluelisttwofields() FileMaker [ ] getvaluelisttwofields() 1 [ ] getvaluelisttwofields() 1 [ ] [ ] getvaluelisttwofields() 1 [ ] [ ] getvaluelisttwofields() getvaluelisttwofields() $layout = $fm->getlayout('customers'); $valuearray = $layout->getvaluelisttwofields("region", 4); foreach ($valuearray as $displayvalue => $value) {... } 1 getvaluelist() FileMaker API for PHP getvaluelisttwofields() 1 getvaluelisttwofields() foreach loop for loop
5 FileMaker API for PHP 37 FileMaker 1 Find All 37 Find All 1 Find Any 37 Find Any 1 Find 38 Find 1 Compound Find 38 Compound Find FileMaker 1 addsortrule() clearsortrules() 1 setlogicaloperator() 1 setrange() getrange() setrange() 100 100 20 1 FileMaker 1 setprecommandscript() 1 setpresortscript() 1 setscript() Find All Find All newfindallcommand() FileMaker_Command_FindAll execute() $findcommand =& $fm->newfindallcommand('form View'); $result = $findcommand->execute; Find All Find Any Find Any newfindanycommand() FileMaker_Command_FindAny execute() $findcommand =& $fm->newfindanycommand('form View'); $result = $findcommand->execute;
5 FileMaker API for PHP 38 Find newfindcommand() FileMaker_Command_Find execute() addfindcriterion() clearfindcriteria() - $findcommand =& $fm->newfindcommand('form View'); $findcommand->addfindcriterion('questionnaire ID', $active_questionnaire_id); $result = $findcommand->execute(); - $findcommand =& $fm->newfindcommand('customer List'); $findcommand->addsortrule('title', 1, FILEMAKER_SORT_ASCEND); $result = $findcommand->execute(); Compound Find Compound Find Compound Find : 1 newcompoundfindcommand() FileMaker_Command_CompoundFind 1 newfindrequest() FileMaker_Command_FindRequest 1 setomit() 1 add() Compound Find 1 execute() Compound Find
5 FileMaker API for PHP 39 - Compound Find // Create the Compound Find command object $compoundfind = $fm->newcompoundfindcommand('form View'); // Create first find request $findreq1 = $fm->newfindrequest('form View'); // Create second find request $findreq2 = $fm->newfindrequest('form View'); // Create third find request $findreq3 = $fm->newfindrequest('form View'); // Specify search criterion for first find request $findreq1->addfindcriterion('quantity in Stock', '<100'); // Specify search criterion for second find request $findreq2->addfindcriterion('quantity in Stock', '0'); $findreq2->setomit(true); // Specify search criterion for third find request $findreq3->addfindcriterion('cover Photo Credit', 'The London Morning News'); $findreq3->setomit(true); // Add find requests to compound find command $compoundfind->add(1,$findreq1); $compoundfind->add(2,$findreq2); $compoundfind->add(3,$findreq3); // Set sort order $compoundfind->addsortrule('title', 1, FILEMAKER_SORT_DESCEND); // Execute compound find command $result = $compoundfind->execute(); // Get records from found set $records = $result->getrecords(); // Print number of records found echo 'Found '. count($records)."results.<br><br>";
5 FileMaker API for PHP 40 1 getrecords() FileMaker_Record API 1 getfields() 1 getfoundsetcount() 1 getfetchcount() getfoundsetcount() count($response->getrecords()) 1 getfield() 1 Unix PHP getfieldastimestamp() 1 1 1970 1 1 1 FileMaker Unix 1 getfieldastimestamp() FileMaker_Error 1 getcontainerdata() <IMG src= img.php?-url=<?php echo urlencode($record->getfield('cover Image'));?> > echo $fm->getcontainerdata($_get['-url']); 1 URL getcontainerdataurl() // For images, use the HTML img tag echo '<img src="'.$fm-> getcontainerdataurl($record->getfield('container')).'">'; // For movies and PDF files, use the HTML embed tag //echo '<embed src="'.$fm-> getcontainerdataurl($record->getfield('container')).'">'; setrelatedsetsfilters() setrelatedsetsfilters() 1 : layout none 1 none Web 1 layout FileMaker Pro [ ] [ ]
5 FileMaker API for PHP 41 1 : all 1 [ ] [ ] all Web 1 [ ] [ ] [ ] FileMaker Web PHP Web FileMaker PHP 1 1 1 1 M/D/YYYY M 12 D 31 YYYY 0001 4000 1/30/3030 4/31/2013 31 /\- 1\30-2013 1 12 1 H 1 H:M 1 H:M:S 1 H:M:S AM/PM 1 H:M AM/PM H 12 M S 60
5 FileMaker API for PHP 42 PHP 1 1/30 1 H 24 24 1 FileMaker FileMaker Pro 1 1 1 1 1 validate() PHP validate() TRUE validate() FileMaker_Error _Validation validate() PHP validate() TRUE validate() FileMaker_Error _Validation
5 FileMaker API for PHP 43 validate() validate() TRUE validate() FileMaker_Error _Validation FileMaker_Error_Validation 1. 2. 1 - FILEMAKER_RULE_NOTEMPTY 2 - FILEMAKER_RULE_NUMERICONLY 3 - FILEMAKER_RULE_MAXCHARACTERS 4 - FILEMAKER_RULE_FOURDIGITYEAR 5 - FILEMAKER_RULE_TIMEOFDAY 6 - FILEMAKER_RULE_TIMESTAMP_FIELD 7 - FILEMAKER_RULE_DATE_FIELD 8 - FILEMAKER_RULE_TIME_FIELD 3. FileMaker_Error_Validation 1 isvalidationerror() 1 numerrors()
5 FileMaker API for PHP 44 //Create an Add request $addrequest =& $fm->newaddcommand('test', array('join' => 'added', 'maxchars' => 'abcx', 'field' => 'something', 'numericonly' => 'abc')); //Validate all fields $result = $addrequest->validate(); //If the validate() method returned any errors, print the name of the field, the error number, and the value that failed. if (FileMaker::isError($result)) { } echo 'Validation failed:'."n"; $validationerrors= $result->geterrors(); foreach ($validationerrors as $error) { } $field = $error[0]; echo 'Field Name:'.$field->getName()."n"; echo 'Error Code:'.$error[1]."n"; echo 'Value:'.$error[2]."n"; Validation failed: Field Name:numericonly Error Code:2 Value:abc Field Name:maxchars Error Code:3 Value:abcx
5 FileMaker API for PHP 45 FileMaker PHP FileMaker_Error FileMaker_Error 1 iserror() FileMaker Error 1 numerrors() 1 geterrors() 1 getmessage() $result = $findcommand->execute(); if (FileMaker::isError($result)) { echo "<p>error:".". $result->getmessage().""</p>"; exit; } FileMaker Error A Web with PHP
6 Web Web 1. 3 Web 2. Web with PHP FileMaker Server Admin Console FileMaker Server 3. Web Web 4. FileMaker Server Web Web 1 HTTP HTTPS IISWindows: [ ]:Program FilesFileMakerFileMaker Server HTTPServerConf [ ] FileMaker Server Web 1 HTTP ApacheOS X: / /FileMaker Server/HTTPServer/htdocs 1 HTTPS ApacheOS X: / /FileMaker Server/HTTPServer/htdocs/httpsRoot 5. Web 1 FileMaker Server FileMaker 1 FileMaker Pro Web Web 1 FileMaker Pro FileMaker Server FileMaker Server FileMaker Pro 1 19 RC_Data_FMS 18 Web 6.
6 47 Web Web 1 1 1 Web 22 FileMaker Web 1 Web 1 FileMaker API for PHP FileMaker API for PHP Web Web Web Web URL http://127.0.0.1/< > < > Web Web 1 Web 1 Web 1 Web 1 Tomcat Web 1 IISWindows: Microsoft IIS Web Windows W3C Extended Log File Format Web HTTP W3C Common Logfile Format Microsoft IIS Web 1 ApacheOS X : Apache Web Apache W3C Common Logfile Format Web HTTP Apache HTTP Apache Web W3C Common Logfile Format W3C Extended Log File Format World Wide Web Consortium Web www.w3.org
6 48 Web Web Web wpe.log Web XML Web Web Web FileMaker API for PHP HTTP POST Web wpe.log PHP wpe.log XML PHP wpe.log FileMaker Server Web 1 IISWindows: [ ]:Program FilesFileMakerFileMaker ServerHTTPServerLogswpe.log [ ] 1 ApacheOS X: / /FileMaker Server/HTTPServer/Logs/wpe.log Web wpe.log [Web ] Admin Console wpe.log Web Web Web XML [ ] Admin Console FileMaker Server wpe.log Admin Console wpe.log wpe.log Web wpe.log 1 wpe.log.1 wpe.log wpe.log.1 Web wpe.log [TIMESTAMP_GMT] [WPC_HOSTNAME] [CLIENT_IP:PORT] [ACCOUNT_NAME] [MODULE_TYPE] [SEVERITY] [FM_ERRORCODE] [RETURN_BYTES] [MESSAGE] 1 [TIMESTAMP_GMT] GMT 1 [WPC_HOSTNAME] Web 1 [CLIENT_IP:PORT] XML IP 1 [ACCOUNT_NAME] FileMaker 1 [MODULE_TYPE] Web with XML XML Web with PHP PHP 1 [SEVERITY] INFO ERROR
6 49 1 [FM_ERROR_CODE] FileMaker 51 FileMaker HTTP: HTTP 1 [RETURN_BYTES] 1 [MESSAGE]. Web wpe.log 1 Web 2013-06-02 15:15:31-0700 - - - - INFO - - FileMaker Server Web Publishing Engine started. 2013-06-02 15:46:52-0700 - - - - INFO - - FileMaker Server Web Publishing Engine stopped. 1 XML 2013-06-02 15:21:08-0700 WPC_SERVER 192.168.100.101:0 jdoe XML INFO 0 3964 "/fmi/xml/fmresultset.xml?-db=contacts&-lay=contact_details&-findall" 2013-06-02 15:26:31-0700 WPC_SERVER 192.168.100.101:0 jdoe XML ERROR 5 596 "/fmi/xml/fmresultset.xml?-db=contacts&-layout=contact_details&-findall" 1 2013-06-02 17:33:12-0700 WPC_SERVER 192.168.100.101:0 jdoe - ERROR 4 - Web Scripting Error:4, File:"10b_MeetingsUpload", Script:"OnOpen", Script Step:"Show Custom Dialog" 1 Web 2013-06-09 10:59:49-0700 WPC_SERVER 192.168.100.101:0 jdoe - INFO - - XML Web Publishing Engine is enabled. 1 2013-06-02 15:30:42-0700 WPC_SERVER 192.168.100.101:0 jdoe XML ERROR - - Communication failed Web Web Web Web web_server_module_log.txtweb FileMaker ServerLogs 1 IISWindows: [ ]:Program FilesFileMakerFileMaker ServerLogsweb_server_module_log.txt [ ] 1 ApacheOS X: / /FileMaker Server/Logs/web_server_module_log.txt Tomcat Web FileMaker Server Tomcat Tomcat FileMaker Server Web 1 IISWindows: [ ]:Program FilesFileMakerFileMaker ServerAdminadmin-master-tomcatlogs [ ] 1 ApacheOS X: / /FileMaker Server/Admin/admin-master-tomcat/logs/
6 50 1 Web with PHP 15 Web with PHP 1 FileMaker Server FileMaker Server 1 1 Web Web 1 Web PHP 1 [FileMaker Server ] http://< >:16000/test < > FileMaker Server 1 [PHP Web ] FMServer_Sample PHP FileMaker Server FileMaker Server
A Web with PHP Web Web 1 Web FileMaker API for PHP FileMaker_Error FileMaker 1 PHP curl PHP 58 PHP FileMaker Web Web -1 0 1 2 3 4 5 [ ] 6 7 8 9 10 11 12 13 14 15 16 17 UTF-16 18 19 A Za z0 9ASCII 20
A Web with PHP 52 21 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 130 131 Starter Solutions 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216
A Web with PHP 53 217 218 300 301 302 303 304 306 ID 307 308 400 401 402 403 FileMaker Pro 404 405 406 407 ) 408 409 410 412 FileMaker Pro 413 414 415 416 417 418 INSERT 500 501 502 503 504 505 506 507 508 509 510 511
A Web with PHP 54 512 513 600 601 602 603 700 706 EPSF 707 708 709 QuickTime 710 QuickTime 711 714 715 Excel 716 ODBC DELETEINSERT UPDATE SQL 717 XML/XSL 718 Xerces XML 719 Xalan XSL XML 720 721 722 723 724 725 726 727 729 730 Excel Excel 2007/2008 731 732 733 734 735 736 737 Bento
A Web with PHP 55 738 800 801 802 1 1 FileMaker Server 1 803 804 805 806 FileMaker Pro 807 FileMaker Pro 808 809 / 810 / 811 FileMaker Pro 812 813 814 815 816 817 819 820 821 822 FMI 823 824 FileMaker 825 826 850 851 852 853 1 900 901 902 903 905
A Web with PHP 56 906 920 921 922 923 951 954 XML 955 956 957 958 959 Web 960 1200 1201 1202 1203 1204 ( 1205 */ 1206 1207 1208 ( 1209 1210 1211 1212 +-* 1213 Let 1214 AVERAGECOUNTEXTENDGETREPETITIONMAXMINNPVSTDEVSUM GETSUMMARY 1215 1216 GetSummary 1217 1218 1219 1220 1221 1222 1223 1224 1225
A Web with PHP 57 1300 1301 1400 ODBC ODBC 1401 ODBC 1402 ODBC 1403 ODBC 1404 ODBC 1405 ODBC 1406 SQL API ODBC 1407 ODBC 1408 ODBC 1409 ODBC 1410 ODBC 1411 ODBC 1412 ODBC 1413 ODBC 1414 SQL 1450 PHP 1451 1501 SMTP 1502 SMTP 1503 SSL 1504 SMTP 1505 SMTP 1506 E 1507 SMTP 1550 1551 1626 1627 1628 SSL 1629 60 1630 URL 1631
A Web with PHP 58 PHP FileMaker API for PHP PHP PHP Web Publishing Core FileMaker Server curl CURLE_GOT_NOTHING (52) PHP PHP Web http://php.net
A Add 30 add() 38 addsortrule() 37 Admin Console 14, 15 C clearsortrules() 37 commit() 30 Compound Find 38 39 createrecord() 30 curl 12 curl 58 D Delete 31 delete() 31, 35 Duplicate 30 E Edit 30 F FileMaker API for PHP 13 28 9 27 28 FileMaker API for PHP 28 FileMaker API for PHP 13 FileMaker API for PHP 13 FileMaker API for PHP 28 FileMaker Server 6 6 FileMaker Server Admin Admin Console FileMaker WebDirect 7 6 FileMaker 28 FileMaker 33 29 29 30 FileMaker Compound Find 38 Find All 37 Find Any 37 Find 37, 38 31 30 30 30 Find All 37 Find Any 37 Find 38 G getcontainerdata() 18, 40 getcontainerdataurl() 19, 40 getdatabase() 33 geterrors() 45 getfetchcount() 40 getfield() 40 getfieldastimestamp() 40 getfields() 33, 40 getfoundsetcount() 40 getlayout() 33 getmessage() 45 getname() 33, 34 getrange() 37 getrecords() 40 getrelatedset() 34 getrelatedsets() 34 getvaluelists() 36 getvaluelisttwofields() 36 I iserror() 45 isvalidationerror() 43 J JDBC 6 L Latin-1 26 listfields() 33 listlayouts() 33 listrelatedsets() 33 listscripts() 31 listvaluelists() 33, 35
60 N newaddcommand() 30 newcompoundfindcommand() 38 newdeletecommand() 31 newduplicatecommand() 30 neweditcommand() 30 newfindallcommand() 37 newfindanycommand() 37 newfindcommand() 38 newfindrequest() 38 newperformscriptcommand() 31 newrelatedrecord() 35 numerrors() 43, 45 O ODBC 6 ODBC 15 OS X Server Admin 12 P PHP Web 47 58 25 13 15 50 9 PHP 5 12 PHP 50 PHP 25 Q QuickTime Web 19 S SAT Admin Console Server Admin OS X Server Admin setlogicaloperator() 37 setomit() 38 setprecommandscript() 32, 37 setpresortscript() 32, 37 setproperty() 29 setrange() 37 setrelatedsetsfilters() 40 setresultslayout() 33 setscript() 32, 37 SSLSecure Sockets Layer 16 T Tomcat 49 U Unicode 26 Unix 40 UTF-8 26 V validate() 42 W Web 48 51 8 8 Web 8 Web 47 Web 47 Web FileMaker 6 47 46 47 50 Web 47 Web 46 Web 47 Web Web Web 47 50 Web PHP 25 QuickTime 19 18 51 16 Web 19 Web 21 web_server_module_log.txt 49 wpe.log 48 X XML 10
61 Web 15 17 22 17 Web 15 35 42 48 6 Web 47 45 51 45 Web 21 19 19 18 6 SQL 15 42 Web PHP 9 Web 16 Web IP 16 XML 9 15 23 22 15 7 Web with XML 9 Web PHP API 9 Web 15 33 42 URL 12 42 17 17 40 40 37 37 16 11 41 [ ] 17 41, 42 15, 17 35 31 33 33 30 41 22 Web 22 17 24 17 22
62 IP 12 7 IP 16 16 16 8 FileMaker 29 FileMaker Server 29 40, 42 41 41 41 41, 42 41 42 42 43 42 41 41 41 41, 42 41 42 42 43 42 16 51 51 29, 30 15, 17 Web 15 50 6 IP 12 24 Web 15 [ ] 17 17 [ ] 17 40 42 41 41 41, 42 41 42 42 18, 21 33 [ ] 40 6
63 add() 38 addsortrule() 37 clearsortrules() 37 commit() 30 createrecord() 30 delete() 31, 35 getcontainerdata() 18, 40 getcontainerdataurl() 19, 40 getdatabase() 33 geterrors() 45 getfetchcount() 40 getfield() 40 getfieldastimestamp() 40 getfields() 33, 40 getfoundsetcount() 40 getlayout() 33 getmessage() 45 getname() 33, 34 getrange() 37 getrecords() 40 getrelatedset() 34 getrelatedsets() 34 getvalueliststwofields() 36 getvaluelisttwofields() 36 iserror() 45 isvalidationerror() 43 listfields() 33 listlayouts() 33 listrelatedsets() 33 listscripts() 31 listvaluelists() 33, 35 newaddcommand() 30 newcompoundfindcommand() 38 newdeletecommand() 31 newduplicatecommand() 30 neweditcommand() 30 newfindallcommand() 37 newfindanycommand() 37 newfindcommand() 38 newfindrequest() 38 newperformscriptcommand() 31 newrelatedrecord() 35 numerrors() 43, 45 setlogicaloperator() 37 setomit() 38 setprecommandscript() 32, 37 setpresortscript() 32, 37 setproperty() 29 setrange() 37 setrelatedsetsfilters() 40 setresultslayout() 33 setscript() 32, 37 validate() 42 Web 15 42 41 27 33 30 31 30 30 30 Tomcat 49 web_server_module_log.txt 49 wpe.log 48 Web 47 47