JDatabaseMySQLi/getTableCreate

The "API15" namespace is an archived namespace. This page contains information for a Joomla! version which is no longer supported. It exists only as a historical reference, it will not be improved and its content may be incomplete and/or contain broken links.

Description[edit]

Shows the CREATE TABLE statement that creates the given tables

[Edit Descripton]

Template:Description:JDatabaseMySQLi/getTableCreate

Syntax[edit]

getTableCreate($tables)

Parameter Name	Default Value	Description
$tables		A table name or a list of table names

Returns[edit]

array A list the create SQL for the tables

Defined in[edit]

libraries/joomla/database/database/mysqli.php

Importing[edit]

jimport( 'joomla.database.database.mysqli' );

Source Body[edit]

function getTableCreate( $tables )
{
        settype($tables, 'array'); //force to array
        $result = array();

        foreach ($tables as $tblval)
        {
                $this->setQuery( 'SHOW CREATE table ' . $this->getEscaped( $tblval ) );
                $rows = $this->loadRowList();
                foreach ($rows as $row) {
                        $result[$tblval] = $row[1];
                }
        }

        return $result;
}

Examples[edit]

API15