Murach Joel, Harris Ray. Murach’s PHP and MySQL

2nd Edition. — Mike Murach & Associates, 2014. — 896 p., 376 ill. + Code. — ISBN: 978-1-890774-79-0.PHP and MySQL are two of today’s most popular, open-source tools for server-side web programming. And with this book, you’ll learn right from the start how to use them together, the way the pros do. In fact, you’ll create a database-driven website that implements the MVC pattern in the first 6 chapters! Then, the rest of the chapters show you how to build out your PHP and MySQL skills to the professional level.What's new in this edition:
All PHP code has been updated to work with the latest version of PHP.
All HTML and CSS has been updated to use the best HTML5 and CSS3 practices.
Improved coverage of security has been integrated throughout the book, including how to prevent cross-site scripting (XSS) and SQL injection attacks.
A third appendix shows how to install all software and source code on Linux.This book gets you started with PHP and MySQL as quickly as possible and then builds out your skills in a professional way. To present the whole array of PHP and MySQL skills in a manageable progression, this book is divided into four sections.Section 1: Get started fast with PHP and MySQL.
This section is designed to get you off to a fast start whether or not you have any programming experience. So chapter 2 presents a complete subset of PHP; chapter 3 shows you how to use a MySQL database; chapter 4 shows you how to develop database applications with PHP; chapter 5 shows how to structure the code in your applications by using the MVC pattern; and chapter 6 shows you how to test and debug your web applications.This section uses a self-paced approach that lets experienced programmers move more quickly and beginners work at a pace that’s comfortable for absorbing all of the new information. Then, when you finish this section, you’ll understand how all the pieces of a web application fit together, and you’ll be ready for rapid progress in the sections that follow. Most important, you’ll actually be able to build database-driven web applications of your own!Section 2: Master PHP programming.
In this section, you’ll expand your PHP skills to include the professional skills you’ll need on the job every day. That means you’ll soon be coding applications that use arrays, functions, regular expressions, exception handling, libraries, your own objects…and more! The last application in this section illustrates an object-oriented approach to data validation that you can use as a model for data validation in your own applications.Section 3: Master MySQL programming.
In this section, you’ll expand your MySQL and PHP skills to include the skills you need for building full-fledged database-driven web applications.That includes:
how to design a database;
how to use SQL DDL statements to create a database;
how to use SQL DML statements to extract and update the data in a database;
the advanced PHP skills that you need for developing database applications;Section 4: Advanced skills for building websites.
The last section in this book rounds out your web development skills by showing you how to:
secure a website;
send email and access other websites;
work with files, uploads, and images.These are the skills you need to ensure that your web applications come across as trustworthy, reliable, and fully professional to your visitors. Then, the last chapter in this section shows how to put all your skills together in an e-commerce website.Who this book is for:This book is for anyone who wants to learn how to build and maintain websites that use PHP and MySQL. If you have some programming experience, you’ll move through this book more quickly. But because of its self-paced approach, this book also works for beginning programmers.
The only prerequisite for this book is that you have some elementary HTML and CSS skills. If you don’t have these skills or if you want to add to your skill set, you can read Murach’s HTML5 and CSS3.