Jon Stephens

PHP 5 Recipes: A Problem-Solution Approach supplies you with complete code for all of the common coding problems you are likely to face when using PHP in your day-to-day work. The book begins with an in-depth discussion of PHP 5 object-oriented techniques and methodology, and gets you up to speed on OOP with PHP: where and where not to use it, and how to use it. This invaluable guide includes over 200 recipes and covers numerous topics: math, arrays, automation, security, graphics, regular expressions, web basics, HTML forms, database access, date and time, variables and functions, and internationalization and localization. Help yourself achieve a winning edge with this one-of-a-kind cookbook.

Nearly every non-trivial application requires data persistence, and for an application of any significant size and scope, persistence is typically realized using a database. For open source and many other projects, the MySQL database is a very popular choice: it’s free; it’s fast, robust, and scalable; and it runs on all of the major platforms, allowing maximal use of available hardware resources. However, it’s easy to throw away MySQL’s speed and other advantages if your database design is inefficient. Needlessly duplicating data, using improper types for columns, overloading a single table where multiple tables should be used, failing to leverage the calculation features of MySQL, and making multiple queries instead of efficient, single query are some of the common mistakes. MySQL Database Design and Optimization, shows you how to identify, overcome, and avoid gross inefficiencies, and demonstrates how to maximize the many data manipulation features that MySQL has built-in. MySQL Database Design and Optimization explains how to include tests and branching in your queries, how to normalize your database, and how to issue concurrent queries to boost performance, among many other design and optimization topics. If you’re building or maintaining any significant application and are using MySQL, this book is for you. Ur innehållet: Introduction.- Review of MySQL Basics.- Keys, Indexes, and Normalization.- Operators, Functions and Branching.- Joins, Temporary Tables, and Transactions.- Finding the Bottlenecks.- Looking Ahead to MySQL 4 - 1 and MySQL 5.

When developing a web site, one of the most important things to consider is the navigation menu, to allow your users to find their way around it. It needs to usable, informative, and well implemented, but this can take time. This book will take all the hassle out of implementing web menus, in whatever style and technology you wish, by providing full code samples, along with walkthrough tutorials on how they work to allow easy customisation for your own needs. This book covers: a. Guidelines on designing usable web menus, with 12 common-sense rules to follow b. Information Architecture for menus (including identifying your target user), and user testing c. Easy to Follow tutorials on building menus with HTML, JavaScript, CSS and Flash d. Advanced tutorials on dynamically populating menus from XML and databases with server-side scripting, including PHP and ASP e. Extensive Web support including fully adaptable downloadable code for your own use, and a gallery of working menu examples. From the Publisher This book is for intermediate to advanced web professionals who need to implement a navigation menu on a web site as quickly as possible, with the minimum of hassle. About the Author Andy Beaumont is a freelance interactive developer/designer based in central London. As a firm believer in the "sharing of knowledge" ethos that has made the Flash community so strong, Andy writes Flash tutorials for the likes of pixelsurgeon.com and Computer Arts magazine, teaches Flash and ActionScript at Mac Uni in London, and runs a personal Flash help site. As something of an ActionScript mercenary Andy has worked with many top design agencies including magneticNorth, Conkerco and Broadsnout. Dave Gibbons is a writer and web designer from Beaverton, Oregon, US. He recently worked for five years as a writer, Web/Intranet Designer and programmer, and usability tester at Intel.When not losing sleep over proper menu design, Dave writes humor ("humour" in the rest of the English-speaking world), novels, and screenplays. Jon Stephens is a site developer, writer, and consultant living and working in Scottsdale, Arizona, Jon Stephens works with JavaScript, PHP and in producing technical documentation for area firms. He's an original member of CNET's Builder Buzz developers' site, and has served there as a Community Leader since 1998. Jon has co-authored two books on HTML and JavaScript for Wrox Press.

Creating a usable e-commerce application is a daunting challenge. There is so much to do, from the initial concept, through to designing and coding the application. This leaves a lot of scope for things to go wrong. In this book we take all the hassle out of online shopping applications, by showing you how to plan your application, design the user interface and data store, and code the entire thing. Ur innehållet: E-Commerce and Shopping Carts.- Information Architecture for Shopping Systems.- User Interface and Interaction Design.- DataStore.- Product Display.- The Shopping Cart.- Checkout Time.- Staying Secure.- Resources.

Forms are an integral part of many web sites, whether they are registration forms, feedback forms, or order forms. However, forms are time consuming for the site user to fill out, and need to be implemented to be as usable as possible, otherwise they can be frustrating and annoying, spoiling the user experience. This book takes all the hassle out of implementing forms in whatever way you wish, dealing with client-side forms in HTML and Flash, client- and server-side form validation, and server-side data processing. It provides code samples fully adaptable to your own needs, along with walkthrough tutorials on how they work, and an HTML form element reference. INCLUDES: * Easy to Follow tutorials and reference on building form user interfaces with HTML and Flash * Tips to follow for designing usable forms * Client- and server-side data validation techniques using JavaScript, ASP and PHP * Server-side data processing using ASP and PHP, with Access and MySQL databases * Coverage of .NET Forms * Extensive online support, including fully operational, downloadable code and a gallery of working form examples From the Publisher This book is for intermediate to advanced web professionals who need to implement a form on a web site as quickly as possible, with the minimum of hassle. About the Author Chapter 1: HTML Forms Chapter 2: Designing Usable Forms Chapter 3: Flash Forms Chapter 4: Using Forms with ASP Chapter 5: Using Forms with PHP and MySQL Chapter 6: Form Validation Techniques Chapter 7: Advanced Client-side Form Scripting Chapter 8: Forms in ASP.NET