$mainwp_wpcreport_db_version
$mainwp_wpcreport_db_version : string
Class MainWP_Live_Reports_Responder_DB
get_tokens_by(string $by = 'id', null $value = null, string $site_url = '') : \MainWP\Dashboard\(array|object|null|\MainWP\Dashboard\void)
Method get_tokens_by()
Get report tokens by ID, name or URL.
string | $by | By token name or token ID. Default: id. |
null | $value | Token ID. |
string | $site_url | Child Site URL. |
Database query result by token or null on failure
get_default_token_site(mixed $token_name, mixed $site_url) : \MainWP\Dashboard\(string|\MainWP\Dashboard\bool)
Method get_default_token_site()
Get default Child Site token.
mixed | $token_name | Token name. |
mixed | $site_url | Child ite URL. |
Return string Child Site name|URL or false on failer.
update_token_site(mixed $token_id, mixed $token_value, mixed $site_url) : \MainWP\Dashboard\(string|\MainWP\Dashboard\bool)
Method update_token_site()
Update Child Site token value.
mixed | $token_id | Token ID. |
mixed | $token_value | Token value. |
mixed | $site_url | Child Site URL. |
Return token value or false on failer.
delete_site_tokens(null $token_id = null, null $site_url = null) : \MainWP\Dashboard\(int|\MainWP\Dashboard\bool)
Method delete_site_tokens()
Delete Child Site token value.
null | $token_id | Token ID. |
null | $site_url | Child SIte URL. |
Number of rows affected/selected for all other queries and Boolean true. Boolean false on error.
delete_token_by(string $by = 'id', null $value = null) : \MainWP\Dashboard\(bool)
Method delete_token_by()
Delete Child Site token by id.
string | $by | Query type. Default: 'id'. |
null | $value | Token id. |
Boolean true on success. Boolean false on error.
get_report_by(string $by = 'id', null $value = null, string $orderby = null, string $order = null, object $output = OBJECT) : \MainWP\Dashboard\(object|\MainWP\Dashboard\bool)
Method get_report_by()
Get Client Report by given query type $by.
string | $by | Query type. Default: 'id'. Choices: id, client, site, title, all. |
null | $value | Further variables to substitute into the query's placeholders if being called with individual arguments. |
string | $orderby | Order By. Default: null. Choices: client, name. |
string | $order | Order. Default: null. Choices: client, name. |
object | $output | Report object. |
Return Client Report object or false on failer.
delete_report_by(string $by = 'id', null $value = null) : \MainWP\Dashboard\(bool)
Method delete_report_by()
Delete Client Report by id.
string | $by | Query type. Default: 'id'. |
null | $value | Client Report ID. |
Return true on success and false on failer.
get_client_by(string $by = 'clientid', null $value = null) : \MainWP\Dashboard\(array|object|null|\MainWP\Dashboard\void)
Method get_client_by()
Get client by clientid.
string | $by | Query type. Defualt: 'clientid'. |
null | $value | Query value placeholder. |
Database query result for client or null on failure.
get_format_by(string $by, mixed $value, null $type = null) : \MainWP\Dashboard\(array|object|null|\MainWP\Dashboard\void)
Method get_format_by()
Get Client Report format by.
string | $by | Query type. id|title. |
mixed | $value | Id or title to grab. |
null | $type | format type. Default: null as query placeholder. |
Database query result or null on failure.
update_format(object $format) : \MainWP\Dashboard\(int|\MainWP\Dashboard\false)
Method update_format()
Update Client Report format.
object | $format | Client Report format object. |
The number of rows inserted, or false on error.
delete_format_by(string $by = 'id', null $value = null) : \MainWP\Dashboard\(bool)
Method delete_format_by()
Delete Client Report format by id.
string | $by | Query type. Default: 'id'. |
null | $value | Query value placeholder. |
Return true on success and false on failer.
query(mixed $sql) : \MainWP\Dashboard\(bool|\MainWP\Dashboard\object)
Method query()
SQL Query.
mixed | $sql | Given SQL Query. |
Returns false on failure. For successful SELECT, SHOW, DESCRIBE or EXPLAIN queries mysqli_query() will return a mysqli_result object. For other successful queries mysqli_query() will return TRUE.
m_query(mixed $query, mixed $link) : \MainWP\Dashboard\(bool)
Method m_query()
MySQLi or MySQL Query.
mixed | $query | SQL query. |
mixed | $link | mysqli_connect link. |
Returns false on failure. For successful SELECT, SHOW, DESCRIBE or EXPLAIN queries mysqli_query() will return a mysqli_result object. For other successful queries mysqli_query() will return true.
fetch_object(object $result) : \MainWP\Dashboard\(object|\MainWP\Dashboard\null)
Method fetch_object(
MySQLi Query.
object | $result | SQL Query. |
Returns an object with string properties that corresponds to the fetched row or null if there are no more rows in resultset.
data_seek(mixed $result, mixed $offset) : \MainWP\Dashboard\(bool)
Method data_seek()
Data Seek.
mixed | $result | Required. Specifies a result set identifier returned by mysqli_query(), mysqli_store_result() or mysqli_use_result() |
mixed | $offset | Required. Specifies the field offset. Must be between 0 and the total number of rows - 1. |
Returns true on success or false on failure.
fetch_array(mixed $result, null $result_type = null) : array
Method fetch_array()
Fetch array.
mixed | $result | Required. Specifies which data pointer to use. The data pointer is the result from the mysql_query() function |
null | $result_type | Optional. Specifies what kind of array to return. Placeholder: null. |
The array that was fetched.