//-------------------------------------------ČÁST QUERY BUILDERU ---------------//

    public function insertRow($table, array $values)
    {
        $stmt = DbInPrep::insert(self::getColumns($table), $values);
        $query = $this->PDO_connection->prepare("INSERT INTO `$table` ({$stmt['columns']}) VALUES ({$stmt['values']})");
        return $query->execute($values);
    }
    public function getColumns($table)
    {
        $query = $this->PDO_connection->prepare("DESCRIBE $table");
        $query->execute();
        return $query->fetchAll(PDO::FETCH_COLUMN);
    }




//-----------------------------třída pro přípravu sql stringu pro insert--------------------------------//

class DbInPrep
{
    public static function insert($columns, $values)
    {
        self::verifyParamCount($columns, $values) or die("Invalid input");

        return  [
                'columns' => DbInPrep::prepareColString($columns),
                'values' => DbInPrep::prepareValString($values)
                ];

    }
    protected static function prepareColString($columns)
    {
        return implode(", ", $columns);
    }
    protected static function prepareValString($values)
    {
        return implode(",",array_fill(0, sizeof($values), "?"));
    }
    protected static function verifyParamCount($columns, $values)
    {
        if(sizeof($columns) == sizeof($values))
            return 1;
        else
            return 0;
    }
}