PHP and MySQL Web Development - P97: PHP and MySQL Web Development teaches the reader to develop dynamic, secure, commercial Web sites. Using the same accessible, popular teaching style of the first edition, this best-selling book has been updated to reflect the rapidly changing landscape of MySQL and PHP. | 452 Chapter 22 Using PHP and MySQL for Large Projects Using Zend Products Zend Technologies owns the Open Source PHP scripting engine for used in PHP 4 onward. In addition to the basic engine you can also download the Zend Optimizer. This is a multi-pass optimizer that will optimize your code for you and can increase the speed at which your scripts run from 40 to 100 .You will need PHP or upward to run the optimizer. Although closed source it is free for download from Zend s site http This add-on works by optimizing the code produced by the runtime compilation of your script. Other Zend products include the Zend Studio Zend Accelerator Zend Encoder and commercial support agreements. Testing Reviewing and testing code is another basic point of software engineering that is often overlooked in Web development. It s easy enough to try running the system with two or three test cases and then say yup it works fine. This is a commonly made mistake. Ensure that you have extensively tested and reviewed several scenarios before making the project production ready. We suggest two approaches you can use to reduce the bug level of your code. You can never eliminate bugs altogether but you can certainly eliminate or minimize most of them. First adopt a practice of code review. This is the process in which another programmer or team of programmers look at your code and suggest improvements. This type of analysis will often suggest Errors you have missed Test cases you have not thought of Optimization Improvements in security Existing components you could use to improve a piece of code Additional functionality Even if you work alone it can be a good thing to find a code buddy who is in the same situation and review code for each other. The second suggestion that we have is that you find testers for your Web applications who represent the end users of the product. The primary difference between Web applications and desktop applications is that anyone and everyone