Beginning PHP and MySQL 5: From Novice to Professional

✍ Scribed by W. Jason Gilmore (auth.)

• Publisher: Apress
• Year: 2006
• Tongue: English
• Leaves: 922
• Edition: 2
• Category: Library

✦ Synopsis

• Written for the budding web developer searching for a powerful, low-cost solution for building flexible, dynamic web sites.
• Essentially three books in one: provides thorough introductions to the PHP language and the MySQL database, and shows you how these two technologies can be effectively integrated to build powerful websites.
• Provides over 500 code examples, including real-world tasks such as creating an auto-login feature, sending HTML-formatted e-mail, testing password guessability, and uploading files via a web interface.
• Updated for MySQL 5, includes new chapters introducing triggers, stored procedures, and views.

✦ Table of Contents

Front Matter....Pages i-xxxiv
An Introduction to PHP....Pages 1-7
Installing and Configuring Apache and PHP....Pages 9-42
PHP Basics....Pages 43-89
Functions....Pages 91-101
Arrays....Pages 103-131
Object-Oriented PHP....Pages 133-156
Advanced OOP Features....Pages 157-176
Error and Exception Handling....Pages 177-189
Strings and Regular Expressions....Pages 191-227
Working with the File and Operating System....Pages 229-258
PEAR....Pages 259-270
Date and Time....Pages 271-301
Forms and Navigational Cues....Pages 303-323
Authentication....Pages 325-343
Handling File Uploads....Pages 345-358
Networking....Pages 359-398
PHP and LDAP....Pages 399-423
Session Handlers....Pages 425-446
Templating with Smarty....Pages 447-471
Web Services....Pages 473-514
Secure PHP Programming....Pages 515-533
SQLite....Pages 535-553
Introducing PDO....Pages 555-572
Introducing MySQL....Pages 573-580
Installing and Configuring MySQL....Pages 581-605
The Many MySQL Clients....Pages 607-630
MySQL Storage Engines and Datatypes....Pages 631-659
Securing MySQL....Pages 661-687
PHP’s MySQL Extension....Pages 689-718
PHP’s mysqli Extension....Pages 719-743
Stored Routines....Pages 745-766
MySQL Triggers....Pages 767-778
Views....Pages 779-791
Practical Database Queries....Pages 793-815
Indexes and Searching....Pages 817-830
Transactions....Pages 831-843
Importing and Exporting Data....Pages 845-857
Back Matter....Pages 859-913

✦ Subjects

Programming Languages, Compilers, Interpreters