kerim/basedb

简单的PDO数据库库。

维护者

详细信息

github.com/kerimay1/basedb

源代码

问题

安装: 0

依赖: 0

建议者: 0

安全: 0

星标: 0

关注者: 1

分支: 0

开放问题: 0

dev-main 2022-08-02 17:45 UTC

MIT 9fcb2e8b44b4591922e4c4dbf7ce9839227d07cb

  • Kerim Ay <aykerim0505.woop@gmail.com>

This package is auto-updated.

Last update: 2024-09-30 01:54:29 UTC

README

简单的PDO数据库库

安装

composer require kerim/basedb

用法

use Kerim\Basedb\BaseDB;
BaseDB::method();

方法

连接

use Kerim\Basedb\BaseDB;
BaseDB::connect("dbname", ["user" => "username", "pass" => "password"], "host", "charset")

表

use Kerim\Basedb\BaseDB;
BaseDB::table("table")

条件

use Kerim\Basedb\BaseDB;
BaseDB::table("table")::where(["key" => "value"])

选择

use Kerim\Basedb\BaseDB;
BaseDB::table("table")::select(["column1", "column2", "..."])
/*** OR ***/
BaseDB::table("table")::select()

一个

use Kerim\Basedb\BaseDB;
BaseDB::table("table")::where(["key" => "value"])::select()::one();

所有

use Kerim\Basedb\BaseDB;
BaseDB::table("table")::select()::all();

插入

use Kerim\Basedb\BaseDB;
BaseDB::table("table")::insert([
    "key" => "value",
    "other_key" => "other_value"
])

更新

use Kerim\Basedb\BaseDB;
BaseDB::table("table")::where(["key" => "value"])::update([
    "key" => "changed_value",
])

删除

use Kerim\Basedb\BaseDB;
BaseDB::table("table")::where(["key" => "value"])::delete();
/*** OR ***/
BaseDB::table("table")::delete();