dbutil/crud

一个用于创建、读取、更新和删除应用程序数据的项目的工具。

维护者

详细信息

github.com/eric-araujo/CRUD

源代码

问题

安装: 8

依赖项: 0

建议者: 0

安全: 0

星标: 0

关注者: 1

分支: 0

开放问题: 0

v1.0.1 2022-03-10 11:50 UTC

Requires

  • php: >=7.4.0

MIT ecfa1de2d0bf5be62ee2f8d5f79961fffcdf074a

crudupdateinsertdeletereadcreate

This package is auto-updated.

Last update: 2024-09-10 17:42:21 UTC

README

Badge Badge Badge Badge Badge Badge

📄 项目描述

一个用于创建、读取、更新和删除应用程序数据的项目的工具。

⏬ 下载说明

composer require dbutil/crud

📋 使用示例

📦 实例化类

$connection = new PDO(
    'mysql:host=localhost;dbname=agent_atw',
    'root',
    '123456'
);

$crud = new Crud($connection);

🗃 选择数据

$selectUsers = "SELECT * FROM users WHERE ic_status = true ORDER BY dt_include DESC";

$results = $crud->selectData($selectUsers);

💾 插入数据

$data = array(
    "nm_user" => "ElicX2",
    "nm_email" => "elic@gmail.com.br",
    "nm_password" => "123456"
);

$table = "users";

$columnsThatWillBeFilled = array(
    "nm_user",
    "nm_email",
    "nm_password",
);

$saved = $crud->saveData($data, $table, $columnsThatWillBeFilled);

📝 更新数据

$data = array(
    "nm_user" => "Lic",
    "nm_email" => "lic@gmail.com.br",
);

$table = "users";

$where = "WHERE id_user = 4 AND ic_status = true";

$updated = $crud->updateData($data, $table, $where);

🗑️ 删除数据

$table = "users";

$where = "WHERE id_user = 4 AND ic_status = true";

$deleted = $crud->deleteData($table, $where);