$database->getVariable() method

Get the value of a MySQL variable

Example

// Get the minimum fulltext index word length
$value = $database->getVariable('ft_min_word_len');
echo $value; // outputs "4"

Usage

// basic usage
$string = $database->getVariable(string $name);

// usage with all arguments
$string = $database->getVariable(string $name, bool $cache = true, bool $sub = true);

Arguments

NameType(s)Description
namestring

Name of MySQL variable you want to retrieve

cache (optional)bool

Allow use of cached values? (default=true)

sub (optional)bool

Allow substitution of MyISAM variable names to InnoDB equivalents when InnoDB is engine? (default=true)

Return value

string null


$database methods and properties

API reference based on ProcessWire core version 3.0.236

Latest news

  • ProcessWire Weekly #522
    In the 522nd issue of ProcessWire Weekly we'll check out the latest core updates, introduce a new module called File Mover, and more. Read on!
    Weekly.pw / 11 May 2024
  • ProFields Table Field with Actions support
    This week we have some updates for the ProFields table field (FieldtypeTable). These updates are primarily focused on adding new tools for the editor to facilitate input and management of content in a table field.
    Blog / 12 April 2024
  • Subscribe to weekly ProcessWire news

“Indeed, if ProcessWire can be considered as a CMS in its own right, it also offers all the advantages of a CMF (Content Management Framework). Unlike other solutions, the programmer is not forced to follow the proposed model and can integrate his/her ways of doing things.” —Guy Verville, Spiria Digital Inc.