Kimai_Database_Mysql::name2id PHP Method

name2id() private method

Query a table for an id by giving the name of an entry.
Author: sl
private name2id ( string $table, string $endColumn, string $filterColumn, integer $value ) : string | boolean
$table string
$endColumn string
$filterColumn string
$value integer
return string | boolean
    private function name2id($table, $endColumn, $filterColumn, $value)
    {
        $filter[$filterColumn] = MySQL::SQLValue($value);
        $filter['trash'] = 0;
        $columns[] = $endColumn;
        $result = $this->conn->SelectRows($table, $filter, $columns);
        if ($result == false) {
            $this->logLastError('name2id');
            return false;
        }
        $row = $this->conn->RowArray(0, MYSQLI_ASSOC);
        if ($row === false) {
            return false;
        }
        return (int) $row[$endColumn];
    }
Kimai_Database_Mysql