wpdb::get_var() – Method | Developer.WordPress.org

Retrieves one value from the database.

Description

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.

Parameters

$querystring|nulloptional: SQL query. Defaults to null, use the result from the previous query.
Default:null
$xintoptional: Column of value to return. Indexed from 0. Default 0.
$yintoptional: Row of value to return. Indexed from 0. Default 0.

Return

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

Source

 * @param int         $x     Optional. Column of value to return. Indexed from 0. Default 0.
 * @param int         $y     Optional. Row of value to return. Indexed from 0. Default 0.
 * @return string|null Database query result (as string), or null on failure.
 */
public function get_var( $query = null, $x = 0, $y = 0 ) {
	$this->func_call = "\$db->get_var(\"$query\", $x, $y)";

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

		$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 ] ) );
	}

View all references View on Trac View on GitHub

Changelog

Version	Description
0.71	Introduced.

User Contributed Notes

Skip to note 3 content

WPBody 9 years ago

You must log in to vote on the helpfulness of this noteVote results for this note: 5You must log in to vote on the helpfulness of this note
// Retrieve and display the number of users.
```
$user_count = $wpdb->get_var( "SELECT COUNT(*) FROM $wpdb->users" );
echo "<p>User count is {$user_count}</p>";
```
Log in to add feedback
Skip to note 4 content

Jam Viet 7 years ago

You must log in to vote on the helpfulness of this noteVote results for this note: 4You must log in to vote on the helpfulness of this note
get total post from an user:
```
$sum = $wpdb->get_var( $wpdb->prepare( "SELECT COUNT(*) from $wpdb->posts where post_status = 'publish' and user_id = %d", $user_id ) );

printf('This user has %d posts', $sum);
```
Log in to add feedback

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

In this article