xPDO.getValue

xPDO::getValue¶

Executes a prepared PDOStatement and returns the value of one column from the first row of the result set. This is a convenience wrapper around PDOStatement::fetchColumn() that also tracks query time and the executed-query count.

Syntax¶

mixed getValue (\PDOStatement $stmt, [integer|null $column = null])

• $stmt — a prepared \PDOStatement object.
• $column — 0-indexed number of the column to retrieve. If omitted or null, the first column is fetched.

Example¶

$stmt = $xpdo->prepare('SELECT COUNT(*) FROM my_table');
$count = $xpdo->getValue($stmt);

See Also¶

• xPDO.prepare
• xPDO.query
• xPDO