CMS-CSE/core/class/clients.class.php

<?php

class clients
{

    public static function getAll() {
        db::query("SELECT "
            . "* "
            . "FROM " . DB_T_CLIENTS . " "
            . "ORDER BY label ASC");
        return db::resultset();
    }

    public static function insert(string $_client) {
        db::query("INSERT INTO " . DB_T_CLIENTS . " (label) VALUES (:label)");
        db::bind(':label', $_client);

        try {
            db::execute();
            return TRUE;
        } catch (Exception $ex) {
            return FALSE;
        }
    }

    public static function maj(float $_id, string $_tag) {
        db::query("UPDATE " . DB_T_CLIENTS . " SET label = :label WHERE id = :id; ");
        db::bind(':label', $_tag);
        db::bind(':id', $_id);

        try {
            db::execute();
            return TRUE;
        } catch (Exception $ex) {
            return FALSE;
        }
    }

}