Murach’s PHP and MySQL, 2nd Edition

“I can’t count how many PHP books I have purchased over the years trying to learn the language. Murach’s was the first book that helped me grasp the concepts and got me onto actually scripting in PHP.”

That’s what one developer said in an online review of the first edition of Murach’s PHP and MySQL. Now, 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.

Table of Contents

Section 1 Get started fast w ith PHP and MySQL
Chapter 1 Introduction to web developtnent with PHP
Chapter 2 How to code a PHP application
Chapter 3 Introduction to relational databases and MySQL
Chapter 4 How to use PHP with a MySQL database
Chapter 5 How to use the MYC pattern to organize your code
Chapter 6 How to test and debug a PHP applicaton

Section 2 Master PHP programming
Chapter 7 How to work with form data
Chapter 8 How to code control statetnents
Chapter 9 How to work with strings and numbers
Chapter 10 How to work with dates
Chapter 11 How to create and use arrays
Chapter 12 How to work with cookies and sessions
Chapter 13 How to create and use functions
Chapter 14 How to create and use objects
Chapter 15 How to use regu lar expressions, handle exceptions, and validate data

Section 3 Master MySQL programming
Chapter 16 How to design a database
Chapter 17 How to use SQL to create a MySQL database
Chapter 18 How to use SQL to work with a MySQL database
Chapter 19 Professional PHP for working with MySQL
Chapter 20 A database-driven website

Section 4 Master the advanced skills for building websites
Chapter 21 How to create secure websites
Chapter 22 How to send email and access other websites
Chapter 23 How to work with files, uploads, and itnages
Chapter 24 An eCom1nerce website

Appendix A How to set up Wi ndows for this book
Appendix B How to set up Mac OS X for this book
Appendix C How to set up L inux for this book