Application Design
• Use prepared queries and placeholders
– MySQL doesn’t yet support them
– Your API may
– When MySQL does, you benefit!
– The API may be more efficient anyway
– MySQL 4.1 and PHP 5.0 benefit
SELECT name, address, state, zip
  FROM customers
 WHERE id = ?
Copyright 2003, Jeremy Zawodny