JDatabaseMySQLi/getTableCreate: Difference between revisions
From Joomla! Documentation
m removing red link to edit, no existant pages |
m preparing for archive only |
||
| Line 56: | Line 56: | ||
===Examples=== | ===Examples=== | ||
=== Code Examples === | |||
<dpl> | <dpl> | ||
noresultsheader=\n | noresultsheader=\n | ||
category=getTableCreate | category=getTableCreate | ||
category=JDatabaseMySQLi | category=JDatabaseMySQLi | ||
namespace=CodeExample | |||
category=MethodExample | category=MethodExample | ||
include=* | include=* | ||
Latest revision as of 00:28, 25 March 2017
Description
Shows the CREATE TABLE statement that creates the given tables
[<! removed edit link to red link >]
<! removed transcluded page call, red link never existed >
Syntax
getTableCreate($tables)
| Parameter Name | Default Value | Description |
|---|---|---|
| $tables | A table name or a list of table names |
Returns
array A list the create SQL for the tables
Defined in
libraries/joomla/database/database/mysqli.php
Importing
jimport( 'joomla.database.database.mysqli' );
Source Body
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;
}
[<! removed edit link to red link >] <! removed transcluded page call, red link never existed >
Examples
Code Examples