The MySQL Connection Manager for classic (no-ORM) queries

Singleton And Connection Manager

Singleton: one class that (via itself) creates one and only one instance (of itself) if that instance was not created before, and always returns that instance.

ConnectionManager: Class that acts as a a set of singletons, so it creates for each database account one and only one singleton.

The default database account in CakePHP is ‘default’ and it is is of type mysql.

Since most of PHP developers are fans of MySQL (both the mysql and mysqli extensions), I created the class below, to show you how to integrate your old Mysql Connection Manager into the CakePHP framework.

Mysql Connection Manager Class

Downloaded the Mysql Connection Manager From http://github.com/Harake

(I personally put the class in “app\libs\mysql” folder and name it as “mysql_connection_manager.php”)

---

The Changes in your own “app\config\bootstrap.php”

Just add this function

function cn($account = 'default') {
  if (!class_exists('MysqlConnectionManager')) {
    include_once APP . 'libs' . DS . 'mysql' . DS . 'mysql_connection_manager.php';
  }
  return MysqlConnectionManager::connect($account);
}

---

Where and how to use it

In general, it can be used anywhere in your application like this

/*

when you call $c = cn();

you are sure that a MySQL connection is created

if it was not existing (singleton pattern)

*/

$c = cn();
if ($c) {
 //...
 $id = $c->loadValue("SELECT MAX(id) FROM users WHERE status = 1");
 $ids = $c->loadColumn("SELECT id FROM users WHERE status = 1");
 $user = $c->loadSingle("SELECT * FROM users WHERE status = 1 LIMIT 1");
 $users = $c->load("SELECT * FROM users WHERE status = 1");
 //... and many more...just read the class to discover
}

Please leave a comment, If you like this article or have one or more remark(s) on it

function cn($account = ‘default’) {
if (!class_exists(‘MysqlConnectionManager’)) {
if (floatval(Configure::read(‘Cake.version’)) < 1.3) {
include_once APP . ‘libs’ . DS . ‘mysql’ . DS . ‘mysql_connection_manager.php’;
} else {
App::import(‘Lib’, ‘mysql’ . DS . ‘mysql_connection_manager’);
}
}
return MysqlConnectionManager::connect($account);
}

Advertisement