PHP and MySQL Web Development, Fifth Edition
The definitive guide to building database-driven Web applications with PHP and MySQL
PHP and MySQL are popular open-source technologies that are ideal for quickly developing database-driven Web applications. PHP is a powerful scripting language designed to enable developers to create highly featured Web applications quickly, and MySQL is a fast, reliable database that integrates well with PHP and is suited for dynamic Internet-based applications.
PHP and MySQL Web Development shows how to use these tools together to produce effective, interactive Web applications. It clearly describes the basics of the PHP language, explains how to set up and work with a MySQL database, and then shows how to use PHP to interact with the database and the server.
The final part of this book describes how to approach real-world projects and takes the reader through the design, planning, and building of several projects, including:
- User authentication and personalization
- Web-based email
- Social media integration
- Shopping cart
The fifth edition of PHP and MySQL Web Development has been thoroughly updated, revised, and expanded to cover developments in PHP through versions 5.6 and 7, as well as features introduced in recent stable releases of MySQL.
Free Access to Web Edition
Purchase of this book in any format, electronic or print, includes free access to the corresponding Web Edition, which provides several special features:
- The complete text of the book online
- Exercises and interactive quizzes to test your understanding of the material
- Bonus chapters not included in the print or e-book editions
- Updates and corrections as they become available
The Web Edition can be viewed on all types of computers and mobile devices with any modern web browser that supports HTML5.
Contents at a Glance
Part I: Using PHP
1 PHP Crash Course
2 Storing and Retrieving Data
3 Using Arrays
4 String Manipulation and Regular Expressions
5 Reusing Code and Writing Functions
6 Object-Oriented PHP
7 Error and Exception Handling
Part II: Using MySQL
8 Designing Your Web Database
9 Creating Your Web Database
10 Working with Your MySQL Database
11 Accessing Your MySQL Database from the Web with PHP
12 Advanced MySQL Administration
13 Advanced MySQL Programming
Part III: Web Application Security
14 Web Application Security Risks
15 Building a Secure Web Application
16 Implementing Authentication Methods with PHP
Part IV: Advanced PHP Techniques
17 Interacting with the File System and the Server
18 Using Network and Protocol Functions
19 Managing the Date and Time
20 Internationalization and Localization
21 Generating Images
22 Using Session Control in PHP
24 Other Useful Features
Part V: Building Practical PHP and MySQL Projects
25 Using PHP and MySQL for Large Projects
26 Debugging and Logging
27 Building User Authentication and Personalization
28 (Web Edition) Building a Web-Based Email Client with Laravel Part I
29 (Web Edition) Building a Web-Based Email Client with Laravel Part II
30 (Web Edition) Social Media Integration Sharing and Authentication
31 (Web Edition) Building a Shopping Cart
Part VI: Appendix
A Installing Apache, PHP, and MySQL
Most helpful customer reviews
43 of 43 people found the following review helpful.
This isn't the book you are looking for.
You will not receive the complete book with this purchase. Four chapters, two regarding setting up php email service, one for social media integration and authentication and one for building a shopping cart are not in the book but are instead listed as being "web edition" and you must register your book to access the content online. Two of these items are listed on the back cover of the book as important topics within so it is pretty unacceptable they place content like that online instead of the book. It wouldn't be that big of a deal except that I have followed the directions in the text, visited their website and created an account and registered my book. Upon attempting to access the web content for the four web edition chapters I do not get a link to click which gives me access to any content. I see that I have registered the product but I do not have access to any form of digital content. Attempts to contact the company have gone unanswered and I am very disappointed with this purchase as social media integration was one of the reasons I purchased the book. I will also add that I HATE web based content, I buy books because that is the way I want to learn, i admit it is nice to have access to the code to copy and paste if I need to but I can't even access that if I wanted to.
0 of 0 people found the following review helpful.
Great web dev book
By Marvin S Mallari
Why so many 1 star reviews?
This book is great, doesn't hold your hands and moves at a fairly fast pace. In my view, this is not a beginners book but as long as you have a good working knowledge of basic web principles and programming fundamentals from any language this book has great value for anyone wanting to learn PHP.
The MYSQL section is also very informative just not as in depth as the PHP section, however it does enough to get you going with working on the web. The MYSQL section does not dive into deep database design principles, however that is not the scope of this book. I'm glad it kept it simple as the main goals are to get an interactive website up and running.
I have thoroughly enjoyed the book and still am learning
0 of 0 people found the following review helpful.
See all 15 customer reviews...
By Earl Gile
fantastic informative book