If you want to learn how to build and maintain websites that use PHP and MySQL, one of the best resources you can find is Murach's PHP and MySQL (3rd Edition) by Joel Murach and Ray Harris. This book is designed to get you started fast with PHP and MySQL, and then build out your skills in a professional way.
In this article, we will give you an overview of what this book covers, why it is different from other books on the topic, and how you can benefit from reading it.
What this book covers
This book is divided into four sections:
Section 1: Get started fast with PHP and MySQL. This section shows you how to use a subset of PHP, how to work with a MySQL database, how to develop database applications with PHP, how to structure your code using the MVC pattern, and how to test and debug your web applications.
Section 2: Master PHP programming. This section covers advanced topics such as object-oriented programming, exception handling, file handling, sessions, cookies, email, web services, security, and authentication.
Section 3: Master MySQL programming. This section teaches you how to design and create databases, how to use SQL statements and stored procedures, how to use transactions and locking, how to optimize database performance, and how to use PHP Data Objects (PDO) to access any database.
Section 4: Master web programming. This section shows you how to use jQuery and Ajax for dynamic web pages, how to use Bootstrap for responsive web design, how to use WordPress for content management systems, and how to deploy your web applications on a web server.
Why this book is different
There are many books on PHP and MySQL, but Murach's book stands out for several reasons:
It uses a self-paced approach that lets you learn at your own speed. Each chapter presents a new topic in a clear and concise way, followed by exercises that let you practice what you have learned.
It uses a paired-pages format that makes it easy to read and understand. On every two-page spread, the left page explains the concepts using plain English and examples, while the right page shows the code and output for those examples.
It uses real-world applications that show you how to use PHP and MySQL in practice. Throughout the book, you will work on two complete web applications: an online music store and a content management system. You will also see how to use popular frameworks and tools such as jQuery, Bootstrap, WordPress, and more.
It covers the latest versions of PHP and MySQL (or MariaDB), as well as the best practices for web development. You will learn how to use features such as namespaces, traits, generators, closures, PDO, prepared statements, mysqli extension, JSON data type, full-text search, etc.
How you can benefit from this book
By reading this book, you will be able to:
Build dynamic websites that use PHP and MySQL (or MariaDB) as the server-side technologies.
Write clean and maintainable code that follows the MVC pattern and object-oriented principles.
Create secure and reliable web applications that handle user input, sessions, cookies, email, web services, etc.
Design and manage databases that store and retrieve data efficiently using SQL statements and stored procedures.
Use jQuery and Ajax for interactive web pages that update without reloading.
Use Bootstrap for responsive web design that adapts to different screen sizes and devices.
Use WordPress for creating content management systems that allow users to edit and publish content online.
Deploy your web applications on a web server using FTP or SSH.
If you are interested in learning more about this book or buying it online,click here. ec8f644aee