emailbroadcasts Database Table

Table: emailbroadcasts

Tool: Email Marketing

Fields

id INT UNSIGNED NOT NULL AUTO_INCREMENT v5

subject VARCHAR(100) NOT NULL v5

body TEXT NOT NULL v5

member INT UNSIGNED NOT NULL v5

added INT UNSIGNED NOT NULL v5

query TEXT NOT NULL v5

begintime INT UNSIGNED NOT NULL v5

ishtml BOOL NOT NULL DEFAULT 0 v5

totalsize MEDIUMINT UNSIGNED NOT NULL v5

locked BIT(1) NOT NULL DEFAULT 0 v5

isbroadcast BIT(1) NOT NULL DEFAULT 0 v5

ismember BIT(1) NOT NULL DEFAULT 0 v5

isadded BIT(1) NOT NULL DEFAULT 0 v5

iscomplete BIT(1) 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 emailbroadcasts");
while ($resRow = $results->fetch_assoc())
{
 $id = $resRow["id"];  //
 $subject = $resRow["subject"];  //
 $body = $resRow["body"];  //
 $member = $resRow["member"];  //
 $added = $resRow["added"];  //
 $query = $resRow["query"];  //
 $begintime = $resRow["begintime"];  //
 $ishtml = $resRow["ishtml"];  //
 $totalsize = $resRow["totalsize"];  //
 $locked = $resRow["locked"];  //
 $isbroadcast = $resRow["isbroadcast"];  //
 $ismember = $resRow["ismember"];  //
 $isadded = $resRow["isadded"];  //
 $iscomplete = $resRow["iscomplete"];  //
}

Other Email Marketing Tables

doubleoptinsettings emailautoresponders emailbroadcasts emaillinkclicks emaillogs emailque emailtemplates removear signatures

Home | Partnership | Testimonials

Privacy/Terms | About Us | Contact Us