mcl/mcldb

维护者

详细信息

github.com/MarceloOProgramador/mcldb

源代码

问题

安装: 15

依赖项: 0

建议者: 0

安全: 0

星标: 0

关注者: 2

分支: 0

开放问题: 0

dev-master 2021-07-07 02:37 UTC

Requires

Requires (Dev)

MIT b422d5af5880d16b58c58f856a436294e12f47f2

This package is auto-updated.

Last update: 2024-09-19 02:57:11 UTC

README

这个库是一个简单的数据库CRUD，包含一些功能。它是由 Marcelo Pereira 为了学习php而私人创建的。

示例

插入示例

$create_instance = new Create();  
$user = [
    "name"  => "Example name",
    "email" => "example@example.com"
];
$table_name = "users";

$create_instance->toCreate($table_name, $user);
$create_instance->exec();

读取示例

$read_instance = new Read();
$table_example = "users";
$read_instance->toRead($table_example)->where("id", "=", 1);
$user = $read_instance->fetch();

更新示例

$table_name = "users"; 
$update_instance = new Update(); 
$read_instance = new Read(); 
 
$read_instance->toRead($table_name)->where("id", "=", 1); 
$user = $read_instance->fetch()[0]; //return array 
 
$user["name"] = "Name updated"; 
$user["email"] = "update@update.com"; 
 
$update_instance->toUpdate($table_name, $user)->where("id", "=", $user["id"]); 
$update_instance->exec(); 
 

$user["name"] = "Name updated";
$user["email"] = "update@update.com";

$update_instance->toUpdate($table_name, $user)->where("id", "=", $user["id"]);
$update_instance->exec();

删除示例

$table_name = "users"; 
$read_instance = new Read(); 
$delete_instance = new Delete(); 
 
$read_instance->toRead($table_name)->where("id", "=", 1); 
$user = $read_instance->fetch()[0];  
 
$delete_instance->toDelete($table_name)->where("id", "=", $user["id"]); 
$delete_instance->exec();