kerim/basedb

Simple PDO database library.

dev-main 2022-08-02 17:45 UTC

MIT

• Kerim Ay

README

Simple PDO database library

Install

composer require kerim/basedb

Usage

use Kerim\Basedb\BaseDB;
BaseDB::method();

Methods:

• connect()
• table()
• where()
• select()
• one()
• all()
• insert()
• update()
• delete()

Connect

use Kerim\Basedb\BaseDB;
BaseDB::connect("dbname", ["user" => "username", "pass" => "password"], "host", "charset")

Table

use Kerim\Basedb\BaseDB;
BaseDB::table("table")

Where

use Kerim\Basedb\BaseDB;
BaseDB::table("table")::where(["key" => "value"])

Select

use Kerim\Basedb\BaseDB;
BaseDB::table("table")::select(["column1", "column2", "..."])
/*** OR ***/
BaseDB::table("table")::select()

One

use Kerim\Basedb\BaseDB;
BaseDB::table("table")::where(["key" => "value"])::select()::one();

All

use Kerim\Basedb\BaseDB;
BaseDB::table("table")::select()::all();

Insert

use Kerim\Basedb\BaseDB;
BaseDB::table("table")::insert([
    "key" => "value",
    "other_key" => "other_value"
])

Update

use Kerim\Basedb\BaseDB;
BaseDB::table("table")::where(["key" => "value"])::update([
    "key" => "changed_value",
])

Delete

use Kerim\Basedb\BaseDB;
BaseDB::table("table")::where(["key" => "value"])::delete();
/*** OR ***/
BaseDB::table("table")::delete();