PHP code example of market-media / datalayer

    
        
<?php
require_once('vendor/autoload.php');

/* Start to develop here. Best regards https://php-download.com/ */

    

market-media / datalayer example snippets

const DATA_LAYER_CONFIG = [
    "driver" => "mysql",
    "host" => "localhost",
    "port" => "3306",
    "dbname" => "datalayer_example",
    "username" => "root",
    "passwd" => "",
    "options" => [
        PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8",
        PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
        PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_OBJ,
        PDO::ATTR_CASE => PDO::CASE_NATURAL
    ]
];

class User extends DataLayer
{
    /**
     * User constructor.
     */
    public function __construct()
    {
        //string "TABLE_NAME", array ["REQUIRED_FIELD_1", "REQUIRED_FIELD_2"], string "PRIMARY_KEY", bool "TIMESTAMPS"
        parent::__construct("users", ["first_name", "last_name"]);
    }
}

use Example\Models\User;

$model = new User();

//find all users
$users = $model->find()->fetch(true);

//find all users limit 2
$users = $model->find()->limit(2)->fetch(true);

//find all users limit 2 offset 2
$users = $model->find()->limit(2)->offset(2)->fetch(true);

//find all users limit 2 offset 2 order by field ASC
$users = $model->find()->limit(2)->offset(2)->order("first_name ASC")->fetch(true);

// find all users with in operator
$users = $model->find()->in("id", [1, 2, 3])->fetch(true);

//looping users
foreach ($users as $user) {
    echo $user->first_name;
}

//find one user by condition
$user = $model->find("first_name = :name", "name=Robson")->fetch();
echo $user->first_name;

//find one user by two conditions
$user = $model->find("first_name = :name AND last_name = :last", "name=Robson&last=Leite")->fetch();
echo $user->first_name . " " . $user->first_last;

//find one user by condition and with in operator
$user = $model->find("first_name = :name", "name=Robson")->in("last_name",["Menezes", "Sampaio"])->fetch(true);

foreach ($users as $user) {
    echo $user->first_name . " " . $user->first_last;
}

use Example\Models\User;

$model = new User();
$user = $model->findById(2);
echo $user->first_name;

$params = http_build_query(["name" => "UpInside & Associated"]);
$company = (new Company())->find("name = :name", $params);
var_dump($company, $company->fetch());

$addresses = new Address();
$address = $addresses->findById(22);
//get user data to this->user->[all data]
$address->user();
var_dump($address);

use Example\Models\User;

$model = new User();
$count = $model->find()->count();

use Example\Models\User;

$user = new User();
$user->first_name = "Robson";
$user->last_name = "Leite";
$userId = $user->save();

use Example\Models\User;

$user = (new User())->findById(2);
$user->first_name = "Robson";
$userId = $user->save();

use Example\Models\User;

$user = (new User())->findById(2);
$user->destroy();

use Example\Models\User;

$user = (new User())->findById(2);
if($user->fail()){
    echo $user->fail()->getMessage();
}

class User{

    public function fullName(): string 
    {
        return "{$this->first_name} {$this->last_name}";
    }
    
    public function document(): string
    {
        return "Restrict";
    }
}

echo $this->full_name; //Robson V. Leite
echo $this->document; //Restrict

$user = new User();

// Exemplo usando inner JOIN
$results = $user->find("users.status = :s", "s=active", "users.id, users.name, roles.title")
    ->join("roles", "roles.id = users.role_id")
    ->fetch(true);

// Exemplo encadeando múltiplos JOINS (INNER e LEFT)
$complexResult = $user->find(null, null, "users.*, posts.title, logs.created_at")
    ->join("posts", "posts.user_id = users.id")
    ->join("logs", "logs.user_id = users.id", "LEFT")
    ->order("users.name ASC")
    ->fetch(true);

$user = new User();
$address = new Address();

// Inicia a transação
$user->beginTransaction();

// Preenche os dados do usuário
$user->first_name = "João";
$user->last_name = "Silva";

if (!$user->save()) {
    // Se falhar, desfaz a transação e exibe o erro
    $user->rollBack();
    echo $user->fail()->getMessage();
    exit;
}

// Preenche os dados do endereço com o ID do usuário recém-criado
$address->user_id = $user->id; // Aqui o Active Record já populou o ID
$address->street = "Rua das Flores";
$address->number = "123";

if (!$address->save()) {
    // Se o endereço falhar, o usuário criado acima TAMBÉM SERÁ APAGADO (Rollback)
    $address->rollBack();
    echo $address->fail()->getMessage();
    exit;
}

// Se tudo deu certo, consolida as alterações no banco de dados
$user->commit();

echo "Usuário e endereço cadastrados com sucesso!";