Overview
  • Namespace
  • Class

Namespaces

  • MatthiasWeb
    • RealMediaLibrary
      • api
      • attachment
      • base
      • comp
        • complexquery
      • folder
      • general
      • metadata
      • order
      • rest
      • usersettings
  • None

Classes

  • ComplexQuery
  • ResetNames

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
Extended by MatthiasWeb\RealMediaLibrary\comp\complexquery\ComplexQuery
Extended by MatthiasWeb\RealMediaLibrary\comp\complexquery\ResetNames
Namespace: MatthiasWeb\RealMediaLibrary\comp\complexquery
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.

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.

See

this::isSingleQueriableWithUserDefinedVars()

Returns

mixed
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.

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.

Note: A procedure can for example write into a temporary table and reads from it again.

See

this::isProcedurable()
this::hasProcedure()
this::install()
this::getProcedureResults()

Returns

mixed
public
# installProcedure( )
public
# fallback( )

This function is called when a single query is not possible and procedures are not allowed.

This function is called when a single query is not possible and procedures are not allowed.

Returns

mixed

Methods inherited from MatthiasWeb\RealMediaLibrary\comp\complexquery\ComplexQuery

__construct(), _isProcedurable(), getCache(), getDbh(), getProcedureResults(), getResult(), getWpdb(), hasProcedure(), install(), isMysqli(), isProcedurable(), isSingleQueriableWithUserDefinedVars()

Methods inherited from MatthiasWeb\RealMediaLibrary\base\Base

debug(), getCore(), getTableName()

Constants summary

Constants inherited from MatthiasWeb\RealMediaLibrary\comp\complexquery\ComplexQuery

CACHE_OPTION_NAME

API documentation generated by ApiGen