PHP Programming with MySQL: The Web Technologies Series, 2nd Edition

  • Don Gosselin
  • Diana Kokoska University of Maine
  • Robert Easterbrooks Maine State Office of Information Technology
  • ISBN-10: 0538745843
  • ISBN-13: 9780538745840
  • 712 Pages Paperback 
  • Previous Editions: 2006
  • © 2011 | Published
Request a Copy
 

About The Solution

Overview

This book covers the basics of PHP and MySQL along with introductions to advanced topics including object-oriented programming and how to build Web sites that incorporate authentication and security. After you complete this course, you will be able to use PHP and MySQL to build professional quality, database-driven Web sites.


Additional Product Information

Features/Benefits

  • Enables users to utilize PHP and MySQL to build professional quality, database-driven Web sites, all with open source software.
  • Covers the basics of PHP and MySQL along with advanced topics including object-oriented programming and how to build Web sites that incorporate authentication and security.
  • Short Careful warnings called point out troublesome issues that you need to watch out for when writing PHP scripts.
  • Short Quizzes serve as quick comprehension checks at the end of each major topic assess understanding of the section material.
  • Reinforcement Exercises include both guided and free-form exercises that reinforce the skills learned in the chapter and build on your learning experience by providing additional ways to apply your knowledge in new situations.
  • Discovery Activities apply the skills learned in the chapter to expand the functionality of an ongoing comprehensive Web site project.

What's New

  • Includes enhanced examples and updated exercises and projects. A comprehensive Web development project that applies chapter concepts begins in Chapter 1 and continues through Chapter 10, resulting in a PHP code demonstration site.
  • A new chapter, Handling User Input (Chapter 4), contains a separate, expanded coverage of Web forms and Web templates.
  • Facts, Carefuls, and Pointers are now prominently displayed in the margin for easier identification.
  • Two new appendices provide coverage of Error Handling and Debugging, and Connecting to SQL Server and Oracle Databases.

Table of Contents

1. Getting Started with PHP.
2. Using Functions and Control Structures.
3. Manipulating Strings.
4. Handling User Input.
5. Working with Files and Directories.
6. Manipulating Arrays.
7. Working with Databases and MySQL.
8. Manipulating MySQL Databases with PHP.
9. Managing State Information.
10. Developing Object-Oriented PHP.
Appendix A: Working with XHTML.
Appendix B: Building a Web Development Environment.
Appendix C: Formatting Strings.
Appendix D: Secure Coding with PHP.
Appendix E: Advanced Debugging Techniques.
Appendix F: Connecting to SQL Server and Oracle Databases.
Appendix D: Secure Coding with PHP.

Supplements

Instructor Supplements

Instructor Supplements

All supplements have been updated in coordination with the main title. Select the main title’s "About the Solution" tab, then select "What's New" for updates specific to title's edition. For more information about these supplements, or to obtain them, contact your Learning Consultant.

Instructor's Resource CD-ROM  (ISBN-10: 0538745851 | ISBN-13: 9780538745857)

Now all instructor materials are available on one convenient and easy-to-use CD. Designed to help facilitate classroom instruction, this CD has instructor files unique to the textbook. A variety of ancillaries are included such as data and solution files, syllabi, and PowerPoint presentations. All of these tools can help motivate students and enhance their knowledge and course appreciation. All materials are available online.


Meet the Author

About the Author

Don Gosselin

Don Gosselin is a technical communications expert with more than 20 years of experience, including application development, technical writing, training, and curriculum development. In addition to JavaScript, he has written or contributed to textbooks on Java programming, Microsoft Visual C++, Web design technologies, Web programming languages, XHTML, PHP programming with MySQL, and ASP.NET programming with C# and SQL Server.

Diana Kokoska

Diana Kokoska, a member of the Computer Information Systems program at the University of Maine at Augusta, has taught computer education at the postsecondary level for more than 20 years. She holds an MS in Business Administration from Husson College and a BS in Business Education from the University of Maine. She has taught a full range of Web design and development courses, from client-side scripting languages to server-side applications, at Washington County Community College, Eastern Maine Community College, and Husson College. She has received multiple teaching recognitions, including the national Teacher of Excellence (NISOD) award. She has been married to her husband, John, for more than 30 years, and resides in Bangor, Maine.

Robert Easterbrooks

Robert Easterbrooks has been a software developer for nearly 20 years, with experience in C/C++, Java, PHP and more. He is currently employed as an applications and database developer for the Maine Office of Information Technology, primarily supporting the Department of Environmental Protection. He has a BS in Computer Science from Westfield State College in Westfield, MA and a BS in Computer Information Systems from the University of Maine at Augusta. Bob lives with his wife and two children on a small farm outside of Augusta, Maine.