FileMaker Server 15 カスタム Web 公開ガイド

FileMaker Server 15 Web

2004-2016 FileMaker, Inc. All Rights Reserved. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054 FileMaker FileMaker Go FileMaker, Inc. FileMaker WebDirect FileMaker, Inc. FileMaker FileMaker, Inc. FileMaker E URL E URL Acknowledgments URL FileMaker, Inc. http://www.filemaker.com/jp 01

8 8 FileMaker 8 1 Web 9 Web 10 Web 10 Web with XML 11 Web with PHP 11 XML PHP 11 XML 11 PHP 12 2 Web 13 Web 13 13 14 Web (MIME ) 15 Web 15 15 16 16 17 Web 18 FileMaker Web 18 18 Web 19 Web 19 3 Web with XML 20 Web Web 20 Web with XML 20 Web 21 Web 21 Web Web 21 22 22

4 4 Web XML 23 Web with XML 23 Web FileMaker Pro XML / 23 Web XML 24 Web XML 25 XML URL 25 XML URL 25 XML FileMaker URL 26 URL 27 Web XML 27 FileMaker XML 28 FileMaker 28 FileMaker 28 fmsresultset 29 fmresultset 29 fmresultset XML 31 FileMaker XML 32 FMPXMLRESULT 32 FMPXMLRESULT XML 33 FMPXMLLAYOUT 33 FMPXMLLAYOUT XML 35 UTF-8 36 FileMaker XML 36 XML 38 XML 38 XML 39 5 XML 40 40 40 41 42 42 44 44 -dbnames () 44 -delete () 44 -dup () 45 -edit () 45 -find-findall -findany () 45 -findquery () 46 -layoutnames () 46 -new () 46 -scriptnames () 47 -view () 47

5 47 -db () 47 -delete.related () 47 -field () 48 fieldname () 48 fieldname.op () 49 -lay () 50 -lay.response () 50 -lop () 50 -max () 50 -modid ( ID) 51 -query () 51 -recid ( ID) 52 -relatedsets.filter () 52 -relatedsets.max () 53 -script () 53 -script.param () 54 -script.prefind () 54 -script.prefind.param () 54 -script.presort () 55 -script.presort.param () 55 -skip () 55 -sortfield () 55 -sortorder () 56 6 Web with PHP 57 Web with PHP 57 Web 57 Web 57 Web Web 58 58 FileMaker API for PHP 59 60 7 Web with PHP 61 Web PHP 61 Web with PHP 61 8 FileMaker API for PHP 63 63 FileMaker API for PHP 63 FileMaker API for PHP 63

FileMaker 64 FileMaker 64 FileMaker 64 FileMaker API 65 FileMaker 65 65 66 66 66 67 FileMaker 67 67 FileMaker 68 68 68 68 69 FileMaker 69 70 70 70 70 70 71 71 71 71 72 72 72 72 73 Find All 73 Find Any 74 Find 74 Compound Find 74 76 77 77 78 79 79 79 81 6

7 9 82 Web 82 Web 83 XML 83 84 Web 84 Web 85 Web 86 Tomcat 87 A Web 88 XML 88 FileMaker 88 89

FileMaker Pro FileMaker Pro FileMaker Pro FileMaker Web Web XML PHP Web FileMaker Server Web 1 Web 1 XML 1 FileMaker Server XML 1 PHP 1 FileMaker Server FileMaker API for PHP 1 Web Web FileMaker 1 FileMaker Server Admin Console [] > [FileMaker Server ] 1 FileMaker Server Admin Console 1 FileMaker http://www.filemaker.com/documentation/ja FileMaker Server Admin Console [] > [FileMaker Server ]

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 2 Web 1 Web with XML: XML FileMaker Web FileMaker HTTP URL FileMaker Server XML XML 1 Web with PHP: FileMaker Pro PHP FileMaker API for PHP FileMaker PHP Web PHP Web

1 Web 10 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 Locator) Web XML Web with PHP: Web Web FileMaker Server PHP Web FileMaker API for PHP.fmp12.fmp12 1 2 3 Web Web Web Web FM API PHP Web 6 5 4 Web FileMaker Server Web Web 1. Web Web 2. Web FileMaker Web Web 3. Web 4. FileMaker Server FileMaker Web 5. Web FileMaker 1 PHP FileMaker API for PHP PHP XML Web XML XML FileMaker API for PHP FileMaker API for PHP XML PHP PHP 1 XML Web Web XML 6. Web Web Web FileMaker Web 2 Web

1 Web 11 Web with XML XML FileMaker Web FileMaker Server FileMaker Pro HTTP FileMaker XML XML Web with PHP FileMaker API for PHP FileMaker PHP FileMaker API for PHP FileMaker Pro Web API FileMaker Pro PHP Web PHP PHP XML PHP XML 1 FileMaker XML 1 XML W3C 1 XML Unicode 1 XML 1 Web XML FileMaker Pro XML FMPXMLRESULT Web with XML 3 Web with XML

1 Web 12 PHP 1 PHP 1 FileMaker API for PHP FileMaker Pro Web 1 PHP 1 PHP 1 PHP Web 1 1 PHP http://php.net 1 PHP Web with PHP 6 Web with PHP

2 Web Web Web Web Web Web FileMaker Server Web Web Web 1. FileMaker Pro [] [] 2. Web 1 Web with XML fmxml 1 Web with PHP fmphp 3. 1 Admin Web Web ASCII (a za Z 0 9 )!% FileMaker Pro Web Web Web Web Web HTTP Web Web Web HTTP

2 Web 14 Web Web 1 Web 1 Web 1 Web Web Web 1 1 Web [] Web 1 () FileMaker Pro 1 Web Web Web Web [] Web FileMaker Pro Web 1 Web 1 Web 1 fmxml fmphp Web 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

2 Web 15 FileMaker Server 1 FileMaker Pro Advanced FileMaker FileMaker Server FileMaker Pro 1 FileMaker Server Admin Console (CLI) FileMaker Server FileMaker 1 FileMaker FileMaker Server FileMaker FileMaker Server 1 Web Web SSL (Secure Sockets Layer) SSL HTTPS FileMaker Server FileMaker, Inc. SSL FileMaker SSL FileMaker Server FileMaker Web Web Web <iframe> Web <iframe> Web Web FileMaker Server Web Web (MIME ) MIME (Multipurpose Internet Mail Extensions) Web Web Web MIME Web Web FileMaker FileMaker Server 25XML URL

2 Web 16 Web 1. FileMaker ProWeb 2. FileMaker Pro [] 3. WebWeb 1 IIS (Windows): []:Program FilesFileMakerFileMaker ServerHTTPServerconf [] FileMaker Server Web 1 Apache (OS X): //FileMaker Server/HTTPServer/htdocs () MIME Web MIME Web Web Web MIME Web (FileMaker Pro [] ) FileMaker Pro FileMaker Server FileMaker Pro FileMaker Server FileMaker Server FileMaker Pro Web : 1. FileMaker Server FileMaker Pro (Windows) (OS X) 1 Windows: []:Program FilesFileMakerFileMaker ServerDataDatabases [] 1 OS X: //FileMaker Server/Data/Databases/ 2. RC_Data_FMS ( )

2 Web 17 3. RC_Data_FMS Customers Customers FileMaker Server 4. OS X fmsadmin FileMaker Server Web (.mp3) (.mov.mp4.avi ) PDF Web Web PDF Web FileMaker Server [ SSL ] FileMaker Server HTTPS 1 FileMaker Server [ SSL ] HTTPS 1 FileMaker Server [ SSL ] HTTP FileMaker FileMaker Server FileMaker FileMaker Server 2 FileMaker Server [ SSL ] FileMaker Server HTTP 1 FileMaker 1 FileMaker Server FileMaker ProFileMaker Go Web FileMaker Server 2 [ SSL ] [ SSL ] FileMaker Server (Windows) FileMaker Server (OS X)

