duncan3dc/sql

A simple database abstraction layer, with an on disk caching facility

dev-master 2017-08-20 17:35 UTC

Requires

• php: ^7.0
• duncan3dc/php-ini: ^0.1.0

Requires (Dev)

• duncan3dc/object-intruder: ^0.3.0
• mockery/mockery: dev-master
• phpunit/phpunit: ^6.3
• satooshi/php-coveralls: ^1.0

Apache-2.0

• Craig Duncan

• database
• sql
• abstraction
• cache
• mysql
• sqlite
• postgres
• mssql
• odbc
• mysqli
• sqlsrv
• redshift

README

A simple database abstraction layer for PHP, with an on disk caching facility

Full documentation is available at http://duncan3dc.github.io/sql/
PHPDoc API documentation is also available at http://duncan3dc.github.io/sql/api/

Installation

The recommended method of installing this library is via Composer.

Run the following command from your project root:

$ composer require duncan3dc/sql

Getting Started

use duncan3dc\Sql\Sql;
use duncan3dc\Sql\Drivers\Mysql\Server;

require __DIR__ . "/vendor/autoload.php";

$sql = new Sql(new Server($hostname, $username, $password));

$row = $sql->select("table", [
    "field1"    =>  "value1",
]);
print_r($row);

Read more at http://duncan3dc.github.io/sql/

Changelog

A Changelog has been available since the beginning of time

Where to get help

Found a bug? Got a question? Just not sure how something works?
Please create an issue and I'll do my best to help out.
Alternatively you can catch me on Twitter