qwant50/dbconnect

Jazz framework DbConnect component

Jazz framework DbConnect component README

Most popular framework DbConnect component, _(*1)

Override

This is a factory PDO based class. Can store multiple instances of connections. Simple and useful., _(*2)

Installation

The preferred way to install this Jazz framework DbConnect component is through composer., _(*3)

Either run, _(*4)

php composer.phar require "qwant50/dbconnect"

or add, _(*5)

"qwant50/dbconnect": "~1.*.*"

to the require section of your composer.json., _(*6)

Usage

Get instance

$db = DbConnect::getInstance(['connectionName' => 'db1',
                              'host' => '127.0.0.1',
                              'dbname' => 'test',
                              'username' => 'webuser',
                              'password' => 'xxxxxxxx',]);

Get connection

$db = DbConnect::getInstance(['connectionName' => 'db1',
                              'host' => '127.0.0.1',
                              'dbname' => 'test',
                              'username' => 'webuser',
                              'password' => 'xxxxxxxx',])->getConnection();

Example to usage

$db = DbConnect::getInstance(['connectionName' => 'db1',
                              'host' => '127.0.0.1',
                              'dbname' => 'test',
                              'username' => 'webuser',
                              'password' => 'xxxxxxxx',])->getConnection();
$stmt = $db->prepare("SELECT * FROM table_name WHERE login = :login");
$stmt->bindParam(':login', $login);
$stmt->execute();