Beginning PHP 5 and MySQL: From Novice to Professional - Softcover

Gilmore, J. W.; Gilmore, W. J.; Gilmore, W. Jason

Softcover

ISBN 10: 1893115518 ISBN 13: 9781893115514

Publisher: Springer, 2004

Synopsis

Beginning PHP 5 and MySQL: From Novice to Professional offers a comprehensive introduction to two of the most popular open-source technologies on the planet: the PHP scripting language and the MySQL database server. You are not only exposed to the core features of both technologies, but will also gain valuable insight into how they are used in unison to create dynamic data-driven web applications, not to mention learn about many of the undocumented features of the most recent versions.

The first part of the book is devoted to PHP's foundational features, with special focus on those new to PHP 5, including the improved object-oriented support, exception handling, SQLite support, SimpleXML, and much more. But PHP 5-specific topics are only part of what's covered; you’ll also learn about the language's core capabilities, beginning with a survey of installation and configuration tasks. Early chapters are devoted to basic PHP programming concepts such as variables, datatypes, arrays, string manipulation, and user interaction. Later chapters cover session handling, LDAP integration, the Smarty templating engine, and Web Services support.

Next up is a broad overview of the powerful MySQL database server. Among other topics, you’ll learn about the installation and configuration process, datatypes, key security features, and various administration utilities. With this groundwork in pace, you'll then learn about PHP's assortment of MySQL functions, accompanied by dozens of examples depicting the creation and execution of queries. You’ll also learn how to perform searches, and manage database transactions.

Whether you’re a newcomer searching for a thorough introduction to these popular technologies, or a seasoned developer in need of a comprehensive reference, this book is for you.

Table of Contents

1. An Introduction to PHP
2. Installing and Configuring PHP
3. PHP Basics
4. Functions
5. Arrays
6. Object-Oriented PHP
7. Advanced OOP Features
8. Error and Exception Handling
9. Strings and Regular Expressions
10. Working with the File and Operating System
11. Forms and Navigational Cues
12. Authentication
13. Handling File Uploads
14. Networking with PHP
15. PHP and LDAP
16. Session Handlers
17. Templating with Smarty
18. Web Services
19. Secure PHP Programming
20. SQLite
21. MySQL: The Disruptive Database
22. Installing and Configuring MySQL
23. The Many MySQL Clients
24. MySQL Table Structures
25. Securing MySQL
26. PHP’s MySQL Functionality
27. Practical Database Queries
28. Indexes and Searching
29. Transactions
30. Importing and Exporting Data

About this title

About the Author

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.

Edition details

• Publisher: Springer
• Publication date: 2004
• ISBN 10: 1893115518
• ISBN 13: 9781893115514
• Binding: Paperback
• Language: English
• Edition number: 1
• Number of pages: 800