PHP Scripts

• Takes you through your development environment set up
• Covers everything you need to create both standards compliant web sutes, and dynamic web applications
• Teaches several real world techniques using a series of step by step tutorials

What youll learn

• How to set up your ideal development environment, using Mac OSX/Windows, Apache (and IIS on Windows,) Apache, MySQL, and phpMyAdmin
• Creating standards compliant web sites using CS3's XHTML and CSS features
• Creating dynamic web applications using CS3's PHP and Spry Ajax server behaviors
• Building several real world web site functions, such as form validation, random quote generator, search function, user management/login pages, dynamic Ajax gallery, and much more.
• Creating an interface design in Fireworks CS3 and importing it into Dreamweaver CS3.
• How use Dreamweaver CS3's XML functionality, to consume RSS feeds, and create Spry data sets
• Using includes, templates and master detail pages.
• How to publish your site after you've created it

Summary of Contents

• Chapter 1: Dreamweaver CS3Your Creative Partner
• Chapter 2: Building Dynamic Sites with Ajax and PHP
• Chapter 3: Getting the Work Environment Ready
• Chapter 4: Setting Up a PHP Site
• Chapter 5: Adding a Touch of Style
• Chapter 6: Creating a CSS Site Straight Out of the Box
• Chapter 7: Building Site Navigation with the Spry Menu Bar
• Chapter 8: Sprucing Up Content with Spry Widgets
• Chapter 9: Building Online Forms and Validating Input
• Chapter 10: Introducing the Basics of PHP
• Chapter 11: Using PHP to Process a Form
• Chapter 12: Working with PHP Includes and Templates
• Chapter 13: Setting Up MySQL and phpMyAdmin
• Chapter 14: Storing Records in a Database
• Chapter 15: Controlling Access to Your Site
• Chapter 16: Working with Multiple Tables
• Chapter 17: Searching Records and Handling Dates
• Chapter 18: Using XSLT to Display Live News Feeds and XML
• Chapter 19: Using Spry to Display XML
• Chapter 20: Getting the Best of Both Worlds with PHP and Spry

Drupal is one of the most popular content management systems in use today. With it, you can create a variety of community-driven sites, including blogs, forums, wiki-style sites, and much more. Pro Drupal Development was written to arm you with knowledge to customize your Drupal installation however you see fit. The book assumes that you already possess the knowledge to install and bring a standard installation online. Then authors John VanDyk and Matt Westgate delve into Drupal internals, showing you how to truly take advantage of its powerful architecture.

Youll learn how to create your own modules, develop your own themes, and produce your own filters. You'll learn the inner workings of each key part of Drupal, including user management, sessions, the node system, caching, and the various APIs available to you. Of course, your Drupal-powered site isnt effective until you can efficiently serve pages to your visitors. As such, the authors have included the information you need to optimize your Drupal installation to perform well under high-load situations. Also featured is information on Drupal security and best practices, as well as integration of Ajax and the internationalization of your Drupal web site. Simply put, if you are working with Drupal at all, then you need this book.

• This book is written by Drupal core developers.
• Drupal architecture and behavior are mapped out visually.
• Common pitfalls are identified and addressed.
• Chapters provide regular discussion and reference to why things work they way they do, not just how.
• The front matter features a foreword by Dries Buytaert, Drupal founder.

Authors Luke Welling and Laura Thomson's technique aims to get readers going on their own projects as soon as possible. They present easily digestible sections on specific technical processes--"Accessing array contents" and "Using encryption with PHP" are two examples. Each section centers on a sample program that strips the task at hand down to its essentials, enabling the reader to fit the process into his or her own solutions as required. Tables that list options and other nuggets of reference material appear as well, but the many examples and the authors' commentary on them take center stage.

For reference material on MySQL, have a look at Paul DuBois's MySQL. On the PHP side, Web Application Development with PHP 4.0 is excellent. --David Wall

Topics covered:

