Murach J., Harris R. Murach’s PHP and MySQL: training & reference

2nd ed. — Mike Murach and Associates, 2014. — 872 p. — ISBN: 9781890774790.This 2nd Edition does an even better job of delivering the real-world skills you need to develop database-driven websites using PHP and MySQL, two of today's most popular open-source software tools.
Section 1 is a quick-start course that shows how to use the latest versions of PHP, MySQL, the Apache web server, and the NetBeans IDE to build your first PHP applications. And right from the start, you'll learn to create applications that conform to the MVC pattern, so they'll be easier to maintain as they grow.
Then, Section 2 takes you deep into PHP by covering the skills you'll use every day in professional applications, like how to work with form data, dates, arrays, sessions, cookies, functions, objects, regular expressions, and exceptions. Likewise, Section 3 dives into MySQL, teaching you how to design and create a database, as well as how to access and maintain the data in a database like the professionals do. Finally, Section 4 teaches you important web programming skills like how to secure web pages, prevent SQL injection attacks, guard against XSS attacks, send email, upload files, process images, and access content from other websites.
Complete sample applications (all using HTML5 and CSS3) along with chapter exercises provide training support throughout. A great choice for any developer who wants to master PHP without a lot of frustration and unnecessary expense.Introduction to web development with PHP
How to code a PHP application
Introduction to relational databases and MySQL
How to use PHP with a MySQL database
How to use the MVC pattern to organize your code
How to test and debug a PHP application
How to work with form data
How to code control statements
How to work strings and numbers
How to work with dates
How to create and use arrays
How to work with cookies and sessions
How to create and use functions
How to create and use objects
How to use regular expressions, handle exceptions, and validate data
How to design a database
How to use SQL to create a MySQL database
How to use SQL to work with a MySQL database
Professional PHP for working with MySQL
A database-driven website
How to create secure websites
How to send email and access other websites
How to work with files, uploads, and images
An eCommerce website
Appendix A: How to set up Windows for this book
Appendix B: How to set up Mac OS X for this book
Appendix C: How to set up Linux for this book.Joel Murach is the oldest son of publishing pioneer Mike Murach. Joel has been writing and editing books about computer programming for over 20 years now. During that time, he has written extensively on a wide range of Java, .NET, web, and database technologies. He has had best-selling books in all of those categories! In his books, you can see his clear approach to teaching any subject.
Besides being a successful author, Joel is also a very talented musician. He writes and performs for his band, Joel Murach and the Low Rollers with regularity in the Bay Area.Ray Harris has been programming since the age of 12, and he s been teaching since he was in the 8th grade...computer literacy to his friends, programming at grad school, Information Warfare classes in the Air Force, and most recently, information security and web development at the ECPI College of Technology. Those experiences allow him to create books that are accessible to programmers at a wide range of levels, whether he s dealing with introductory concepts or covering the technical intricacies of developing professional websites.