Page

An object for adding, viewing, editing and deleting a specific web page.

Database Table: pages
Extends: Result
Extends: AbstractDatabase

Page PHP Methods

add(array $fieldValues) _v5

Adds a new record.
PARAMETERS:
$fieldValues = Array of the values for each column when adding the record (Associative array with key = field name & value = field value).
RETURN VALUE:
int = id of the new record.
0 = if fails

checkLoaded() _v5

Checks if record is loaded. throwing an error if the record failed to load successfully.
PARAMETERS:
NONE
RETURN VALUE:
VOID

clonePage(\WMT\Container $container, int $memberID, int $page, bool $isBackup = false, bool $isDuplicate = false) _v5

Duplicate/clone a page
PARAMETERS:
$container = object
$memberID = int, the new page (cloned page) owner
$page = int, page ID
$isBackup = bool, true if the clone is a backup, false otherwise
$isDuplicate = bool, true if the clone is duplicating the page, false otherwise
RETURN VALUE:
int = page ID

convertHTML(string $htmlContent = "", string $prefix = "", bool $urlEncode = false) _v5

Converts ~~ variables in the $htmlContent that is provided and returns the converted content. The title of the ~~ variables are converted by the content from the column in the database with the matching title.
PARAMETERS:
$htmlContent = String, HTML content body to convert.
$prefix= String, tilde code prefix if any.
$urlEncode = Bool, true if you want to apply URL encode to the content, false otherwise
RETURN VALUE:
String = Converted HTML

delete(string $restoreQuery = "") _v5

Deletes the loaded record from the database.
PARAMETERS:
$restoreQuery = FOR INTERNAL USE. FOR TYPICAL USAGE LEAVE THIS BLANK. The restore query to pass along when deleting an object with dependencies.
RETURN VALUE:
VOID

duplicate(array $newValues = null) _v5

Creates a duplicate record in the database of the current object
PARAMETERS:
$newValues = array, associative array with field name as key and field value as array value containing the new values if any
RETURN VALUE:
int = the id of the new record.

function load(string $queryWhere) _v5

Loads values for the record matching the criteria specified by $queryWhere. If the there is more than one record returned from the query then only the first record is loaded.
PARAMETERS:
$queryWhere = String, SQL where query.
RETURN VALUE:
Bool = true, if success, false otherwise

getBody() _v5

Gets page body content (first editable content) for the loaded page
PARAMETERS:
NONE
RETURN VALUE:
string = first editable content HTML

getContent(int $cpc) _v5

Gets page HTML content for the loaded page
PARAMETERS:
$cpc = int, editable content count number
RETURN VALUE:
string = editable content HTML

getContentCount() _v5

Gets number of editable contents in the loaded page object
PARAMETERS:
NONE
RETURN VALUE:
int = number of editable contents in the loaded page object

getDatabaseName() _v5

Returns object's database table name
PARAMETERS:
NONE
RETURN VALUE:
String = Database name

getDefaultTRHTML() _v5

Returns the default html code for a tr row with all of the fields from the database in it as ~~ vars
PARAMETERS:
NONE
RETURN VALUE:
String = the default HTML code for a tr row with all of the fields from the database in it as ~~ vars

getID() _v5

Sets object ID
PARAMETERS:
NONE
RETURN VALUE:
int = ID

getJSON(bool $returnArr = false) _v5

Get JSON array for the loaded record.
PARAMETERS:
Bool = true if want to return JSON, false otherwise
RETURN VALUE:
Object Array or JSON encoded version of the array

getMemberRedirectURL(\WMT\SQL\Member\Member $member, \WMT\Settings\Core $coreSettings) _v5

Gets the loaded page capture form redirect URL for a specific member
PARAMETERS:
$member = object
$coreSettings = object
RETURN VALUE:
string = redirect URL

getRedirectURL() _v5

Gets the loaded page capture form redirect URL
PARAMETERS:
NONE
RETURN VALUE:
string = redirect URL

getStatsDayTotal() _v5

Gets the loaded page object stats for today
PARAMETERS:
NONE
RETURN VALUE:
int = Number of page views today

getStatsMonthTotal() _v5

Gets the loaded page object stats for this month
PARAMETERS:
NONE
RETURN VALUE:
int = Number of page views this month

getStatsTotal() _v5

Gets the loaded page object stats all the time
PARAMETERS:
NONE
RETURN VALUE:
int = Number of page views all the time

getStatsWeekTotal() _v5

Gets the loaded page object stats for this week
PARAMETERS:
NONE
RETURN VALUE:
int = Number of page views this week

getStatsYearTotal() _v5

Gets the loaded page object stats for this year
PARAMETERS:
NONE
RETURN VALUE:
int = Number of page views this year

getText(int $tID) _v5

