Beginning PHP 5 and MySQL 5: From Novice to Professional, Second Edition, offers a comprehensive guide to two of the most prominent open source technologies on the planet: the PHP scripting language and the MySQL database server. Updated to introduce the features found in MySQL 5, which is MySQL's most significant release to date, this second edition shows readers how to take advantage of both technologies to build powerful, manageable, and stable web applications.

Autorentext
W. Jason Gilmore is a web developer and business consultant with more than 15 years of experience helping companies large and small build amazing software solutions. He has been teaching developers from around the world about web development for over a decade, having written six books, including the bestselling Beginning PHP and MySQL, Fourth Edition and Easy PHP Websites with the Zend Framework, Second Edition .Over the years Jason has been published more than 300 times within popular publications such as Developer.com, PHPBuilder.com, JSMag, and Linux Magazine, and instructed hundreds of students in the United States and Europe. He s recently led the successful development and deployment of a 10,000+ product e-commerce project, and is currently working on a variety of new e-commerce initiatives. Jason is cofounder of the wildly popular CodeMash Conference, the largest multi-day developer event in the Midwest.

Klappentext

• This best-selling title has comprehensive discussions about PHP 5, MySQL 5, and how these two popular open source technologies work together to create powerful websites. * Updated to reflect the new features found in MySQL's most significant release to date. Readers are introduced to advanced database features like triggers, stored procedures, and views. They learn how to integrate these new capabilities into their PHP-driven web applications. The book also discusses PHP's new MySQL extension, mysqli, which is required for MySQL versions 4.1 and higher.

• Packed with hundreds of practical examples covering all aspects of web development, including forms management, templating, database integration, Web services, security, and session handling.

Zusammenfassung

• 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.

Inhalt
An Introduction to PHP.- Installing and Configuring Apache and PHP.- PHP Basics.- Functions.- Arrays.- Object-Oriented PHP.- Advanced OOP Features.- Error and Exception Handling.- Strings and Regular Expressions.- Working with the File and Operating System.- PEAR.- Date and Time.- Forms and Navigational Cues.- Authentication.- Handling File Uploads.- Networking.- PHP and LDAP.- Session Handlers.- Templating with Smarty.- Web Services.- Secure PHP Programming.- SQLite.- Introducing PDO.- Introducing MySQL.- Installing and Configuring MySQL.- The Many MySQL Clients.- MySQL Storage Engines and Datatypes.- Securing MySQL.- PHP's MySQL Extension.- PHP's mysqli Extension.- Stored Routines.- MySQL Triggers.- Views.- Practical Database Queries.- Indexes and Searching.- Transactions.- Importing and Exporting Data.