On the SitePoint PHP blog today there's a new post from Craig Buckler looking at his top ten MySQL mistakes he as a PHP developer has made over time (and suggests a few things so they can keep from making them again).
database is a fundamental component for most web applications. If you're using PHP, you're probably using MySQL - an integral part of the LAMP stack. PHP is relatively easy and most new developers can write functional code within a few hours. However, building a solid, dependable database takes time and expertise. Here are 10 of the worst MySQL mistakes I've made (some apply to any language/database).
Some of the infamous mistakes that made the list include:
- Using PHP's mysql functions (instead of mysqli)
- Not sanitizing user input
- Not using UTF-8
- Not optimizing your queries
- Using * in SELECT queries