PHP Classes

PHP PDO Connection Factory: Create PDO objects to connect to a database

Recommend this page to a friend!
     
  Info   Example   View files Files   Install with Composer Install with Composer   Download Download   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
Not enough user ratingsTotal: 515 All time: 5,735 This week: 455Up
Version License PHP version Categories
connection-factory 1.5GNU General Publi...5.1PHP 5, Databases
Description 

Author

Raul

This class can create PDO objects to connect to a database.

It can take an array of parameters to establish a connection with a database using PDO.

The parameters can define values like the database driver name, database host, user, password and database name.

The class may also change individual connection parameters after the class object is created.

In the end it returns an object of the PDO class ready to be used by the application.

Picture of Raul
  Performance   Level  

Level 3 StarStarStar

 

Example

<?php
use Core\lib\db\ConnectionFactory;
/**
 * The test file is in Core folder
 * Place the class on Core/lib/db
 * directory to use autoloading
 */
require_once 'Core/lib/db/ConnectionFactory.php';

$arguments = [
    'driver' => 'mysql',
    'host' => 'localhost',
    'user' => 'root',
    'password' => '',
    'database' => 'dbname',
];

/*PHP 5.4+ style - just connect*/
$pdo = (new ConnectionFactory($arguments))->getLink();

/*PHP 5.3- style - just connect*/
$connectionFactory = new ConnectionFactory($arguments);
$pdo = $connectionFactory->getLink();

/**
 * You can use the method getLink or the alias getConnection() as well
 */
$pdo = $connectionFactory->getConnection();

/**
 * You can set any attribute or driver option
 */
// Attributes (will add on setAttribute PDO's method
$connectionFactory->addAttribute(\PDO::ATTR_CASE, \PDO::CASE_LOWER);
$connectionFactory->addAttribute(\PDO::ATTR_DEFAULT_FETCH_MODE, \PDO::FETCH_OBJ);
// Driver's option (will add on the fourth parameter on PDO constructor)
$connectionFactory->addDriverOption(\PDO::ATTR_PERSISTENT, true);
$connectionFactory->addDriverOption(\PDO::MYSQL_ATTR_MAX_BUFFER_SIZE, 1024 * 1024 * 10);

$pdo = $connectionFactory->getLink();

/**
 * Now you can use all the PDO's methods!
 */


  Files folder image Files (2)  
File Role Description
Files folder imageCore (1 directory)
Accessible without login Plain text file test.php Example Testing file

The PHP Classes site has supported package installation using the Composer tool since 2013, as you may verify by reading this instructions page.
Install with Composer Install with Composer
Downloadconnection-factory-2014-06-30.zip 2KB
Downloadconnection-factory-2014-06-30.tar.gz 2KB
Install with ComposerInstall with Composer
 Version Control Unique User Downloads Download Rankings  
 0%
Total:515
This week:0
All time:5,735
This week:455Up

  Applications that use this package  
No pages of applications that use this class were specified.

Add link image If you know an application of this package, send a message to the author to add a link here.