onebytesolutions/database

Database Library - A dependency injection based Database Class

v1.6 2023-09-01 20:00 UTC

Requires

• php: >=7.2

GPL-3.0-or-later

• Jason Bryan

• database
• mysql
• pdo

README

Database Library - A dependency injection based Database Class

### Table of Contents

Installation
Initialization
Insert Query
Insert Batch Query
Update Query
Select Query
Delete Query
Raw Query

About

This software was developed during my free time and is free to use.

Installation

Composer

composer require onebytesolutions/database

Initialization

Simple initialization:

use OneByteSolutions\Database\Database,
    OneByteSolutions\Database\Adapters\PdoAdapter;

// set db config
$db = [
    'host' => 'localhost',
    'user' => 'db-username',
    'pass' => 'db-password',
    'database' => 'database-name'
	// OPTIONAL: ,'port' => 3308 
];

// try to connect to the database
try {
    $database = new Database(new PdoAdapter($db));
    $database->connect();
}catch (\Exception $e){
    echo "Unable to connect: ".$e->getMessage();
}

Insert Query

Simple example

// example of inserting a new user, with transactions
$database->beginTransaction();
try {
    $row = [
        'name' => 'John Doe',
        'email' => '[e-mail]'
    ];
    $id = $database->insertRow("users", $row);
    $database->commit();
    
    echo 'inserted id: '.$id;
} catch(\Exception $e){
    echo 'insert failure';
    $database->rollBack();
}

Insert Batch Query

Simple example

// example of inserting a bunch of rows
$rows = [];
$rows[] = [
        'name' => 'John Doe ',
        'email' => '[e-mail]'
];
$rows[] = [
        'name' => 'Jane Doe ',
        'email' => '[e-mail]'
];
$rows[] = [
        'name' => 'Sarah Doe ',
        'email' => '[e-mail]'
];
$database->insertRowBatch("users", $rows);

Update Query

// example of updating a row
$database->updateRowWhere("user", ["lastLogin" => time()], "id", 1);

Select Query

// example of fetching a query as an array
$sql = "SELECT * FROM users LIMIT 30";
$params = [];
$results = $database->queryToArray($sql, $params);

echo '<pre>'.print_r($results,true).'</pre>';

Delete Query

// example of deleting a row
$database->deleteWhere("users", "id", 1);

Raw Query

// example of running raw sql
$database->run("UPDATE users SET name = :name", ['name' => 'Alex Doe']);