PHP code example of joedevsharp / entitylite

1. Go to this page and download the library: Download joedevsharp/entitylite library. Choose the download type require.

2. Extract the ZIP file and open the index.php.

3. Add this code to the index.php. 
    
        
<?php
require_once('vendor/autoload.php');

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

joedevsharp / entitylite example snippets




use EntityLite\Database;

$database = new Database('localhost', 'username', 'password', 'database_name');
$dbConnection = $database->getConnection();




use EntityLite\DbContext;

$dbContext = new DbContext($dbConnection);
$dbContext->addEntity('users', User::class);


$users = $dbContext->users->findAll(); // Retrieves all users




namespace EntityLite;

abstract class Entity {
    public function toArray(): array {
        return get_object_vars($this);
    }
}




use EntityLite\DbSet;

class User extends Entity {
    public $id;
    public $name;
    public $email;
}

// In DbContext
$dbContext->addEntity('users', User::class);


$users = $dbContext->users->findAll();


$user = $dbContext->users->findById(1);


$newUser = new User();
$newUser->name = 'John Doe';
$newUser->email = '[email protected]';

$dbContext->users->insert($newUser);


$existingUser = new User();
$existingUser->name = 'Jane Doe';
$existingUser->email = '[email protected]';

$dbContext->users->update(1, $existingUser);


$dbContext->users->delete(1);




ntityLite\Database;
use EntityLite\DbContext;
use EntityLite\User;

$database = new Database('localhost', 'username', 'password', 'database_name');
$dbConnection = $database->getConnection();

$dbContext = new DbContext($dbConnection);
$dbContext->addEntity('users', User::class);

// Insert a new user
$newUser = new User();
$newUser->name = 'John Doe';
$newUser->email = '[email protected]';
$dbContext->users->insert($newUser);

// Retrieve all users
$users = $dbContext->users->findAll();
foreach ($users as $user) {
    echo $user->name . " - " . $user->email . "\n";
}

// Update a user
$existingUser = new User();
$existingUser->name = 'Jane Doe';
$existingUser->email = '[email protected]';
$dbContext->users->update(1, $existingUser);

// Delete a user
$dbContext->users->delete(2);