duncan3dc/sql-class

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

Maintainers

Package info

github.com/duncan3dc/sql-class

pkg:composer/duncan3dc/sql-class

Statistics

Installs: 77 594

Dependents: 1

Suggesters: 0

Stars: 3

Open Issues: 1

Security

Advisories: 0

Aikido package health analysis

1.9.3 2025-03-06 13:50 UTC

Requires

  • php: ^7.2 || ^8.0

Requires (Dev)

Apache-2.0 158a3cc58c16420fbfe4d9159e9c4ea6a025f656

databasesqlabstractioncachemysqlsqlitepostgresmssqlodbcmysqliredshift

This package is auto-updated.

Last update: 2026-06-12 13:19:52 UTC

README

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

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

Build Status Latest Version

Examples

The classes use a namespace of duncan3dc\SqlClass

use duncan3dc\SqlClass\Sql;
$sql = new Sql([
    "mode"      =>  "mysql",
    "hostname"  =>  "localhost",
    "username"  =>  "root",
    "password"  =>  "password",
]);

$row = $sql->select("table_1",[
    "field1"    =>  "one",
    "field2"    =>  "two",
]);

$sql->update("table_1",[
    "field3"    =>  "three",
],[
    "field1"    =>  $row["field1"],
    "field2"    =>  $row["field2"],
])