emaillogs Database Table

Table: emaillogs

Tool: Email Marketing
Associated Objects: EmailLogs, EmailLog

Fields

id INT UNSIGNED NOT NULL AUTO_INCREMENT v5

emailbroadcast INT UNSIGNED NOT NULL v5

contact INT UNSIGNED NOT NULL DEFAULT 0 v5

member INT UNSIGNED NOT NULL DEFAULT 0 v5

added INT UNSIGNED NOT NULL NOT NULL v5

opened TINYINT UNSIGNED NOT NULL DEFAULT 0 v5

smtp VARCHAR(50) NOT NULL v5

note INT 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 emaillogs");
while ($resRow = $results->fetch_assoc())
{
 $id = $resRow["id"];  //
 $emailbroadcast = $resRow["emailbroadcast"];  //
 $contact = $resRow["contact"];  //
 $member = $resRow["member"];  //
 $added = $resRow["added"];  //
 $opened = $resRow["opened"];  //
 $smtp = $resRow["smtp"];  //
 $note = $resRow["note"];  //
}

Other Email Marketing Tables

doubleoptinsettings emailautoresponders emailbroadcasts emaillinkclicks emaillogs emailque emailtemplates removear signatures

Home | Partnership | Testimonials

Privacy/Terms | About Us | Contact Us