README

安装

在终端运行

composer require kisphp/database:~2.0.0

然后在 PHP 文件中添加

<?php

require 'vendor/autoload.php';

连接到数据库

<?php

use Kisphp\Kisdb;

$db = Kisdb::getInstance();
$db->connect(
    $databaseHost,      // localhost
    $databaseUsername,  // root
    $databasePassword,  // {brank}
    $databaseName       // test
);

数据库插入

$db->insert('table_name', '数据数组');

如果需要 INSERT IGNORE 语法，则将第三个参数传递为 true

$db = Kisdb::getInstance();

$db->insert('test_table', [
    'column_1' => 'value_1',
    'column_2' => 'value_2',
]);

// will return last_insert_id

$insertIgnore = true;
$db->insert(
    'test_table',
    [
        'column_1' => 'value_1',
        'column_2' => 'value_2',
    ],
    $insertIgnore
);
// will execute INSERT IGNORE ...

数据库更新

$db->update('table_name', '数据数组', '条件值', '列名 (默认=id)');

$db = Kisdb::getInstance();

$db->update('test_table', [
    'column_1' => 'value_1',
    'column_2' => 'value_2',
], 20);

// will return affected_rows

获取单个值

$db = Kisdb::getInstance();

$value = $db->getValue("SELECT column_1 FROM test_table");

获取成对值

$db = Kisdb::getInstance();

$pairs = $db->getPairs("SELECT id, column_1 FROM test_table");

/*
will result
$pairs = [
     '1' => 'c1.1',
     '2' => 'c2.1',
     '3' => 'c3.1',
];
*/

获取自定义查询

$db = Kisdb::getInstance();

$query = $db->query("SELECT * FROM test_table ");

while ($item = $query->fetch(\PDO::FETCH_ASSOC)) {
    var_dump($item);
}