Practical PHP and MySQL Website Databases

Practical PHP and MySQL Website Databases is a project-oriented book that demystifies building interactive, database-driven websites. The focus is on getting you up and running as quickly as possible. In the first two chapters you will set up your development and testing environment, and then build your first PHP and MySQL database-driven website. You will then increase its sophistication, security, and functionality throughout the course of the book. The PHP required is taught in context within each project so you can quickly learn how PHP integrates with MySQL to create powerful database-driven websites.

Each project is fully illustrated, so you will see clearly what you are building as you create your own database-driven website. You will build a form for registering users, and then build an interface so that an administrator can view and administer the user database. You will create a message board for users and a method for emailing them. You will also learn the best practices for ensuring that your website databases are secure. Later chapters describe how to create a blog, a product catalog, and a simple e-commerce site. You will also discover how to migrate a database to a remote host. Because you are building the interactive pages yourself, you will know exactly how the MySQL and PHP work, and you will be able to add database interactivity to your own websites with ease.

What you’ll learn

• Download and use a free development and test platform.
• Create interactive database-driven websites.
• Learn how to make website databases secure.
• Create sophisticated projects, such as blogs and e-commerce sites.
• Create user friendly and secure interfaces.
• Migrate a site to a remote host.

Who this book is for

Practical PHP and MySQL Website Databases is for web developers who wish to begin designing database-driven websites. The book is an excellent choice for people who have HTML and CSS skills but would also like to learn MySQL and PHP. For readers who have little or no knowledge of PHP, the book will teach enough PHP to complete all the projects in the book. Web developers who are ready to move beyond the basics or who have not kept up-to-date with their MySQL and PHP knowledge will also benefit from Practical PHP and MySQL Website Databases. College and university I.T. teachers will find that Practical PHP and MySQL Website Databases is an excellent set text, the projects would form a basis for students to adapt for their course work.

Table of Contents

Chapter 1: Create and Test a MySQL Database and Table
Chapter 2: Create Web Pages That Interact with Users
Chapter 3: Login/Logout for Members and an Administrator
Chapter 4: Display Membership Tables for the Administrator
Chapter 5: Register Addresses and Phone Numbers
Chapter 6: The Finishing Touches
Chapter 7: Migrating to a Host and Backing Up Your Web Site Database
Chapter 8: Creating a Product Catalog
Chapter 9: Adding Multiple Tables and Other Enhancements
Chapter 10: Creating a Message Board
Chapter 11: E-Commerce: A Brief Introduction
Chapter 12: Troubleshooting Your Database-Driven Web Site