This comprehensive tutorial and reference covers all the basics of PHP 5, a popular open source Web scripting language, and MySQL 4.012, the most popular open source database engine Explores why users need PHP and MySQL, how to get started, how to add PHP to HTML, and how to connect HTML Web pages to MySQL Offers an extensive tutorial for developing applications with PHP and MySQL Includes coverage of how to install, administer, and design MySQL databases independently of PHP; exception and error handling; debugging techniques; PostgreSQL database system; and PEAR database functions The authors provide unique case studies of how and where to use PHP drawn from their own extensive Web experience

MySQL is the leading open source database on the market and PHP continues to dominate the server side of the scripting market—together, they are the most popular and common team for creating dynamic, database-driven web sites. This comprehensive book covers the newest version of PHP and MySQL and is packed with extensive code examples, full working applications, and valuable troubleshooting advice. You’ll explore installing, developing, and debugging the latest versions of PHP and MySQL and get insight on advanced topics such as error handling, debugging, PEAR, security, HTTP, cookies, and OOP.

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.

* Covers why users need PHP, how to get started, how to add PHP to HTML, and how to connect HTML Web pages to MySQL or Oracle databases. * Authors have extensive experience using PHP and provide case studies of how and where to use PHP. * Covers advanced topics, such as HTTP, cookies, Web services, redirection, building graphics, and sessions.

With special focus on the next major release of MySQL, this resource provides a solid framework for anyone new to MySQL or transitioning from another database platform, as well as experience MySQL administrators. The high-profile author duo provides essential coverage of the fundamentals of MySQL database management—including MySQL’s unique approach to basic database features and functions—as well as coverage of SQL queries, data and index types, stores procedure and functions, triggers and views, and transactions. They also present comprehensive coverage of such topics as MySQL server tuning, managing storage engines, caching, backup and recovery, managing users, index tuning, database and performance monitoring, security, and more.

Get the latest word on the biggest self-hosted blogging tool on the market Within a week of the announcement of WordPress 3.0, it had been downloaded over a million times. Now you can get on the bandwagon of this popular open-source blogging tool with WordPress Bible, 2nd Edition. Whether you're a casual blogger or programming pro, this comprehensive guide covers the latest version of WordPress, from the basics through advanced application development. If you want to thoroughly learn WordPress, this is the book you need to succeed. Explores the principles of blogging, marketing, and social media interaction Shows you how to install and maintain WordPress Thoroughly covers WordPress basics, then ramps up to advanced topics Guides you through best security practices as both a user and a developer Helps you enhance your blog?s findability in major search engines and create customizable and dynamic themes Author maintains a high-profile blog in the WordPress community, Technosailor.com Tech edited by Mark Jaquith, one of the lead developers of WordPress The WordPress Bible is the only resource you need to learn WordPress from beginning to end.

An in-depth look at the internals of the WordPress system. As the most popular blogging and content management platform available today, WordPress is a powerful tool. This exciting book goes beyond the basics and delves into the heart of the WordPress system, offering overviews of the functional aspects of WordPress as well as plug-in and theme development. What is covered in this book? WordPress as a Content Management System Hosting Options Installing WordPress Files Database Configuration Dashboard Widgets Customizing the Dashboard Creating and Managing Content Categorizing Your Content Working with Media Comments and Discussion Working with Users Managing, Adding, Upgrading, and Using the Theme Editor Working with Widgets Adding and Managing New Plugins Configuring WordPress Exploring the Code Configuring Key Files wp-config.php file Advanced wp-config Options What's in the Core? WordPress Codex and Resources Understanding and customizing the Loop Building A Custom Query Complex Database Operations Dealing With Errors Direct Database Manipulation Building Your Own Taxonomies Plugin Packaging Create a Dashboard Widget Creating a Plugin Example Publish to the Plugin Directory Installing a Theme Creating Your Own Theme How and When to Use Custom Page Templates How to Use Custom Page Templates Pushing Content from WordPress to Other Sites Usability and Usability Testing Getting Your Site Found How Web Standards Get Your Data Discovered Load Balancing Your WordPress Site Securing Your WordPress Site Using WordPress in the Enterprise Is WordPress Right for Your Enterprise? and much more!

You could think of Setting Up LAMP as four books in one, but it's actually something much more valuable: a single volume that presents the open-source technologies known collectively as LAMP—Linux, Apache, MySQL, and PHP—as tightly dovetailed components of today's most affordable and effective platform for building dynamic web-based applications. Each technology has uses outside of this context, of course, but within it they form something greater than the sum of their parts. This book shows you how to take full advantage of this power, walking you through all the steps required to lay your Linux foundation, install and configure your Apache web server, and then begin using PHP to access content stored in MySQL. Here are a few of the specific topics you'll find covered inside: Installing and configuring qmail with support for IMAP, POP3, SMTP, virtual domains, spam filtering, and antivirus Managing system users and groups Configuring your network Creating a custom firewall script using IP tables Recognizing when a system is in distress Handling MySQL database replication Configuring virtual domains Writing a basic PHP script that integrates with MySQL If you're new to all of this, you'll quickly get to where you need to be to start developing and deploying the higher-level pieces of your web application. Even if you have experience with one or all of these technologies, this book—including its quick-start installation appendix—is a resource you'll want close by whenever you're setting up or fine-tuning your LAMP system.

PHP and MySQL Web Development, Fourth Edition The definitive guide to building database-drive Web applications with PHP and MySQL and MySQL are popular open-source technologies that are ideal for quickly developing database-driven Web applications. PHP is a powerful scripting language designed to enable developers to create highly featured Web applications quickly, and MySQL is a fast, reliable database that integrates well with PHP and is suited for dynamic Internet-based applications. PHP and MySQL Web Development shows how to use these tools together to produce effective, interactive Web applications. It clearly describes the basics of the PHP language, explains how to set up and work with a MySQL database, and then shows how to use PHP to interact with the database and the server. The fourth edition of PHP and MySQL Web Development has been thoroughly updated, revised, and expanded to cover developments in PHP 5 through version 5.3, such as namespaces and closures, as well as features introduced in MySQL 5.1. This is the eBook version of the title. To gain access to the contents on the CD bundled with the printed book, please register your product at informit.com/register