Table of Contents

getTableFields

API Package Subpackage Class Method Reference Last reviewed Doc status
API Home Package Joomla.Framework Subpackage Database Class JDatabase Method getTableFields Reference getTableFields() Never Work in Progress

Returns a list of fields and field types given a list of tables.

Syntax

array getTableFields ( $tables )

$tables array is an array of strings containing a list of table names.

Examples

Example

$database =& JFactory::getDBO();

$prefix = $database->_table_prefix;
$tables = array( $prefix.'content_frontpage', $prefix.'content_rating' );
$result = $database->getTableFields( $tables );
print_r( $result );

might produce:

Result

Array
(
    [jos_content_frontpage] => Array
        (
            [content_id] => int
            [ordering] => int
        )
 
    [jos_content_rating] => Array
        (
            [content_id] => int
            [rating_sum] => int unsigned
            [rating_count] => int unsigned
            [lastip] => varchar
        )
 
)