Table of contents for Learning PHP and MySQL / Michele E. Davis and Jon A. Phillips.


Bibliographic record and links to related information available from the Library of Congress catalog
Note: Electronic data is machine generated. May be incomplete or contain other coding.


Counter
1. Dynamic Content and the Web ............       ................ 1
LHTTP and the Internet                                          1
PHP and MySQL's Place in Web Development                        2
The Components of a PHP Application                             4
Integrating Many Sources of Information                         7
Requesting Data from a Web Page                                11
2. Installation .......................................            15
Developing Locally                                             15
Working Remotely                                               35
3.  Exploring  PH P  .....................................................  39
PNHP and HTML Text                                             39
Coding Building Blocks                                         43
4. PHP Decision-Making .................. ..............62
Expressions                                                    62
Operator Concepts                                              64
(onditionals                                                   71
Looping                                                        77
5.  Functions  ...................................... ...................  85
Calling Functions                                              87
Defining Functions 8P)
Object-Oriented Programming                                    96
6.  A rrays  ........ ............................         ....... .  107
Array Fundamentals                                              107
7. Working with MySQL ............... ............          ..... 122
MySQL Database                                                  122
Managing the Database                                           125
Using phpMyAdmin                                                126
Database Concepts                                               131
Structured Query Language                                       132
8.  Database Best Practices  ............... ................ ........  146
Database Design                                                 146
Backing Up and Restoring Data                                   155
Advanced SQL                                                    159
9. Getting PHP to Talk to MySQL ................... ............... 179
The Process                                                     180
Querying the Database with PHP Functions                        180
Using PEAR                                                      190
10. Working with Forms ...........................    ............. 199
Building a Form                                                 199
Templates                                                       218
11. Practical PHP ......................       .............. 223
String Functions                                                223
Date and Time Functions                                         233
File Manipulation                                               238
Calling System Calls                                            249
12.  XHTML  ................ ...................  ................... 251
Why XHTML?                                                      253
XHTML and XML Namespaces                                        254
XHTML Versions                                                  254
Generating XHTML with PHP                                       261
13. Modifying MySQL Objects and PHP Data ..............     ........ 263
Changing Database Objects from PHP                              263
Manipulating Table Data                                         266
Displaying Results with Embedded Links                          267
Presclting a Form to Add and Process in One File              270
ępdating Data                                                 276
Deltciing Data                                                277
IPrfiorming a Subquery                                        282
14. Cookies, Sessions, and Access Control .............................. 285
Cook:ies                                                      285
PHP anid HTTP Authenrtication                                 288
Sessions                                                      294
I sing Auth HTTP to Authenticate                              301
15.  Security  .................. ................... ............. ......  307
Session Securitv                                              316
16. Validation and Error Handling .........................  ...... 325
Validating User Input with JavaScript                         325
Pattern Matching                                              329
Re(displaving a Form After PHP Validation Fails               .33
17.  Sample Application  ................. ........................... 339
C oniiguration File                                           340
Page Framework                                                340
D itabase                                                     343
Displaying a Postings Summary                                 346
[)iplayiotg a Posting and Its Comments                        349
Adding and Changing Posts                                     352
Addilng and Changing Comments                                 358
18. Finishing Your Journey .................................. 366
PHIP Cioding Standards                                        366
PE1AR                                                         371
F -amieworks                                                  372
Ajax                                                          373
\ ikis                                                        373
Sinding FHep on the Web                                       373
Appendix.  Solutions to Chapter Questions ......... .......... .......... 377
index .................................     ...........      ...... 391



Library of Congress subject headings for this publication: MySQL (Electronic resource)PHP (Computer program language)SQL (Computer program language)Web databases