FileMaker Server Custom Web Publishing with PHP

Transcription

1 FileMaker Server 11 Web with PHP

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

3 7 1 Web Web 10 Web 10 Web with PHP 11 Web with XML and XSLT 11 PHP XML XSLT 12 PHP 12 XML XSLT 12 2 Web with PHP Web with PHP 13 Web 13 Web 13 Web Web FileMaker API for PHP Web Web with PHP 17 Web with PHP Web 19 Web 20 FileMaker Web Web 21 Web 22

4 4 FileMaker Server Web with PHP 4 Web with PHP Web PHP 23 Web with PHP 23 FileMaker PHP Site Assistant PHP Web 24 PHP Site Assistant 25 PHP Site Assistant 25 PHP Site Assistant 26 5 FileMaker API for PHP 27 FileMaker API for PHP 27 FileMaker API for PHP 27 FileMaker API for PHP 28 FileMaker 28 FileMaker 28 FileMaker 28 FileMaker FileMaker FileMaker FileMaker

5 Find All 35 Find Any 35 Find 35 Compound Find Web 43 Web Web 44 Web 44 Web 45 Web A Web with PHP FileMaker 47 PHP 53

6 6 FileMaker Server Web with PHP

7 PHP Web FileMake 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 Web with PHP PHP Site Assistant Web with XML and XSLT XSLT Site Assistant ODBC JDBC ODBC JDBC FileMaker Server Auto Update FileMaker Pro FileMaker Server FileMaker Server FileMaker Web FileMaker Server Web with PHP PHP Site Assistant FileMaker Server Web with XML and XSLT XSLT Site Assistant FileMaker ODBC JDBC FileMaker Server

8 8 FileMaker Server Web with PHP

9 1 Web FileMaker Server FileMaker Web : Web Web Web Web Web Web FileMaker Pro FileMaker Server FileMaker Pro Web Web FileMaker Pro FileMaker Web : FileMaker Pro Web Web HTML Web Web Web Web FileMaker Server Web FileMaker Web Web : FileMaker Server Web Web FileMaker Server Web FileMaker Pro Web 1 Web 1 1 Web FileMaker Server Web 1 Web with PHP : FileMaker Pro PHP PHP FileMaker API FileMaker PHP Web PHP Site Assistant PHP Web PHP Web 1 Web with XML and XSLT : 1 XML FileMaker Web 1 XSLT FileMaker Web XSLT Site Assistant XSLT

10 10 FileMaker Server Web with PHP Web Web Web FileMaker Server FileMaker Server Web Web Web Web FileMaker Server Web with XML and XSLT: Web XSLT HTML XML vcard Web Web Web Web Web Web HREF Web FileMaker URL Uniform Resource Locator URL XML XSLT Web XML XSLT Web with PHP: Web Web FileMaker Server PHP Web FileMaker API for PHP 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 1 XSLT Web XSLT XML Web HTML XML 6. Web Web Web FileMaker PDF

11 1 Web 11 Web with PHP FileMaker API for PHP FileMaker PHP FileMaker API for PHP FileMaker Pro Web API FileMaker Pro PHP Web PHP PHP FileMaker PHP Site Assistant FileMaker Pro PHP PHP Site Assistant Web Web PHP FileMaker PHP Site Assistant PHP Web FileMaker PHP PHP Site Assistant FileMaker API for PHP Web with XML and XSLT XML FileMaker Web FileMaker Server FileMaker Pro HTTP FileMaker XML XML XML XSLT XSLT FileMaker Web Web XML 1 XSLT FileMaker XML XML 1 1 Web Web Web XSLT HTTP URL Web FileMaker Web XML Web HTML FileMaker XSLT Site Assistant Web with XSLT XSLT XSLT Site Assistant

12 12 FileMaker Server Web with PHP PHP XML XSLT PHP 1 PHP 1 FileMaker API for PHP FileMaker Pro Web 1 PHP 1 PHP 1 PHP Web 1 PHP 1 PHP XML XSLT 1 FileMaker XML 1 XML XSLT W3C 1 XML Unicode 1 XML 1 XSLT XML RSS RTF vcard 1 XSLT XML 1 1 Web FileMaker Pro XML FMPXMLRESULT 1 FileMaker Server FileMaker XSLT XSLT Web with XSLT FileMaker Server Web with XML and XSLT

