mcl/mcldb

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

Requires

• php: ^7.4
• vlucas/phpdotenv: ^5.3

Requires (Dev)

• phpunit/phpunit: ^9.2

MIT

• Marcelo Pereira

README

This libary is a simple database CRUD with some functions. It is created with private intention of studying php by Marcelo Pereira.

• Github: https://github.com/MarceloOProgramador

• E-mail: [e-mail]

• CURRENT VERSION: 1.0.0

• LICENSE: MIT

EXAMPLES

INSERT EXAMPLE

$create_instance = new Create();  
$user = [
    "name"  => "Example name",
    "email" => "[e-mail]"
];
$table_name = "users";

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

READ EXAMPLE

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

UPDATE EXAMPLE

$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"] = "[e-mail]"; 
 
$update_instance->toUpdate($table_name, $user)->where("id", "=", $user["id"]); 
$update_instance->exec(); 
 

$user["name"] = "Name updated";
$user["email"] = "[e-mail]";

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

DELETE EXAMPLE

$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();