News Feed
Sections




News Archive
Looking for more information on how to do PHP the right way? Check out PHP: The Right Way

SitePoint PHP Blog:
Top 10 MySQL Mistakes Made by PHP Developers
November 19, 2010 @ 08:33:16

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
0 comments voice your opinion now!
mysql mistake recommendation topten


blog comments powered by Disqus

Similar Posts

Bill Staples' Blog: IIS7 in the Community

Ilia Alshanetsky's Blog: MySQL Binaries and cURL/http extensions in PHP

O\'Reilly: $lamp =~ /^Linux,\\s*Apache,\\s*MySQL,P(?:hp|ython|erl[56])$/

SitePoint PHP Blog: Top 10 MySQL Mistakes Made by PHP Developers

Internet Super Hero Blog: MySQL native driver for PHP: mysqlnd-5.0.1-beta available


Community Events





Don't see your event here?
Let us know!


code voicesoftheelephpant framework list bugfix introduction conference interview community zendserver laravel language api symfony podcast tips release threedevsandamaybe series deployment

All content copyright, 2014 PHPDeveloper.org :: info@phpdeveloper.org - Powered by the Solar PHP Framework