';
if (! $db_is_system_schema) {
$html_output .= PMA_getHtmlForInsertEmptyDropActionLinks(
$tbl_url_query, $table_is_view,
$titles, $empty_table, $current_table, $drop_query, $drop_message
);
} // end if (! $db_is_system_schema)
// there is a null value in the ENGINE
// - when the table needs to be repaired, or
// - when it's a view
// so ensure that we'll display "in use" below for a table
// that needs to be repaired
$approx_rows = false;
if (isset($current_table['TABLE_ROWS'])
&& ($current_table['ENGINE'] != null
|| $table_is_view)
) {
list($html_view_table, $approx_rows) = PMA_getHtmlForNotNullEngineViewTable(
$table_is_view, $current_table, $collation, $is_show_stats,
$tbl_url_query, $formatted_size, $unit, $overhead, $create_time,
$update_time, $check_time
);
$html_output .= $html_view_table;
} elseif ($table_is_view) {
$html_output .= PMA_getHtmlForViewTable($is_show_stats);
} else {
$html_output .= PMA_getHtmlForRepairtable(
$colspan_for_structure,
$db_is_system_schema
);
} // end if (isset($current_table['TABLE_ROWS'])) else
$html_output .= '
';
return array($html_output, $odd_row, $approx_rows);
}
/**
* Get HTML for Insert/Empty/Drop action links
*
* @param string $tbl_url_query table url query
* @param boolean $table_is_view whether table is view or not
* @param array $titles titles array
* @param string $empty_table HTML link for empty table
* @param array $current_table current table
* @param string $drop_query query for drop table
* @param string $drop_message table drop message
*
* @return string $html_output
*/
function PMA_getHtmlForInsertEmptyDropActionLinks($tbl_url_query, $table_is_view,
$titles, $empty_table, $current_table, $drop_query, $drop_message
) {
$html_output = '
';
return $html_output;
}
/**
* Get HTML to show database structure creation, last update and last checkx time
*
* @param string $create_time create time
* @param string $update_time last update time
* @param string $check_time last check time
*
* @return string $html_output
*/
function PMA_getHtmlForStructureTimes($create_time, $update_time, $check_time)
{
$html_output = '';
if ($GLOBALS['cfg']['ShowDbStructureCreation']) {
$html_output .= '
';
}
return $html_output;
}
/**
* Get HTML for ENGINE value not null or view tables that are not empty tables
*
* @param boolean $table_is_view whether table is view
* @param array $current_table current table
* @param string $collation collation
* @param boolean $is_show_stats whether stats show or not
* @param string $tbl_url_query table url query
* @param string $formatted_size formatted size
* @param string $unit unit
* @param string $overhead overhead
* @param string $create_time create time
* @param string $update_time update time
* @param string $check_time check time
*
* @return string $html_output
*/
function PMA_getHtmlForNotNullEngineViewTable($table_is_view, $current_table,
$collation, $is_show_stats, $tbl_url_query, $formatted_size, $unit,
$overhead, $create_time, $update_time, $check_time
) {
$html_output = '';
$row_count_pre = '';
$show_superscript = '';
if ($table_is_view) {
// Drizzle views use FunctionEngine, and the only place where they are
// available are I_S and D_D schemas, where we do exact counting
if ($current_table['TABLE_ROWS'] >= $GLOBALS['cfg']['MaxExactCountViews']
&& $current_table['ENGINE'] != 'FunctionEngine'
) {
$row_count_pre = '~';
$show_superscript = PMA_Util::showHint(
PMA_sanitize(
sprintf(
__('This view has at least this number of rows. Please refer to %sdocumentation%s.'),
'[doc@cfg_MaxExactCountViews]',
'[/doc]'
)
)
);
}
} elseif ($current_table['ENGINE'] == 'InnoDB'
&& (! $current_table['COUNTED'])
) {
// InnoDB table: we did not get an accurate row count
$row_count_pre = '~';
$show_superscript = '';
}
// Set a flag if there are approximate row counts on page.
if (! empty($row_count_pre)) {
$approx_rows = true;
} else {
// this happens for information_schema, performance_schema,
// and in case there is no InnoDB table on this page
$approx_rows = false;
}
// Get the row count.
$row_count = $row_count_pre
. PMA_Util::formatNumber($current_table['TABLE_ROWS'], 0);
// URL parameters to fetch the real row count.
$real_count_url = array(
'ajax_request' => true,
'db' => $GLOBALS['db'],
'table' => $current_table['TABLE_NAME'],
'real_row_count' => 'true'
);
// Content to be appended into 'tbl_rows' cell.
// If row count is approximate, display it as an anchor to get real count.
$cell_text = (! empty($row_count_pre))
? '' . $row_count . ''
: $row_count;
$html_output .= '
'
. $cell_text
. $show_superscript
. '
';
if (!($GLOBALS['cfg']['PropertiesNumColumns'] > 1)) {
$html_output .= '
';
if (/*overload*/mb_strlen($collation)) {
$html_output .= '
' . $collation . '
';
}
}
if ($is_show_stats) {
$html_output .= PMA_getHtmlForShowStats(
$tbl_url_query, $formatted_size, $unit, $overhead
);
}
$html_output .= PMA_getHtmlForStructureTimes(
$create_time, $update_time, $check_time
);
return array($html_output, $approx_rows);
}
/**
* Get HTML snippet view table
*
* @param boolean $is_show_stats whether stats show or not
*
* @return string $html_output
*/
function PMA_getHtmlForViewTable($is_show_stats)
{
$html_output = '
-
'
. '
' . __('View') . '
'
. '
---
';
if ($is_show_stats) {
$html_output .= '
-
'
. '
-
';
}
return $html_output;
}
/**
* display "in use" below for a table that needs to be repaired
*
* @param integer $colspan_for_structure colspan for structure
* @param boolean $db_is_system_schema whether db is information schema or not
*
* @return string HTML snippet
*/
function PMA_getHtmlForRepairtable(
$colspan_for_structure,
$db_is_system_schema
) {
return '
'
. __('in use')
. '
';
}
/**
* display table header (
...)
*
* @param boolean $db_is_system_schema whether db is information schema or not
* @param boolean $replication whether to sho replication status
*
* @return string html data
*/
function PMA_tableHeader($db_is_system_schema = false, $replication = false)
{
$cnt = 0; // Let's count the columns...
if ($db_is_system_schema) {
$action_colspan = 3;
} else {
$action_colspan = 6;
}
if ($GLOBALS['cfg']['NumFavoriteTables'] > 0) {
$action_colspan++;
}
$html_output = '
'
// larger values are more interesting so default sort order is DESC
. '
' . PMA_sortableTableHeader(__('Rows'), 'records', 'DESC')
. PMA_Util::showHint(
PMA_sanitize(
__(
'May be approximate. Click on the number to get the exact'
. ' count. See [doc@faq3-11]FAQ 3.11[/doc].'
)
)
) . "\n"
. '
' . "\n";
$cnt += 2;
}
if ($GLOBALS['cfg']['ShowDbStructureCreation']) {
// larger values are more interesting so default sort order is DESC
$html_output .= '
' . "\n";
$cnt += 2;
}
if ($GLOBALS['cfg']['ShowDbStructureLastUpdate']) {
// larger values are more interesting so default sort order is DESC
$html_output .= '
' . "\n";
$cnt += 2;
}
if ($GLOBALS['cfg']['ShowDbStructureLastCheck']) {
// larger values are more interesting so default sort order is DESC
$html_output .= '
';
}
return $html_output;
}
/**
* Get HTML for "check all" check box with "with selected" actions in table
* structure
*
* @param string $pmaThemeImage pma theme image url
* @param string $text_dir test directory
* @param boolean $tbl_is_view whether table is view or not
* @param boolean $db_is_system_schema whether db is information schema or not
* @param string $tbl_storage_engine table storage engine
*
* @return string $html_output
*/
function PMA_getHtmlForCheckAllTableColumn($pmaThemeImage, $text_dir,
$tbl_is_view, $db_is_system_schema, $tbl_storage_engine
) {
$html_output = '';
$html_output .= ''
. '';
$html_output .= ''
. __('With selected:') . '';
$html_output .= PMA_Util::getButtonOrImage(
'submit_mult', 'mult_submit', 'submit_mult_browse',
__('Browse'), 'b_browse.png', 'browse'
);
if (! $tbl_is_view && ! $db_is_system_schema) {
$html_output .= PMA_Util::getButtonOrImage(
'submit_mult', 'mult_submit change_columns_anchor ajax',
'submit_mult_change', __('Change'), 'b_edit.png', 'change'
);
$html_output .= PMA_Util::getButtonOrImage(
'submit_mult', 'mult_submit', 'submit_mult_drop',
__('Drop'), 'b_drop.png', 'drop'
);
if ('ARCHIVE' != $tbl_storage_engine) {
$html_output .= PMA_Util::getButtonOrImage(
'submit_mult', 'mult_submit', 'submit_mult_primary',
__('Primary'), 'b_primary.png', 'primary'
);
$html_output .= PMA_Util::getButtonOrImage(
'submit_mult', 'mult_submit', 'submit_mult_unique',
__('Unique'), 'b_unique.png', 'unique'
);
$html_output .= PMA_Util::getButtonOrImage(
'submit_mult', 'mult_submit', 'submit_mult_index',
__('Index'), 'b_index.png', 'index'
);
}
if (! empty($tbl_storage_engine) && $tbl_storage_engine == 'MYISAM') {
$html_output .= PMA_Util::getButtonOrImage(
'submit_mult', 'mult_submit', 'submit_mult_spatial',
__('Spatial'), 'b_spatial.png', 'spatial'
);
}
if (! empty($tbl_storage_engine)
&& ($tbl_storage_engine == 'MYISAM'
|| $tbl_storage_engine == 'ARIA'
|| $tbl_storage_engine == 'MARIA')
) {
$html_output .= PMA_Util::getButtonOrImage(
'submit_mult', 'mult_submit', 'submit_mult_fulltext',
__('Fulltext'), 'b_ftext.png', 'ftext'
);
}
if (isset($GLOBALS['cfgRelation']['central_columnswork'])
&& $GLOBALS['cfgRelation']['central_columnswork']
) {
$html_output .= PMA_Util::getButtonOrImage(
'submit_mult', 'mult_submit', 'submit_mult_central_columns_add',
__('Add to central columns'), 'centralColumns_add.png',
'add_to_central_columns'
);
$html_output .= PMA_Util::getButtonOrImage(
'submit_mult', 'mult_submit', 'submit_mult_central_columns_remove',
__('Remove from central columns'), 'centralColumns_delete.png',
'remove_from_central_columns'
);
}
}
return $html_output;
}
/**
* Get HTML for move columns dialog
*
* @return string $html_output
*/
function PMA_getHtmlDivForMoveColumnsDialog()
{
$html_output = '
';
$html_output .= '
'
. __('Move the columns by dragging them up and down.') . '
';
$html_output .= ''
. '
';
return $html_output;
}
/**
* Get HTML for edit views'
*
* @param string $url_params URL parameters
*
* @return string $html_output
*/
function PMA_getHtmlForEditView($url_params)
{
$query = "SELECT `VIEW_DEFINITION`, `CHECK_OPTION`, `DEFINER`, `SECURITY_TYPE`"
. " FROM `INFORMATION_SCHEMA`.`VIEWS`"
. " WHERE TABLE_SCHEMA='" . PMA_Util::sqlAddSlashes($GLOBALS['db']) . "'"
. " AND TABLE_NAME='" . PMA_Util::sqlAddSlashes($GLOBALS['table']) . "';";
$item = $GLOBALS['dbi']->fetchSingleRow($query);
$view = array(
'operation' => 'alter',
'definer' => $item['DEFINER'],
'sql_security' => $item['SECURITY_TYPE'],
'name' => $GLOBALS['table'],
'as' => $item['VIEW_DEFINITION'],
'with' => $item['CHECK_OPTION'],
);
$url = 'view_create.php' . PMA_URL_getCommon($url_params) . '&';
$url .= implode(
'&',
array_map(
function ($key, $val) {
return 'view[' . urlencode($key) . ']=' . urlencode($val);
},
array_keys($view),
$view
)
);
$html_output = PMA_Util::linkOrButton(
$url,
PMA_Util::getIcon('b_edit.png', __('Edit view'), true)
);
return $html_output;
}
/**
* Get HTML links for 'Print view', 'Relation view', 'Propose table structure',
* 'Track table' and 'Move columns'
*
* @param string $url_query url query
* @param boolean $tbl_is_view whether table is view or not
* @param boolean $db_is_system_schema whether db is information schema or not
* @param string $tbl_storage_engine table storage engine
* @param array $cfgRelation current relation parameters
*
* @return string $html_output
*/
function PMA_getHtmlForOptionalActionLinks($url_query, $tbl_is_view,
$db_is_system_schema, $tbl_storage_engine, $cfgRelation
) {
$html_output = ''
. PMA_Util::getIcon('b_print.png', __('Print view'), true)
. '';
if (! $tbl_is_view && ! $db_is_system_schema) {
// if internal relations are available, or foreign keys are supported
// ($tbl_storage_engine comes from libraries/tbl_info.inc.php
if ($cfgRelation['relwork']
|| PMA_Util::isForeignKeySupported($tbl_storage_engine)
) {
$html_output .= ''
. PMA_Util::getIcon(
'b_relations.png', __('Relation view'), true
)
. '';
}
if (!PMA_DRIZZLE) {
$html_output .= ''
. PMA_Util::getIcon(
'b_tblanalyse.png',
__('Propose table structure'),
true
)
. '';
$html_output .= PMA_Util::showMySQLDocu('procedure_analyse') . "\n";
}
if (PMA_Tracker::isActive()) {
$html_output .= ''
. PMA_Util::getIcon('eye.png', __('Track table'), true)
. '';
}
$html_output .= ''
. PMA_Util::getIcon('b_move.png', __('Move columns'), true)
. '';
$html_output .= ''
. PMA_Util::getIcon('normalize.png', __('Improve table structure'), true)
. '';
}
return $html_output;
}
/**
* Get HTML snippet for "Add column" feature in structure table
*
* @param array $columns_list column list array
*
* @return string $html_output
*/
function PMA_getHtmlForAddColumn($columns_list)
{
$html_output = '';
return $html_output;
}
/**
* Get HTML snippet for table rows in the Information ->Space usage table
*
* @param boolean $odd_row whether current row is odd or even
* @param string $name type of usage
* @param string $value value of usage
* @param string $unit unit
*
* @return string $html_output
*/
function PMA_getHtmlForSpaceUsageTableRow($odd_row, $name, $value, $unit)
{
$html_output = '
';
$html_output .= '
' . $name . '
';
$html_output .= '
' . $value . '
';
$html_output .= '
' . $unit . '
';
$html_output .= '
';
return $html_output;
}
/**
* Get HTML for Optimize link if overhead in Information fieldset
*
* @param string $url_query URL query
*
* @return string $html_output
*/
function PMA_getHtmlForOptimizeLink($url_query)
{
$html_output = '
';
return $html_output;
}
/**
* Get HTML for 'Row statistics' table row
*
* @param boolean $odd_row whether current row is odd or even
* @param string $name statement name
* @param mixed $value value
*
* @return string $html_output
*/
function PMA_getHtmlForRowStatsTableRow($odd_row, $name, $value)
{
$html_output = '
';
$html_output .= '
' . $name . '
';
$html_output .= '
' . $value . '
';
$html_output .= '
';
return $html_output;
}
/**
* Get HTML snippet for display Row statistics table
*
* @param array $showtable show table array
* @param string $tbl_collation table collation
* @param boolean $is_innodb whether table is innob or not
* @param boolean $mergetable Checks if current table is a merge table
* @param integer $avg_size average size
* @param string $avg_unit average unit
*
* @return string $html_output
*/
function getHtmlForRowStatsTable($showtable, $tbl_collation,
$is_innodb, $mergetable, $avg_size, $avg_unit
) {
$odd_row = false;
$html_output = '
'
. __("Favorite List is full!")
. '