13 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 14 FileMaker API for PHP 1 FileMaker Server FileMaker Server Web FileMaker Pro 1 PHP Site Assistant FileMaker Web PHP 24 FileMaker PHP Site Assistant PHP Web 1 FileMaker PHP 1 PHP FileMaker Pro Web 17 1 PHP FileMaker 75 Web 20 FileMaker Web 1 PHP Web PHP Web Web Web Web Web Web with PHP 1 FileMaker Server 1 Microsoft IIS Windows Apache Mac OS X Web FileMaker Web Web 1 FileMaker Web 1 FileMaker

14 14 FileMaker Server Web with PHP 1 Web PHP FileMaker Server PHP 5 Windows Mac OS X v10.5 PHP PHP Mac OS X v10.6 PHP PHP PHP Web PHP curl ( URL ) curl FileMaker Server PHP 5 Mac OS X Server Admin Mac 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 FileMaker API for PHP FileMaker Server FileMaker PHP PHP 5 PHP FileMaker API for PHP FileMaker API for PHP PHP FileMaker PHP PHP

15 2 Web with PHP 15 1 php.ini curl 1 php.ini include_path FileMaker API for PHP 1 PEAR Date FileMaker Server Windows Mac OS X v10.5 PHP Mac OS X v10.6 PHP PHP FileMaker Server FileMaker API for PHP.zip 1 IIS Windows < >: Program Files FileMaker FileMaker Server Web Publishing FM_API_for_PHP_Standalone.zip < > FileMaker Server Web 1 Apache (Mac OS) / /FileMaker Server/Web Publishing/FM_API_for_PHP_Standalone.zip FM_API_for_PHP_Standalone.zip FileMaker.php FileMaker FileMaker.php FileMaker 1 PHP Web 1 IIS Windows < >: Inetpub wwwroot < > FileMaker Server Web 1 Apache Mac OS/ /WebServer/Documents 1 PHP include_path Mac OS X /usr/lib/php Web 1 Web FileMaker Server Admin Console FileMaker Server FileMaker Server 1 FileMaker FileMaker Pro Web 17 Web with PHP 1 FileMaker API for PHP FileMaker 5 FileMaker API for PHP

16 16 FileMaker Server Web with PHP

17 3 Web Web Web with PHP Web with PHP Web FileMaker Server Web Web Web 1. FileMaker Pro [ ] [ ] 2. fmphp Web with PHP 3. Web Admin Web ASCII a z A Z!% : 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 Web with PHP 1 Web with PHP 1 Web with PHP

18 18 FileMaker Server Web with PHP 1 fmphp Web with PHP FileMaker Pro 1 FileMaker Server Admin Console Web Web Web FileMaker Server FileMaker Server 1 Web IP Web IP Web IP Web 1 Web Web SSL Secure Sockets Layer SSL SSL Web FileMaker Pro PDF PHP Web PHP FileMaker API for PHP fmphp FileMaker API for PHP PHP FileMaker API for PHP setproperty() 27 FileMaker API for PHP PHP Site Assistant 1 PHP 1 PHP PHP PHP Site Assistant Web 1 Web PHP 1 PHP PHP Web PHP fmphp 1 fmphp 1 PHP Web Web 1 FileMaker Pro

19 3 Web 19 1 PHP FileMaker Pro PHP PHP Web Web [ ] Web FileMaker Pro Web FileMaker PHP 1 HTML Web HTML URL <IMG src="img.php?-url=<?php echo urlencode($record->getfield('cover Image'));?>"> 1 FileMaker API for PHP getcontainerdata() $fm = & new FileMaker(); $fm->setproperty('database', $databasename); $fm->setproperty('username', $username); $fm->setproperty('password', $password); echo $fm->getcontainerdata($_get['-url']); FileMaker API for PHP 27 FileMaker API for PHP Web 1. FileMaker Pro Web 2. FileMaker Pro [ ] 3. WebWeb 1 IIS Windows : < >: Inetpub wwwroot < > FileMaker Server Web 1 Apache Mac OS / /WebServer/Documents 1 MIME Multipurpose Internet Mail Extensions Web MIME Web Web Web MIME Web 1 QuickTime