2 Web 18 Web Web 1 Web Web 1 Web FileMaker Web FileMaker Pro Web Web FileMaker FileMaker Web URL Web Web FileMaker Pro [] [ Web ] Web FileMaker Pro Web 19 Web Web Web (wpe.log) 85Web 1 FileMaker Pro Web XML max PHP setrange() 1 Web Web Web 1 Web [] 1

2 Web 19 1 Web FileMaker WebDirect FileMaker Server Admin Console [[] Web ] Web 1 FileMaker Pro 1 [/ ] Web Web 1 () [/] [] [ ][] [/ ] Web [/] 1 Get () Web Publishing Engine Web FileMaker Pro 1 Web Web Web Web Web FileMaker Pro FileMaker Pro FileMaker FileMaker Server FileMaker Web Web Web FileMaker Pro () Web FileMaker Pro OnFirstWindowOpen OnLastWindowClose

3 Web with XML Web Web Web XML FileMaker Server Web Web 1 : Web FileMaker Web 1 : FileMaker XML FileMaker Web 1 : FileMaker Web Web FileMaker Web 1 : FileMaker Server XML Web FileMaker XML Web Web 1 : 1 : Web XML URL Web with XML Web with XML FileMaker HTTP FileMaker XML XML 27Web XML Web with XML XML FileMaker Server Web 1 FileMaker Server FileMaker Pro 1 JavaScript XML 1 FileMaker Pro Web 14 1 Web FileMaker Web 18FileMaker Web

3 Web with XML 21 1 FileMaker 54-script.param () 54-script.prefind.param () 55-script.presort.param () 1 fmresultset XML relatedset () 1 5 XML Web Web Web with XML 1 FileMaker Server 1 Microsoft IIS (Windows) Apache (OS X) Web 1 Web FileMaker 1 Web 1 FileMaker Server 1 FileMaker Pro 1 Web IP 1 Web Web Web FileMaker Server Web Web Web Web with XML 1 Web 1 Web 1 Web IP

3 Web with XML 22 FileMaker Server 1 Web Web 1 FileMaker Server Web () IP ISP () IP IP IP ISP Web 1 Web FileMaker Server Admin Console FileMaker Server FileMaker Server 1 FileMaker FileMaker Pro Web 13 Web 1 XML FileMaker 27Web XML

4 Web XML Web FileMaker XML (Extensible Markup Language) XML Web with XML XML URL Web with XML Web HTTP URL FileMaker FileMaker Server XML XML FileMaker Web XML XML 1.0 XML http://www.w3.org XML Web FileMaker Pro XML / Web FileMaker Pro FileMaker XML 2 1 XML Web fmresultsetfmpxmlresult FMPXMLLAYOUT FileMaker Pro XML FMPXMLRESULT FMPXMLRESULT 27Web XML 1 Web XML URL Web FileMaker Pro XML FileMaker Pro 1 Web FileMaker Server FileMaker Pro XML 1 Web URL FileMaker XML FileMaker Pro XML XML 1 Web XML FileMaker Pro XML 1 Web FileMaker XML FileMaker Pro

4 Web XML 24 1 Web FileMaker Pro 1 Web HTTP HTTPS FileMaker FileMaker Pro FileMaker Pro XML FileMaker Pro Web XML XML Web Web FileMaker XML Web 1. Web Web XML HTTP HTTPS Web Web 2. Web Web FileMaker Server Web Web CWPE ( Web ) 3. Web FileMaker.fmp12 FileMaker.fmp12 Web FileMaker XML.fmp12.fmp12 FileMaker Web XML Web 5. Web XML Web FileMaker Server Web Web 4. FileMaker Web 6. Web Web Web Web CWPE ( Web )

4 Web XML 25 Web XML Web FileMaker XML 1. FileMaker Server Admin Console XML FileMaker Server 2. FileMaker FileMaker Pro XML Web fmxml 13 Web XML [] [] [] () XML XML XML () 3. HTML HREF Web FileMaker XML 1 1 FileMaker URL HTTP HTTPS Web Web URL URL XML URL 36FileMaker XML 5XML 4. Web URL ( ) XML Web 5. Web XML Web XML URL Web FileMaker XML URL XML URL Web FileMaker XML URL <>://<> [:<>]/fmi/xml/<xml >.xml [?<>] 1 <> HTTP HTTPS 1 <> Web IP 1 <> Web () (HTTP 80HTTPS 443)

4 Web XML 26 1 <XML > FileMaker XML fmresultsetfmpxmlresult FMPXMLLAYOUT29fmsresultset 32 FileMaker XML 1 <> FileMaker XML 1 1 (-dbnames ) 36FileMaker XML 5XML URL URL FMPXMLRESULT FMPXMLLAYOUT 2 40 Web XML URL 2 http://server.company.com/fmi/xml/fmresultset.xml?-db=products&-lay=sales&-findall http://192.168.123.101/fmi/xml/fmpxmlresult.xml?-db=products&-lay=sales&-findall XML FileMaker URL XML XML <data> URL <data>/fmi/xml/cnt/data.<>?<></data> <>.jpg MIME Web <> XML URL : <data>/fmi/xml/cnt/data.jpg?-db=products&-lay=sales&-field=product_image(1)&-recid=2</data> XML -field 42 <>://<>[:<>]/fmi/xml/cnt/data.<>?<> <><> <> XML URL : http://www.company.com/fmi/xml/cnt/data.jpg?-db=products&-lay=sales&-field=product_image(1)&-recid=2

4 Web XML 27 <data> : <data>/images/logo.jpg</data> FileMaker Pro Web Web 15Web <data> URL XML URL UTF-8 (Unicode Transformation 8 Bit) 36UTF-8 infofiancée URL http://server.company.com/fmi/xml/fmresultset.xml?-db=members&-lay=relationships&-recid=2&info= fianc%c3%a9e&-edit URL %C3%A9 é UTF-8 URL URL http://www.w3.org Web XML Web XML FileMaker 1 FileMaker 1 FileMaker URL Web XML XML 1 fmresultset: Web XML () FileMaker Web FMPXMLRESULT 29fmsresultset 1 FMPXMLRESULT FMPXMLLAYOUT: XML FMPXMLRESULT FMPXMLLAYOUT Web XML Web 1 FMPXMLRESULT FMPXMLLAYOUT 32 FileMaker XML

4 Web XML 28 URL Web 1 XML XML XML FileMaker XML Web 1 FileMaker XML Web XML UTF-8 (Unicode Transformation Format 8) 36UTF-8 FileMaker XML XML XML 2 <DATABASE> (FileMaker XML Oracle XML 1 ) XML <DATABASE> Web fmresultset FMPXMLRESULT FMPXMLLAYOUT xmlns="http://www.filemaker.com/xml/fmresultset" xmlns="http://www.filemaker.com/fmpxmlresult" xmlns="http://www.filemaker.com/fmpxmllayout" FileMaker Web XML (0) fmresultset FMPXMLRESULT FMPXMLLAYOUT <error code="0"></error> <ERRORCODE>0</ERRORCODE> <ERRORCODE>0</ERRORCODE> XML A Web FileMaker FileMaker DTD () HTTP fmresultset FMPXMLRESULT FMPXMLLAYOUT HTTP http://<>[:<]/fmi/xml/fmresultset.dtd http://<>[:<]/fmi/xml/fmpxmlresult.dtd http://<>[:<]/fmi/xml/fmpxmllayout.dtd

