$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

Newest forum posts

Latest news

  • ProcessWire Weekly #549
    In the 549th issue of ProcessWire Weekly we’re going to check out the latest core updates, highlight one older yet still very relevant third party module, and more. Read on!
    Weekly.pw / 17 November 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