20 20 FileMaker Server Web with PHP Web 1 OLE 1 Web Web 1 GIF JPEG Web Web JPEG 1 Web Web FileMaker Web FileMaker Pro ScriptMaker Web Web FileMaker FileMaker [ ] Web FileMaker 75 Web FileMaker Pro [ ] [ ] [Web ] Web FileMaker Pro Web 21 Web Web 1 Web Web Web 1 Web [ ] 1 [ ] [ ]

21 3 Web 21 1 Web [ ] 1 [ ] 1 [ ] 1 1 FileMaker Pro [ / ] Web Web 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 20 Web Web Web Web Web Web Web [ ] Web

22 22 FileMaker Server Web with PHP / Web [ ] Web [ / ] Web FileMaker Pro ( ) Web Web OnObjectEnter OnObjectEnter FileMaker Pro

23 4 Web with PHP FileMaker API for PHP FileMaker PHP PHP FileMaker Server Web PHP FileMaker PHP Site Assistant 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 PHP FileMaker PHP Site Assistant PHP PHP Site Assistant PHP FileMaker Pro 24 FileMaker PHP Site Assistant PHP Web

24 24 FileMaker Server Web with PHP 4. Web 1 IIS Windows < >Inetpub wwwroot < > FileMaker Server Web 1 Apache Mac OS / /WebServer/Documents 5. FileMaker Pro Web Web 19 Web Web 8. web URL >/< > 1 < > FileMaker Server 1 < > 4 Web c: Inetpub wwwroot customers index.php Web Web URL PHP 4 PHP 5 Latin-1 (ISO ) FileMaker Server Unicode (UTF-8) FileMaker Server Admin Console PHP UTF-8 ISO PHP <HEAD> charset FileMaker PHP Site Assistant PHP Web PHP Site Assistant FileMaker Server FileMaker Pro PHP Web PHP Site Assistant PHP PHP Site Assistant PHP PHP PHP Site Assistant FileMaker API for PHP Web with PHP Web Web PHP Site Assistant

25 4 Web with PHP 25 PHP Site Assistant PHP Site Assistant 1. 3 Web 2. FileMaker Server Admin Console Web Web FileMaker Server 3. PHP Web PHP Web FileMaker Server 4. PHP Site Assistant Web FileMaker Pro PHP Site Assistant PHP Site Assistant PHP Site Assistant FileMaker Server PHP Site Assistant PHP Site Assistant FileMaker Server Java Web Start PHP Site Assistant PHP Site Assistant FileMaker Server PHP Site Assistant 1. PHP Site Assistant 1 Web [FileMaker Server Web ] >:16000/tools < > FileMaker Server [ ] [PHP Site Assistant ] 1 FileMaker Pro Advanced [ ] > [ ] fmphp FileMaker Server [ ] > [PHP Assistant ] 1 FileMaker Server Admin Console. [ ] >[PHP Site Assistant ] FileMaker Server Admin ConsolePHP Site AssistantPHP Site Assistant FileMaker Server 2. [ ] [ ] (Mac OS) 3. [ ] PHP Site Assistant Windows Mac OS[ ] 4. PHP Site Assistant PHP Site Assistant

26 26 FileMaker Server Web with PHP PHP Site Assistant 1 FileMaker Pro Advanced PHP Site Assistant FileMaker Server fmphp 1 FileMaker Server IP 1 Web PHP Web PHP Site Assistant PHP Site Assistant PHP PHP FileMaker API PHP FileMaker PHP Site Assistant 5 FileMaker API for PHP PHP Site Assistant 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 14 FileMaker API for PHP FileMaker API for PHP FileMaker API for PHP FileMaker Server Web 1 IIS Windows < >: Program Files FileMaker FileMaker Server Documentation PHP API Documentation index.html < > FileMaker Server Web 1 Apache Mac OS / /FileMaker Server/Documentation/PHP API Documentation/index.html FileMaker API for PHP FileMaker API for PHP FileMaker Server Web 1 IIS Windows < >: Program Files FileMaker FileMaker Server Examples PHP Tutorial < > FileMaker Server Web 1 Apache Mac OS / /FileMaker Server/Examples/PHP/Tutorial PHP Web

28 28 FileMaker Server Web with PHP FileMaker API for PHP FileMaker API for PHP FileMaker Server Web 1 IIS Windows< >: Program Files FileMaker FileMaker Server Examples PHP API Examples < > FileMaker Server Web 1 Apache Mac OS / /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 FileMaker FileMaker execute() FileMaker 1 Add 1 Compound Find Set 1 Delete 1 Duplicate 1 Edit 1 Find Find All Find Any 1 Find Request Compound Find Set 1 Perform Script FileMaker 1 35

