JDatabaseMySQLi/getTableCreate
From Joomla! Documentation
< API16:JDatabaseMySQLi
The "API16" 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
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]
public 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;
}
[Edit See Also] Template:SeeAlso:JDatabaseMySQLi/getTableCreate
Examples[edit]
<CodeExamplesForm />