O'Reilly Open Source Convention - August 1-5, 2005

Tutorial
PHP/MySQL Best Practices
Luke Welling, Security Analyst, OmniTI
Laura Thomson, Mozilla Corporation

Track: PHP
Date: Tuesday, August 2nd, 2005
Time: 1:30pm - 5:00pm
Location: Portland 252
Many web programmers use PHP with MySQL. However, lots of hard working programmers work to tight deadlines, are self-taught, and may never have experimented with some of this combination's newer features. In this session, we will look at best practices for using MySQL from PHP, showing how common web development tasks can be made easier, more efficient, or more secure.
Welling and Thomson discuss when and how to use the following features in the web environment:
- Different storage engines
- The MySQL query cache
- Prepared statements for efficiency and protection against SQL injection attacks
- Transactions
- Full text searching
- Subqueries
This tutorial is aimed at programmers who already use PHP and MySQL together, but want to get more out of the pairing.