Murach's PHP and MySQL (Murach: Training & Reference)

Publisher:This book was developed by the same team that authored Murachs javascript and DOM Scripting, and it has the same strong content organization that lets you focus on what you need to know, when you need to know it. So its a great first book in web programming if youre just starting out: \* It shows you how to get an Apache web server environment set up, so you can test the apps on your computer \* It gives you a quick-start course that shows you how to develop, test, and debug PHP applications that get data from a MySQL database...in just 6 chapters Then, whether youre a beginning or experienced web developer, the rest of the book gives you a full set of professional PHP and MySQL skills: \* The 9-chapter section on PHP teaches you how to build web applications using all the skills that make for a smooth user experience...like how to handle forms, strings, dates, arrays, cookies, sessions, and exceptions \* The 5-chapter section on MySQL teaches you all the standard features you need to know for working with databases...like how to design and create a database and how to use SQL and PHP to work with database data \* The 4-chapter section on advanced skills teaches you how to handle professional requirements, like ensuring security, generating email, processing images, and working with code from other web sites (like YouTube videos)...and it culminates with a Guitar Shop web site that shows how everything in the book ties together Regardless of what youre learning next, each chapter covers skills from the simple to the complex. So you can go deeper and deeper to gain a sophisticated set of web and database skills, at your own pace. So dont wait! Get your copy right away. I think youll be delighted at how quickly youll be creating your own database-driven websites using PHP and MySQL. 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.

Section 1. Get started fast with PHP and MySQL 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 Section 2. Master PHP programming How to work with form data How to code control statements How to work with 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 Master MySQL programming 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 web site Section 4. Master the advanced skills for building web sites How to create secure web sites How to send email and access other web sites How to work with files, uploads, and images An eCommerce web site Reference aids.