29 5 FileMaker API for PHP 29 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 FileMaker FileMaker Pro 1 Add Delete Duplicate Edit Find Find All Find 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()

30 30 FileMaker Server Web with PHP $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(); 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 20 FileMaker Web listscripts() listscripts() (29 FileMaker $scripts = $fm->listscripts(); FileMaker newperformscriptcommand() FileMaker_Command_PerformScript execute()

31 5 FileMaker API for PHP 31 $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() 35 Find $findcommand =& $fm->newfindcommand('students'); $findcommand->setpresortscript('removeexpelled'); setscript() 35 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() 6. setscript() 7. addsortrule() 102

32 32 FileMaker Server Web with PHP 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(); FileMaker_Result getrelatedsets() $relatedsetsnames = $result->getrelatedsets(); getrelatedsets() FileMaker_RelatedSet FileMaker_RelatedSet

33 5 FileMaker API for PHP 33 $relatedsetsarray = $currentlayout->getrelatedsets(); getrelatedset() FileMaker_RelatedSet $relatedset = $currentlayout->getrelatedset('customers'); getname() $tablename = $relatedset->getname(); getrelatedset() $relatedrecordsarray = $currentrecord->getrelatedset('customers'); newrelatedrecord() commit() //'customer' $new_row = $currentrecord->newrelatedrecord('customer'); // $new_row->setfield('customer::name', $newname); $new_row->setfield('customer::company', $newcompany); $result = $new_row->commit(); delete() $relatedset = $currentrecord->getrelatedset('customers'); /* */ foreach ($relatedset as $nextrow) { $namefield = $nextrow->getfield('customer::name') if ($namefield == $badname ) { $result = $newrow->delete(); } }

34 34 FileMaker Server Web with PHP FileMaker FileMaker Pro listvaluelists() $valuelistnames = $currentlayout->listvaluelists(); getvalueliststwofields() $valuelistsarray = $currentlayout->getvalueliststwofields(); getvaluelists() FileMaker API for PHP getvalueliststwofields() PHP Site Assistant getvaluelists() 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() PHP Site Assistant getvaluelist()

35 5 FileMaker API for PHP 35 1 getvaluelisttwofields() foreach loop for loop FileMaker 1 Find All 35 Find All 1 Find Any 35 Find Any 1 Find 35 Find 1 Compound Find 36 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; Find Use the newfindcommand() FileMaker_Command_Find execute() addfindcriterion() clearfindcriteria()

36 36 FileMaker Server Web with PHP $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

37 5 FileMaker API for PHP 37 Compound Find // Compound Find $compoundfind =& $fm->newcompoundfindcommand('form View'); // $findreq1 =& $fm->newfindrequest('form View'); // $findreq2 =& $fm->newfindrequest('form View'); // $findreq3 =& $fm->newfindrequest('form View'); // $findreq1->addfindcriterion('quantity in Stock', '<100'); // $findreq2->addfindcriterion('quantity in Stock', '0'); $findreq2->setomit(true); // $findreq3->addfindcriterion('cover Photo Credit', 'The London Morning News'); $findreq3->setomit(true); // Compound Find $compoundfind->add(1,$findreq1); $compoundfind->add(2,$findreq2); $compoundfind->add(3,$findreq3); // $compoundfind->addsortrule('title', 1, FILEMAKER_SORT_DESCEND); // $result = $compoundfind->execute(); // $records = $result->getrecords(); // echo 'Found '. count($records)."results.<br><br>"; 1 getrecords() FileMaker_Record API 1 getfields() 1 getfoundsetcount() 1 getfetchcount() getfoundsetcount() count($response->getrecords())

38 38 FileMaker Server Web with PHP 1 getfield() getfieldastimestamp() Unix PHP FileMaker Unix 1 getfieldastimestamp() FileMaker_Error setrelatedsetsfilters() setrelatedsetsfilters() 1 layout none 1 none Web 1 layout FileMaker Pro [ ] [ ] 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\

39 5 FileMaker API for PHP H 1 H:M 1 H:M:S 1 H:M:S AM/PM 1 H:M AM/PM H 12 M S 60 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 validate()

40 40 FileMaker Server Web with PHP 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() // $addrequest =& $fm->newaddcommand('test', array('join' => 'added', 'maxchars' => 'abcx', 'field' => 'something', 'numericonly' => 'abc')); // $result = $addrequest->validate(); //validate() 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

41 5 FileMaker API for PHP 41 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

42 42 FileMaker Server Web with PHP

43 6 Web Web 1. 3 Web 2. Web Web 3. FileMaker Server Web Web 1 IIS Windows< >: Inetpub wwwroot < > FileMaker Server Web 1 Apache Mac OS/ /WebServer/Documents 4. Web FileMaker Pro Web Web 19 Web 5. Web Web Web 20 FileMaker Web 1 Web

44 44 FileMaker Server Web with PHP Web Web URL 1 > 1 > < > Web Web 1 Web 1 Web 1 Web 1 Web Web 1 IIS WindowsMicrosoft IIS Web Windows W3C Extended Log File Format Web HTTP W3C Common Logfile Format Microsoft IIS Web 1 Apache Mac OS 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 Web Web Web pe_application_log.txt FileMaker Server Web 1 IIS Windows< >Program Files FileMaker FileMaker Server Logs pe_application_log.txt < > 1 Apache Mac OS/ /FileMaker Server/Logs/pe_application_log.txt pe_application_log.txt Web [ ] pe_application_log.txt [ :] Web Web [ :] Web Web

45 6 45 Admin Console FileMaker Server Web Web Web Web web_server_module_log.txt FileMaker Server Web 1 IIS Windows < >: Program Files FileMaker FileMaker Server Logs web_server_module_log.txt < > 1 Apache Mac OS/ /FileMaker Server/Logs/web_server_module_log.txt Web Web Web Web wpc_access_log.txt Web FileMaker Server Web Web Web FileMaker API for PHP HTTP POST Web PHP FileMaker Server Web 1 IIS Windows < >: Program Files FileMaker FileMaker Server Logs wpc_access_log.txt < > 1 Apache Mac OS/ FileMaker Server/Logs/wpc_access_log.txt 1 Web with PHP 17 Web with PHP 1 FileMaker Server FileMaker Server 1 1 Web Web 1 Web [PHP ] 1 [FileMaker Server ] /test < > FileMaker Server 1 PHP Web ] FMServer_Sample PHP FileMaker Server FileMaker Server