Gets page text content for the loaded page
PARAMETERS:
$tID = int, editable content count number
RETURN VALUE:
string = editable content text

getURL(\WMT\SQL\Member\Member $member) _v5

Get the page's full URL
PARAMETERS:
$member = object
RETURN VALUE:
string = page URL

getValue(string $fieldName = "value") _v5

Returns the value from a specific column for this record.
PARAMETERS:
$fieldName = String, field name.
RETURN VALUE:
Field value

hasField(string $fieldName) _v5

Checks if the field shown or hidden
PARAMETERS:
$fieldName= String, Field title.
RETURN VALUE:
Bool= True if the field show is true, false otherwise

hideAllFields() _v5

hides all fields(columns)
PARAMETERS:
NONE
RETURN VALUE:
VOID

hideField($fieldTitle) _v5

Hides specific field title by its column title
PARAMETERS:
$fieldTitle = String, Field title.
RETURN VALUE:
VOID

isLoaded() _v5

Checks if an object is loaded correctly (can be used to check if ID exists).
PARAMETERS:
NONE
RETURN VALUE:
Bool = True if the object loaded successfully, false otherwise

loadFilename(string $filename, int $memberID = 1) _v5

Loads page by its filename
PARAMETERS:
$filename = string, page file name
$memberID = int, member ID (referrer)
RETURN VALUE:
int = 0 if the page failed to load, 1 if loaded successfully

loadFirstID() _v5

Get object's first id
PARAMETERS:
NONE
RETURN VALUE:
int = First ID

loadID(int $id) _v5

Loads values for the record with the id specified.
PARAMETERS:
$id = int, record ID.
RETURN VALUE:
Bool = true, if success, false otherwise

loadPage(int $pageID, \WMT\Settings\Core $coreSettings, int $memberID, int $parentID = 0, bool $canSharePages = false) _v5

Loads a page
PARAMETERS:
$pageID = int, page ID
$coreSettings = object
$memberID = int, page owner member ID
$parentID = int, member's parent ID (if the page was shared)
$canSharePages = bool, true to allow share the page with downline, false otherwise
RETURN VALUE:
int = 0 if the page failed to load, page ID if loaded correctly

makeMyRedirect(int $memberID) _v5

Set the loaded page as member's default redirect URL
PARAMETERS:
$memberID = int, member ID
RETURN VALUE:
void

save(array $fieldValues) _v5

Saves the record with the new values specified in the $fieldValuesarray.
PARAMETERS:
$fieldValues = Array of the values for each column when adding the record (Associative array with key = field name & value = field value).
RETURN VALUE:
Bool = True on success, False otherwise.

setMyMemberID(int $memberID) _v5

Sets member's ID
PARAMETERS:
$memberID = int, member id
RETURN VALUE:
VOID

setRestoreID(int $id) _v5

Sets restor point ID
PARAMETERS:
$id = int, restore ID
RETURN VALUE:
VOID

settingHTTPS(bool $useHTTPS = true) _v5

Sets site to use https or http
PARAMETERS:
$useHTTPS = True if https on, false otherwise (default true).
RETURN VALUE:
VOID

settingSiteURL(string $siteURL) _v5

Sets Site Domain
PARAMETERS:
$siteURL = String, site URL
RETURN VALUE:
VOID

showAllFields() _v5

Show all fields(columns)
PARAMETERS:
NONE
RETURN VALUE:
VOID

showField($fieldTitle) _v5

Shows specific field title by its column title
PARAMETERS:
$fieldTitle = String, Field title.
RETURN VALUE:
VOID

Page PHP Variables

🔎︎ %l4610%

Columns in the pages Database Table:

id title description keywords filename editable member number type redirect notes dorder contactgroup membership membercanedit passprotect exitpopup allowdownlinecopy allowallcopy isbackup pagedynamic afterdelay afternotify aftercontactgroup afterimessage chat bootstrap inviteron aftergroupmatch updated afterpoints aftertitle ispublic hideredirect fbimage lightbox ismobile responsive afterpagecontent autosave

Code Example

Use the code below to view a record in an html page:

<?php
// ###PUT YOUR CONTENT BELOW###
 $id = 1;  // The ID of the record being retrieved

