PHP and MySQL Web Development - New PHP 7 Coverage

Long acknowledged as the clearest and most practical guide to PHP/MySQL web development, the brand-new Fifth Edition of PHP and MySQL Web Development fully reflects the latest versions of PHP and MySQL to help your students master today's best practices for succeeding with PHP 7 and MySQL 5.7 web database development. New coverage of security, cloud and mobile development, and using the PEAR repository's massive resources have been added to this edition. The authors teach all these things while maintaining the clarity and character that thousands of readers have found so appealing in the book's first four editions.

List of contents

PHP and MySQL Web Development, 5th Edition

Introduction

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 E-commerce and Security
14 Running an E-commerce Site
15 E-commerce Security Issues
16 Web Application Security
17 Implementing Authentication with PHP and MySQL
18 Implementing Secure Transactions with PHP and MySQL

Part IV Advanced PHP Techniques
19 Interacting with the File System and the Server
20 Using Network and Protocol Functions
21 Managing the Date and Time
22 Generating Images
23 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
27 Building User Authentication and Personalization: Social Bookmarking
28 Building a Shopping Cart
29 Building a Content Management System
30 Building a Web-Based Email Service
31 Building a Mailing List Manager
32 Building Web Forums
33 Generating Personalized Documents in Portable Document Format (PDF)
34 Connecting to Web Services with XML and SOAP
35 Building Web 2.0 Applications with Ajax

Part VI: Appendices
A Installing PHP5 and MySQL5
B Web Resources

About the author

Laura Thomson is director of engineering at Mozilla Corporation. She was formerly a principal at both OmniTI and Tangled Web Design, and she has worked for RMIT University and the Boston Consulting Group. She holds a Bachelor of Applied Science (Computer Science) degree and a Bachelor of Engineering (Computer Systems Engineering) degree with honors.

Luke Welling is a software engineer and regularly speaks on open source and web development topics at conferences such as OSCON, ZendCon, MySQLUC, PHPCon, OSDC, and LinuxTag. He has worked for OmniTI, for the web analytics company Hitwise.com, at the database vendor MySQL AB, and as an independent consultant at Tangled Web Design. He has taught computer science at RMIT University in Melbourne, Australia, and holds a Bachelor of Applied Science (Computer Science) degree.

Summary

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.

This practical, hands-on book consistently focuses on real-world applications, even in the introductory chapters. The authors cover important aspects of security and authentication as they relate to building a real-world website and show you how to implement these aspects in PHP and MySQL. They also introduce you to the integration of front-end and back-end technologies by using JavaScript in your application development.

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

23 Integrating JavaScript and 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 (PDF with Product Registration) Building a Web-Based Email Client with Laravel Part I

29 (PDF with Product Registration) Building a Web-Based Email Client with Laravel Part II

30 (PDF with Product Registration) Social Media Integration Sharing and Authentication

31 (PDF with Product Registration) Building a Shopping Cart

Part VI: Appendix

A Installing Apache, PHP, and MySQL

Product details

• Authors: Laura Thomson, Luke Welling
• Publisher: Addison-Wesley
• Languages: English
• Product format: Paperback / Softback
• Released: 01.05.2019
• EAN: 9780321833891
• ISBN: 978-0-321-83389-1
• No. of pages: 688
• Dimensions: 178 mm x 229 mm x 42 mm
• Weight: 1050 g
• Series: Addison-Wesley; Addison-Wesley; Developer's Library
• Subject: Natural sciences, medicine, IT, technology > IT, data processing > Programming languages