JDatabaseMySQLi/getTableCreate: Difference between revisions
From Joomla! Documentation
New page: ===Description===
Shows the CREATE TABLE statement that creates the given tables
<span class="editsection" style="font-size:76%;">
<nowiki>[</nowiki>[[Description:JDatabaseMySQLi/getT... |
m preparing for archive only |
||
| (2 intermediate revisions by the same user not shown) | |||
| Line 2: | Line 2: | ||
Shows the CREATE TABLE statement that creates the given tables | Shows the CREATE TABLE statement that creates the given tables | ||
<! removed transcluded page call, red link never existed > | |||
===Syntax=== | ===Syntax=== | ||
| Line 49: | Line 47: | ||
</source> | </source> | ||
<! removed transcluded page call, red link never existed > | |||
< | |||
===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=* | ||
format= ,,, | format= ,,, | ||
</dpl> | </dpl> | ||
[[Category:Archived pages API16]] | |||
Latest revision as of 01:28, 25 March 2017
Description
Shows the CREATE TABLE statement that creates the given tables
<! 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
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;
}
<! removed transcluded page call, red link never existed >
Examples
Code Examples