Core web application development with PHP and MySQL

✍ Scribed by Wandschneider, Marc

• Publisher: Prentice Hall PTR
• Year: 2005;2006
• Tongue: English
• Leaves: 885
• Series: Prentice Hall PTR core series
• Edition: 1. printing
• Category: Library

✦ Synopsis

PHP and MySQL have become a serious and commercially viable system with which to develop web applications. With the relase of PHP 5, J2EE developers, in particular, are starting to take a second look at PHP. And while there are many books on the makret that describe PHP language syntax, there are very few that fully describe web application development with PHP and related technologies. This book describes the complete web application development lifecycle, from planning the application to designing the user interface to building in robust security. And since web applications serve the entire world, often neglected globalization issues are treated in detail. Though MySQL is used throughout the examples, Part IV also contains examples of building applications on top of both Oracle and PostgresSQL, two popular alternatives to MySQL for use in mission-critical systems.

✦ Table of Contents

Cover......Page 1
Contents......Page 6
Target Audience......Page 24
Layout......Page 25
Acknowledgments......Page 26
In Closing......Page 27
PART I: The Basics of PHP......Page 28
Your First PHP Programs......Page 30
Entering PHP Scripts......Page 33
How to Store Data......Page 36
Entering Basic Types in PHP......Page 37
Some Very Useful Functions......Page 43
Summary......Page 45
More on Entering Strings......Page 46
More on Data Types......Page 48
Type Conversions......Page 51
Variables and Constants......Page 57
Expressions and Operators......Page 60
Control Structures......Page 69
Summary......Page 74
Basic Code Reuse: Functions......Page 76
Intermediate Code Reuse: Using and Including Files......Page 92
Summary......Page 103
Moving Beyond Libraries......Page 104
Object-Oriented Programming......Page 108
Extending Objects......Page 122
Other Features......Page 134
Summary......Page 138
Arrays Revisited......Page 140
Iterating Over Elements in an Array......Page 147
Multi-Dimensional Arrays......Page 152
Operations on Arrays......Page 154
Summary......Page 159
Strings and PHP......Page 160
Character Sets and Unicode......Page 161
Making Sense of It All in PHP......Page 163
Configuring PHP for Unicode......Page 167
Operating on Strings......Page 168
Summary......Page 177
An Example of Forms......Page 178
Working with HTML Forms......Page 181
Working with the Server......Page 189
Redirecting the User......Page 195
Summary......Page 197
PART II: Database Basics......Page 198
What Are We Talking About?......Page 200
Motivations for Using a DBMS......Page 202
Major Database Servers......Page 204
How to Select a Database Server......Page 206
Our Choice......Page 207
Summary......Page 208
What to Put into the Database......Page 210
Organizing Your Data......Page 212
An Introduction to SQL......Page 219
Creating Databases......Page 220
Setting User Permissions......Page 223
Creating Tables......Page 226
Deleting Tables and Databases......Page 236
Summary......Page 237
Before We Begin......Page 238
Inserting Data into Our Tables......Page 239
Retrieving Data from Tables......Page 243
Modifying Data in Your Tables......Page 252
Deleting Data from Tables......Page 253
Summary......Page 254
Transactions......Page 256
More Advanced Queries......Page 262
Modifying Table Schemas......Page 271
Summary......Page 272
Getting Ready......Page 274
Connecting and Authenticating......Page 276
Executing Queries......Page 279
Queries a Go-Go......Page 289
Old-School Interfaces......Page 292
Summary......Page 295
PART III: Planning Web Applications......Page 298
A Closer Look at the World Wide Web......Page 300
Designing Web Applications......Page 309
Summary......Page 318
User Interface Considerations......Page 320
Implementing Your User Interface......Page 326
Summary......Page 337
How Users Connect to Our Application......Page 340
Visitors Versus Known Users......Page 343
Validating Users......Page 344
Summary......Page 347
Strategies for Dealing with Security......Page 348
Identifying the Threats......Page 350
Securing Your Code......Page 354
Summary......Page 364
Securing Your Web Server and PHP......Page 366
Secure Sockets Layer (SSL)......Page 372
Database Security......Page 373
Protecting the Network......Page 375
Computer and Operating System Security......Page 377
Summary......Page 378
PART IV: Implementing Your Web Application......Page 380
How Errors Are Born......Page 382
How PHP Manages Errors......Page 386
Exceptions......Page 394
Debugging......Page 404
Summary......Page 407
Cookies: Tasty and Useful......Page 408
Sessions......Page 416
Session Security......Page 432
Summary......Page 435
Planning for Members......Page 436
Web Server-Provided Authentication......Page 439
Implementing Our Own Authentication......Page 446
Summary......Page 471
Globalization and Locales......Page 474
Formatted Output......Page 481
Output Buffering......Page 488
Summary......Page 491
Using Regular Expressions......Page 494
Data Validation with Regular Expressions......Page 503
Other Regular Expression Functions......Page 506
Summary......Page 509
XML......Page 510
Working with XML in PHP......Page 523
XHTML......Page 537
Summary......Page 541
Accessing Files......Page 542
Accessing Directories......Page 552
Security Considerations......Page 556
Summary......Page 558
Uploading User Files......Page 560
A File-Uploading Example......Page 570
Security Considerations......Page 579
Summary......Page 580
Sources of Dates and Times......Page 582
Dates and Times in PHP......Page 585
More Dates and Times in Database Servers......Page 599
Summary......Page 601
XML Web Services......Page 602
How Web Services Work......Page 605
Using Web Services in PHP......Page 614
Sample: Working with the Google APIs......Page 621
Summary......Page 629
Introduction to PEAR......Page 630
Installation and Configuration......Page 631
Basic Commands......Page 634
Example: Using the Date Class......Page 640
Summary......Page 643
Coding Standards......Page 644
Source Code Control......Page 651
Testing......Page 658
Deployment......Page 665
Summary......Page 667
PART V: Sample Projects and Further Ideas......Page 668
Singleton Objects......Page 670
Session Management......Page 673
A Holistic Approach to Error Handling......Page 677
Database Connection Management......Page 687
PHP Configuration Settings......Page 694
Summary......Page 695
Overview......Page 698
Structure and Page Progression......Page 700
Code Walkthrough......Page 708
Suggestions/Exercises......Page 728
Summary......Page 730
Overview......Page 732
Installing and Running the Sample......Page 734
Structure and Page Progression......Page 735
Code Walkthrough......Page 742
Suggestions/Exercises......Page 768
Summary......Page 770
Overview......Page 772
Installing and Running the Sample......Page 774
Structure and Page Progression......Page 775
Code Walkthrough......Page 787
Suggestions/Exercises......Page 813
Summary......Page 814
PART VI: Appendixes......Page 816
Installation......Page 818
Configuration......Page 839
Summary......Page 842
Working with Databases......Page 844
Data Description and Creation......Page 845
Other Functions and Interesting Notes......Page 848
Summary......Page 849
Appendix C: Recommended Reading......Page 850
A......Page 852
C......Page 854
D......Page 857
E......Page 861
F......Page 862
I......Page 865
J-K......Page 866
M......Page 867
N......Page 868
O......Page 869
P......Page 870
R......Page 874
S......Page 875
T......Page 878
U......Page 880
V......Page 881
W......Page 882
X......Page 884
Y-Z......Page 885

✦ Subjects

Computer Science;Programming