• The MySQL database server (for both Unix and Windows)
• Accessing MySQL databases through PHP scripting (the letters don't really stand for anything)
• Database creation and modification
• PHP tricks in order of increasing complexity--everything from basic SQL queries to secure transactions for commerce
• Authentication
• Network connectivity
• Session management
• Content customization

Beginning PHP and MySQL: From Novice to Professional, Third Edition offers a comprehensive introduction to two of the most prominent open source technologies on the planet: the PHP scripting language and the MySQL database server. Updated to introduce the features found in MySQLs most significant release to date, readers learn how to take advantage of the latest features of both technologies to build powerful, manageable, and stable web applications.

Essentially three books in one, readers not only profit from extensive introductions to the core features of each technology, but also learn how to effectively integrate the two in order to build robust data-driven applications. Packed with practical examples and insight into the real-world challenges faced by developers based on author W. Jason Gilmore's 7 years of expertise working with these technologies, readers will repeatedly return to this book as both a valuable instructional tool and reference guide.

What youll learn

• The PHP language
• How to back your web site with MySQL
• Templating so that you can apply a consistent design across all pages on your site
• How to authenticate your web site users
• How to use cookies to maintain information (such as items in a shopping cart) while a user is browsing your site

Who is this book for?

This book is written for developers seeking to take advantage of the PHP language and MySQL database to create powerful web applications.

About the Apress Beginning Series

The Beginning series from Apress is the right choice to get the information you need to land that crucial entry-level job. These books will teach you a standard and important technology from the ground up because they are explicitly designed to take you from "novice to professional." Youll start your journey by seeing what you need to knowbut without needless theory and filler. Youll build your skill set by learning how to put together real-world projects step by step. So whether your goal is your next career challenge or a new learning opportunity, the Beginning series from Apress will take you thereit is your trusted guide through unfamiliar territory!

Related Titles

• Beginning PHP 5 and MySQL E-Commerce: From Novice to Professional
• Beginning Ajax with PHP: From Novice to Professional
• PHP 5 Recipes: A Problem-Solution Approach
• Pro PHP Security
• PHP 5 Objects, Patterns, and Practice

The authors use a Talmudic style to explore PHP's capabilities and explain them to their readers, meaning that they like to present code and commentary in close formation, with each enhancing the other. Typically, they'll present a capability generically and show the relevant code. Then they'll dig into variations on the theme, calling attention to required code alterations as they go. This is a book about PHP itself, so practically no attention is paid to PHP Builder or other development tools. Regardless, this book will help you solve programming challenges with PHP, and enable you to write efficient, attractive code. --David Wall

Topics covered: The PHP programming language, for people who are coming to PHP with a bit of programming experience in other languages or who want to expand their existing PHP knowledge beyond the basics. Sections deal with the core language, as well as HTTP session management, database connectivity (to MySQL and Oracle, as well as with PHP Extension and Application Repository--PEAR), graphics file manipulation, XML parsing, and PDF creation. There are instructions for building a PHP extension library in C, as well as a function reference and guide to existing extensions.

Want to assert yourself as a cutting–edge PHP web developer? Take a practical approach, learning by example from author Quentin Zervaas, and discover how to bring together the many technologies needed to create a successful, modern web application.

In Practical Web 2.0 Applications with PHP, PHP, MySQL, CSS, XHTML, and JavaScript/Ajax development techniques are brought together to show you how to create the hottest PHP web applications, from planning and design up to final implementation, without going over unnecessary basics that will hold you back. This book includes must–have application features such as search functionality, maps, blogs, dynamic image galleries, and personalized user areas. The Zend Framework is used extensively to build the application, allowing you to focus on developing the application rather than on reinventing the wheel.

Topics covered include application planning and design; setting up the application framework; using CSS for easier styling; adding dynamic effects the easy way using JavaScript libraries such as Prototype and script.aculo.us; and implementing several must–have web application features such as user login, blogs, dynamic image galleries, search functionality, mapping with Google Maps, and much more. Zervaas covers everything in a practical, tutorial style so you can start working on your own projects as quickly as possible.

• Create cutting–edge PHP/MySQL web applications.
• Implement must–have functionality such as blogs, maps, search functionality, and dynamic image galleries.
• Master styling with CSS and dynamic effects using Ajax/JavaScript libraries.

What you’ll learn

• How to set up the perfect PHP/MySQL application development environment
• How to implement basic user management functionality
• How to use many of the components from the Zend Framework
• How to effectively make use of the Prototype and script.aculo.us JavaScript libraries, including many examples of developing custom JavaScript classes
• How to create standards–compliant and accessible HTML code and effectively style it using CSS
• How to create a basic blog system and enhance it with Ajax
• How to add personalized user areas to your web application
• How to create a dynamic image gallery
• How to add search functionality to your application
• How to use the Google Maps API to add maps to your application
• How to implement popular Web 2.0 features, such as microformats, tags, and web feeds

Who is this book for?

This book is for any PHP developer who wants to stay ahead of the curve, with practical, high–level web application development techniques.

About the Apress Practical Series

The Practical series from Apress is your best choice for getting the job done, period. From professional to expert, this series lets you apply project–motivated templates (or frameworks) step by step in a very direct, practical, and efficient manner toward current real–world projects that may be sitting on your desk. So whatever your career goal, Apress can be your trusted guide to take you where you want to go on your IT career empowerment path.

Related Titles from Apress

• Beginning PHP and MySQL: From Novice to Professional, Third Edition
• PHP 5 Objects, Patterns, and Practice
• Beginning PHP and MySQL E-Commerce: From Novice to Professional, Second Edition

DuBois organizes his cookbook's recipes into sections on the problem, the solution stated simply, and the solution implemented in code and discussed. The implementation and discussion sections are the most valuable, as they contain the command sequences, code listings, and design explanations that can be transferred to outside projects. The main gripe readers will have about MySQL Cookbook is that the author, in his effort to cover the range of MySQL-friendly programming languages, uses different languages in his solutions to various problems. You'll see a Perl solution to one programming challenge (Perl, in fact, is the most frequently used language, followed by PHP), a Python fix for the next, and a Java sample after that. Readers have to hope that they find a solution in the language they're working with, or that they're able to transliterate the one DuBois has provided. It's usually not a big problem. --David Wall

Topics covered: How to make MySQL databases do your bidding--in terms of queries, table manipulation, data formatting, transactions, and Web interfaces--through the database server's command line interfaces and (more importantly) through the MySQL APIs of Perl, PHP, Java, and Python. Particularly excellent coverage deals with formatting dates and times, management of null values, string manipulation, and import/export techniques.

Instead of starting at "Hello World," Wicked Cool PHP assumes that you're familiar with the language and jumps right into the good stuff. After you learn the FAQs of life-the most commonly wished for PHP scripts-you'll work your way through smart configuration options and the art of forms, all the way through to complex database-backed scripts.

Wicked Cool PHP contains a wide variety of scripts to process credit cards, check the validity of email addresses, template HTML, and serve dynamic images and text. The 76 easily implemented scripts will also teach you how to: