Murach’s PHP and MySQL
This book is for any developer who wants to learn how to develop professional-level web applications using PHP and MySQL.
If you’re new to web programming, this book will get you going faster and better than any other book on the market. If you already have some web programming experience, this book lets you learn new skills whenever you have a few minutes. And new or experienced, this is the ideal reference for PHP and MySQL programming because you simply can’t remember the countless details that are required.
The only prerequisite for this book is that you have basic HTML and CSS skills. If you don’t have these skills, you can get them by reading the first 6 chapters of Murach’s HTML5 and CSS3.
Anytime you’re on the web, you’re going to be landing on PHP pages. By most counts, over a million web sites have been written in PHP, including some of today’s largest, most recognizable sites. And those sites often use MySQL as the database.
That means there’s a continuing demand for web developers who know how to use PHP and MySQL at the professional level. With this book, you can become one of them!
This book teaches developers how to build database-driven web applications using two of today s most popular open-source software tools, PHP and MySQL.
To get you off to a fast start, the first 6 chapters teach you how to develop, test, and debug your first PHP applications. That includes getting data from MySQL databases and structuring your PHP applications the right way, using the MVC pattern.
Then, Section 2 takes you deeper into PHP, moving from the simple to the complex as it covers the professional skills you ll use every day in coding your applications .skills like how to work with form data, dates, arrays, sessions, cookies, functions, objects, and regular expressions, and how to handle exceptions in a way that makes sense to your site visitors. Section 3 then dives into MySQL, teaching you how to design and create a database, as well as giving you more skills for accessing and maintaining database data like a pro. Finally, Section 4 teaches you the specialized web skills you need for certain web sites, like how to secure web pages, send email, upload files, process images, and access content (like YouTube videos) from other web sites to incorporate into your own. Full coding examples and chapter exercises provide training support throughout. A great read for any developer who wants to master PHP.
What you’ll learn in this book
If you look at the table of contents, you’ll see that this book teaches all the skills you need to develop almost any type of database-driven web site with PHP and MySQL. The chapters gradually move from the simple to the complex as they show you how to work with:
- the PHP language
- the MySQL database
- the SQL statements for MySQL
- the PDO and mysqli extensions
- the MVC pattern
- debugging and exception handling
- sessions and cookies
- object-oriented PHP
- regular expressions and data validation
- SSL and secure connections
- authentication and login forms
- email and content from other sites (like YouTube)
- file uploads
- and more!
What’s more, within each chapter, the topics also move from the simple to the complex, so you can push your skills as far as you want to. Then, the chapter exercises let you practice what you’ve learned.
To complete your training, the last chapter presents an overview of an eCommerce web site. Then, you can download the PHP and MySQL code for free, to see how it puts the skills you’ve learned into context. Once you understand how this web site works, you will have all the skills and code you need to start creating your own database-driven web sites.