krzysztofzylka/database-manager

Database Manager

v1.0.33 2024-04-30 20:07 UTC

Requires

• php: >=8.1
• ext-pdo: *
• krzysztofzylka/arrays: ^1.0.0

MIT

• krzysztofzylka

README

Hi in DatabaseManager, see Wiki!

Required:

• PHP 8.1
• MySQL or SQLite

Connect to database

$databaseManager = new \krzysztofzylka\DatabaseManager\DatabaseManager();

try {
    $connect = \krzysztofzylka\DatabaseManager\DatabaseConnect::create()
        ->setType(\krzysztofzylka\DatabaseManager\Enum\DatabaseType::mysql)
        ->setDatabaseName('database')
        ->setUsername('username')
        ->setPassword('password');
    
    $databaseManager->connect($connect);
} catch (\krzysztofzylka\DatabaseManager\Exception\DatabaseManagerException $exception) {
    die($exception->getHiddenMessage());
}

Get table instance

$table = new \krzysztofzylka\DatabaseManager\Table('table name')

Query

$table = new \krzysztofzylka\DatabaseManager\Table('table name');
var_dump($table->query('sql'));

Find single data

$table = new \krzysztofzylka\DatabaseManager\Table('table name');
var_dump(
    $table->find()
);

Find all data

$table = new \krzysztofzylka\DatabaseManager\Table('table name');
var_dump(
    $table->findAll()
);

Find count

$table = new \krzysztofzylka\DatabaseManager\Table('table name');
var_dump(
    $table->findCount()
);

Find isset

$table = new \krzysztofzylka\DatabaseManager\Table('table name');
var_dump(
    $table->findIsset()
);

Insert

$table = new \krzysztofzylka\DatabaseManager\Table('table name');
$table->insert([
    'column' => 'value'
])

Update

$table = new \krzysztofzylka\DatabaseManager\Table('table name');
$table->setId('element id')->update([
    'column' => 'new value'
])

Update single column value

$table = new \krzysztofzylka\DatabaseManager\Table('table name');
$table->setId('element id')->updateValue('column', 'new value');

Conditions

Simple array

$conditions = [
    'column' => 'value',
    'column2' => 'value'
];

Extended array

$conditions = [
    'column' => 'value',
    new \krzysztofzylka\DatabaseManager\Condition('column', '>', 5),
    new \krzysztofzylka\DatabaseManager\Condition('column', 'LIKE', '%value%')
];