46 46 FileMaker Server Web with PHP

47 A Web with PHP Web Web 1 Web FileMaker API for PHP FileMaker_Error FileMaker 1 PHP curl PHP 53 PHP FileMaker Web Web [ ] UTF A Z a z 0 9 ASCII

48 48 FileMaker Server Web with PHP

49 A Web with PHP ID FileMaker Pro ) FileMaker Pro

50 50 FileMaker Server Web with PHP 706 EPSF QuickTime 710 QuickTime Excel 716 ODBC DELETE INSERT UPDATE SQL 717 XML/XSLT 718 Xerces XML 719 Xalan XSL XML Excel Excel 7.0 Excel 95Excel XP Bento FileMaker Server 1

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

52 52 FileMaker Server Web with PHP 959 Web ( 1205 */ ( * 1213 Let 1214 AVERAGE COUNT EXTEND GETREPETITION MAX MIN NPV STDEV SUM GETSUMMARY 1215 Get 1216 GetSummary ODBC ODBC 1401 ODBC 1402 ODBC 1403 ODBC 1404 ODBC 1405 ODBC 1406 SQL API ODBC 1407 ODBC 1408 ODBC 1409 ODBC 1410 ODBC

53 A Web with PHP ODBC 1412 ODBC 1413 ODBC 1450 PHP SMTP 1502 SMTP 1503 SSL 1504 SMTP 1505 SMTP 1506 E 1507 SMTP PHP FileMaker API for PHP PHP PHP Web Publishing Core FileMaker Server curl CURLE_GOT_NOTHING (52) PHP PHP Web

54 54 FileMaker Server Web with PHP

55 A Admin Console 15, 17 add() method 35, 36 Add 29 addsortrule() 35 C clearsortrules() 35 commit() method 29 Compound Find createrecord() 29 curl 14 curl 53 D delete() 30, 33 Delete 30 Duplicate 29 E Edit 30 Error() 41 F FileMaker API for PHP FileMaker API for PHP 27 FileMaker API for PHP 15 FileMaker API for PHP 15 FileMaker API for PHP 28 FileMaker class objects record 35, 37, 38 FileMaker Server 7 7 FileMaker Server Admin Admin Console 18 FileMaker 28 FileMaker FileMaker Add 35 Delete 35 Edit 35 Find 35 Find All 35 G Compound Find 35 Duplicate 35 Find Any 35 getdatabase() 32 geterrors() 41 getfetchcount() 37 getfield() 38 getfields() 32, 37 getfieldastimestamp() 38 getfoundsetcount() 37 getlayout() 32 getmessage() 41 getname() 32, 33 getrecords() 37 getrelatedset() 33 getrelatedsets() 32 getrange() 35 getvaluelists() 34 getvaluelisttwofields() method 29, 30, 31, 32, 33, 34 getvaluelisttwofields() 34 GIF Web 20 I iserror() 41 isvalidationerror() 40 J JDBC 7 JPEG Web 20 L Latin-1 24 listfields() 32 listlayouts() 32 listrelatedsets() 32 listscripts() 30 listvaluelists() 32, 34 M Mac OS X Server Admin 14 methods add() 35, 36 getvaluelisttwofields() 29, 30, 31, 32, 33, 34 N newaddcommand() 29 newdeletecommand() 30 newduplicatecommand() 29 neweditcommand() 30

56 56 FileMaker Server Web with PHP numerrors() 40, 41 newfindallcommand() 35 newfindanycommand() 35 newfindcommand() 35 newperformscriptcommand() 30 newrelatedrecord() 33 O ODBC 7 ODBC 17 P PHP Web PHP 5 14 PHP Site Assistant PHP 45 PHP 26 Q QuickTime Web 19 R record object 35, 37, 38 S SAT Admin Console Server Admin Mac OS X Server Admin setlogicaloperator() 35 setomit() 36 setprecommandscript() 31, 35 setpresortscript() 31, 35 setproperty() 29 setrange() 35 setrelatedsetsfilters() 38 setresultslayout() 32 setscript() 31, 35 Site Assistant 25 SSL Secure Sockets Layer 18 U UTF-8 24 Unicode 24 Unix 38 V validate() 39 W Web Web 10 Web 44 Web 45 Web 44 Web FileMaker Web 44 Web 43 Web 43 Web 45 Web PHP 23 QuickTime Web 19 Web 10 Web 20 wpc_access_log.txt45 web_server_module_log.txt45 X XML XSLT 12 XML Web 11 XSLT Web 11

57 57 Web Web 17 Web Web Web Web Web PHP 11 Web 18 Web IP 18 XML 11 XSLT Web PHP API 11 Web SQL 17 PHP 23 Web 9 39 URL [ ] 19 17, Web

58 58 FileMaker Server Web with PHP IP 14 9 IP FileMaker Server 29 FileMaker 29 38, Web 17 7 IP 14 Web Web [ ] 19 Web [ ] 38 PDF7 addsortrule() 35 clearsortrules() 35 commit() 29 createrecord() 29 delete() 30, 33 listfields() 32 listlayouts() 32 listrelatedsets() 32 listscripts() 30 iserror() 41 listvaluelists() 32, 34 isvalidationerror() 40 getdatabase() 32 geterrors() 41 getfetchcount() 37 getfield() 38 getfields() 32, 37 getfieldastimestamp() 38 getfoundsetcount() 37 getlayout() 32 getmessage() 41 getname() 32, 33 getrecords() 37 getrelatedset() 33 getrelatedsets() 32 getrange() 35 getvaluelists() 34 getvaluelisttwofields() 34 newaddcommand() 29 newdeletecommand() 30

59 59 newduplicatecommand() 29 neweditcommand() 30 newfindallcommand() 35 newfindanycommand() 35 newfindcommand() 35 newperformscriptcommand() 30 newrelatedrecord() 33 numerrors() 40, 41 setrelatedsetsfilters() 38 setrange() 35 setlogicaloperator() 35 setproperty() 29 setprecommandscript() 31, 35 setpresortscript() 31, 35 setresultslayout() 32 setscript() 31, 35 validate() 39 Web , 45 Web 44 web_server_module_log.txt 45 44

60 60 FileMaker Server Web with PHP