Sloth Framework - Orm

Assume we have models defined in Defining Models

Retrieving A Record By Primary Key

    $user = User::first(1);
    echo $user->name;

Retrieving A Record By Conditions

    $user = User::first('email = ?', 'user@example.com');

By the convention, the Model property name is processed by camelCase. For example, if the users table has column created_time. To get the created_time value through model, you should use: $user->createdTime

Working with CRUD

CREATE

    $user = User::create([
        'name'  => 'Ly Tran',
        'email' => 'prtran@gmail.com',
    ]);

    $user->save();
    echo $user->id;
    // or
    $user = new User();
    $user->name = 'Ly Tran';
    $user->email = 'prtran@gmail.com';

READ

    $users = User::all();
    var_dump($user->toArray());
    echo json_encode($users);

    ///
    $user = User::first(1);

    echo $user->name;
    echo $user->email;
    var_dump($user->toArray());
    echo json_encode($user);

UPDATE

    $user = User::first(1);

    $user->name = 'Ly Tran';
    $user->email = 'prtran@gmail.com';

    $user->save();

    // mass assignment
    $user->fromArray([
        'name'  => 'Ly Tran',
        'email' => 'prtran@gmail.com'
    ]);
    $user->save();

DELETE

    $user = User::first(1);
    $user->delete();