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:
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:
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
Do you want to take your web dev skills to the next level?Discover the power of PHP as you take your web development skills to the next level.
PHP is the most common programming language for server-side web development. One of the best things about this language is that it is fairly easy to learn. In fact, most beginners find the language simple.
This books takes you through the advanced parts of the PHP server-side language, including abstract classes, extend interfaces, object-oriented programming, and many more. You will learn an overview of each topic, teach you how to code each item, and then show you how to expand further.
Discover how to solve problems, establish consistency, and prevent your program from crashing by using the techniques shared in this book. Take your object-oriented programming skills beyond the basics and methods into implementing constructors, destructors, and singletons. Learn how to create exceptions, and explore more ways you can build a flexible software using PHP.
And many more.
Are you ready to launch your PHP coding skills to the next level?
Effective, readable, and robust codes in PHP
PHP is a server-side scripting language that is widely used for web development. With this book, you will get a deep understanding of the advanced programming concepts in PHP and how to apply it practically
The book starts by unveiling the new features of PHP 7 and walks you through several important standards set by PHP Framework Interop Group (PHP-FIG). You'll see, in detail, the working of all magic methods, and the importance of effective PHP OOP concepts, which will enable you to write effective PHP code. You will find out how to implement design patterns and resolve dependencies to make your code base more elegant and readable. You will also build web services alongside microservices architecture, interact with databases, and work around third-party packages to enrich applications. This book delves into the details of PHP performance optimization. You will learn about serverless architecture and the reactive programming paradigm that found its way in the PHP ecosystem. The book also explores the best ways of testing your code, debugging, tracing, profiling, and deploying your PHP application.
By the end of the book, you will be able to create readable, reliable, and robust applications in PHP to meet modern day requirements in the software industry.
This book is for intermediate level developers who want to become a master of PHP. Basic knowledge of PHP is required across areas such as basic syntax, types, variables, constants, expressions, operators, control structures, and functions.
Explore the engine that drives the internet
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 includes numerous examples that demonstrate common tasks such as authenticating users, constructing a shopping cart, generating PDF documents and images dynamically, sending and managing email, facilitating user discussions, connecting to Web services using XML, and developing Web 2.0 applications with Ajax-based interactivity.
The fourth edition of PHP and MySQL Web Development has been thoroughly updated, revised, and expanded to cover developments in PHP 5 through version 5.3, such as namespaces and closures, as well as features introduced in MySQL 5.1.
TABLE OF CONTENTS 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 28 Building a Shopping Cart 29 Building a Web-Based Email Service 30 Building a Mailing List Manager 31 Building Web Forums 32 Generating Personalized PDF Documents 33 Connecting to Web Services with XML and SOAP 34 Building Web 2.0 Applications with Ajax Part VI: Appendixes Appendix A: Installing PHP and MySQL Appendix B: Web Resources
Regardless of whether you run Linux, Windows, or MacOS, the book includes complete instructions to install all the software you need to set up a stable environment for learning, testing, and production.
Step-by-step instructions carefully walk you through the most common web application development tasks.
Practical, hands-on examples show you how to apply what you learn.
Quizzes and exercises help you test your knowledge andÂ stretch your skills.
Learn how to:
â¢Â Build web pages with HTML5 and CSS
â¢ Enhance interactivity with AJAX
â¢ Work with cookies and user sessions
â¢ Get user input with web-based forms
â¢ Use basic SQL commands
â¢ Interact with the MySQL database using PHP
â¢ Write maintainable code and get started with version control
â¢ Decide when frameworks such as Bootstrap, Foundation, React, Angular,
and Laravel can be useful
â¢ Create a web-based discussion forum or calendar
â¢ Add a storefront and shopping cart to your site
PART I Web Application Basics
1 Understanding How the Web Works
2 Structuring HTML and Using Cascading Style Sheets
3 Understanding the CSS Box Model and Positioning
5 Introducing PHP
PART II Getting Started with Dynamic Web Sites
6 Understanding Dynamic Web Sites and HTML5 Applications
10 The Basics of Using jQuery
PART III Taking Your Web Applications to the Next Level
11 AJAX: Getting Started with Remote Scripting
12 PHP Fundamentals: Variables, Strings, and Arrays
13 PHP Fundamentals: Functions, Objects, and Flow Control
14 Working with Cookies and User Sessions
15 Working with Web-Based Forms
PART IV Integrating a Database into Your Applications
16 Understanding the Database Design Process
17 Learning Basic SQL Commands
18 Interacting with MySQL Using PHP
PART V Getting Started with Application Development
19 Creating a Simple Discussion Forum
20 Creating an Online Storefront
21 Creating a Simple Calendar
22 Managing Web Applications
PART VI Appendixes
A Installation QuickStart with XAMPP
B Installing and Configuring MySQL
C Installing and Configuring Apache
D Installing and Configuring PHP
PHP and MySQL in easy steps, 2nd edition teaches the user to write PHP server-side scripts and how to make MySQL database queries. It has an easy-to-follow style that will appeal to:
PHP and MySQL in easy steps, 2nd edition demonstrates by example how to produce data-driven web pages using the powerful PHP scripting language and the popular free MySQL database server. The book examples provide clear syntax-highlighted code showing how to selectively insert and extract data from databases for presentation on your web browser.
PHP and MySQL in easy steps, 2nd edition begins by explaining how to install a free web server, the PHP interpreter, and MySQL database server, to create an environment in which you can produce your very own data-driven server-side web pages. You will learn how to write PHP server-side scripts and how to make MySQL database queries. Examples illustrate how to store and retrieve Session Data, how to provide a Message Board, and how to create an E-Commerce Shopping Cart.
This book assumes you have no previous experience of any programming or scripting language so is ideal for the newcomer to PHP and MySQL technologies.
Covers MySQL 8.0.
Manage research, learning and skills at IT1me. Create an account using LinkedIn to manage and organize your IT knowledge. IT1me works like a shopping cart for information -- helping you to save, discuss and share.