Muutke küpsiste eelistusi

Web Publishing with PHP and FileMaker 9 [Pehme köide]

  • Formaat: Paperback / softback, 264 pages, kõrgus x laius x paksus: 231x178x16 mm, kaal: 418 g
  • Ilmumisaeg: 13-Sep-2007
  • Kirjastus: Sams Publishing
  • ISBN-10: 0672329506
  • ISBN-13: 9780672329500
Teised raamatud teemal:
  • Formaat: Paperback / softback, 264 pages, kõrgus x laius x paksus: 231x178x16 mm, kaal: 418 g
  • Ilmumisaeg: 13-Sep-2007
  • Kirjastus: Sams Publishing
  • ISBN-10: 0672329506
  • ISBN-13: 9780672329500
Teised raamatud teemal:
Whether you are a FileMaker developer who is new to web publishing, a web developer who is new to FileMaker, or a complete beginner looking to put your data online, this book is for you.

In Part I, you learn the basics of how web publishing works and how to write your own HTML and PHP. In Part II, you learn how to build a FileMaker database and install and configure the FileMaker Server to host the database. In Part III, you learn how to put it all together to create web pages that talk to your database and allow people to view the data and, if you like, modify it. Throughout the book, publishing a FileMaker Product Catalog to the web is used as an example. Each chapter builds on the previous chapter. When you are done, you will have a working website!

 

Detailed information on how to





Master web publishing Read and write basic HTML Read and write basic PHP Build a FileMaker database Install and configure FileMaker Server Publish your FileMaker data to the web Work with portals and container fields Repurpose your FileMaker layouts on the web

 

 

Introduction 1 Part I: Basics of Web Publishing Chapter 1: How Web Publishing Works 7 Chapter 2: Introduction to HTML 17 Chapter 3: Introduction to PHP 31 Part II: Laying the Groundwork Chapter 4: Building a Simple FileMaker File 49 Chapter 5: Configuring the Server(s) 67 Part III: Publishing FileMaker Data on the Web Chapter 6: Viewing FileMaker Data 91 Chapter 7: Altering FileMaker Data 115 Chapter 8: Working with Related Data (Portals) 137 Chapter 9: Working with Images 167 Chapter 10: Repurposing a FileMaker Layout on the Web 189 Part IV: More Information Appendix A: Performance Tuning 213 Appendix B: Security Concerns 217 Appendix C: Error Handling and Prevention 225 Appendix D: FileMaker PHP API Reference 231 Index 239

Muu info

