Useful Books and Software

• Install, configure, and troubleshoot a testing environment with PHP/MySQL and Apache or IIS
• Learn the fundamentals of PHP and good database design
• Use Dreamweaver 8 server behaviors to create robust dynamic applications that validate user input for greater security and reliability
• Incorporate live XML feeds into your web pages with PHP and Dreamweaver 8s new XSL Transformation server behavior
• Download and apply a suite of custom-built PHP functions designed exclusively for this book

• Introduction
• Chapter 1: So, You Want to Build Dynamic Sites?
• Chapter 2: Dreamweaver and PHPA Productive Partnership
• Chapter 3: Getting the Work Environment Ready
• Chapter 4: Getting Ready for the Case Study
• Chapter 5: Integrating PHP into Your Site
• Chapter 6: Getting Feedback from an Online Form
• Chapter 7: Putting the Power of a Database
• Chapter 8: Building a Random Quotation Generator
• Chapter 9: Working with Multiple Tables
• Chapter 10: Using Sessions to Track
• Chapter 11: Displaying a Blog and Photo Gallery
• Chapter 12: Using XSLT to Display Live News Feeds and XML
• Appendix A: Using Languages Other Than English in MySQL
• Appendix B: Essential MySQL Maintenance
• Index

New Price: $7.49 / Used Price: $6.99

New Price: $28.99 / Used Price: $20.00

• 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

New Price: $28.00 / Used Price: $28.00

MySQL is one of the most popular database management systems available, powering everything from Internet powerhouses to individual corporate databases to simple end-user applications, and everything in between. And this book will teach you all you need to know to be immediately productive with MySQL. By working through 30 highly focused hands-on lessons, your MySQL Crash Course will be both easier and more effective than you'd have thought possible. Learn how to:

• Retrieve and sort data
• Filter data using comparisons, regular expressions, full text search, and much more
• Join relational data
• Create and alter tables
• Insert, update, and delete data
• Leverage the power of stored procedures and triggers
• Use views and Cursors
• Manage transactional processing
• Create user accounts and manage security via access control

Ben Forta is Macromedia's Senior Technical Evangelist, and has almost 20 years of experience in the computer industry in product development, support, training, and product marketing. Ben is the author of the best-selling Sams Teach Yourself SQL in 10 Minutes (now in its third edition, and translated into over a dozen languages), ColdFusion Web Application Construction Kit, and Advanced ColdFusion Development (both published by Que Publishing), Sams Teach Yourself Regular Expressions in 10 Minutes, as well as books on SQL, Flash, JSP, HomeSite, WAP, Windows 2000, and other subjects.

New Price: $14.89 / Used Price: $14.97

Pro MySQL is the first book that exclusively covers intermediate and advanced features of MySQL, the world's most popular open source database server. Whether you are a seasoned MySQL user looking to take your skills to the next level, or youre a database expert searching for a fast-paced introduction to MySQL's advanced features, this book is for you.

The first part of this book discusses topics related to design and development. Topics include transaction processing and indexing theory, benchmarking and profiling, and advanced coverage of storage engines and data types. The authors also delve deep into the MySQL source code and system architecture at a level you won't find anywhere else. Essential advanced SQL is also covered, with discussion of subqueries, derived tables, and joins. These concepts are demonstrated in a range of situation-specific examplesfrom dealing with hierarchical data to performing Geographic Information System (GIS) examples with just MySQL. This section also covers MySQL 5's new enterprise features like stored procedures, triggers, and views.

The latter part of this book devotes itself to administration topics. Topics include MySQL installation and upgrading, user administration, database backups, replication, and clustering. You'll also learn about the new data dictionary features available in MySQL 5.

New Price: $30.99 / Used Price: $31.29

• Delivering and forwarding mail
• Relaying
• Masquerading
• Routing mail
• Controlling spam
• Strong authentication
• Securing the mail transport
• Managing the queue
• Securing sendmail

New Price: $16.69 / Used Price: $8.68

• Filesystem overview
• Running Java® applications
• System and Network Administration
• Directory Services and NetInfo
• Scripting on Mac OS X Panther
• Using CVS
• Unix Command Reference
• An overview of the Apple® X11 distribution

New Price: $0.75 / Used Price: $0.01

A concise introduction to the fundamentals of working with MySQL.

MySQL is an open-source relational database management system that is rapidly growing in popularity. Known for its speed, reliability, and ease of use, MySQL has proven itself to be particularly well suited both for beginners and for experienced developers to create sophisticated database-backed Web sites and applications.

MySQL Tutorial is a clear, concise introduction to the fundamental concepts and techniques of working with MySQL. It teaches the beginning MySQL user how to create and administer powerful databases that can be used at home, at work, and on the Web.

Whether you are a novice to databases or a technical professional looking to find out more about how MySQL works, MySQL Tutorial efficiently guides you through the information you need in order to get started with MySQL and quickly become proficient.

New Price: $29.99 / Used Price: n.a.

Although MySQL's source code is open in the sense of being publicly available, it's essentially closed to you if you don't understand it. In this book, Sasha Pachev -- a former member of the MySQL Development Team -- provides a comprehensive tour of MySQL 5 that shows you how to figure out the inner workings of this powerful database. You'll go right to heart of the database to learn how data structures and convenience functions operate, how to add new storage engines and configuration options, and much more.

The core of Understanding MySQL Internals begins with an Architecture Overview that provides a brief introduction of how the different components of MySQL work together. You then learn the steps for setting up a working compilable copy of the code that you can change and test at your pleasure. Other sections of the book cover:

• Core server classes, structures, and API
• The communication protocol between the client and the server
• Configuration variables, the controls of the server; includes a tutorial on how to add your own
• Thread-based request handling -- understanding threads and how they are used in MySQL
• An overview of MySQL storage engines
• The storage engine interface for integrating third-party storage engines
• The table lock manager
• The parser and optimizer for improving MySQL's performance
• Integrating a transactional storage engine into MySQL
• The internals of replication

Understanding MySQL Internals provides unprecedented opportunities for developers, DBAs, database application programmers, IT departments, software vendors, and computer science students to learn about the inner workings of this enterprise-proven database. With this book, you will soon reach a new level of comprehension regarding database development that will enable you to accomplish your goals. It's your guide to discovering and improving a great database.

New Price: $27.48 / Used Price: $13.98

New Price: $7.95 / Used Price: $3.29