Description

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: marceloopromador@gmail.com

• CURRENT VERSION: 1.0.0

• LICENSE: MIT

---

EXAMPLES

INSERT EXAMPLE

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

---

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