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

Transcription

1 FileMaker Server 15 Web

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

3 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 Web (MIME ) 15 Web Web 18 FileMaker Web Web 19 Web 19 3 Web with XML 20 Web Web 20 Web with XML 20 Web 21 Web 21 Web Web

4 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 dbnames () 44 -delete () 44 -dup () 45 -edit () 45 -find-findall -findany () 45 -findquery () 46 -layoutnames () 46 -new () 46 -scriptnames () 47 -view () 47

5 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 FileMaker API for PHP Web with PHP 61 Web PHP 61 Web with PHP 61 8 FileMaker API for PHP FileMaker API for PHP 63 FileMaker API for PHP 63

6 FileMaker 64 FileMaker 64 FileMaker 64 FileMaker API 65 FileMaker FileMaker FileMaker FileMaker Find All 73 Find Any 74 Find 74 Compound Find

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

8 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 FileMaker Server Admin Console [] > [FileMaker Server ]

9 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

10 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.fmp Web Web Web Web FM API PHP Web 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

11 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

12 1 Web 12 PHP 1 PHP 1 FileMaker API for PHP FileMaker Pro Web 1 PHP 1 PHP 1 PHP Web 1 1 PHP 1 PHP Web with PHP 6 Web with PHP

13 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

14 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 IP Web IP Web

15 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

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

17 2 Web 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)

18 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

19 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

20 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

21 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

22 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

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

24 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 )

25 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)

26 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 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 :

27 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 fianc%c3%a9e&-edit URL %C3%A9 é UTF-8 URL URL 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

28 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=" xmlns=" xmlns=" 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

29 4 Web XML 29 fmsresultset XML FileMaker fmresultset Web XML URL fmresultset fmresultset.xml : 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 ( ) 1 dd - 2 (00 31 ) 1 yyyy XML <datasource> time-format HH:mm:ss 1 HH - 2 ( ) 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

30 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

31 4 Web XML 31 fmresultset XML <fmresultset xmlns=" version="1.0"> <error code="0"/> <product build="02/10/2016" name="filemaker Web Publishing Engine" version=" "/> <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>

32 4 Web XML 32 FileMaker XML FileMaker XML FMPXMLRESULT fmresultset FMPXMLLAYOUT FMPXMLRESULT FMPXMLLAYOUT FMPXMLRESULT Web XML URL FMPXMLRESULT.xml : FMPXMLLAYOUT Web XML URL -view FMPXMLLAYOUT.xml : 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

33 4 Web XML 33 FMPXMLRESULT XML FMPXMLRESULT XML <FMPXMLRESULT xmlns=" <ERRORCODE>0</ERRORCODE> <PRODUCT BUILD="02/10/2016" NAME="FileMaker Web Publishing Engine" VERSION=" "/> <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

34 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

35 4 Web XML 35 FMPXMLLAYOUT XML <FMPXMLLAYOUT xmlns=" <ERRORCODE>0</ERRORCODE> <PRODUCT BUILD="02/10/2016" NAME="FileMaker Web Publishing Engine" VERSION=" "/> <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>

36 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 Unicode UTF-8 Web UTF-8 1 ASCII 1 UTF-8 ASCII UTF-8 1 ASCII () 1 UTF UTF-8 Unicode 1 UTF-8 ASCII Unicode UTF-8 Unicode 50% FileMaker XML FileMaker XML FileMaker URL -findall products FileMaker -new 1 -dbnames -db URL FileMaker 40XML -dbnames -delete -dup -edit -find -findall -findany -findquery Web

37 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

38 4 Web XML 38 XML -lay XML XML XML XML -lay.response BudgetSalary 100,000 ExecListSalary &-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

39 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

40 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 new -new -edit 1 -dbnames -db 36FileMaker XML 1 -db=employees -findall =

41 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 ) lop -delete -lop A Web

42 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 () URL Employees John Doe Jane Dependents NamesID ID &-lay=family&firstname=john&lastname=doe&id=9756&dependents::names.0=jane&-new 1 1

43 5 XML edit ID ID ID XML <relatedset> <record> record-id 29fmsresultset URL ID 1001 DependentsNamesNames.22 ID &-recid=1001&dependents::names.2=kevin&-edit 1 &-recid=1001&dependents::names.2=kevin&dependents::names.5=susan&-edit -edit ID 0 : &-recid=1001&dependents::names.0=timothy&-edit -delete -edit -delete.related URL employees &-recid=1001&-delete URL Dependents1001 ID 3 &-recid=1001&-delete.related=dependents.3&-edit 47-delete.related () -relatedsets.filter -relatedsets.max 52-relatedsets.filter ( ) 53-relatedsets.max ()

