az26/db

此包的最新版本（v0.3.1）没有可用的许可证信息。

数据库类

维护者

详情

github.com/26az/db

源代码

问题

安装: 13

依赖项: 0

建议者: 0

安全: 0

星标: 0

关注者: 0

分支: 0

开放问题: 0

v0.3.1 2023-07-10 02:14 UTC

Requires

  • php: >=7.0.0
  • ext-pdo: *

Unknown License a77fe3d0113423c1230c96752665703fd793b5df

  • lukeme <luke-me.woop@qq.com>

This package is auto-updated.

Last update: 2024-09-10 04:36:46 UTC

README

use Az26\Util\Db;

require_once '../vendor/autoload.php';
$conf = [
    'driver' => 'mysql',
    'host' => 'localhost',
    'port' => '3306',
    'name' => 'test',
    'user' => 'root',
    'pass' => 'phpts',
    'char' => 'utf8',
];

$db = new Db($conf);

$row = $db->fetchOne("select * from posts limit 1");
vd($db->getSql('posts', $row));
vd($db->getSql('posts', $row, [], 'pgsql'));
vd($row);

批量插入

$rows = [
    ['name' => 'dd', 'sex' => 'f', 'age' => 12], 
    ['name' => 'aa', 'sex' => 'm', 'age' => 12]
];
$db->table('users')->insert($rows);

批量更新

$rows = [
    ['name' => 'dd', 'sex' => 'f', 'id' => 1], 
    ['name' => 'aa', 'sex' => 'm', 'id' => 2]
];
$db->table('users')->update($rows, 'id');

提取

$db->table('users')->order('id', 'desc')->limit(2)->pluck('name', 'id');
1# array (
  19 => 'aa',
  18 => 'dd',
)