* This best-selling title has comprehensive discussions about PHP 5, MySQL 5, and how these two popular open source technologies work together to create powerful websites. * Updated to reflect the new features found in MySQL’s most significant release to date. Readers are introduced to advanced database features like triggers, stored procedures, and views. They learn how to integrate these new capabilities into their PHP-driven web applications. The book also discusses PHP’s new MySQL extension, mysqli, which is required for MySQL versions 4.1 and higher. * Packed with hundreds of practical examples covering all aspects of web development, including forms management, templating, database integration, Web services, security, and session handling.

Provides programmers with a complete foundation in MySQL, the multi-user, multi-threaded SQL database server that easily stores, updates, and accesses information Offers detailed instructions for MySQL installation and configuration on either Windows or Linux Shows how to create a database, work with SQL, add and modify data, run queries, perform administrative tasks, and build database applications Demonstrates how to connect to a MySQL database from within PHP, Java, ASP, and ASP.NET applications Companion Web site includes SQL statements needed to create and populate a database plus three ready-to-use database applications (in PHP, Java, and ASP.NET)

* Shows how to take advantage of MySQL's built-in functions, minimizing the need to process data once it's been retrieved from the database. * Demonstrates how to write and use advanced and complex queries to cut down on (middleware) application logic, including nested sub-queries and virtual tables (added since MySQL 4.1). * Points out database design do's and don'ts, including many real-world examples of bad database designs and how the databases were subsequently improved. * Includes a review of MySQL fundamentals and essential theory, such as naming conventions and connections, for quick reference purposes.

Provides programmers with a complete foundation in MySQL, the multi-user, multi-threaded SQL database server that easily stores, updates, and accesses information Offers detailed instructions for MySQL installation and configuration on either Windows or Linux Shows how to create a database, work with SQL, add and modify data, run queries, perform administrative tasks, and build database applications Demonstrates how to connect to a MySQL database from within PHP, Java, ASP, and ASP.NET applications Companion Web site includes SQL statements needed to create and populate a database plus three ready-to-use database applications (in PHP, Java, and ASP.NET)

*The most updated PostgreSQL book on the market, covering version 8.0 *Highlights the most popular PostgreSQL APIs, including C, Perl, PHP, and Java *This is two books in one; it simultaneously covers key relational database design principles, while teaching PostgreSQL

Market_Desc: The primary audience includes PHP beginners, although basic HTML knowledge is useful. Experienced programmers whose current website has outgrown traditional static structure will also benefit from this book offering them a cost-effective way to upgrade and make their website more efficient and user-friendly. Special Features: · Major release of PHP and MySQL are expected late 2008 - this book will cover the updated features of PHP 6 and MySQL 6· Written by experts in a informal tone and is easy for beginners to understand· Provides plenty of tips and explanations with useful, real-world examples· A solid, practical guide for a quick understanding of the PHP, Apache and MySQL stack About The Book: PHP, Apache, and MySQL are the three key open source technologies that form the basis for most active Web servers. This book takes the reader step-by-step through understanding each component - using it and combining it with the others on both Linux and Windows servers. Beginning PHP 6, Apache, and MySQL 6 guide the reader through the process of creating dynamic, data-driven sites, using the open source AMP model: Apache Web server, the MySQL database system, and the PHP scripting language. The team of expert authors cover topics including: new features of PHP 6 and MySQL 6, PHP scripting, database management, security, integration, e-commerce functions, and provide a complete syntax reference.

What is this book about? PHP, Apache, and MySQL are the three key open source technologies that form the basis for most active Web servers. This book takes you step-by-step through understanding each — using it and combining it with the other two on both Linux and Windows servers. This book guides you through creating your own sites using the open source AMP model. You discover how to install PHP, Apache, and MySQL. Then you create PHP Web pages, including database management and security. Finally, you discover how to integrate your work with e-commerce and other technologies. By building different types of Web sites, you progress from setting up simple database tables to tapping the full potential of PHP, Apache, and MySQL. When you’re finished, you will be able to create well-designed, dynamic Web sites using open source tools. What does this book cover? Here's what you will learn from this book: How PHP server-side scripting language works for connecting HTML-based Web pages to a backend database Syntax, functions, and commands for PHP, Apache, and MySQL Methods and techniques for building user-friendly forms How to easily store, update, and access information using MySQL Ways to allow the user to edit a database E-commerce applications using these three technologies How to set up user logins, profiles, and personalizations Proper protocols for error handling Who is this book for? This book is for beginners who are new to PHP and who need to learn quickly how to create Web sites using open source tools. Some basic HTML knowledge is helpful but not essential.