4 Web XML 29 fmsresultset XML FileMaker fmresultset Web XML URL fmresultset fmresultset.xml : http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=family&-findall fmresultset Web fmresultset XML XML Web <?xml...?> 2 <!DOCTYPE> fmresultset <!DOCTYPE> fmresultset DTD URL fmresultset fmresultset <datasource> <metadata> <resultset> <datasource> fmresultset <datasource> tablelayoutdate-formattime-formattimestamp-formattotalcount database 1 XML <datasource> date-format MM/dd/yyyy 1 MM - 2 (01 12 01 1 12 12 ) 1 dd - 2 (00 31 ) 1 yyyy - 4 1 XML <datasource> time-format HH:mm:ss 1 HH - 2 (24 00 23 ) 1 mm - 2 (00 59 ) 1 ss - 2 (00 59 ) 1 <datasource> timestamp-format date-format time-format 1 MM/dd/yyyy HH:mm:ss

4 Web XML 30 <metadata> fmresultset <metadata> 1 <field-definition> <relatedset-definition> 1 <field-definition> 1 auto-enter (yesno) 1 four-digit-year (yesno) 1 global (yesno) 1 (max-repeat ) 1 (max-characters ) 1 not-empty (yesno) 1 numeric-only (yesno) 1 (textnumberdatetimetimestampcontainer) 1 time-of-day (yesno) 1 (normalcalculationsummary) 1 () <relatedset-definition> <relatedset-definition> <field-definition> <relatedset-definition> <resultset> <resultset> <record> <record> 1 ( mod-id record-id ) 1 <data> <relatedset> <record> <relatedset> count table

4 Web XML 31 fmresultset XML <fmresultset xmlns="http://www.filemaker.com/xml/fmresultset" version="1.0"> <error code="0"/> <product build="02/10/2016" name="filemaker Web Publishing Engine" version="15.0.1.00"/> <datasource database="art" date-format="mm/dd/yyyy" layout="web3" table="art" time-format="hh:mm:ss" timestampformat="mm/dd/yyyy HH:mm:ss" total-count="12"/> <metadata> <field-definition auto-enter="no" four-digit-year="no" global="no" max-repeat="1" name="title" not-empty="no" numeric-only="no" result="text" time-of-day="no" type="normal"/> <field-definition auto-enter="no" four-digit-year="no" global="no" max-repeat="1" name="artist" not-empty="no" numeric-only="no" result="text" time-of-day="no" type="normal"/> <field-definition auto-enter="no" four-digit-year="no" global="no" max-repeat="1" name="style" not-empty="no" numeric-only="no" result="text" time-of-day="no" type="normal"/> <field-definition auto-enter="no" four-digit-year="no" global="no" max-repeat="1" name="length" not-empty="no" numeric-only="no" result="number" time-of-day="no" type="calculation"/> <relatedset-definition table="artlocations"> <field-definition auto-enter="no" four-digit-year="no" global="no" max-repeat="1" name="artlocations::location" notempty="no" numeric-only="no" result="text" time-of-day="no" type="normal"/> <field-definition auto-enter="no" four-digit-year="no" global="no" max-repeat="1" name="artlocations::date" notempty="no" numeric-only="no" result="date" time-of-day="no" type="normal"/> </relatedset-definition> </metadata> <resultset count="1" fetch-size="1"> <record mod-id="6" record-id="17"> <field name="title"> <data>spring in Giverny 6</data> </field> <field name="artist"> <data>claude Monet</data> </field> <field name="style"> <data/> </field> <field name="length"> <data>19</data> </field> <relatedset count="0" table="artlocations"/> </record> </resultset> </fmresultset>

4 Web XML 32 FileMaker XML FileMaker XML FMPXMLRESULT fmresultset FMPXMLLAYOUT FMPXMLRESULT FMPXMLLAYOUT FMPXMLRESULT Web XML URL FMPXMLRESULT.xml : http://192.168.123.101/fmi/xml/fmpxmlresult.xml?-db=employees&-lay=family&-findall FMPXMLLAYOUT Web XML URL -view FMPXMLLAYOUT.xml : http://192.168.123.101/fmi/xml/fmpxmllayout.xml?-db=employees&-lay=family&-view FMPXMLRESULT FMPXMLLAYOUT XML Web <?xml...?> 2 <!DOCTYPE> <!DOCTYPE> DTD URL FMPXMLRESULT FMPXMLRESULT <DATABASE> NAMERECORDSDATEFORMAT TIMEFORMAT XML <DATABASE> DATEFORMAT XML <DATABASE> TIMEFORMAT FMPXMLRESULT fmresultset 29fmresultset FMPXMLRESULT <METADATA> 1 <FIELD> / 1 (Yes)/ (No) (EMPTYOK ) (MAXREPEAT ) TEXTNUMBERDATETIME TIMESTAMP CONTAINER <RESULTSET> <ROW> <ROW> 1 / RECORDID MODID (51-modid ( ID) ) <COL> <COL> 1 / <DATA> 1

4 Web XML 33 FMPXMLRESULT XML FMPXMLRESULT XML <FMPXMLRESULT xmlns="http://www.filemaker.com/fmpxmlresult"> <ERRORCODE>0</ERRORCODE> <PRODUCT BUILD="02/10/2016" NAME="FileMaker Web Publishing Engine" VERSION="15.0.1.00"/> <DATABASE DATEFORMAT="MM/dd/yyyy" LAYOUT="web" NAME="art" RECORDS="12" TIMEFORMAT="HH:mm:ss"/> <METADATA> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Title" TYPE="TEXT"/> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Artist" TYPE="TEXT"/> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Image" TYPE="CONTAINER"/> </METADATA> <RESULTSET FOUND="1"> <ROW MODID="6" RECORDID="18"> <COL> <DATA>Spring in Giverny 7</DATA> </COL> <COL> <DATA>Claude Monet</DATA> </COL> <COL> <DATA> /fmi/xml/cnt/untitled.pct?-db=art&-lay=web&-recid=18&-field=image(1) </DATA> </COL> </ROW> </RESULTSET> </FMPXMLRESULT> <COL> <METADATA> <FIELD> <METADATA> TitleArtistSpring in Giverny 7Claude Monet <RESULTSET> <ROW> FMPXMLLAYOUT FMPXMLLAYOUT <FIELD> <LAYOUT> <FIELD> VALUELIST <VALUELISTS> <VALUELIST> 1 ( <VALUE> ) FileMaker [] <VALUE> 2 DISPLAY ID ("100") 2 ("Impressionism" ) [] DISPLAY

4 Web XML 34 1 [2 ] DISPLAY XML DISPLAY ID <VALUELISTS> <VALUELIST NAME="style"> <VALUE DISPLAY="100">100</VALUE> <VALUE DISPLAY="101">101</VALUE> <VALUE DISPLAY="102">102</VALUE> </VALUELIST> </VALUELISTS> 1 [2 ] [2 ] DISPLAY 2 XML DISPLAY <VALUELISTS> <VALUELIST NAME="style"> <VALUE DISPLAY="Impressionism">100</VALUE> <VALUE DISPLAY="Cubism">101</VALUE> <VALUE DISPLAY="Abstract">102</VALUE> </VALUELIST> </VALUELISTS> 1 [2 ] [2 ] DISPLAY XML DISPLAY ID <VALUELISTS> <VALUELIST NAME="style"> <VALUE DISPLAY="100 Impressionism">100</VALUE> <VALUE DISPLAY="101 Cubism">101</VALUE> <VALUE DISPLAY="102 Abstract">102</VALUE> </VALUELIST> </VALUELISTS> fm fm MM/DD/YYYY hh:mm:ss MM/DD/YYYY hh:mm:ss birthdaysbirthdate birthdate fm 2 1

