Offering a step-by-step walk through understanding the three key open source technologies that form the basis for most active web servers, this book demonstrates how to quickly create a professional-looking, functional site using Apache Web server, the MySQL database system, and the PHP scripting language. You’ll take an in-depth look at why the combination of PHP, MySQL, and Apache has become so popular: flawless interaction, flexibility, customization, and cost, as well as their ability to run on both Linux and Windows servers.

MySQL 5.0 Certification Study Guide (MySQL Press)

Product Description

This is the official guide to passing the two MySQL certification tests for MySQL 5, the long-awaited major revision of MySQL. The number of MySQL certification exams taken has doubled in the last six months.

Certcities.com lists the MySQL certification as one of the top 10 certifications to grow in 2005. MySQL professionals need a way to distinguish themselves from the vast majority of database administrators and developers. With more than 4 million active installations, MySQL is the world’s most popular open-source database. Known for its speed, reliability and case of use, MySQL has become a low-cost alternative to expensive database systems such as Oracle, IBM and Microsoft. MySQL AB has aggressively improved the feature set of MySQL with MySQL 5, making it more suitable for enterprise-level applications and uses. The MySQL certification tests, available at over 3,000 PearsonVUE testing centers, is a key component of this enterprise growth strategy, establishing a base level of skills for database users, administrators and programmers

The MySQL Core Certification is aimed at the database user who wants proof of his or her abilities in such fundamental areas as SQL, data entry and maintenance, and data extraction. The MySQL Professional Certification test is designed for the advanced user who wants to prove his or her knowledge in such areas as database management, installation, security, disaster prevention and optimization. Both tests are thoroughly covered in the MySQL 5.0 Certification Study Guide. Written by Paul DuBois, the leading author of books on MySQL topics, and reviewed for technical accuracy by MySQL AB, this book is the fastest, most reliable way for MySQL users, developers, and administrators to prepare for either of the MySQL tests.

PHP and MySQL Everyday Apps For Dummies is a one-stop reference providing all you need to build dynamic, real-world, ready-to-use apps with the popular PHP (a scripting language) and MySQL (a database system) software. The book is a hands-on, go-to-guide that
Walks you through installing the applications files from the CD-ROM and setting up your programming environment

Contains all the code needed to create seven applications:
User authentication with HTTP
User login
On-line catalog
Shopping cart
Content management system
Web forum
Building and managing a mailing list (on the CD-ROM)
Automates the programming process and walks you through building the application from start to finish

Explains how to write secure code

Features complete code—not just snippets, but neatly assembled packages with “instant” real-world functionality

Shows how to build the applications in two forms — procedural and object-oriented programming — providing programmers who want to switch to the object-oriented method of coding (which is new in PHP 5!) with the essential know-how

Includes a companion CD-ROM that contains every line of code in the applications from the book plus a bonus chapter that shows how to build a mailing list

Information on each application includes a discussion of issues, structure of the database, code listings, and an explanation of the code. You can use these applications as is, modify them for use on your Web site, or build your own application using techniques described. If you want real-world Web apps you can use right away, this is the book for you.