README

欢迎来到DatabaseManager，请参阅Wiki！

要求

• PHP 8.1
• MySQL或SQLite

连接到数据库

$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());
}

获取表实例

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

查询

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

查找单个数据

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

查找所有数据

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

查找计数

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

查找isset

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

插入

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

更新

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

更新单列值

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

条件

简单数组

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

扩展数组

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