Class ResetNames
Define your complex SQL query. When implementing your complex query do not use global $wpdb; in your methods. Use ::getWpdb() instead.
A complex query can be splitted into three parts:
- 1. Single Query: The query can be processed through one single SQL query with user defined variables
- 2. Procedure: The procedure can write for example to an temporary table and reads again from this one
- 3. Fallback: The fallback can throw an error or do the query through PHP functions
- MatthiasWeb\RealMediaLibrary\base\Base
-
MatthiasWeb\RealMediaLibrary\comp\complexquery\ComplexQuery
-
MatthiasWeb\RealMediaLibrary\comp\complexquery\ResetNames
Example: $rows = new MyComplexQuery($wpdb)->getResults();
Located at comp/complexquery/ResetNames.class.php
Methods summary
public
|
#
singleQuery( )
This function is called when user defined variables are support. This method should return your expected result. It works with both mysqli_connect and mysql_connect. |
public
|
#
procedure( )
This function is called when procedures (stored functions and procedures) are available. It is also necessery that mysqli is in use. mysql_connect does not support store_results() method. This method should return your expected result. You should work with this::hasProcedure() to install your procedure if not exists. |
public
|
|
public
|
Methods inherited from MatthiasWeb\RealMediaLibrary\comp\complexquery\ComplexQuery
__construct()
,
_isProcedurable()
,
getCache()
,
getDbh()
,
getProcedureResults()
,
getResult()
,
getWpdb()
,
hasProcedure()
,
install()
,
isMysqli()
,
isProcedurable()
,
isSingleQueriableWithUserDefinedVars()