4 Web XML 35 FMPXMLLAYOUT XML <FMPXMLLAYOUT xmlns="http://www.filemaker.com/fmpxmllayout"> <ERRORCODE>0</ERRORCODE> <PRODUCT BUILD="02/10/2016" NAME="FileMaker Web Publishing Engine" VERSION="15.0.1.00"/> <LAYOUT DATABASE="art" NAME="web2"> <FIELD NAME="Title"> <STYLE TYPE="EDITTEXT" VALUELIST=""/> </FIELD> <FIELD NAME="Artist"> <STYLE TYPE="EDITTEXT" VALUELIST=""/> </FIELD> <FIELD NAME="Image"> <STYLE TYPE="EDITTEXT" VALUELIST=""/> </FIELD> <FIELD NAME="artlocations::Location"> <STYLE TYPE="EDITTEXT" VALUELIST=""/> </FIELD> <FIELD NAME="artlocations::Date"> <STYLE TYPE="EDITTEXT" VALUELIST=""/> </FIELD> <FIELD NAME="Style"> <STYLE TYPE="POPUPMENU" VALUELIST="style"/> </FIELD> </LAYOUT> <VALUELISTS> <VALUELIST NAME="style"> <VALUE DISPLAY="Impressionist">Impressionist</VALUE> <VALUE DISPLAY="Modern">Modern</VALUE> <VALUE DISPLAY="Abstract">Abstract</VALUE> </VALUELIST> </VALUELISTS> </FMPXMLLAYOUT>

4 Web XML 36 UTF-8 Web XML UTF-8 (Unicode Transformation 8 Bit) ASCII Unicode 16 8 XML Unicode UTF-8 UTF-8 ASCII 0 127 Unicode UTF-8 Web UTF-8 1 ASCII 1 UTF-8 ASCII UTF-8 1 ASCII () 1 UTF-8 1 1 1 2 1 UTF-8 Unicode 1 UTF-8 ASCII Unicode UTF-8 Unicode 50% FileMaker XML FileMaker XML FileMaker URL -findall products FileMaker http://192.168.123.101/fmi/xml/fmresultset.xml?-db=products-lay=sales&-findall -new 1 -dbnames -db URL FileMaker 40XML -dbnames -delete -dup -edit -find -findall -findany -findquery Web

4 Web XML 37 -layoutnames -new -scriptnames -view Web Web FMPXMLLAYOUT fmresultset FMPXMLRESULT XML <metadata> -db () -delete.related -field fieldname fieldname.op () -lay () -lay.response (XML ) -lop () -max () -modid ( ID) -query -recid ( ID) -relatedsets.filter -relatedsets.max -script () -script.param (-script ) -script.prefind (-find-findanyfindall ) -script.prefind.param (-script.prefind ) -script.presort () -script.presort.param (-script.presort ) -skip () -sortfield.[1-9] () -sortorder.[1-9] () -dbnames -edit URL 26 XML FileMaker URL -edit 1 -find 48fieldname () -find -dbnames-layoutnames -scriptnames -dbnames-layoutnames -scriptnames -find -find-findall -findquery -edit -findquery -edit-delete -dup -find -find-findall-findany-edit-new-dup -findquery -find-edit-new-dup -findquery -find-findall-findany-new-edit-delete-dup-view -findquery -script -findquery -find-findany-findall -findquery -script.prefind -findquery -find-findall -findquery -script.presort -findquery -find -findall -findquery -find-findall -findquery -find -findall

4 Web XML 38 XML -lay XML XML XML XML -lay.response BudgetSalary 100,000 ExecListSalary http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees &-lay=budget&salary=100000&salary.op=gt&-find&-lay.response=execlist XML XML XML FileMaker Server Web XML 1. -lay 2. (URL.global=) 3. -script.prefind () 4. -find -new 5. -script.presort () 6. () 7. -script () 8. -lay.response () 9. XML -sortfield 102

4 Web XML 39 XML Web XML 1 XML Web 13 Web 1 FileMaker Server FileMaker Server FileMaker Server 1 1 FileMaker Server Web 1 FileMaker Server Web 1 Web XML FileMaker Server

5 XML Web FileMaker XML - -dbnames (44) -delete (44) -dup (45) -edit (45) -find-findall-findany (45) -findquery (46) -layoutnames (46) -new (46) -scriptnames (47) -view (47) -db (47) -field (48) fieldname (48) fieldname.op (49) -lay (50) -lay.response (50) -lop (50) -max (50) -modid (51) -query (51) -recid (52) -relatedsets.filter (52) -relatedsets.max (53) -script (53) -script.param (54) -script.prefind (54) -script.prefind.param (54) -script.presort (55) -script.presort.param (55) -skip (55) -sortfield.[1-9] (55) -sortorder.[1-9] (56) -dbnames-layoutnames -scriptnames -lay 1 1 2 -new -new -edit 1 -dbnames -db 36FileMaker XML 1 -db=employees -findall =

5 XML 41 1 Web (: -lop=and, -lop=or, -sortorder=ascend, -sortorder=descend, -max=all) 1 MyLayout -lay=mylayout 1 1 myfield.9 1 op(2 op) myfield.op 1 global(global) myfield.global (text.field) HTTP XML ID 1 -find Field1=Blue Field1=blue -new -edit LastName=Doe Web XML 1. : -database 2. 2 : -find&-edit 3. : -lop=amd 4. (-db ) 5. (-lay ) 6. 7. -lop -delete -lop A Web

5 XML 42 :: ().record-id 1 1 () 1 (2) 2 -new -edit -find 1 record-id ID record-id -new -edit -find -new 1 1 ID 0 1 1 1 () URL Employees John Doe Jane Dependents NamesID ID http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees &-lay=family&firstname=john&lastname=doe&id=9756&dependents::names.0=jane&-new 1 1

5 XML 43 1 -edit ID ID ID XML <relatedset> <record> record-id 29fmsresultset URL ID 1001 DependentsNamesNames.22 ID http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=family &-recid=1001&dependents::names.2=kevin&-edit 1 http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=family &-recid=1001&dependents::names.2=kevin&dependents::names.5=susan&-edit -edit ID 0 : http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=family &-recid=1001&dependents::names.0=timothy&-edit -delete -edit -delete.related URL employees1001 http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=family &-recid=1001&-delete URL Dependents1001 ID 3 http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=family &-recid=1001&-delete.related=dependents.3&-edit 47-delete.related () -relatedsets.filter -relatedsets.max 52-relatedsets.filter ( ) 53-relatedsets.max ()

5 XML 44 :: ().global global ( ) 42 FileMaker Pro.global Web XML.global Web : http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=departments &Country.global=USA&-recid=1&-edit XML -dbnames () FileMaker Server Web with XML : () : : http://192.168.123.101/fmi/xml/fmresultset.xml?-dbnames -delete () -recid : -db-lay-recid : -script : : http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=departments&-recid=4&-delete

5 XML 45 -dup () -recid : -db-lay-recid : -script : : http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=departments&-recid=14&-dup -edit () /-recid -recid : -db-lay-recid1 : -modid, -script -edit 43 : : http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=departments&-recid=13&country=usa&-edit -find-findall -findany () : -db-lay : -recid-lop-op-max-skip-sortorder-sortfield-script-script.prefind -script.presort : : http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=family&country=usa&-find 1 FileMaker Server ID : http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=family&-recid=427&-find -findall : http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=family&-findall -findall -max 1 -findany : http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=family&-findany

