FileMaker Server Custom Web Publishing with PHP

Transcription

1 FileMaker Server 13 Web with PHP

2 FileMaker, Inc. All Rights Reserved. FileMaker, Inc Patrick Henry Drive Santa Clara, California FileMaker Bento FileMaker, Inc. FileMaker WebDirect Bento FileMaker, Inc. FileMaker FileMaker, Inc. FileMaker E URL E URL Acknowledgements URL FileMaker, Inc. 01

3 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 FileMaker API for PHP Web 15 Web with PHP 15 Web with PHP Web Web 21 FileMaker Web Web 23 Web 24

4 4 4 Web with PHP 25 Web PHP 25 Web with PHP 25 5 FileMaker API for PHP FileMaker API for PHP 27 FileMaker API for PHP 28 FileMaker API for PHP 28 FileMaker 28 FileMaker 28 FileMaker 29 FileMaker FileMaker FileMaker FileMaker Find All 37 Find Any 37 Find 38 Compound Find

5 Web 46 Web Web 47 Web 48 Web 49 Tomcat A Web with PHP 51 FileMaker 51 PHP 58 59

6 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 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

7 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

8 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 fmp12.fmp12 Web Web Web FM API PHP Web Web 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

9 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 1 PHP

10 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

11 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

12 2 Web with PHP 12 1 Web PHPFileMaker Server PHP 5 OS X PHP PHP Windows PHP PHP PHP Web PHP curl URL 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

13 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 FileMaker Server OS X 10.8 PHP OS X 10.9 PHP Windows PHP 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

14 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

15 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

16 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 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 Web with PHP PHP Web PHP FileMaker API for PHP fmphp FileMaker API for PHP PHP

17 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

18 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

19 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()

20 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/

21 3 Web 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

22 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

23 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 [ / ]

24 3 Web 24 Web FileMaker Pro Web Web OnObjectEnter OnObjectEnter FileMaker Pro OnFirstWindowOpen OnLastWindowClose

25 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

26 4 Web with PHP 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 Web 8. Web URL >/< > 1 < > FileMaker Server 1 < > 4 Web c:inetpub wwwrootcustomersindex.php Web Web URL PHP 5 Latin-1 (ISO ) FileMaker Server Unicode (UTF-8) FileMaker Server Admin Console PHP UTF-8 ISO UTF-8 PHP <HEAD> charset PHP 6

27 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 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

28 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

29 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 FileMaker 1 37 FileMaker FileMaker setproperty() : $fm = new FileMaker(); $databases = $fm->listdatabases(); : $fm = new FileMaker(); $fm->setproperty('database', 'questionnaire'); $fm->setproperty('hostspec', ' $fm->setproperty('username', 'web'); $fm->setproperty('password', 'web'); hostspec PHP FileMaker Server Web hostspec PHP hostspec FileMaker Server Web

30 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();

31 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()

32 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() setpresortscript() 4. addsortrule() 5. setresultlayout()

33 5 FileMaker API for PHP 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();

34 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');

35 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();

36 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

37 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() 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;

38 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

39 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>";

40 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() 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 [ ] [ ]

41 5 FileMaker API for PHP 41 1 : all 1 [ ] [ ] all Web 1 [ ] [ ] [ ] FileMaker Web PHP Web FileMaker PHP M/D/YYYY M 12 D 31 YYYY /30/3030 4/31/ /\- 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

42 5 FileMaker API for PHP 42 PHP 1 1/30 1 H FileMaker FileMaker Pro validate() PHP validate() TRUE validate() FileMaker_Error _Validation validate() PHP validate() TRUE validate() FileMaker_Error _Validation

43 5 FileMaker API for PHP 43 validate() validate() TRUE validate() FileMaker_Error _Validation FileMaker_Error_Validation 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()

44 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

45 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

46 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.

47 6 47 Web Web Web 22 FileMaker Web 1 Web 1 FileMaker API for PHP FileMaker API for PHP Web Web Web Web URL > < > 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

48 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

49 [FM_ERROR_CODE] FileMaker 51 FileMaker HTTP: HTTP 1 [RETURN_BYTES] 1 [MESSAGE]. Web wpe.log 1 Web :15: INFO - - FileMaker Server Web Publishing Engine started :46: INFO - - FileMaker Server Web Publishing Engine stopped. 1 XML :21: WPC_SERVER :0 jdoe XML INFO "/fmi/xml/fmresultset.xml?-db=contacts&-lay=contact_details&-findall" :26: WPC_SERVER :0 jdoe XML ERROR "/fmi/xml/fmresultset.xml?-db=contacts&-layout=contact_details&-findall" :33: WPC_SERVER :0 jdoe - ERROR 4 - Web Scripting Error:4, File:"10b_MeetingsUpload", Script:"OnOpen", Script Step:"Show Custom Dialog" 1 Web :59: WPC_SERVER :0 jdoe - INFO - - XML Web Publishing Engine is enabled :30: WPC_SERVER :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/

50 Web with PHP 15 Web with PHP 1 FileMaker Server FileMaker Server 1 1 Web Web 1 Web PHP 1 [FileMaker Server ] >:16000/test < > FileMaker Server 1 [PHP Web ] FMServer_Sample PHP FileMaker Server FileMaker Server

51 A Web with PHP Web Web 1 Web FileMaker API for PHP FileMaker_Error FileMaker 1 PHP curl PHP 58 PHP FileMaker Web Web [ ] UTF A Za z0 9ASCII 20

52 A Web with PHP Starter Solutions

53 A Web with PHP ID FileMaker Pro ) FileMaker Pro INSERT

54 A Web with PHP EPSF QuickTime 710 QuickTime Excel 716 ODBC DELETEINSERT UPDATE SQL 717 XML/XSL 718 Xerces XML 719 Xalan XSL XML Excel Excel 2007/ Bento

55 A Web with PHP FileMaker Server FileMaker Pro 807 FileMaker Pro / 810 / 811 FileMaker Pro FMI FileMaker

56 A Web with PHP XML Web ( 1205 */ ( * 1213 Let 1214 AVERAGECOUNTEXTENDGETREPETITIONMAXMINNPVSTDEVSUM GETSUMMARY GetSummary

57 A Web with PHP 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 SMTP 1502 SMTP 1503 SSL 1504 SMTP 1505 SMTP 1506 E 1507 SMTP SSL URL 1631

58 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

59 A Add 30 add() 38 addsortrule() 37 Admin Console 14, 15 C clearsortrules() 37 commit() 30 Compound Find createrecord() 30 curl 12 curl 58 D Delete 31 delete() 31, 35 Duplicate 30 E Edit 30 F FileMaker API for PHP 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 FileMaker Compound Find 38 Find All 37 Find Any 37 Find 37, 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 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 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 Web 8 Web 47 Web 47 Web FileMaker Web 47 Web 46 Web 47 Web Web Web Web PHP 25 QuickTime Web 19 Web 21 web_server_module_log.txt 49 wpe.log 48 X XML 10

61 61 Web Web Web Web SQL Web PHP 9 Web 16 Web IP 16 XML Web with XML 9 Web PHP API 9 Web URL [ ] 17 41, 42 15, Web

62 62 IP 12 7 IP FileMaker 29 FileMaker Server 29 40, , , , 30 15, 17 Web IP Web 15 [ ] [ ] , , [ ] 40 6

63 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 Tomcat 49 web_server_module_log.txt 49 wpe.log 48 Web 47 47