44 5 XML 44 :: ().global global ( ) 42 FileMaker Pro.global Web XML.global Web : &Country.global=USA&-recid=1&-edit XML -dbnames () FileMaker Server Web with XML : () : : -delete () -recid : -db-lay-recid : -script : :

45 5 XML 45 -dup () -recid : -db-lay-recid : -script : : -edit () /-recid -recid : -db-lay-recid1 : -modid, -script -edit 43 : : -find-findall -findany () : -db-lay : -recid-lop-op-max-skip-sortorder-sortfield-script-script.prefind -script.presort : : 1 FileMaker Server ID : -findall : -findall -max 1 -findany :

46 5 XML 46 -findquery () : -db-lay-query : -max-skip-sortorder-sortfield-script-script.prefind-script.presort : Fluffy &-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 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 : : -new () / : -db-lay : 1 -script 42 : :

47 5 XML 47 -scriptnames () FileMaker Server Web with XML : -db : : -view () FMPXMLLAYOUT FMPXMLLAYOUT (fmresultset FMPXMLRESULT) XML metadata : -db-lay : -script : : : XML -db () : () -db -db : -dbnames : -delete.related () : -edit : ID

48 5 XML 48 : jobtable7 ID 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 : &-lay=departments&-op=eq&firstname=sam&-max=1&-find 1 FileMaker Server

49 5 XML 49 fieldname.op () -find : eq cn bw ew gt gte lt lte neq FileMaker Pro = ** * * > >= < <= : -find : ::=&::.op= 1 1 cn 1 : bw (//) fieldname.op FileMaker Pro (...)... : FileMaker Pro

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

51 5 XML 51 : -modid ( ID) ID -edit ID ID ID -edit : ID ID FileMaker ID : -edit : -recid : &-lay=departments&-recid=22&-modid=6&last_name=jones&-edit -query () 46-findquery () : : -findquery -query=<><>&-findquery <> 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

52 5 XML 52 <> (-) : : : -< ID>=<>&-< ID>.value=<> -q1=typeofanimal&-q1.value=cat -q2=name&-q2.value=fluffy FluffyGray &-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: 2: -relatedsets.filter () : layout none 1 -relatedsets.filter layout FileMaker Pro [] [] 1 [] [] -relatedsets.max -relatedsets.max () 1 [] -relatedsets.max [] [] 1 none-relatedsets.filter none Web [] [] []

53 5 XML relatedsets.filter XML -relatedsets.filter layoutnonefilemaker Pro 1 [] [] XML [] : -find-edit-new-dup -findquery : -relatedsets.max=all&-findany -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 : -relatedsets.max=all&-findany -relatedsets.max=10&-findany -script () FileMaker 39XML : : -dbnames-layoutnames -scriptnames :

54 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 : &-lay=departments&-script=myscript&-script.param=smith%7cchatterjee%7csu&-findall -script.prefind () -find () FileMaker : : -dbnames-layoutnames -scriptnames : -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 : &-lay=departments&-script.prefind=myscript&-script.prefind.param=payroll&-findall

55 5 XML 55 -script.presort () -find () FileMaker : -dbnames-layoutnames -scriptnames : &-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 : &-lay=departments&-script.presort=myscript&-script.presort.param=18%7c65 &-sortfield.1=dept&-sortfield.2=rating&-findall -skip () : 0 : -find : -sortfield () : : -find -findall

56 5 XML 56 -sortfield -sortfield. = -sortfield. precedence-number : deptrating-sortorder : &-lay=performance&-sortfield.1=dept&-sortfield.2=rating&-findall -sortorder () : <> Custom ascend descend <> FileMaker Pro a z z a10-10 : -find -findall : -sortfield -sortorder -sortfield -sortorder. = 1 -sortorder.-sortorder -sortfield ascend 1 (dept) ascend 2 (rating) descend -sortorder.2 2 -sortorder.2=descend -sortfield.2=rating : &-lay=performance&-sortfield.1=dept&-sortorder.1=ascend&-sortfield.2=rating &-sortorder.2=descend&-findall -sortorder

57 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

58 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 1 Web PHP curl ( URL ) 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

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

60 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

61 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

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

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

64 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

65 8 FileMaker API for PHP 65 PHP FileMaker 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', ' $fm->setproperty('username', 'web'); $fm->setproperty('password', 'web'); hostspec PHP FileMaker Server Web hostspec PHP hostspec FileMaker Server Web FileMaker FileMaker Pro 1 AddDeleteDuplicate Edit (FindFind AllFind Any Compound Find)

66 8 FileMaker API for PHP 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();

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

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

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

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

71 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(); }

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

