DB_common::getListOf()
DB_common::getListOf() – Views database system information
Synopsis
array getListOf (
string $type
)
Description
Retrieves information about database users, avaible databases, views and functions.
Parameter
-
string
$type -
type of requested info, valid values for
$typeare database dependent, ie:tables,databases,users,view,functions
Return value
array - an ordered array containing the requested data or a DB_Error object on failure
Throws
| Error code | Error message | Reason | Solution |
|---|---|---|---|
| DB_ERROR_UNSUPPORTED | not supported | The requested information is not avaible. | Check your user permissions and the database system for support quering the requested information. |
Note
This function can not be called statically.
Example
Using getListOf()
<?php
// Once you have a valid DB object named $db...
$data = $db->getListOf('tables');
if (PEAR::isError($data)) {
die($data->getMessage());
}
echo implode("\n", $data);
?>