PHP Solutions or Excel 2003 VBA Programmers Reference

PHP Solutions: Dynamic Web Design Made Easy

Author: David Powers

In this book you'll learn how to:

• Create dynamic websites with design and usability in mind, as well as functionality
• Understand how PHP scripts work, giving you confidence to adapt them to your own needs
• Bring online forms to life, check required fields, and ensure user input is safe to process
• Upload files and automatically create thumbnails from larger images
• Manage website content with a searchable database

You want to make your websites more dynamic by adding a feedback form, creating a private area where members can upload images that are automatically resized, or perhaps storing all your content in a database. The problem is, you're not a programmer and the thought of writing code sends a chill up your spine. Or maybe you've dabbled a bit in PHP and MySQL, but you can't get past baby steps. If this describes you, then you've just found the right book.
PHP and the MySQL database are deservedly the most popular combination for creating dynamic websites. They're free, easy to use, and provided by many web hosting companies in their standard packages. Unfortunately, most PHP books either expect you to be an expert already or force you to go through endless exercises of little practical value. In contrast, this book gives you real value right away through a series of practical examples that you can incorporate directly into your sites, optimizing performance and adding functionality such as file uploading, email feedback forms, image galleries, content management systems, and much more. Each solution is created with not only functionality in mind, but also visual design.
But this book doesn't just providea collection of ready-made scripts: each PHP Solution builds on what's gone before, teaching you the basics of PHP and database design quickly and painlessly. By the end of the book, you'll have the confidence to start writing your own scripts or—if you prefer to leave that task to othersto adapt existing scripts to your own requirements.
Right from the start, you're shown how easy it is to protect your sites by adopting secure coding practices. The book has been written with an eye on forward and backward compatibilityrecommending the latest PHP 5 techniques, but providing alternative solutions for servers still running PHP 4.3. All database examples demonstrate how to use the original MySQL extension, MySQL Improved, or the PHP Data Objects (PDO) introduced in PHP 5.1, letting you choose the most suitable option for your setup.
Summary of Contents:

• Chapter 1: What Is PHPAnd Why Should I Care?
• Chapter 2: Getting Ready to Work with PHP
• Chapter 3: How to Write PHP Scripts
• Chapter 4: Lightening Your Workload with Includes
• Chapter 5: Bringing Forms to Life
• Chapter 6: Uploading Files
• Chapter 7: Using PHP to Manage Files
• Chapter 8: Generating Thumbnail Images
• Chapter 9: Pages That Remember: Simple Login and Multipage Forms
• Chapter 10: Setting Up MySQL and phpMyAdmin
• Chapter 11: Getting Started with a Database
• Chapter 12: Creating a Dynamic Online Gallery
• Chapter 13: Managing Content
• Chapter 14: Solutions to Common PHP/MySQL Problems
• Chapter 15: Keeping Intruders at Bay

Table of Contents:

Summary of contents:

• Chapter 1: What Is PHPAnd Why Should I Care?
• Chapter 2: Getting Ready to Work with PHP
• Chapter 3: How to Write PHP Scripts
• Chapter 4: Lightening Your Workload with Includes
• Chapter 5: Bringing Forms to Life
• Chapter 6: Uploading Files
• Chapter 7: Using PHP to Manage Files
• Chapter 8: Generating Thumbnail Images
• Chapter 9: Pages That Remember: Simple Login and Multipage Forms
• Chapter 10: Setting Up MySQL and phpMyAdmin
• Chapter 11: Getting Started with a Database
• Chapter 12: Creating a Dynamic Online Gallery
• Chapter 13: Managing Content
• Chapter 14: Solutions to Common PHP/MySQL Problems
• Chapter 15: Keeping Intruders at Bay

See also: Bach Flower Remedies for Women or My Child Has Diabetes

Excel 2003 VBA Programmer's Reference

Author: Brian Patterson

What is this book about?

Excel 2003 VBA Programmer's Reference is an updated and expanded version of the two previous editions now with a reference section downloadable from the Web for easy perusal. The book is aimed at Excel users who want to gain more control over their spreadsheets using VBA or who want to develop Excel applications for other users. The book starts with a primer chapter focused on bringing the readers up to speed with Excel and VBA. From there, the book expands to focus on major issues faced by advanced Excel users and developers.

What does this book cover?

In this book, you'll discover how to do the following:

• Set up applications and convert them to add-ins

• Package and distribute Excel applications

• Set up interaction with other Office applications and databases

• Program the VB Editor and use the Windows API

• Use VB6 and VB.NET with Excel

• Set up internationalization

• Advanced debugging and error handling techniques