$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 #553
    In the 553rd issue of ProcessWire Weekly we'll check out the latest weekly update from Ryan, introduce a new third party module called Text Synthesis, and more. Read on!
    Weekly.pw / 14 December 2024
  • Custom Fields Module
    This week we look at a new ProFields module named Custom Fields. This module provides a way to rapidly build out ProcessWire fields that contain any number of subfields/properties within them.
    Blog / 30 August 2024
  • Subscribe to weekly ProcessWire news

“I am currently managing a ProcessWire site with 2 million+ pages. It’s admirably fast, and much, much faster than any other CMS we tested.” —Nickie, Web developer