wpdb::get_var() WP 1.0

Retrieves 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, the value in the column and row specified is returned. If $query is null, the value in the specified column and row from the previous SQL result is returned.

{} It's a method of the class: wpdb{}

No Hooks.

Return

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

Usage

global $wpdb;
$wpdb->get_var( $query, $x, $y );

$query(string|null)

SQL query.
Default: null, use the result from the previous query

$x(int)

Column of value to return. Indexed from 0.

$y(int)

Row of value to return. Indexed from 0.

Changelog

Code of wpdb::get_var() wpdb::get var ^{WP 5.8}

<?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->check_safe_collation( $query ) ) {
		$this->check_current_query = false;
	}

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

	// Extract var out of cached results based on 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;
}

Related Functions

From tag: wpdb

More from category: SQL