SMS Extension

The SMS extension lets you send SMS messages to mobile phones. myDBR currently supports sending SMS via Clickatell. Before sending SMS messages, you need to sign up for a Clickatell account.

Configuration

Create an HTTP API integration in the Clickatell Platform and add your Clickatell API key to user/extension_init.php:

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

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;