method getKeyVal documentation in bbn\Db\Engines

Return an array indexed on the first field of the request.

The value will be an array if the request has more than two fields.

function() { /** * Return an array with the values of single field resulting from the query. * * @param string query * @param mixed values * @return array */ public function getColArray(): array; /** * Return a count of identical values in a field as array, Reporting a structure type 'num' - 'val'. * * @param $table * @param string|null $field * @param array $where * @param array $order * @return array|null */ public function countFieldValues($table, string $field = null, array $where = [], array $order = []): ?array; /** * Return a numeric indexed array with the values of the unique column ($field) from the selected $table * * ```php * X::dump($db->getColumnValues('table_users','surname',['id','>',1])); * /* * array [ * "Smith", * "Jones", * "Williams", * "Taylor" * ] * ``` * * @param string|array $table The table's name or a configuration array * @param string|null $field The field's name * @param array $where The "where" condition * @param array $order The "order" condition * @param int $limit * @param int $start * @return array */ public function getColumnValues($table, string $field = null, array $where = [], array $order = [], int $limit = 0, int $start = 0): ?array; /** * Return an indexed array with the first result of the query or false if there are no results. * * @param string $query * @return array|false */ public function fetch(string $query); /** * Return an array of indexed array with all results of the query or false if there are no results. * * @param string $query * @return array|false */ public function fetchAll(string $query); /** * @param $query * @param int $num * @return mixed */ public function fetchColumn($query, int $num = 0); /** * @param $query * @return bool|\stdClass */ public function fetchObject($query); /** * @return array */ public function getCfg(): array; /** * Gets the created hash. * * @return string */ public function getHash(): string; /** * Checks if the database is ready to process a query. * @return bool */ public function check(): bool; /** * Sets the error mode. * * @param string $mode */ public function setErrorMode(string $mode); /** * @return string */ public function getErrorMode(): string; /** * Returns the last error. * * @return string|null */ public function getLastError(): ?string; /** * Returns the current database selected by the current connection. * * @return string|null */ public function getCurrent(): ?string; /** * Returns the host of the current connection. * * @return string|null */ public function getHost(): ?string; /** * @return string */ public function getConnectionCode(); /** * Return the last config for this connection. * * @return array|null */ public function getLastCfg(): ?array; /** * @param array $cfg The user's options * @return array|null The final configuration */ }

Return an array indexed on the first field of the request. BBN is a suite of PHP and JS libraries and VueJS components - all open-source! bbn.io, build applications, the quick way

This website uses cookies to ensure you get the best experience on our website.