Model

Prerequisites

• An already structured database must exist
• The SLSQL script must be imported

How to use?

Create new Model

Example 1:

class Users extends Model
{
    public $name, $psw, $email, $id;
}

Example 2:

class Users extends Model
{
    public $name, $psw, $email, $id;
    public function __construct($name, $password, $mail = "test", $id = null)
    {
        $this->id = $id;
        $this->name = $name;
        $this->psw = $password;
        $this->email = $mail;
    }
}

Use new Model

Example 1:

$user = new Users();
$user->name = "CreBast";
$user->psw = "123";
$user->email = "[email protected]";
$user->Save();

Example 2:

$user = Users::get()->firstOrDefault()

Methods

Model

save()

Save object on database :

$user = new Users();
$user->name = "Bastien"; // Actually not on DB
$user->Save(); // Now yes

get(condition = null, $arr = array())

Get list of 'Users' with condition :

$user = Users::get('id = ? or id = ?', array(1, 2));
// Return ListModels() with users with ids 1 and 2 (if exist)

remove()

Remove object on database :

$user = Users::get('id = ?', array(1))->first();
$user->remove()
// Remove user with id 1

ids()

Return all ids on one list :

$user_ids = Users::ids();
// Return : array(1, 2, 3, ...)

all(field = 'id')

Return all values of field on list :

$all_names = Users::all("name");
// Return : array(Bastien, José, Bastien, ...)

allDistinct()

Return all values of field on list (distinct) :

$all_names = Users::all("name");
// Return : array(Bastien, José, ...)

count()

Count number of objects :

$number = Users::count();
// Return : number

countWhere(condition = null, $arr = array())

Count with condition :

$number = Users::countWhere('name = ?', array('Bastien');
// Return : number

ListModels

add(Model)

Add new elements on ListModels() :

$listModels = new ListModels;
$listModels->add(new Users);

all()

Return one list with all datas :

$users = Users::get()->all();
// Return all users

firstOrDefault(default value = null)

Return the first user returned. With default value if nothing :

$user = Users::get()->firstOrDefault(false);
// Return the first user returned. If nothing : false

first()

Return the first user returned :

$user = Users::get()->first();
// Return the first user returned. If nothing : null

lastOrDefault()

Return the last user returned. With default value if nothing :

$user = Users::get()->lastOrDefault(false);
// Return the last user returned. If nothing : false

last()

Return the last user returned :

$user = Users::get()->last();
// Return the last user returned. If nothing : null