PHP and MySQL Web Development: A Beginner’s Guide

by Matthews, Marty

• ISBN13: 9780071837309
• ISBN10: 0071837302
• Edition: 1st
• Format: Paperback
• Copyright: 2014-12-29
• Publisher: McGraw-Hill Education

Summary

Essential Skills—Made Easy!

PHP and MySQL Web Development: A Beginner's Guide takes you from building static web pages to creating comprehensive database-driven web applications. The book reviews HTML, CSS, and JavaScript and then explores PHP--its structure, control statements, arrays, functions, use with forms, and file handling capabilities. Next, the book examines MySQL, including SQL, the MySQL command set, and how to use it with PHP to create a relational database and build secure, databasedriven web applications. This practical resource features complete, step-by-step examples with code that you can use as templates for your own projects.

Designed for Easy Learning

• Key Skills & Concepts--Chapter-opening lists of specific skills covered in the chapter
• Try This--Hands-on exercises that show you how to apply your skills
• Notes--Extra information related to the topic being covered
• Tips--Helpful reminders or alternate ways of doing things
• Cautions--Errors and pitfalls to avoid
• Self Tests--End-of-chapter quizzes to reinforce your skills
• Annotated Syntax--Example code with commentary that describes the programming techniques being illustrated

Ready-to-use code at www.mhprofessional.com

Table of Contents

Part I: Getting Ready
Ch 1: Setting Up Your Programming Workstation
Ch 2: Building Web Pages with HTML
Ch 3: Using CSS and Templates
Ch 4: Adding Dynamic Elements with JavaScript
Part II: Exercising the Server with PHP
Ch 5: Introduction to PHP
Ch 6: Fundamentals of PHP
Ch 7: Reading and Writing Files
Ch 8: User Authentication and Error Handling
Part III: Creating and Using a Relational Database with MySQL
Ch 9: Introduction to Databases, SQL, and MySQL
Ch 10: Fundamentals of MySQL
Ch 11: Adding, Modifying, and Deleting Tables and Records
Ch 12: Querying Tables and Using the Results
Part IV: Powering Databases with PHP and MySQL
Ch 13: Connecting to and Accessing a MySQL Database with PHP
Ch 14: Working with Data, Forms, and Records
Ch 15: Registering Users and Responding to Their Needs
Ch 16: Providing For and Handling Online Purchases