seleda/dbeasy

v0.0.6 2024-06-10 16:15 UTC

Requires (Dev)

• phpunit/phpunit: ^8.5

MIT

• Seleda

README

Easy connection and work with the database

Project setup

composer require seleda/dbeasy

Usage

Define global constants before calling:

• _DB_SERVER_
• _DB_USER_
• _DB_PASSWD_
• _DB_NAME_
• _DB_PREFIX_(optional)

or

Seleda\Dbeasy\Db::$_servers = [
    [
        'server' => '',
        'user' => '',
        'password' => '',
        'database' => ''
    ]
];

Methods

Db::getInstance()->insert('table_without prefix', [
    'column' => $value
]);

Db::getInstance()->update('table_without prefix', [
    'column' => $value
], 'condition');

Db::getInstance()->delete('table_without prefix', 'condition');

Executes a query.

Db::getInstance()->execute($qyery);

Executes return the result of $sql as array.

Db::getInstance()->executeS($sql);

Returns an associative array containing the first row of the query This function automatically adds "LIMIT 1" to the query.

Db::getInstance()->getRow($sql);

Returns a value from the first row, first column of a SELECT query.

Db::getInstance()->getValue($sql);