5 XML 46 -findquery () : -db-lay-query : -max-skip-sortorder-sortfield-script-script.prefind-script.presort : Fluffy http://host/fmi/xml/fmresultset.xml?-db=vetclinic&-lay=animals &-query=(q1);(q2);!(q3)&-q1=typeofanimal&-q1.value=cat&-q2=typeofanimal &-q2.value=dog&-q3=name&-q3.value=fluffy&-findquery -findquery -findquery 4 1 -query 1 1 1 q: -q1 1 :-q1.value=fieldvalue 1 fieldvalue begins with: -q1.value=fieldvalue* 1 -findquery -query 51-query () -layoutnames () FileMaker Server Web with XML : -db : : http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-layoutnames -new () / : -db-lay : 1 -script 42 : : http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=departments&country=australia&-new

5 XML 47 -scriptnames () FileMaker Server Web with XML : -db : : http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-scriptnames -view () FMPXMLLAYOUT FMPXMLLAYOUT (fmresultset FMPXMLRESULT) XML metadata : -db-lay : -script : : http://192.168.123.101/fmi/xml/fmpxmllayout.xml?-db=employees&-lay=departments&-view : http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=departments&-view XML -db () : () -db -db : -dbnames : http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=departments&-findall -delete.related () : -edit : ID

5 XML 48 : jobtable7 ID 20 http://host/fmi/xml/fmresultset.xml?-db=career&-lay=applications&-recid=7&-delete.related=jobtable.20&-edit -field () : 25XML URL fieldname () -find / (-) : FileMaker 1 myfield.9 1 op(2 op) myfield.op 1 global(global) myfield.global HTTP XML 42 ID : -new -edit -find fmfm MM/DD/YYYY hh:mm:ss MM/DD/YYYY hh:mm:ss : -edit : -new -find : http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees &-lay=departments&-op=eq&firstname=sam&-max=1&-find 1 FileMaker Server

