``Get(string $name, mixed $default = null): mixed`` Get a value from ``$_GET``. If the value is not set, the default value ``$default`` (``null`` by default) is returned.

``Post(string $name, mixed $default = null): mixed`` Get a value from ``$_POST``. If the value is not set, the default value ``$default`` (``null`` by default) is returned.

``Param(string $name, mixed $default = null): mixed`` Get a value from ``$_POST``. If not set, get the value from ``$_GET``. If still not set, the default value ``$default`` (``null`` by default) is returned.

``Config(mixed ...$args): mixed`` Get/Set config. If value is of array type, dot notation is supported.

``Log(string $msg, array $context = []): void`` Log debug information to the log file. The first argument ``$message`` is a string or an object with a ``__toString()`` method, see [Message](https://www.php-fig.org/psr/psr-3/#12-message) for details. Note that the optional second argument ``$context`` is an ARRAY for adding extra information along the textual message, the array can contain anything. A given value in the context MUST NOT throw an exception nor raise any php error, warning or notice. See [Context](https://www.php-fig.org/psr/psr-3/#13-context) for details.

``Route(int|string|null $idx = null): string|array|null`` Get the route value by index (nth, 0-based) or by name. If ``$i`` unspecified, all route values are returned as array. For example, if you make a request to API like ``/api/hello/world``, the parameters are ``hello/world``, the first value, ``Route(0)``, is the action name "hello", the second value, ``Route(1)``, is "world".

``Conn(string $dbid = "DB"): Connection`` Get the global connection object. If ``$dbname`` is not specified, it returns the connection object for the database of the project. If ``$dbname`` is specified, it returns the connection object for the specified database of a Linked Table.

``Security(): AdvancedSecurity`` Get the global security object

``Language(): Language`` Get the global language object.

``Profile(array ...$args): mixed`` Get the global user profile object.

``Session(mixed ...$args): mixed`` Get the global session object, or get/set attribute(s).

``CurrentUser(): ?UserInterface`` Get current user entity.

``CurrentUserName(): string`` Get current user name.

``CurrentUserEmail(): ?string`` Get current user email. Requires [Email Field](securitysetup.html#options) enabled.

``CurrentUserID(): mixed`` For used with User ID Security (see [Security Settings](securitysetup.html)). Get current User ID.

``CurrentUserLevel(): int`` For used with User Level Security (see [Security Settings](securitysetup.html)). Get current user's User Level ID (integer). (Note NOT current user's permission as integer.)

``CurrentUserInfo(string $fldname): mixed`` For used with Advanced Security (see [Security Settings](securitysetup.html)). Get current user's info from the user table. The argument is the field name in the user table.

``CurrentPageID(): string`` Get current page ID. A page ID identifies the page type, it can be "list", "view", "add", "edit", "delete", "search", etc.

&CurrentPage(): ?object Get current page object.

``CurrentPageName(): string`` Get current page (route) name without path.

``CurrentPageTitle(?string $value = null): string`` Get/Set current page title.

&CurrentTable(): ?DbTablebase Get current table object.

``CurrentTableName(): string`` Get current table name.

``CurrentLanguageID(): string`` Get current language ID.

&Page(string $name = ""): ?object Get page object of another table in the page, e.g. the page object of the master table or detail table. If ``$tablename`` is not specified, it returns ``CurrentPage()``.

``Container(mixed ...$args): mixed`` Get (or create if not exist) object.

``IsLoggedIn(): bool`` For used with Advanced Security (see [Security Settings](securitysetup.html)). Get the login status of the current user.

``IsAdmin(): bool`` For used with Advanced Security (see [Security Settings](securitysetup.html)). Check if the current user is an administrator.

``IsExport(string $format = ""): bool`` Check if the page is exporting data.

``ExecuteQuery(string $sql, Connection|string|null $c = null): \Doctrine\DBAL\Result`` Executes SELECT statement and returns the [Doctrine\DBAL\Result](https://github.com/doctrine/dbal/blob/3.6.x/src/Result.php) instance for accessing the results by [fetch API](https://www.doctrine-project.org/projects/doctrine-dbal/en/current/reference/data-retrieval-and-manipulation.html#using-prepared-statements).

``ExecuteStatement(string $sql, Connection|string|null $c = null): int`` Executes UPDATE, INSERT, or DELETE statements and returns number of rows affected.

``ExecuteRow(string $sql, Connection|string|null $c = null, int $mode = \PDO::FETCH_ASSOC): mixed`` Executes the query, and returns the first row as an array.

``ExecuteRows(string $sql, Connection|string|null $c = null, int $mode = \PDO::FETCH_ASSOC): array|false`` Executes the query, and returns the rows as an array.

``ExecuteScalar(string $sql, Connection|string|null $c = null): mixed`` Executes the query, and returns the first column of the first row.

``ExecuteHtml(string $sql, ?array $options = null, Connection|string|null $c = null): string`` Executes the query, and returns the data as HTML table. See source code for options.

``ExecuteJson(string $sql, array|bool|null $options = null, Connection|string|null $c = null): string`` Executes the query, and returns the data as JSON. See source code for options.

``QueryBuilder(string $dbid = "DB"): QueryBuilder`` Create a [QueryBuilder](https://www.doctrine-project.org/projects/doctrine-dbal/en/current/reference/query-builder.html) for the database connection.

``Insert(string $table): QueryBuilder`` Create a [QueryBuilder](https://www.doctrine-project.org/projects/doctrine-dbal/en/current/reference/query-builder.html) of INSERT statement for the specified table. Also see ``GetFieldParameterType()`` below.

``Update(string $table): QueryBuilder`` Create a [QueryBuilder](https://www.doctrine-project.org/projects/doctrine-dbal/en/current/reference/query-builder.html) of UPDATE statement for the specified table. Also see ``GetFieldParameterType()`` below.

``Delete(string $table): QueryBuilder`` Create a [QueryBuilder](https://www.doctrine-project.org/projects/doctrine-dbal/en/current/reference/query-builder.html) of DELETE statement for the specified table. Also see ``GetFieldParameterType()`` below.

``GetFieldParameterType(string $table, string $field): string|int`` Get the [parameter type](https://github.com/doctrine/dbal/blob/3.6.x/src/ParameterType.php) of a field.

``EntityManager(string $dbid = "DB"): EntityManager`` Get the [EntityManager](https://www.doctrine-project.org/projects/doctrine-orm/en/3.2/reference/architecture.html#the-entitymanager) object. If ``$dbname`` is not specified, it returns the entity manager object for the database of the project. If ``$dbname`` is specified, it returns the entity manager object for the specified database of a Linked Table. For example, if the table is named "Users", the entity class name is the singular form "User". The class is ``Entity\User`` under the namespace of the project.

``SetClientVar(string $key, mixed $value): void`` Pass server side data to client side as a property of the ``ew.vars`` object.

``CreateLoginLink(UserInterface $user, ?int $lifetime = null): LoginLinkDetails`` Create a passwordless [Login Link](authentication.html?id=login-link).

``IsGranted(mixed $attributes, mixed $subject = null): bool`` Check if the attributes are granted against the current authentication token and optionally supplied subject, e.g.

``IsImpersonator(): bool`` Check if the current user is impersonating another user, e.g.

``OriginalUser(): ?UserInterface`` Get the original user when impersonating another user, e.g.

``AddDebugMessage(mixed $message, string $label = "info", bool $isString = true): void`` Write your own debug messages and output to the "Messages" panel of the debug bar. If the data you pass to the first argument ``$message`` is not string, you should set the third argument ``$isString`` as ``false``, then the function will try to dump the data automatically.

``Nonce(): string`` Returns nonce attribute if [Use nonce (strict CSP)](tools.html?id=use-nonce-strict-csp) is enabled, e.g. ``nonce="mDFOblRcXBin0EPgL3bInkIQ"``.

``SendSmsNotification(#[\SensitiveParameter] string $phone, string $content, mixed $region = null, int $format = 0): bool|string`` Send SMS notification. Note that the [SmsNotifier](extension.html?id=additional-extensions-and-custom-view-tags-for-registered-users) extension(for registered users only) must be enabled and you must subscribe to a third party SMS service and retrieve the credentials for the integration.

``SendEmailNotification(#[\SensitiveParameter] string $email, string $subject, string $content): bool|string`` Send simple ext-based email notification. Note that the [Email Settings](phpsetup.html?id=email-settings) must be properly set up.

``SendEmail(string $fromEmail,`` `` string $toEmail,`` `` string $ccEmail,`` `` string $bccEmail,`` `` string $subject,`` `` string $mailContent,`` `` string $format = "html",`` `` string $charset = EMAIL_CHARSET,`` `` int|string $priority = 3,`` `` array $attachments = [],`` `` array $images = []`` ``): string|bool`` Send email. Note that: 1. [Email Settings](phpsetup.html?id=email-settings) must be properly set up. 1. If you send attachments, you should provide full paths, or you can use relative paths if you place the images in the global [upload folder](phpsetup.html?id=file-upload). If you provide the attachment content as string, you can use ["filename" => $filename, "content" => $content] instead of file path for that attachment. 1. If you embed images, you should provide full paths, or you can use relative paths if you place the images in the global [upload folder](phpsetup.html?id=file-upload). Then you can use ```` in your email content, where ``{ContentId}`` can be obtained by ``GetContentId($image)``.

``AddListener(string $eventName, callable|array $listener, int $priority = 0)`` For use with [Event Listeners](customscripts.html?id=event-listeners). The ``AddListener()`` method takes up to three arguments: