Design

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

Database Table: designs
Extends: Result
Extends: AbstractDatabase

Design 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

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

getAdded() _v19

getAID() _v19

getComplete() _v19

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

getDesignApproved() _v4.92

getDraftUpdated() _v19

getID() _v5

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

getID() _v19

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

getLastClientAction() _v19

getLastClientActionTime() _v19

getLastEmployeeAction() _v19

getLastEmployeeActionID() _v19

getLastEmployeeActionTime() _v19

getLastEmployeeName() _v19

getLocked() _v19

getNextStep() _v19

getPaid() _v19

getPhotosApproved() _v19

getPhotosIncluded() _v19

getPrice() _v19

getRevisions() _v19

getScriptApproved() _v19

getSiteID() _v19

getSiteTitle() _v19

getStatusColor() _v19

getStatusUpdated() _v19

getTemplateID() _v19

getType() _v19

getTypeString() _v19

getURL() _v19

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

loadDesign($dID) _v4.92

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

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.

static setLastClientAction($dID, $descr) _v19

static setLastEmployeeAction($dID, $descr, $eID) _v19

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

Design PHP Variables

$descr _v4.92

A description of the design.

$title _v4.92

Title of the design

Columns in the designs Database Table:

id member title designtype description price paid scriptapproved designapproved complete photosapproved added updated template site lastemployeeactiontime lastclientactiontime lastemployeeactionid lastemployeeaction lastclientaction statusupdated statuscolor draftupdated revisions locked photos designtemplate url

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>1266</tr>";
 $content .= "<tr><td>member<td>~member~</tr>";
 $content .= "<tr><td>title<td>~title~</tr>";
 $content .= "<tr><td>designtype<td>~designtype~</tr>";
 $content .= "<tr><td>description<td>~description~</tr>";
 $content .= "<tr><td>price<td>~price~</tr>";
 $content .= "<tr><td>paid<td>~paid~</tr>";
 $content .= "<tr><td>scriptapproved<td>~scriptapproved~</tr>";
 $content .= "<tr><td>designapproved<td>~designapproved~</tr>";
 $content .= "<tr><td>complete<td>~complete~</tr>";
 $content .= "<tr><td>photosapproved<td>~photosapproved~</tr>";
 $content .= "<tr><td>added<td>~added~</tr>";
 $content .= "<tr><td>updated<td>~updated~</tr>";
 $content .= "<tr><td>template<td>~template~</tr>";
 $content .= "<tr><td>site<td>~site~</tr>";
 $content .= "<tr><td>lastemployeeactiontime<td>~lastemployeeactiontime~</tr>";
 $content .= "<tr><td>lastclientactiontime<td>~lastclientactiontime~</tr>";
 $content .= "<tr><td>lastemployeeactionid<td>~lastemployeeactionid~</tr>";
 $content .= "<tr><td>lastemployeeaction<td>~lastemployeeaction~</tr>";
 $content .= "<tr><td>lastclientaction<td>~lastclientaction~</tr>";
 $content .= "<tr><td>statusupdated<td>~statusupdated~</tr>";
 $content .= "<tr><td>statuscolor<td>~statuscolor~</tr>";
 $content .= "<tr><td>draftupdated<td>~draftupdated~</tr>";
 $content .= "<tr><td>revisions<td>~revisions~</tr>";
 $content .= "<tr><td>locked<td>~locked~</tr>";
 $content .= "<tr><td>photos<td>~photos~</tr>";
 $content .= "<tr><td>designtemplate<td>~designtemplate~</tr>";
 $content .= "<tr><td>url<td>~url~</tr>";
 $content .= "</table>";

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


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

 $design = new Design();  //Create object
 $design->loadID($id);
 $converted = $design->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["member"] = "INT UNSIGNED NOT NULL";
 $valueArray["title"] = "VARCHAR(255) ";
 $valueArray["designtype"] = "TINYINT UNSIGNED";
 $valueArray["description"] = "TEXT";
 $valueArray["price"] = "FLOAT";
 $valueArray["paid"] = "FLOAT";
 $valueArray["scriptapproved"] = "BOOL";
 $valueArray["designapproved"] = "BOOL";
 $valueArray["complete"] = "BOOL";
 $valueArray["photosapproved"] = "BOOL";
 $valueArray["added"] = "INT UNSIGNED";
 $valueArray["updated"] = "INT UNSIGNED";
 $valueArray["template"] = "INT UNSIGNED default 1";
 $valueArray["site"] = "INT UNSIGNED DEFAULT 0";
 $valueArray["lastemployeeactiontime"] = "INT UNSIGNED DEFAULT 0";
 $valueArray["lastclientactiontime"] = "INT UNSIGNED";
 $valueArray["lastemployeeactionid"] = "INT UNSIGNED";
 $valueArray["lastemployeeaction"] = "VARCHAR(50) ";
 $valueArray["lastclientaction"] = "VARCHAR(50) ";
 $valueArray["statusupdated"] = "INT UNSIGNED DEFAULT 0";
 $valueArray["statuscolor"] = "TINYINT";
 $valueArray["draftupdated"] = "INT UNSIGNED DEFAULT 0";
 $valueArray["revisions"] = "TINYINT DEFAULT 0";
 $valueArray["locked"] = "BIT(1) DEFAULT 0";
 $valueArray["photos"] = "TINYINT DEFAULT 5";
 $valueArray["designtemplate"] = "INT UNSIGNED DEFAULT 0";
 $valueArray["url"] = "VARCHAR(100)";

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


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

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

 echo $design->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
 $design = new Design();
 $design->loadID($id);
 
// Delete and echo if success or failure
 if ($design->deletThis()) echo "Success";
 else echo "Failure";

Home | Partnership | Testimonials

Privacy/Terms | About Us | Contact Us

Design

Design PHP Methods

add(array $fieldValues) v5

checkLoaded() v5

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

delete(string $restoreQuery = "") v5

duplicate(array $newValues = null) v5

function load(string $queryWhere) v5

getAdded() v19

getAID() v19

getComplete() v19

getDatabaseName() v5

getDefaultTRHTML() v5

getDesignApproved() v4.92

getDraftUpdated() v19

getID() v5

getID() v19

getJSON(bool $returnArr = false) v5

getLastClientAction() v19

getLastClientActionTime() v19

getLastEmployeeAction() v19

getLastEmployeeActionID() v19

getLastEmployeeActionTime() v19

getLastEmployeeName() v19

getLocked() v19

getNextStep() v19

getPaid() v19

getPhotosApproved() v19

getPhotosIncluded() v19

getPrice() v19

getRevisions() v19

getScriptApproved() v19

getSiteID() v19

getSiteTitle() v19

getStatusColor() v19

getStatusUpdated() v19

getTemplateID() v19

getType() v19

getTypeString() v19

getURL() v19

getValue(string $fieldName = "value") v5

hasField(string $fieldName) v5

hideAllFields() v5

hideField($fieldTitle) v5

isLoaded() v5

loadDesign($dID) v4.92

loadFirstID() v5

loadID(int $id) v5

save(array $fieldValues) v5

static setLastClientAction($dID, $descr) v19

static setLastEmployeeAction($dID, $descr, $eID) v19

setMyMemberID(int $memberID) v5

setRestoreID(int $id) v5

settingHTTPS(bool $useHTTPS = true) v5

settingSiteURL(string $siteURL) v5

showAllFields() v5

showField($fieldTitle) v5