smslogs Database Table

Table: smslogs

Tool: SMS/Voice Marketing
Associated Objects: SMSLog, SMSLogs

Fields

id INT UNSIGNED NOT NULL AUTO_INCREMENT v5

member INT UNSIGNED NOT NULL v5

added INT UNSIGNED NOT NULL v5

contact VARCHAR(255) NOT NULL DEFAULT '' v5

content VARCHAR(255) NOT NULL v5

smsaccount MEDIUMINT UNSIGNED NOT NULL DEFAULT 0 v5

status SMALLINT NOT NULL DEFAULT 0 v5

vendormessageid VARCHAR(255) NOT NULL v5

campaign INT UNSIGNED NOT NULL DEFAULT 0 v5

title VARCHAR(255) NOT NULL 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 smslogs");
while ($resRow = $results->fetch_assoc())
{
 $id = $resRow["id"];  //
 $member = $resRow["member"];  //
 $added = $resRow["added"];  //
 $contact = $resRow["contact"];  //
 $content = $resRow["content"];  //
 $smsaccount = $resRow["smsaccount"];  //
 $status = $resRow["status"];  //
 $vendormessageid = $resRow["vendormessageid"];  //
 $campaign = $resRow["campaign"];  //
 $title = $resRow["title"];  //
}

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