diff options
Diffstat (limited to 'framework/Data/TDbCommand.php')
| -rw-r--r-- | framework/Data/TDbCommand.php | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/framework/Data/TDbCommand.php b/framework/Data/TDbCommand.php index f5d7d647..b4bd9dd4 100644 --- a/framework/Data/TDbCommand.php +++ b/framework/Data/TDbCommand.php @@ -283,6 +283,23 @@ class TDbCommand extends TComponent throw new TDbException('dbcommand_query_failed',$e->getMessage(),$this->getDebugStatementText());
}
}
+
+ /**
+ * Executes the SQL statement and returns the first column of the result.
+ * This is a convenient method of {@link query} when only the first column of data is needed.
+ * Note, the column returned will contain the first element in each row of result.
+ * @return array the first column of the query result. Empty array if no result.
+ * @throws TDbException execution failed
+ * @since 3.1.2
+ */
+ public function queryColumn()
+ {
+ $rows=$this->query()->readAll();
+ $column=array();
+ foreach($rows as $row)
+ $column[]=current($row);
+ return $column;
+ }
}
?>
\ No newline at end of file |