5 XML 49 fieldname.op () -find : eq cn bw ew gt gte lt lte neq FileMaker Pro = ** * * > >= < <= : -find : ::=&::.op= 1 1 cn 1 : http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=departments&name=tim&name.op=cn&-find bw (//) fieldname.op FileMaker Pro (...)... : http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=departments&idnum=915...925&-find FileMaker Pro

5 XML 50 -lay () : : -dbnames-layoutnames -scriptnames : http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=departments&-view -lay.response () -lay XML -lay.response -lay.response -lay XML -lay.response : : -dbnames-layoutnames -scriptnames : http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees &-lay=budget&salary=100000&salary.op=gt&-find&-lay.response=execlist -lop () -find andor : and or -lop -find and : -find -findquery : http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees &-lay=departments&last+name=smith&birthdate=2/5/1972&-lop=and&-find -max () : all -max : -find-findall -findquery -max 53-relatedsets.max ()

5 XML 51 : http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=departments&-max=10&-findall http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=departments&-max=all&-findall -modid ( ID) ID -edit ID ID ID -edit : ID ID FileMaker ID : -edit : -recid : http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees &-lay=departments&-recid=22&-modid=6&last_name=jones&-edit -query () 46-findquery () : : -findquery -query=<><>&-findquery <> 2 1 1 q: q1 1 AND (q1, q2) q1 q2 q and 1 FileMaker Pro (!) : (q1);!(q2) q1 q2 1 OR (q1);(q2) q1 or q2 OR 1

5 XML 52 <> (-) : : : -< ID>=<>&-< ID>.value=<> -q1=typeofanimal&-q1.value=cat -q2=name&-q2.value=fluffy FluffyGray http://host/fmi/xml/fmresultset.xml?-db=petclinic&-lay=patients &-query=(q1, q2);!(q3)&-q1=typeofanimal&-q1.value=cat&-q2=color &-q2.value=gray&-q3=name&-q3.value=fluffy&-findquery -recid ( ID) -edit -delete view FMPXMLLAYOUT : ID FileMaker : -edit-delete -dup : -find -view 1: http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=departments&-recid=22&-delete 2: http://localhost/fmi/xml/fmpxmllayout.xml?-db=test&-lay=empty&-view&-recid=9 -relatedsets.filter () : layout none 1 -relatedsets.filter layout FileMaker Pro [] [] 1 [] [] -relatedsets.max -relatedsets.max () 1 [] -relatedsets.max [] [] 1 none-relatedsets.filter none Web [] [] []

5 XML 53 1 -relatedsets.filter XML -relatedsets.filter layoutnonefilemaker Pro 1 [] [] XML [] : -find-edit-new-dup -findquery : http://localhost/fmi/xml/fmresultset.xml?-db=fmphp_sample&-lay=english&-relatedsets.filter=none&-findany http://localhost/fmi/xml/fmresultset.xml?-db=fmphp_sample&-lay=english&relatedsets.filter=layout& -relatedsets.max=all&-findany http://localhost/fmi/xml/fmresultset.xml?-db=fmphp_sample&-lay=english&-relatedsets.filter=layout& -relatedsets.max=10&-findany -relatedsets.max () : all 1 -relatedsets.max [] FileMaker Pro [] -relatedsets.filter layout 1 -relatedsets.max Web 1 -relatedsets.max allweb -relatedsets.filter () : -find-edit-new-dup -findquery : http://localhost/fmi/xml/fmresultset.xml?-db=fmphp_sample&-lay=english&relatedsets.filter=layout& -relatedsets.max=all&-findany http://localhost/fmi/xml/fmresultset.xml?-db=fmphp_sample&-lay=english&-relatedsets.filter=layout& -relatedsets.max=10&-findany -script () FileMaker 39XML : : -dbnames-layoutnames -scriptnames : http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=departments&-script=myscript&-findall

5 XML 54 -script.param () -script FileMaker : 1 1 param1 param2 param3 param1%7cparam2%7cparam3 URL 1 GetAsNumber (Get ( )) 1 -script -script.param -script.param 1 -script.param Web : -script : http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees &-lay=departments&-script=myscript&-script.param=smith%7cchatterjee%7csu&-findall -script.prefind () -find () FileMaker : : -dbnames-layoutnames -scriptnames : http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=departments&-script.prefind=myscript&-findall -script.prefind.param () -script.prefind FileMaker : 1 1 param1 param2 param3 param1%7cparam2%7cparam3 URL 1 GetAsNumber (Get ( )) 1 -script.prefind -script.prefind.param -script.prefind.param 1 -script.prefind.param Web : -script.prefind : http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees &-lay=departments&-script.prefind=myscript&-script.prefind.param=payroll&-findall

5 XML 55 -script.presort () -find () FileMaker : -dbnames-layoutnames -scriptnames : http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees &-lay=departments&-script.presort=myscript&-sortfield.1=dept&-sortfield.2=rating&-findall -script.presort.param () -script.presort FileMaker : 1 1 param1 param2 param3 param1%7cparam2%7cparam3 URL 1 GetAsNumber (Get ( )) 1 -script.presort -script.presort.param -script.presort.param 1 -script.presort.param Web : -script.presort : http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees &-lay=departments&-script.presort=myscript&-script.presort.param=18%7c65 &-sortfield.1=dept&-sortfield.2=rating&-findall -skip () : 0 : -find 10 11 15 : http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=departments&-skip=10&-max=5&-findall -sortfield () : : -find -findall

5 XML 56 -sortfield -sortfield. = -sortfield. precedence-number : 1 1 1 1 9 deptrating-sortorder : http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees &-lay=performance&-sortfield.1=dept&-sortfield.2=rating&-findall -sortorder () : <> Custom ascend descend <> FileMaker Pro a z-10 10 z a10-10 : -find -findall : -sortfield -sortorder -sortfield -sortorder. = 1 -sortorder.-sortorder -sortfield 1 9 1 ascend 1 (dept) ascend 2 (rating) descend -sortorder.2 2 -sortorder.2=descend -sortfield.2=rating : http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees &-lay=performance&-sortfield.1=dept&-sortorder.1=ascend&-sortfield.2=rating &-sortorder.2=descend&-findall -sortorder

6 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 PHP ( PHP 59FileMaker API for PHP ) 1 FileMaker Server FileMaker Server FileMaker Pro Web 1 FileMaker PHP 1 PHP FileMaker Pro Web 14 1 PHP FileMaker Web 18FileMaker Web 1 PHP Web PHP Web Web Web Web Web Web with PHP 1 3 FileMaker Server : 1 Microsoft IIS (Windows) Apache (OS X) Web FileMaker Web Web 1 FileMaker Web 1 FileMaker

6 Web with PHP 58 1 FileMaker Server 1 FileMaker Pro 1 Web IP 1 Web Web Web 1 Web PHPFileMaker Server PHP 1 PHP FileMaker Server 1 PHP http://php.net 1 Web PHP curl ( URL ) curl http://php.net/curl FileMaker Server PHP OS X Server Admin ()OS X Server Admin PHP FileMaker Server PHP PHP 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

6 Web with PHP 59 FileMaker API for PHP FileMaker Server FileMaker PHP 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/ PHP FileMaker Server PHP FileMaker API for PHP PHP FileMaker Server FileMaker API for PHP.zip 1 IIS (Windows): []:Program FilesFileMakerFileMaker ServerWeb PublishingFM_API_for_PHP_Standalone.zip [] FileMaker Server Web 1 Apache (OS 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 IIS (Windows): []:Program FilesFileMakerFileMaker ServerHTTPServerConf [] FileMaker Server Web 1 HTTP Apache (OS X): //FileMaker Server/HTTPServer/htdocs 1 HTTPS Apache (OS X): //FileMaker Server/HTTPServer/htdocs/httpsRoot 1 PHP include_path 1 OS X /usr/lib/php

6 Web with PHP 60 1 Web FileMaker Server Admin Console FileMaker Server FileMaker Server 1 FileMaker FileMaker Pro Web 13 Web 1 FileMaker API for PHP FileMaker 8 FileMaker API for PHP

7 Web with PHP FileMaker API for PHP FileMaker PHP PHP FileMaker Server Web FileMaker API for PHP 8 FileMaker API for PHP Web PHP FileMaker Server Web Web 3 (1 2 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 1. Admin Console PHP FileMaker Server 2. Admin Console [] FileMaker Web with PHP fmphp FileMaker Pro Web 2 Web PHP FileMaker FileMaker 3. PHP FileMaker API PHP FileMaker PHP 8 FileMaker API for PHP

7 Web with PHP 62 4. Web 1 HTTP HTTPS IIS (Windows): []: Program FilesFileMakerFileMaker ServerHTTPServerConf [] FileMaker Server Web 1 HTTP Apache (OS X): //FileMaker Server/HTTPServer/htdocs 1 HTTPS Apache (OS X): //FileMaker Server/HTTPServer/htdocs/httpsRoot 5. FileMaker Pro Web Web 15Web 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 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 9

8 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 59 FileMaker API for PHP FileMaker API for PHP FileMaker API for PHP FileMaker Server Web 1 IIS (Windows): []:Program FilesFileMakerFileMaker ServerDocumentationPHP API Documentationindex.html [] FileMaker Server Web 1 Apache (OS X): //FileMaker Server/Documentation/PHP API Documentation/index.html FileMaker API for PHP FileMaker API for PHP FileMaker Web http://www.filemaker.com/jp/support/technologies/php.html

8 FileMaker API for PHP 64 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 1 Delete 1 Duplicate 1 Edit 1 Find Find All Find Any 1 Find Request (Compound Find ) 1 Perform Script FileMaker.php TRUE FileMaker_Error FileMaker_Result FileMaker API for PHP

8 FileMaker API for PHP 65 PHP 1 65 1 67FileMaker 1 73 FileMaker API PHP Web URL FileMaker API for PHP URL PHP urldecode() : $user = urldecode($_get['user']); $event = urldecode($_get['event']); 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 FileMaker FileMaker Pro 1 AddDeleteDuplicate Edit (FindFind AllFind Any Compound Find)

8 FileMaker API for PHP 66 2 1 createrecord() () createrecord() commit() : $rec = $fm->createrecord('form View', $values); $result = $rec->commit(); FileMaker_Record commit() $result TRUE FileMaker $result FileMaker_Error commit() 1 Add newaddcommand() FileMaker_Command_Add execute() : $newadd =& $fm->newaddcommand('respondent', $respondent_data); $result = $newadd->execute(); FileMaker_Command execute() $result FileMaker_Result $result FileMaker_Error execute() Duplicate newduplicatecommand() ID FileMaker_Command_Duplicate execute() $newduplicate = $fm->newduplicatecommand('respondent', $rec_id); $result = $newduplicate->execute(); 2 1 Edit neweditcommand() IDFileMaker_Command_Edit execute() : $newedit =& $fm->neweditcommand('respondent', $rec_id, $respondent_data); $result = $newedit->execute();

8 FileMaker API for PHP 67 1 commit() : $rec = $fm->getrecordbyid('form View', $rec_id); $rec->setfield('name', $nameentered); $result = $rec->commit(); 2 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 ) 18 FileMaker Web listscripts() listscripts() (65FileMaker ) $scripts = $fm->listscripts();

8 FileMaker API for PHP 68 FileMaker newperformscriptcommand() FileMaker_Command_PerformScript execute() FileMaker FileMaker_Result FileMaker FileMaker FileMaker_Result PHP FileMaker FileMaker $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() 74Find $findcommand =& $fm->newfindcommand('students'); $findcommand->setpresortscript('removeexpelled'); setscript() 74 Find $findcommand =& $fm->newfindcommand('students'); $findcommand->setscript('myscript','param1 param2 param3');

8 FileMaker API for PHP 69 setprecommandscript()setpresortscript() setscript() setresultlayout() addsortrule() FileMaker Server Web 1. setprecommandscript() () 2. 3. setpresortscript() () 4. addsortrule() 5. setresultlayout() () 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()

8 FileMaker API for PHP 70 1 FileMaker FileMaker Pro listrelatedsets() $tablenames = $currentlayout->listrelatedsets(); FileMaker_Result getrelatedsets() $relatedsetsnames = $result->getrelatedsets(); getrelatedsets() FileMaker_RelatedSet FileMaker_RelatedSet $relatedsetsarray = $currentlayout->getrelatedsets(); getrelatedset() FileMaker_RelatedSet $relatedset = $currentlayout->getrelatedset('customers');

8 FileMaker API for PHP 71 getname() $tablename = $relatedset->getname(); getrelatedset() $relatedrecordsarray = $currentrecord->getrelatedset('customers'); 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(); }

8 FileMaker API for PHP 72 FileMaker FileMaker Pro listvaluelists() $valuelistnames = $currentlayout->listvaluelists(); getvalueliststwofields() $valuelistsarray = $currentlayout->getvalueliststwofields(); getvaluelists() FileMaker API for PHP getvalueliststwofields() getvaluelisttwofields() 2 FileMaker [] getvaluelisttwofields() 2 1 [2 ] getvaluelisttwofields() 1 [2 ] [2 ] getvaluelisttwofields() 2 1 [2 ] [2 ] getvaluelisttwofields() 2 getvaluelisttwofields()

8 FileMaker API for PHP 73 $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 FileMaker 4 1 Find All 73Find All 1 Find Any 74Find Any 1 Find 74Find 1 Compound Find 74Compound Find FileMaker 4 1 addsortrule() clearsortrules() 1 setlogicaloperator() 1 setrange() getrange() setrange() 100 100 20 5 1 FileMaker 1 setprecommandscript() 1 setpresortscript() 1 setscript() Find All Find All newfindallcommand() FileMaker_Command_FindAll execute()

8 FileMaker API for PHP 74 $findcommand =& $fm->newfindallcommand('form View'); $result = $findcommand->execute; Find All 1 Find Any Find Any 1 newfindanycommand() FileMaker_Command_FindAny execute() $findcommand =& $fm->newfindanycommand('form View'); $result = $findcommand->execute; 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 1 Compound Find 1 newcompoundfindcommand() FileMaker_Command_CompoundFind 1 newfindrequest() 1 FileMaker_Command_FindRequest 1 add() Compound Find 1 execute() Compound Find

8 FileMaker API for PHP 75 - 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'); // Specify search criterion for third find request $findreq3->addfindcriterion('cover Photo Credit', 'The London Morning News'); // 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>";

8 FileMaker API for PHP 76 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')).'">';

8 FileMaker API for PHP 77 setrelatedsetsfilters() setrelatedsetsfilters() 2 1 : layout none 1 none Web 1 layout FileMaker Pro [] [] 1 : all 1 [] [] all Web 1 [] [] [] [] [] PHP [] FileMaker Web PHP Web FileMaker PHP 1 1 1 1 1 4 M/D/YYYY 4 M 1 12 D 1 31 YYYY 0001 4000 1/30/3030 4 4/31/2016 4 31 4 (/) (\) (-) 1\30-2016

8 FileMaker API for PHP 78 1 1 12 1 h 1 h:m 1 h:m:s 1 h:m:s AM/PM 1 h:m AM/PM h 1 12 m s 1 60 PHP 1 04 ( ) 4 1/30 1 (H) 24 1 24 1 FileMaker FileMaker Pro 1 1 1 / 1 1 validate() PHP 1 validate() TRUE validate() FileMaker_Error _Validation

8 FileMaker API for PHP 79 validate() PHP 1 validate() TRUE validate() FileMaker_Error _Validation validate() validate() TRUE validate() FileMaker_Error _Validation FileMaker_Error_Validation 3 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()

8 FileMaker API for PHP 80 //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

8 FileMaker API for PHP 81 FileMaker PHP FileMaker_Error FileMaker_Error FileMaker_Error 1 iserror() FileMaker Error 1 numerrors() 1 geterrors() 1 1 getmessage() $result = $findcommand->execute(); if (FileMaker::isError($result)) { echo "<p>error: ".$result->getmessage(). "</p>"; exit; } FileMaker Error A Web

9 Web Web 1. 2 Web 2. Web FileMaker Server Admin Console FileMaker Server 3. Web Web 4. FileMaker Server Web Web 1 HTTP HTTPS IIS (Windows): []: Program Files FileMaker FileMaker Server HTTPServer Conf [] FileMaker Server Web 1 HTTP Apache (OS X): //FileMaker Server/HTTPServer/htdocs 1 HTTPS Apache (OS 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 16 RC_Data_FMS 6. Web Web Web with XML Web XML

9 83 Web Web 1 1 1 Web 18FileMaker Web 1 Web 1 FileMaker API for PHP FileMaker API for PHP Web Web 1 Web Web URL http://127.0.0.1/ 1 PHP http://127.0.0.1/<> <> 1 XML URL 25XML URL XML XML XSLT 2 1 XML Web XML <?xml version="1.0" encoding="utf-8"?> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/xsl/transform" xmlns:fmrs="http://www.filemaker.com/xml/fmresultset"> <xsl:output method="xml"/> <xsl:template match="/"> <xsl:copy-of select="."/> </xsl:template> </xsl:stylesheet>

9 84 1 HTML <textarea> XML <?xml version="1.0" encoding="utf-8"?> <xsl:stylesheet version="1.0" <html> </html> xmlns:xsl="http://www.w3.org/1999/xsl/transform" xmlns:fmrs="http://www.filemaker.com/xml/fmresultset"> <xsl:output method="html"/> <body> <xsl:template match="/fmrs:fmresultset"> <textarea rows="20" cols="100"> <xsl:copy-of select="."/> </textarea><br/> </xsl:template> </body> </xsl:stylesheet> Web Web 1 Web 1 Web 1 Web 1 Tomcat Web IIS (Windows): Microsoft IIS Web Windows W3C Extended Log File Format Web HTTP W3C Common Logfile Format Microsoft IIS Web Apache (OS 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 http://www.w3.org

9 85 Web Web Web wpe.log Web XML Web Web Web wpe.log FileMaker Server Web 1 Windows: []: Program Files FileMaker FileMaker Server Logs wpe.log [] 1 OS X: //FileMaker Server/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

9 86 1 [FM_ERROR_CODE] FileMaker (88FileMaker ) HTTP: HTTP 1 [RETURN_BYTES] 1 [MESSAGE] Web wpe.log 1 Web 2016/06/02 15:15:31-0700 - - - - INFO - - FileMaker Server Web Publishing Engine started. 2016/06/02 15:46:52-0700 - - - - INFO - - FileMaker Server Web Publishing Engine stopped. 1 XML 2016/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" 2016/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 2016-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 2016/06/09 10:59:49-0700 WPC_SERVER 192.168.100.101:0 jdoe - INFO - - XML Web Publishing Engine is enabled. 1 2016/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

9 87 Tomcat Web FileMaker Server Tomcat Tomcat FileMaker Server Web 1 Windows: 1 []: Program Files FileMaker FileMaker Server Admin admin-master-tomcat logs [] 1 []: Program Files FileMaker FileMaker Server Web Publishing publishing-engine jwpc-tomcat logs [] 1 OS X: 1 //FileMaker Server/Admin/admin-master-tomcat/logs/ 1 //FileMaker Server/Web Publishing/publishing-engine/jwpc-tomcat/logs

A Web Web XML FileMaker XML Web XML XML fmresultset <error code> FMPXMLRESULT FMPXMLLAYOUT <ERRORCODE> fmresultset <?xml version="1.0" encoding="utf-8" standalone="no"?> <!DOCTYPE fmresultset PUBLIC "-//FMI//DTD fmresultset//en" "http://192.168.123.101/fmi/xml/fmresultset.dtd"> <fmresultset xmlns="http://www.filemaker.com/xml/fmresultset" version="1.0"> <error code="0"></error> FMPXMLRESULT <?xml version="1.0" encoding="utf-8" standalone="no"?> <!DOCTYPE FMPXMLRESULT PUBLIC "-//FMI//DTD FMPXMLRESULT//EN" "http://192.168.123.101/fmi/xml/fmpxmlresult.dtd"> <fmpxmlresult xmlns="http://www.filemaker.com/fmpxmlresult"> <ERRORCODE>0</ERRORCODE> <error code> <ERRORCODE> Web Web FileMaker FileMaker Pro FileMaker Pro FileMaker Server 959 FileMaker Server Admin Console [Web ] > [XML] Web with XML XML 959 FMPXMLLAYOUT 959 <FMPXMLLAYOUT> <ERRORCODE>959</ERRORCODE> <LAYOUT DATABASE="" NAME=""/> <VALUELISTS/> </FMPXMLLAYOUT>

A Add 66 add() 74 addsortrule() 73 Admin Console 14, 25, 60 auto-enter 30 C clearsortrules() 73 commit() 66 Compound Find 74 75 createrecord() 66 curl 58 CWPE ( Web ) 24 D <datasource> 29 -db 47 -dbnames 44 -delete 44 Delete 67 -delete.related 43 delete() 67, 71 -dup 45 Duplicate 66 E -edit 45 Edit 66 <error code> <ERRORCODE> 88 Extensible Markup Language (XML)XML F -field () 48 <field-definition> 30 -fieldname.op 49 FileMaker API for PHP 11 59 63 FileMaker API for PHP 59 FileMaker API for PHP 59 FileMaker ProWeb 23 FileMaker Server Admin Console 14, 25 FileMaker Server 8 FileMaker WebDirect 9 FileMaker 64 FileMaker 70 65 64 65 FileMaker Add 66 Compound Find 74 Delete 67 Duplicate 66 Edit 66 Find 73, 74 Find All 73 Find Any 74 Find All 73 Find Any 74 -find 45 Find 74 -findall 45 -findany 45 -findquery 46 FMPXMLLAYOUT 23, 27, 33 34 FMPXMLRESULT 23, 27, 32 33 fmresultset 23, 27, 29 30 fmsadmin 17 four-digit-year 30 G getcontainerdata() 76 getcontainerdataurl() 76 getdatabase() 69 geterrors() 81 getfetchcount() 76 getfield() 76 getfieldastimestamp() 76 getfields() 69, 76 getfoundsetcount() 76 getlayout() 69 getmessage() 81 getname() 69, 71 getrange() 73 getrecords() 76 getrelatedset() 70 getrelatedsets() 70 getvalueliststwofields() 72 getvaluelisttwofields() 72 I iserror() 81 isvalidationerror() 79

90 L Latin-1 62 -lay 38, 50 -lay.response 38, 50 -layoutnames 46 listfields() 69 listlayouts() 69 listrelatedsets() 69, 70 listscripts() 67 listvaluelists() 69, 72 -lop 50 M -max 50 max-characters 30 max-repeat 30 <metadata> 30 MIME (Multipurpose Internet Mail Extensions) 15 -modid 51 N name 30 -new 46 newaddcommand() 66 newcompoundfindcommand() 74 newdeletecommand() 67 newduplicatecommand() 66 neweditcommand() 66 newfindallcommand() 73 newfindanycommand() 74 newfindcommand() 74 newfindrequest() 74 newperformscriptcommand() 68 newrelatedrecord() 71 not-empty 30 numeric-only 30 numerrors() 79, 81 O OS X Server Admin 58 P PDF 8 PHP Web 11 59 13 PHP fmphp 13 PHP 12 PHP 58 PHP FileMaker 65 Q -query 51 R -recid 52 <relatedset-definition> 30 -relatedsets.filter 52 -relatedsets.max 53 result 30 <resultset> 30 S SATFileMaker Server Admin Console -script 53 -script.param 54 -script.prefind 54 -script.prefind.param 54 -script.presort 55 -script.presort.param 55 -scriptnames 47 Server Admin 58 setlogicaloperator() 73 setprecommandscript() 68, 73 setpresortscript() 68, 73 setproperty() 65 setrange() 73 setrelatedsetsfilters() 77 setresultslayout() 69 setscript() 68, 73 -skip 55 -sortfield 55 -sortorder 56 SSL (Secure Sockets Layer) 15 T time-of-day 30 Tomcat 87 type 30 U UACFileMaker Server Admin Console Unicode FileMaker Server 62 XML 36 Unix 76 URL 27 URL XML 26 XML 25 UTF-8 (Unicode Transformation 8 Bit) 27, 36 UTF-8 62

91 V validate() 78 -view 47 W Web Admin Console 25 XML 24 XML 25 85 88 10 10 20 Web 10 Web 24 Web MIME 15 XML 24 84 Web 84 Web FileMaker 8 Web 20 84 83 Web 84 Web XML 25 22 15 88 14 21 Web 18 Web 21 13 Web 13 Web 13 X XML FMPXMLLAYOUT 33 FMPXMLRESULT 32 fmresultset <metadata> 30 29 <datasource> 29 <field-definition> 30 <relatedset-definition> 30 <resultset> 30 URL 27 UTF-8 28, 36 XML 1.0 23 XML 25 XML 39 38 Web 11 36, 40 25 13 28 25, 36 (DTD) 28, 29, 32 27 38 XML 24 38 11 XML 38 XML fmxml 13, 25 XML 23 XML 23 XML 38 XML 25 XML ASCII 36 XML 27 XML 27 XML 28 XML Web 24 XML HTML 25 XML 38 XML 25 <xsl:stylesheet> 83 <xsl:template> 83, 84 Web 13 14 18 14 Web 13 PHP 72 XML 33 78 85 Web 84 81 88 28 88 81 URL 27 XML 28, 36 49

92 Web 18 XML URL 26 16 16 15 17 8 XML 25 Web 9 78 Web PHP 11 Web 14 Web 19 Web IP 14 Web 13 XML 11, 23 9 13 14 20 19 18 IP 22 13 9 21 Web 20 Web 21 Web 13 Web 13, 25 42 70 78 77 XML 36, 40 40 42 44 36, 40 43 42 URL 58 44 30 78 Web 14 14 14 76 76 73 73 14 57 77 78 47 47 46 47 46 77 PHP 67 XML 25 18 Web 18 18 19 83 IP 58 9 4 77 IP 14 14 14 10 76, 78

93 14 28, 88 88 65 Web 13 URL 27 XML 28 Web 83 XML 83 IP 58 XML 39 Web Web 83 77 77 77 78 77 4 77 78 78 79 79 77 77 77 78 77 4 77 78 78 79 79 Web 13 Web 13 14 76 78 PHP 70 XML 30, 42 15, 26, 32 77 42 26, 42 29 27, 29 77 32, 34, 78 27, 29 32, 77 4 77 30 32, 34, 78 32 32, 34, 78 30, 42 49 42 () 48 46 51 19 17 (DTD) 28, 32 PHP 70 52 52 52 43 53 42 43 52, 53 53 53 52 43 43 FileMaker 8

94 add() 74 addsortrule() 73 clearsortrules() 73 commit() 66 createrecord() 66 delete() 67, 71 getcontainerdata() 76 getcontainerdataurl() 76 getdatabase() 69 geterrors() 81 getfetchcount() 76 getfield() 76 getfieldastimestamp() 76 getfields() 69, 76 getfoundsetcount() 76 getlayout() 69 getmessage() 81 getname() 69, 71 getrange() 73 getrecords() 76 getrelatedset() 70 getrelatedsets() 70 getvalueliststwofields() 72 getvaluelisttwofields() 72 iserror() 81 isvalidationerror() 79 listfields() 69 listlayouts() 69 listrelatedsets() 69, 70 listscripts() 67 listvaluelists() 69, 72 newaddcommand() 66 newcompoundfindcommand() 74 newdeletecommand() 67 newduplicatecommand() 66 neweditcommand() 66 newfindallcommand() 73 newfindanycommand() 74 newfindcommand() 74 newfindrequest() 74 newperformscriptcommand() 68 newrelatedrecord() 71 numerrors() 79, 81 setlogicaloperator() 73 setprecommandscript() 68, 73 setpresortscript() 68, 73 setproperty() 65 setrange() 73 setrelatedsetsfilters() 77 setresultslayout() 69 setscript() 68, 73 validate() 78 18 Web 13 Web 13 78 FMPXMLLAYOUT 33 FMPXMLRESULT 32 fmresultset 29 28 63 FMPXMLRESULT 33 PHP 69 XML 38 PHP 73 PHP 67 PHP 66 PHP 66 PHP 66 XML 45 XML 44 XML 46 XML 55 XML 45 XML 45 65 67 PHP 66 XML 46 66 66 83 Tomcat 87 Web 84 84