// The HTML Code that we will convert the ~~ values inside of it
 $content = "<table>"; 
 $content .= "<tr><td>id<td>274</tr>";
 $content .= "<tr><td>title<td>~title~</tr>";
 $content .= "<tr><td>description<td>~description~</tr>";
 $content .= "<tr><td>keywords<td>~keywords~</tr>";
 $content .= "<tr><td>filename<td>~filename~</tr>";
 $content .= "<tr><td>editable<td>~editable~</tr>";
 $content .= "<tr><td>member<td>~member~</tr>";
 $content .= "<tr><td>number<td>~number~</tr>";
 $content .= "<tr><td>type<td>TINYINT NOT NULL</tr>";
 $content .= "<tr><td>redirect<td>~redirect~</tr>";
 $content .= "<tr><td>notes<td>Internal notes for the page only seen by members.</tr>";
 $content .= "<tr><td>dorder<td>~dorder~</tr>";
 $content .= "<tr><td>contactgroup<td>~contactgroup~</tr>";
 $content .= "<tr><td>membership<td>~membership~</tr>";
 $content .= "<tr><td>membercanedit<td>~membercanedit~</tr>";
 $content .= "<tr><td>passprotect<td>~passprotect~</tr>";
 $content .= "<tr><td>exitpopup<td>~exitpopup~</tr>";
 $content .= "<tr><td>allowdownlinecopy<td>~allowdownlinecopy~</tr>";
 $content .= "<tr><td>allowallcopy<td>~allowallcopy~</tr>";
 $content .= "<tr><td>isbackup<td>~isbackup~</tr>";
 $content .= "<tr><td>pagedynamic<td>~pagedynamic~</tr>";
 $content .= "<tr><td>afterdelay<td>~afterdelay~</tr>";
 $content .= "<tr><td>afternotify<td>~afternotify~</tr>";
 $content .= "<tr><td>aftercontactgroup<td>~aftercontactgroup~</tr>";
 $content .= "<tr><td>afterimessage<td>~afterimessage~</tr>";
 $content .= "<tr><td>chat<td>~chat~</tr>";
 $content .= "<tr><td>bootstrap<td>~bootstrap~</tr>";
 $content .= "<tr><td>inviteron<td>~inviteron~</tr>";
 $content .= "<tr><td>aftergroupmatch<td>~aftergroupmatch~</tr>";
 $content .= "<tr><td>updated<td>~updated~</tr>";
 $content .= "<tr><td>afterpoints<td>~afterpoints~</tr>";
 $content .= "<tr><td>aftertitle<td>~aftertitle~</tr>";
 $content .= "<tr><td>ispublic<td>~ispublic~</tr>";
 $content .= "<tr><td>hideredirect<td>~hideredirect~</tr>";
 $content .= "<tr><td>fbimage<td>~fbimage~</tr>";
 $content .= "<tr><td>lightbox<td>~lightbox~</tr>";
 $content .= "<tr><td>ismobile<td>~ismobile~</tr>";
 $content .= "<tr><td>responsive<td>~responsive~</tr>";
 $content .= "<tr><td>afterpagecontent<td>~afterpagecontent~</tr>";
 $content .= "<tr><td>autosave<td>~autosave~</tr>";
 $content .= "</table>";

// ###PUT YOUR CONTENT ABOVE###


 include("admin/load/nosession.php");

 $page = new Page();  //Create object
 $page->loadID($id);
 $converted = $page->convertHTML($content);  //Convert ~~ Codes

 echo $converted;  // Display results

Use the code below to add a record:

// ###PUT YOUR CONTENT BELOW###
 $id = 1;  // The ID of the record being retrieved

