Web Marketing Tool
Reseller
Chris B.
MemberNotifyEmails
Login

MemberNotifyEmails


An object for getting a list of member notification emails.
Filename: /admin/tools/WMT\SQL\Member.php
Database Table: membernotifyemails
Extends: Results
      Extends: AbstractDatabase


MemberNotifyEmails PHP Methods

addApostrophe($nField, $newField) v4.92

addConditionalContent($cField, $cValue, $cTilde, $cContent) v4.3

Allows you to have dynamic data displayed in the results for each record that has a column that matches a specific value. If the value of the $cField column equals $cValue then $cContent is replaced with the value of $cTilde for that record inside the results returned. If $cField does not match $cValue then $cTilde is replaced with a blank value |
$cField = The name of the column in the database to use to compare against value. |
$cTilde = The title of the tilde used in the string used for formatting the results (exa: ~mytilde~). |
$cContent = The content that replaces the tilde in the records that contain a match.

addDate($dField, $nDate) v4.2

This method allows you to have a timestamp value to be formatted as a date in the results that are returned. |
$dField = The column name of the record that contains a time stamp |
$nDate = The format of the date to return. Follows the same format as the date() php function.

addMethod($fField, $fName) v4.3

Adds a method to be called and used to get the value for a column field in the results. The value returned by the method is used. |
$tField = The name of the column that should use the method to get it's value. |
$fName = The name of the method belonging to the corresponding LCPSResult object that should be called.

addMoney($nField) v4.92

addSmartDate($dField, $displayType = 1, $showTime = -1, $showYear = -1, $abbrMonth = 1, $abbrDay = 0, $abbrOther = 0, $relType = 1) v4.92

addValueLabel($dField, $labelArray) v4.3

This method allows you to have a column that contains integers replaced with value of an array where they key of the array matches the value of the integer in the column. |
$dField = The column name of the records that contain an integers that should have their values replaced |
$nDate = An array where the key of the array maps to the value inside the results column that is defined by $dField. The value of that array is then used in place of the value in the column wherever the column value matches a key in the array. If the value of the column does not have a corresponding key in the array then the column value is used without being substituted.

getArray($nField, $whereQuery = '', $orderQuery = '') v4.3

Returns an array of results from the database table. The key used in the array is the id of the record in the database. The value of the array is the value of the column specified by $nField. |
$nField = The name of the column to use for the value of the array that is returned. |
$whereQuery = The condition to use to filter the results that are returned. Should be formatted using mysql syntax. If blank returns all records in the database table. |
$orderQuery = The order with which the array should be sorted. If blank the array is sorted by the value of $nField ascending. Should be formatted using mysql syntax.

getCount() v4.2

Returns the amount of results found once the object has been loaded using a loadXXXX() method.

getIDArray($idTitle = null) v4.92

getObjects($query) v4.92

Get all objects without needing the following code:
$this->setResultLimit(0);
$this->useObjectsOn();
$this->loadCustomQuery($query);
$this->getResults();

getOptions($nField, $whereQuery = '', $orderQuery = '') v4.3

Similar to the getArray() method except this method returns a string of html option results to be put inside of an html select tag. The value of the option is the id of the record in the database. The title of the option is the value of the column specified by $nField. |
$nField = The name of the column to use for the title of the options returned. |
$whereQuery = The condition to use to filter the results that are returned. Should be formatted using mysql syntax. If blank returns all records in the database table. |
$orderQuery = The order with which the options should be sorted. If blank the array is sorted by the value of $nField ascending. Should be formatted using mysql syntax.

getPages($filename, $pTitle = 'Page:') v4.3

Returns a string of links to pages providing a pagination index for the results. If the results only contains 1 page then this message returns a blank string. |
$filename = The name of the filename that the pagination links should point to. |
$pTitle = The title that should appear before the links if there is more than one page (if only 1 page the results returned is blank).

getResultLimit() v4.2

Returns the maximum results that are allowed per a page. If 0 is returned it means that there is no limit and all of the results are returned on the first page.

getResults() v4.2

Returns an array of the results found. This is normally only used when objects are turned on (useObjectsOn()). If objects are turned on then this returns an array of LCPSResult objects.

getTable($trTemplate = '') v4.2

Returns a formatted string of the results. |
$trTemplate = The formatting to use for each row of data returned. ~COLUMNNAME~ can be used to specify where a value should appear in the results. For example ~id~ would be replaced by the value of the id column in the results. If left blank returns a table tr for each row that contains all of the columns in the database table.

getValue($itemID, $fieldName) v4.3

Returns the value of a specific column for the specified id. |
$itemID = The id of the record for which the value is pulled from. |
$fieldName = The column name which the value returned belongs to.

hideAllFields() v4.23

Hides all of the columns (fields) from the database table from being returned in the results.

hideField($fieldTitle) v4.23

Hides a specific column (field) from the database table from being returned in the results.

loadAll() v4.3

Loads all of the records in the database table.

loadCustomQuery($query) v4.2

Loads the results from a mysql query statement. |
$query = The mysql query to use to select the results from the database table.

sendEmail($member) v4.3

setPage($nPage) v4.23

Defines which page of results should be returned when using a method that returns the results. |
$nPage = An integer defining which page number should be returned.

setResultLimit($nResultLimit) v4.2

The amount of results to return per a page. |
$nResultLimit = An integer defining the amount of results to display on each page. If set to 0 returns all the results on a single page.

showAllFields() v4.23

Shows all the columns (fields) from the database table in the results that are returned.

showField($fieldTitle) v4.23

Shows a specific column (field) from the database table in the results that are returned.

useObjectsOff() v4.2

Turns off using objects for storing/retrieving values from the results. By default using objects is turned off.

useObjectsOn() v4.2

Turns on using objects for storing/retrieving values from the results. By default using objects is turned off.

__construct($databaseTable = '') v4.2

If $databaseTable is specified then it opens for the specified database table. Objects extending WMTResults do not need this to be specified because it is set from a protected variable.


Columns in the membernotifyemails Database Table:

id    subject    message    

Code Example




Sample Usage

Below is an example of how to use the MemberNotifyEmails object to get a report showing all sent available notify emails for logged in member. The example is from within / (the main/root folder):



webmarketingtool.com Webutation DMCA.com Protection Status Authorize.net GoDaddy
Valid HTML! Valid CSS!


Reseller: Chris Brevig
|
Login
(502) 225-3237