You appear to be a bot. Output may be restricted

Description

Retrieve one variable from the database.

Executes a SQL query and returns the value from the SQL result. If the SQL result contains more than one column and/or more than one row, this function returns the value in the column and row specified. If $query is null, this function returns the value in the specified column and row from the previous SQL result.

Usage

$string|null = wpdb::get_var( $query, $x, $y );

Parameters

$query

( string|null ) optional – Optional. SQL query. Defaults to null, use the result from the previous query.

$x

( int ) optional – Optional. Column of value to return. Indexed from 0.

$y

( int ) optional – Optional. Row of value to return. Indexed from 0.

Returns

string|null Database query result (as string), or null on failure

Source

File name: wordpress/wp-includes/wp-db.php

  public function get_var( $query = null, $x = 0, $y = 0 ) {
    $this->func_call = "\$db->get_var(\"$query\", $x, $y)";

    if ( $this->check_current_query && $this->wpdb::check_safe_collation( $query ) ) {
      $this->check_current_query = false;
    }

    if ( $query ) {
      $this->wpdb::query( $query );
    }

    // Extract var out of cached results based x,y vals.
    if ( ! empty( $this->last_result[ $y ] ) ) {
      $values = array_values( get_object_vars( $this->last_result[ $y ] ) );
    }

    // If there is a value return it else return null.
    return ( isset( $values[ $x ] ) && '' !== $values[ $x ] ) ? $values[ $x ] : null;
  }
 

 View on GitHub View on Trac