View Single Post
  #9 (permalink)  
Old 12-13-2007, 01:41 PM
kgun's Avatar
kgun kgun is offline
WebProWorld 1,000+ Club
WebProWorld MVP
 
Join Date: May 2005
Location: Norway
Posts: 5,681
kgun RepRank 9kgun RepRank 9kgun RepRank 9kgun RepRank 9kgun RepRank 9kgun RepRank 9kgun RepRank 9kgun RepRank 9kgun RepRank 9kgun RepRank 9kgun RepRank 9
Default Re: mySQL Too Many Connections Open error

Quote:
Originally Posted by getmea View Post
I'm not sure if my webhost is PHP 5.0 able yet...
Than you should aske your hoster to upgrade the sooner than later. Using the Database object has the following advenatges:
  1. Encapsulates database connection that makes it more secure. Character escaping is taken care of in the API, so SQL injection attacks is not that threat any longer.
  2. You can

    try { the connection }

    and

    catch (the error) { }

    and continue.
  3. There are drivers for the most important commercial and free database platforms.
  4. Seamless integrate database connection(s) and SQL statements into your code.
Reply With Quote