$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.244

Latest news

  • ProcessWire Weekly #558
    In the 558th issue of ProcessWire Weekly we'll check out the blog post that introduces ProcessWire 3.0.244, share some recent ProcessWire highlights, and more. Read on!
    Weekly.pw / 18 January 2025
  • ProcessWire 3.0.244 new main/master version
    ProcessWire 3.0.244 is our newest main/master/stable version. It's been more than a year in the making and is packed with tons of new features, issue fixes, optimizations and more. This post covers all the details.
    Blog / 18 January 2025
  • Subscribe to weekly ProcessWire news

“…building with ProcessWire was a breeze, I really love all the flexibility the system provides. I can’t imagine using any other CMS in the future.” —Thomas Aull