starter-kit-sql

PHP singleton for PDO

Requirements

• PHP >= 5.3
• PHP PDO extension

Installation

Install directly via Composer:

$ composer require starter-kit/sql

Basic Usage

<?php

// Require your autoloading script (Composer autoload here) to use namespaces
require_once 'vendor/autoload.php';

use StarterKit\SQL\SimplePDO;

// First instanciation : pass your DB parameters
$PDOInstance = SimplePDO::getInstance('YOUR_DB_NAME', 'YOUR_DB_SERVER', 'YOUR_DB_PORT', 'YOUR_DB_USER', 'YOUR_DB_PASSWORD');

// Later in your code : you can retrieve your instance at any time, without creating new PDO connection
$query = SimplePDO::getInstance()->prepare('SELECT * FROM YOUR_DB_TABLE');
$res = $query->execute();