Whether you are a FileMaker developer who is new to web publishing, a web developer who is new to FileMaker, or a complete beginner looking to put your data online, this book is for you. In Part I, you learn the basics of how web publishing works and how to write your own HTML and PHP. In Part II, you learn how to build a FileMaker database and install and configure the FileMaker Server to host the database. In Part III, you learn how to put it all together to create web pages that talk to your database and allow people to view the data and, if you like, modify it. Throughout the book, publishing a FileMaker Product Catalog to the web is used as an example. Each chapter builds on the previous chapter. When you are done, you will have a working website! Detailed information on how to! *Master web publishing*Read and write basic HTML*Read and write basic PHP*Build a FileMaker database*Install and configure FileMaker Server*Publish your FileMaker data to the web*Work with portals and container fields*Repurpose your FileMaker layouts on the web Introduction 1 Part I: Basics of Web Publishing Chapter 1: How Web Publishing Works 7 Chapter 2: Introduction to HTML 17 Chapter 3: Introduction to PHP 31 Part II: Laying the Groundwork Chapter 4: Building a Simple FileMaker File 49 Chapter 5: Configuring the Server(s) 67 Part III: Publishing FileMaker Data on the Web Chapter 6: Viewing FileMaker Data 91 Chapter 7: Altering FileMaker Data 115 Chapter 8: Working with Related Data (Portals) 137 Chapter 9: Working with Images 167 Chapter 10: Repurposing a FileMaker Layout on the Web 189 Part IV: More Information Appendix A: Performance Tuning 213 Appendix B: Security Concerns 217 Appendix C: Error Handling and Prevention 225 Appendix D: FileMaker PHP API Reference 231 Index 239
Introduction 1(1)
Introduction to the Introduction
1(1)
Okay, Here's the Real Introduction
1(1)
Conclusion to the Introduction
2(1)
How This Book Is Organized
2(1)
Conventions Used in This Book
3(4)
Web Pages
3(1)
Code Samples
3(1)
Special Elements
3(4)
Part I Basics of Web Publishing
How Web Publishing Works
7(10)
What Do I Mean by Web Publishing, Anyway?
7(1)
Simple Website in Five Steps
8(4)
Step 1: Create an HTML Document
8(1)
Step 2: Buy a Domain Name
9(1)
Step 3: Rent a Web Server
10(1)
Step 4: Link the Domain Name to the IP Address
11(1)
Step 5: Put the HTML Document on the Web Server
12(1)
Anatomy of a URL
12(2)
One Last Thing About URLs
13(1)
What Have We Learned So Far?
14(1)
Smart Web Pages
14(1)
But, Can Apache Run Scripts?
15(1)
Databases
15(1)
Summary
16(1)
Introduction to HTML
17(14)
Before You Start
17(1)
The Scenario
17(1)
Case 1: Company Home Page
18(6)
Case 2: Product List
24(3)
Case 3: Contact Page
27(2)
Summary
29(2)
Introduction to PHP
31(18)
Downloading and Testing PHP
31(1)
Downloading PHP
31(1)
Testing Your PHP Installation
32(1)
Basic PHP Syntax
32(4)
Adding Comments to Your PHP Code
33(1)
Using Variables
33(1)
Combining Strings
34(1)
Conditional Structures
35(1)
Simple Arrays
36(2)
Associative Arrays
38(1)
Multidimensional Arrays
39(2)
Looping
41(3)
Form Handling
44(2)
Summary
46(3)
Part II Laying the Groundwork
Building a Simple FileMaker File
49(18)
Introduction
49(1)
Creating a FileMaker File
50(15)
Creating Fields
51(2)
Auto-Enter Field Options
53(2)
Record IDs
55(4)
Working with Records
59(1)
Finding Records
59(2)
Accounts and Privileges
61(4)
File Options
65(1)
Summary
65(2)
Configuring the Server(s)
67(24)
Introduction
67(1)
Overview of Machine Configuration Options
68(1)
Installing and Configuring FileMaker Server
69(8)
Administration: Clients
74(1)
Administration: Databases
75(1)
Administration: Schedules
75(2)
Testing Your Installation
77(1)
Hosting Your File
77(3)
PHP Site Assistant
80(7)
Launching the PHP Site Assistant
80(1)
Building a Search Site
81(6)
Summary
87(4)
Part III Publishing FileMaker Data on the Web
Viewing FileMaker Data
91(24)
Introduction
91(4)
Static
91(1)
Instant Web Publishing (IWP)
92(1)
Open Database Connectivity (ODBC)
93(1)
Extensible Markup Language (XML)
93(2)
Viewing FileMaker Data
95(17)
Retrieving All Records
95(5)
Sorting Records
100(3)
Finding Records
103(4)
Drill Down Links
107(3)
Drill Down Pages
110(2)
Summary
112(3)
Altering FileMaker Data
115(22)
Introduction
115(1)
Creating Records
115(6)
Deleting Records
121(6)
Editing Records
127(8)
Summary
135(2)
Working with Related Data (Portals)
137(30)
Introduction
137(1)
Adding a Related Table to the Database
138(8)
Creating a Relationship
139(2)
Creating a Portal
141(3)
Adding Related Records
144(2)
Viewing Portal Data with FileMaker.php
146(4)
Creating Related Records
150(6)
Altering Related Records
156(5)
Editing a Related Record
161(3)
Deleting a Related Record
164(2)
Summary
166(1)
Working with Images
167(22)
Introduction
167(1)
Embedding Images in a Container Field
167(1)
Storing Image URLs in a Text Field
168(1)
Recommendation
168(1)
Embedding Images in a Container Field
168(7)
Storing Images as URLs
175(13)
Summary
188(1)
Repurposing a FileMaker Layout on the Web
189(24)
Introduction
189(1)
List View
190(12)
Detail View
202(8)
Summary
210(3)
Part IV More Information
A. Performance Tuning
213(4)
Introduction
213(1)
Keep Fields on Web Layouts to a Minimum
213(1)
Specify Result Layouts
214(1)
Minimize Database Requests
215(1)
Summary
215(2)
B. Security Concerns
217(8)
Introduction
217(1)
Filter All Incoming Data
217(4)
Maximum Length
218(1)
Whitelist
218(1)
Validating File Uploads
218(1)
Cross-Site Scripting Attacks
219(2)
FMP Injection
221(1)
Keep Connection Info Above the Web Root Directory
221(2)
Do Not Report Errors to the Browser
223(1)
Summary
224(1)
C. Error Handling and Prevention
225(6)
Introduction
225(1)
FileMaker Errors
226(1)
PHP Errors
227(1)
Error Logs
228(1)
Final Considerations
229(1)
Summary
230(1)
D. FileMaker PHP API Reference
231(8)
Index 239


Jonathan Stark is the president of Jonathan Stark Consulting, a software consulting firm specializing in data solutions for creative professionals. Past clients include Staples, Turner Broadcasting, and Ambrosi (now Schawk). He has spoken at the FileMaker Developers Conference and has had numerous articles published in FileMaker Advisor and php|architect magazines. Jonathan is reluctant to admit that he began his programming career more than 20 years ago on a Tandy TRS-80.