Installation

Installation of ezSQL

The following instructions outlines how to get started with ezSQL. From here it is recommended to check out the detailed examples.

Version 4.x (latest)

Note: Composer is required for version 4. Head to the composer website if you don't already have it installed.

composer require ezsql/ezsql

Default initialization

<?php
require 'vendor/autoload.php'; // Needed to load composer autoloader

use ezsql\Database; // Load ezSQL Database Class

$db = Database::initialize('****', [user, password, database, other settings], **optional tag);

You can also initialize your database with the following alternative initialization

<?php
require 'vendor/autoload.php'; // Needed to load composer autoloader

use ezsql\Config; // Load ezSQL Config Class
use ezsql\Database\ez_****; // Load ezSQL driver Class

$settings = new Config('****', [user, password, database, other settings]);
$db = new ez_****($settings);

Note: **** is one of mysqli, pgsql, sqlsrv, sqlite3, or pdo.

---

Examples of connections with v4

1. MySQLi Connection

<?php
require 'vendor/autoload.php'; // Needed to load composer autoloader
use ezsql\Database; // Load ezSQL Database Class

// FORMAT - DB_USER, DB_PASSWORD, DB_NAME
$db = Database::initialize('mysqli', [''ezsql_user', 'ezsql_password123', `ezsql_database`]);

2. PDO MySQL Connection

<?php
require 'vendor/autoload.php'; // Needed to load composer autoloader
use ezsql\Database; // Load ezSQL Database Class

// FORMAT - DB_HOST/DB_NAME/DB_CHARSET, DB_USER, DB_PASSWORD
$db = Database::initialize('pdo', ['mysql:host=localhost;dbname=ezsql_database;charset=utf8', 'ezsql_user', 'ezsql_password123']);

3. PDO pgSQL Connection

<?php
require 'vendor/autoload.php'; // Needed to load composer autoloader
use ezsql\Database; // Load ezSQL Database Class

// FORMAT - DB_HOST/DB_NAME/DB_CHARSET, DB_USER, DB_PASSWORD
$db = Database::initialize('pdo', ['pgsql:host=localhost;dbname=ezsql_database;charset=utf8', 'ezsql_user', 'ezsql_password123']);

4. PDO SQLite Connection

<?php
require 'vendor/autoload.php'; // Needed to load composer autoloader
use ezsql\Database; // Load ezSQL Database Class

// FORMAT - SQLITE_DB
$db = Database::initialize('pdo', ['sqlite:./db/ezsql_database.sqlite', '', '', array(), true]);

5. PDO SQLSRV Connection

<?php
require 'vendor/autoload.php'; // Needed to load composer autoloader
use ezsql\Database; // Load ezSQL Database Class

// FORMAT - DB_HOST/DB_NAME, DB_USER, DB_PASSWORD
$db = Database::initialize('pdo', ['sqlsrv:Server=localhost;Database=ezsql_database', 'ezsql_user', 'ezsql_password123']);

6. PostgreSQL Connection

<?php
require 'vendor/autoload.php'; // Needed to load composer autoloader
use ezsql\Database; // Load ezSQL Database Class

// FORMAT - DB_USER, DB_PASSWORD, DB_NAME, DB_HOST, DB_PORT
$db = Database::initialize('pgsql', ['ezsql_user', 'ezsql_password123', 'ezsql_database', 'localhost', '5432']);

7. SQLite Connection

<?php
require 'vendor/autoload.php'; // Needed to load composer autoloader
use ezsql\Database; // Load ezSQL Database Class

// FORMAT - SQLITE_DB_DIR, SQLITE_DB
$db = Database::initialize('sqlite3', ['./db/ezsql_database/', 'ez_test.sqlite3']);

8. SQLSRV Connection

<?php
require 'vendor/autoload.php'; // Needed to load composer autoloader
use ezsql\Database; // Load ezSQL Database Class

// FORMAT - DB_USER, DB_PASSWORD, DB_NAME
$db = Database::initialize('sqlsrv', ['ezsql_user', 'ezsql_password123', 'ezsql_database']);

More detailed examples can be found in the tests folder

Version 3.x

Note: Composer is not required for version 3.x, but it is recommended.

composer require ezsql/ezsql=^3.1.2

Default initialization Using Composer

<?php
require 'vendor/autoload.php'; // Needed to load composer autoloader

$db = new ezSQL_****(user, password, database, or, other settings);

Alternative initialization manually downloading

Manually download https://github.com/ezSQL/ezSQL/archive/v3.zip and extract it to your required web directory.

<?php
require 'ez_sql_loader.php'; // Require path to where you extracted your ezSQL v3 file

$db = new ezSQL_****(user, password, database, or, other settings);

Note: **** is one of mysqli, pgsql, sqlsrv, sqlite3, or pdo.