PHP Foundations
Using MySQL from PHP, Part 2  One of PHP's prime benefits is its close integration with databases, especially MySQL. Having explained the basics of MySQL, John Coggeshall turns his attention to demonstrating how to use MySQL from PHP. This week, learn how to count results, handle errors, and handle picky details.   [PHP DevCenter]

Database Templates with MySQL  After designing a few databases for clients, you'll likely start to see design similarities. Why not exploit those patterns to create templates for further customization? Russell Dyer demonstrates how to create and customize generic MySQL table templates.   [ONLamp.com]

PHP Foundations
Using MySQL from PHP  One of PHP's prime benefits is its close integration with databases, especially MySQL. Having explained the basics of MySQL, John Coggeshall turns his attention to demonstrating how to use MySQL from PHP.   [PHP DevCenter]

Web App Security Testing with a Custom Proxy Server  Assuming users will only access your web applications as you intend may be the best way to invite abuse. Attackers have tools to build bogus responses, so why not use the same techniques to toughen your own sites? Nitesh Dhanjani demonstrates how a custom proxy server can help you test the security of your web apps.   [PHP DevCenter]

PHP Foundations
MySQL Crash Course, Part 3  Almost every serious web application uses a relational database to store its data. At some point, you'll have to learn how to use them. John Coggeshall explains how to make the most of the SQL SELECT statement across multiple tables.   [ONLamp.com]

Using PHP 5's SimpleXML  Unless you've worked with SGML, you may find it ironic that XML can be hard to parse. Most choices boil down to event-based parsing, bulky tree-walking, or writing more XML. The upcoming PHP 5 has another option, SimpleXML, that can take the pain out of simple and common XML uses. Adam Trachtenberg explains.   [PHP DevCenter]

PHP Foundations
MySQL Crash Course, Part 2  Almost every serious web application uses a relational database to store its data. At some point, you'll have to learn how to use it. John Coggeshall explains how to change tables, select only the data you want, and delete rows from MySQL.   [ PHP DevCenter]

PHP Foundations
MySQL Crash Course  Almost every serious web application uses a relational database to store its data. At some point, you'll have to learn how to use them. John Coggeshall explains the basics of relational databases with MySQL.   [PHP DevCenter]

Pitfalls of Transactions with PHP  Database transactions are important for data reliability and consistency. Used properly, they can prevent many types of errors. Used improperly, they can cause many other kinds of errors. Kimberlee Jensen demonstrates using transactions with PHP well.   [PHP DevCenter]

PHP Web Services Without SOAP  Web services are hot these days, and SOAP gets a lot of the buzz. It's not the only game in town, though. REST advocates claim their approach is how the Web was meant to be. You decide. Adam Trachtenberg, coauthor of PHP Cookbook, demonstrates how to access Amazon.com's web services with PHP and REST; no special tools needed!   [PHP DevCenter]

Looking into Zend Studio 3.0  Longtime PHP supporter Zend recently released Zend Studio 3.0, a revised and revamped development environment for PHP. PHP Foundations columnist John Coggeshall leaped at the chance to take it for a test drive.   [PHP DevCenter]

PHP Foundations
PHP Security, Part 3  A malicious user will likely start his attack by using your system in ways you never anticipated. Your system logs are an oft-neglected defense tool. John Coggeshall shows how PHP's error logging and reporting functions can help you secure your applications.   [PHP DevCenter]

Modular PHP Development with FastTemplate  Good web developers already have a handle on separating logic from presentation from content. Great web developers know how best to work with their teams. If you're responsible for pulling together developers, designers, localizers, and writers, how can you separate responsibilities in your web application? Daniel Solin explains how his team uses PHP's FastTemplate to keep everyone on track.   [PHP DevCenter]

PHP Foundations
PHP Security, Part 2  If you have users, you'll undoubtedly have bad guys trying to break things. As a developer, it's your responsibility to make sure your code is secure. John Coggeshall explains how system calls from PHP can be exploited -- and how to make them secure.   [PHP DevCenter]

PHP Foundations
PHP Security, Part 1  If you have users, you'll undoubtedly have bad guys trying to break things. As a PHP developer, it's your responsibility to make sure your code is secure. John Coggeshall demonstrates one common PHP error that can leave you vulnerable, and he explains how to think like a bad guy to prevent these mistakes in the first place.   [PHP DevCenter]

PHP Foundations
Common Style Mistakes, Part 2  Writing code well means balancing expressiveness with elegance. Remember, you're writing code that must be maintained. In the second of a series on PHP Paranoia, John Coggeshall gives three tips to write code that's easier to understand.   [PHP DevCenter]

A PHP Web Services Client  Web services are promised to make your life easier. For now, a few companies allow you access to their data through web services APIs. Adam Trachtenberg, coauthor of PHP Cookbook, demonstrates how to write a PHP application to Amazon's web services API.   [PHP DevCenter]

PHP Foundations
Common Style Mistakes, Part 1  Programming securely is more than working down a list of checkboxes. You must adopt a security mindset. In the first of a series called PHP Paranoia, John Coggeshall explains several PHP style mistakes that make writing solid code more difficult.   [PHP DevCenter]

PHP Foundations
Working with Forms in PHP, Part 2  If you're doing any serious work with PHP, you'll eventually have to deal with file uploads. John Coggeshall explains how to process HTTP file uploads with PHP 4.3.   [PHP DevCenter]

The Dynamic Duo of PEAR::DB and Smarty  It can be difficult to separate business logic and formatting in PHP. There are several good templating solutions, though, including the popular and powerful Smarty. Joao Prado Maia demonstrates how to use Smarty with a database back end through the PEAR::DB library.   [PHP DevCenter]

PHP and Heredocs  Tired of having PHP, HTML, and even SQL jumbled together in the same file? Are your designers, coders, and DBAs going crazy trying to keep everything in check? A clean layer of separation can help. Daniel Smith explains how PHP's heredocs can make your life much easier by separating presentation, content, and logic.   [PHP DevCenter]

Ten Security Checks for PHP, Part 2  The same global access that makes web apps useful means that you have to keep on top of security. Though it's easy to create sites in PHP, it's not immune to sloppy coding. Clancy Malcolm explains how to recognize and fix five potential security holes with PHP in the second of two articles.   [PHP DevCenter]

Contact Us | Advertise with Us | Privacy Policy | Press Center | Jobs

Copyright © 2000-2004 O’Reilly Media, Inc. All Rights Reserved.
All trademarks and registered trademarks appearing on the O'Reilly Network are the property of their respective owners.

For problems or assistance with this site, email