73 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() FileMaker 1 setprecommandscript() 1 setpresortscript() 1 setscript() Find All Find All newfindallcommand() FileMaker_Command_FindAll execute()

74 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

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

76 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() 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')).'">';

77 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 M/D/YYYY 4 M 1 12 D 1 31 YYYY /30/ /31/ (/) (\) (-) 1\

78 8 FileMaker API for PHP 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) FileMaker FileMaker Pro / 1 1 validate() PHP 1 validate() TRUE validate() FileMaker_Error _Validation

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

80 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

81 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

82 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

83 9 83 Web Web Web 18FileMaker Web 1 Web 1 FileMaker API for PHP FileMaker API for PHP Web Web 1 Web Web URL 1 PHP <> 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=" xmlns:fmrs=" <xsl:output method="xml"/> <xsl:template match="/"> <xsl:copy-of select="."/> </xsl:template> </xsl:stylesheet>

84 HTML <textarea> XML <?xml version="1.0" encoding="utf-8"?> <xsl:stylesheet version="1.0" <html> </html> xmlns:xsl=" xmlns:fmrs=" <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

85 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

86 [FM_ERROR_CODE] FileMaker (88FileMaker ) HTTP: HTTP 1 [RETURN_BYTES] 1 [MESSAGE] Web wpe.log 1 Web 2016/06/02 15:15: INFO - - FileMaker Server Web Publishing Engine started. 2016/06/02 15:46: INFO - - FileMaker Server Web Publishing Engine stopped. 1 XML 2016/06/02 15:21: WPC_SERVER :0 jdoe XML INFO "/fmi/xml/fmresultset.xml?-db=contacts&-lay=contact_details&-findall" 2016/06/02 15: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 2016/06/09 10:59: WPC_SERVER :0 jdoe - INFO - - XML Web Publishing Engine is enabled /06/02 15:30: WPC_SERVER :0 jdoe XML ERROR - - Communication failed Web Web Web Web web_server_module_log.txtweb FileMaker ServerLogs

87 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

88 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" " <fmresultset xmlns=" version="1.0"> <error code="0"></error> FMPXMLRESULT <?xml version="1.0" encoding="utf-8" standalone="no"?> <!DOCTYPE FMPXMLRESULT PUBLIC "-//FMI//DTD FMPXMLRESULT//EN" " <fmpxmlresult xmlns=" <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>

89 A Add 66 add() 74 addsortrule() 73 Admin Console 14, 25, 60 auto-enter 30 C clearsortrules() 73 commit() 66 Compound Find 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 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 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, FMPXMLRESULT 23, 27, fmresultset 23, 27, 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 90 L Latin 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 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 91 V validate() 78 -view 47 W Web Admin Console 25 XML 24 XML Web 10 Web 24 Web MIME 15 XML Web 84 Web FileMaker 8 Web Web 84 Web XML Web 18 Web Web 13 Web 13 X XML FMPXMLLAYOUT 33 FMPXMLRESULT 32 fmresultset <metadata> <datasource> 29 <field-definition> 30 <relatedset-definition> 30 <resultset> 30 URL 27 UTF-8 28, 36 XML XML 25 XML Web 11 36, , 36 (DTD) 28, 29, XML 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 Web 13 PHP 72 XML Web URL 27 XML 28, 36 49

92 92 Web 18 XML URL XML 25 Web 9 78 Web PHP 11 Web 14 Web 19 Web IP 14 Web 13 XML 11, IP Web 20 Web 21 Web 13 Web 13, XML 36, , URL Web PHP 67 XML Web IP IP , 78

93 , Web 13 URL 27 XML 28 Web 83 XML 83 IP 58 XML 39 Web Web Web 13 Web PHP 70 XML 30, 42 15, 26, , , , 34, 78 27, 29 32, , 34, , 34, 78 30, () (DTD) 28, 32 PHP , FileMaker 8

94 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() Web 13 Web FMPXMLLAYOUT 33 FMPXMLRESULT 32 fmresultset 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 PHP 66 XML Tomcat 87 Web 84 84