// The values to use for creating a new record
 $valueArray = array();
 $valueArray["id"] = "0";
 $valueArray["title"] = "VARCHAR(50) NOT NULL";
 $valueArray["description"] = "TEXT NOT NULL";
 $valueArray["keywords"] = "TEXT NOT NULL";
 $valueArray["filename"] = "VARCHAR(100) NOT NULL";
 $valueArray["editable"] = "BIT(1) NOT NULL";
 $valueArray["member"] = "INT UNSIGNED NOT NULL";
 $valueArray["number"] = "SMALLINT NOT NULL";
 $valueArray["type"] = "TINYINT NOT NULL";
 $valueArray["redirect"] = "VARCHAR(255) NOT NULL";
 $valueArray["notes"] = "VARCHAR(255) NOT NULL";
 $valueArray["dorder"] = "SMALLINT UNSIGNED NOT NULL";
 $valueArray["contactgroup"] = "SMALLINT UNSIGNED NOT NULL DEFAULT 1";
 $valueArray["membership"] = "SMALLINT UNSIGNED NOT NULL DEFAULT 0";
 $valueArray["membercanedit"] = "BIT(1) NOT NULL DEFAULT 1";
 $valueArray["passprotect"] = "BIT(1) NOT NULL DEFAULT 0";
 $valueArray["exitpopup"] = "BIT(1) NOT NULL DEFAULT 0";
 $valueArray["allowdownlinecopy"] = "BIT(1) NOT NULL DEFAULT 0";
 $valueArray["allowallcopy"] = "BIT(1) NOT NULL DEFAULT 0";
 $valueArray["isbackup"] = "BIT(1) NOT NULL DEFAULT 0";
 $valueArray["pagedynamic"] = "INT UNSIGNED NOT NULL DEFAULT 0";
 $valueArray["afterdelay"] = "SMALLINT UNSIGNED NOT NULL DEFAULT 0";
 $valueArray["afternotify"] = "TINYINT NOT NULL DEFAULT 0";
 $valueArray["aftercontactgroup"] = "SMALLINT UNSIGNED NOT NULL DEFAULT 0";
 $valueArray["afterimessage"] = "BIT(1) NOT NULL DEFAULT 0";
 $valueArray["chat"] = "BIT(1) NOT NULL DEFAULT 1";
 $valueArray["bootstrap"] = "BIT(1) NOT NULL DEFAULT 0";
 $valueArray["inviteron"] = "BIT(1) NOT NULL DEFAULT 0";
 $valueArray["aftergroupmatch"] = "SMALLINT UNSIGNED NOT NULL DEFAULT 0";
 $valueArray["updated"] = "INT UNSIGNED NOT NULL DEFAULT 0";
 $valueArray["afterpoints"] = "TINYINT UNSIGNED NOT NULL DEFAULT 5";
 $valueArray["aftertitle"] = "VARCHAR(50) NOT NULL";
 $valueArray["ispublic"] = "BIT(1) NOT NULL DEFAULT 1";
 $valueArray["hideredirect"] = "VARCHAR(255) NOT NULL";
 $valueArray["fbimage"] = "VARCHAR(255) NOT NULL";
 $valueArray["lightbox"] = "BIT(1) NOT NULL DEFAULT 0";
 $valueArray["ismobile"] = "BIT(1) NOT NULL DEFAULT 0";
 $valueArray["responsive"] = "BIT(1) NOT NULL DEFAULT 0";
 $valueArray["afterpagecontent"] = "INT UNSIGNED NOT NULL DEFAULT 0";
 $valueArray["autosave"] = "BIT(1) NOT NULL DEFAULT 0";

// ###PUT YOUR CONTENT ABOVE###


 include("admin/load/nosession.php");

 $page = new Page();  //Create object
 $page->add($valueArray);  // Add the record

 echo $page->getID();  // Echo the id of the newly created record

Use the code below to delete a record:

// ###PUT YOUR CONTENT BELOW###
 $id = 1;  // The ID of the record being deleted
// ###PUT YOUR CONTENT ABOVE###


 include("admin/load/nosession.php");

// Create object
 $page = new Page();
 $page->loadID($id);
 
// Delete and echo if success or failure
 if ($page->deletThis()) echo "Success";
 else echo "Failure";

Sample Usage

Below is an example of how to get page content. The example is from within / (the main/root folder):

<?php
 include("admin/load/visitor.php");

 if($visitor->getMemberID()){
 $templateNumber = 95;
 $page = \WMT\Factory\SQL\Page\Page::create($container);
 $page->loadPage($templateNumber, $container->settingsCore(), $visitor->getMemberID());
 echo $page->getValue("filename"); 
 }

Home | Partnership | Testimonials

Privacy/Terms | About Us | Contact Us

Page

Page PHP Methods

add(array $fieldValues) v5

checkLoaded() v5

clonePage(\WMT\Container $container, int $memberID, int $page, bool $isBackup = false, bool $isDuplicate = false) v5

convertHTML(string $htmlContent = "", string $prefix = "", bool $urlEncode = false) v5

delete(string $restoreQuery = "") v5

duplicate(array $newValues = null) v5

function load(string $queryWhere) v5

getBody() v5

getContent(int $cpc) v5

getContentCount() v5

getDatabaseName() v5

getDefaultTRHTML() v5

getID() v5

getJSON(bool $returnArr = false) v5

getMemberRedirectURL(\WMT\SQL\Member\Member $member, \WMT\Settings\Core $coreSettings) v5

getRedirectURL() v5

getStatsDayTotal() v5

getStatsMonthTotal() v5

getStatsTotal() v5

getStatsWeekTotal() v5

getStatsYearTotal() v5

getText(int $tID) v5

getURL(\WMT\SQL\Member\Member $member) v5

getValue(string $fieldName = "value") v5

hasField(string $fieldName) v5

hideAllFields() v5

hideField($fieldTitle) v5

isLoaded() v5

loadFilename(string $filename, int $memberID = 1) v5

loadFirstID() v5

loadID(int $id) v5

loadPage(int $pageID, \WMT\Settings\Core $coreSettings, int $memberID, int $parentID = 0, bool $canSharePages = false) v5

makeMyRedirect(int $memberID) v5

save(array $fieldValues) v5

setMyMemberID(int $memberID) v5

setRestoreID(int $id) v5

settingHTTPS(bool $useHTTPS = true) v5

settingSiteURL(string $siteURL) v5

showAllFields() v5

showField($fieldTitle) v5