smsaccounts Database Table

Table: smsaccounts

Tool: SMS/Voice Marketing
Associated Objects: SMSAccount, SMSAccounts

Fields

key2 VARCHAR(255) NOT NULL v5

id MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT v5

member INT UNSIGNED NOT NULL DEFAULT 1 v5

company TINYINT UNSIGNED NOT NULL DEFAULT 0 v5

phone VARCHAR(20) NOT NULL v5

key1 VARCHAR(255) NOT NULL v5

country VARCHAR(2) NOT NULL DEFAULT 'US' v5

dailylimit SMALLINT UNSIGNED NOT NULL DEFAULT 0 v5

forwardreply BIT(1) NOT NULL DEFAULT 0 v5

storereply BIT(1) NOT NULL DEFAULT 1 v5

key3 TEXT NOT NULL v5

answermessage VARCHAR(255) NOT NULL v5

answersms VARCHAR(255) NOT NULL v5

offtime TINYINT UNSIGNED NOT NULL DEFAULT 0 v5

ontime TINYINT UNSIGNED NOT NULL DEFAULT 0 v5

Example PHP Usage

The following php example is designed for the main folder: /

<?php
include("admin/load/nosession.php");  //Load Database Connection

$results = $mysqli->query("SELECT * FROM smsaccounts");
while ($resRow = $results->fetch_assoc())
{
 $key2 = $resRow["key2"];  //
 $id = $resRow["id"];  //
 $member = $resRow["member"];  //
 $company = $resRow["company"];  //
 $phone = $resRow["phone"];  //
 $key1 = $resRow["key1"];  //
 $country = $resRow["country"];  //
 $dailylimit = $resRow["dailylimit"];  //
 $forwardreply = $resRow["forwardreply"];  //
 $storereply = $resRow["storereply"];  //
 $key3 = $resRow["key3"];  //
 $answermessage = $resRow["answermessage"];  //
 $answersms = $resRow["answersms"];  //
 $offtime = $resRow["offtime"];  //
 $ontime = $resRow["ontime"];  //
}

Other SMS/Voice Marketing Tables

smsaccountextensions smsaccountgroups smsaccounts smsar smsautoresponders smscredits smsfailures smsinbox smskeywords smslogs smsque

Home | Partnership | Testimonials

Privacy/Terms | About Us | Contact Us