PHP & MySQL Web Database Application Development Guide (Second Edition)

Author: (Australia) Williams, (Australia) Ryan, translated by O’Reilly Taiwan Company
Publisher:
Publish Date: 2006-11-01
Features: There are many reasons why a website needs to support dynamic content, including: providing online shopping websites, creating personalized pages, managing large amounts of information from databases, etc. With basic HTML and website management knowledge, anyone can learn PHP and MySQL to create dynamic websites. The purpose of this book is to teach the background knowledge required to create dynamic websites and to use these tools to set up secure and stable websites. "PHP MySQL Web Database Application Development Guide (Second Edition)" reflects the needs of actual programs in detail, carefully exploring external data validation (e.g., the format of credit card numbers), user login, and how to use templates to establish a standard appearance for web pages. The content of this book is not limited to these. It also mentions how to integrate JavaScript and PHP to make user operations faster and more convenient. There are also methods for correctly handling user input errors to make the website look more professional. Additionally, it introduces powerful features from the PEAR extension library, with detailed explanations of commonly used and powerful packages. Although this book is a guide for programming beginners, it does not overlook important techniques needed for websites. Any website that needs to update data will face the issue of multiple users accessing the data simultaneously; when a user clicks the "refresh" button, it may lead to the addition of duplicate records to the database. We have provided relevant solutions for various types of problems. The book emphasizes excellent design concepts, such as separating program logic from page display. This book introduces the features of PHP5 and MySQL4.1, while also providing tips for older versions of the programs. The PEAR package is also one of the highlights of this book. Packages such as templates and database-independent APIs frequently appear in integrated examples and are accompanied by detailed explanations. The content of this book includes:
● Overview of PHP, SQL, and MySQL management
● Session management, including methods to improve efficiency with custom databases
● User input data validation, security protection, and authentication
● PEAR library, with special detailed explanations of PEARDB usage and the Template class
● Generating PDF-formatted reports
There are many reasons why a website needs to support dynamic content, including: providing online shopping websites, creating personalized pages, managing large amounts of information from databases, etc. With basic HTML and website management knowledge, anyone can learn PHP and MySQL to create dynamic websites. The purpose of this book is to teach the background knowledge required to create dynamic websites and to use these tools to set up secure and stable websites. "PHP MySQL Web Database Application Development Guide (Second Edition)" reflects the needs of actual programs in detail, carefully exploring external data validation (e.g., the format of credit card numbers), user login, and how to use templates to establish a standard appearance for web pages. The content of this book is not limited to these. It also mentions how to integrate JavaScript and PHP to make user operations faster and more convenient. There are also methods for correctly handling user input errors to make the website look more professional. Additionally, it introduces powerful features from the PEAR extension library, with detailed explanations of commonly used and powerful packages. Although this book is a guide for programming beginners, it does not overlook important techniques needed for websites. Any website that needs to update data will face the issue of multiple users accessing the data simultaneously; when a user clicks the "refresh" button, it may lead to the addition of duplicate records to the database. We have provided relevant solutions for various types of problems. The book emphasizes excellent design concepts, such as separating program logic from page display. This book introduces the features of PHP5 and MySQL4.1, while also providing tips for older versions of the programs. The PEAR package is also one of the highlights of this book. Packages such as templates and database-independent APIs frequently appear in integrated examples and are accompanied by detailed explanations. The content of this book includes:
● Overview of PHP, SQL, and MySQL management
● Session management, including methods to improve efficiency with custom databases
● User input data validation, security protection, and authentication
● PEAR library, with special detailed explanations of PEARDB usage and the Template class
● Generating PDF-formatted reports