SMS Extension

Commands

dbr.sms - Sends SMS messages through the configured provider

Syntax

select 'dbr.sms', [simulate];

Parameters:

• simulate: Optional flag. Set to 1 to simulate sending. When enabled, the provider URL is displayed without performing the actual transmission.

Configuration

To use the SMS extension, create an HTTP API integration on the Clickatell Platform and add your API key to user/extension_init.php:

$mydbr_sms = [ 
    'sender'  => "clickatell",
    'apiKey'  => "your_api_key"
];

Usage

The following example demonstrates how to send SMS messages to recipients from a database:

select 'dbr.sms';

select phone_nr, message
from mydbr.sms_recipients;