0 ) {
$sql_query = 'ALTER TABLE ' . PMA_backquote($GLOBALS['table']);
$sql_query .= "\r\n" . implode("\r\n", $table_alters);
$message = PMA_DBI_query($sql_query) ? $strSuccess : $strError;
$reread_info = true;
unset( $table_alters );
}
}
/**
* Reordering the table has been requested by the user
*/
if ( isset( $_REQUEST['submitorderby'] ) && ! empty( $_REQUEST['order_field'] ) ) {
$sql_query = '
ALTER TABLE ' . PMA_backquote($GLOBALS['table']) . '
ORDER BY ' . PMA_backquote(urldecode($_REQUEST['order_field']));
if ( isset( $_REQUEST['order_order'] ) && $_REQUEST['order_order'] === 'desc' ) {
$sql_query .= ' DESC';
}
$message = PMA_DBI_query($sql_query) ? $strSuccess : $strError;
} // end if
if ( $reread_info ) {
$pack_keys = $checksum = $delay_key_write = 0;
require('./libraries/tbl_properties_table_info.inc.php');
}
unset( $reread_info );
/**
* Displays top menu links
*/
require_once('./libraries/tbl_properties_links.inc.php');
$url_params['goto'] = 'tbl_properties_operations.php';
$url_params['back'] = 'tbl_properties_operations.php';
/**
* Get columns names
*/
$local_query = '
SHOW COLUMNS
FROM ' . PMA_backquote($GLOBALS['table']) . '
FROM ' . PMA_backquote($GLOBALS['db']);
$columns = PMA_DBI_fetch_result($local_query, null, 'Field');
unset( $local_query );
/**
* Displays the page
*/
?>
5.0.4, >4.1.12 and >4.0.11, so I decided not to
// check for version
?>
'CHECK TABLE ' . PMA_backquote($GLOBALS['table']) ));
?>
-
'ALTER TABLE ' . PMA_backquote($GLOBALS['table']) . ' ' . PMA_ENGINE_KEYWORD . '=InnoDB' ));
?>
-
'ANALYZE TABLE ' . PMA_backquote($GLOBALS['table']) ));
?>
-
'REPAIR TABLE ' . PMA_backquote($GLOBALS['table']) ));
?>
-
'OPTIMIZE TABLE ' . PMA_backquote($GLOBALS['table']) ));
?>
-
'FLUSH TABLE ' . PMA_backquote($GLOBALS['table']),
'zero_rows' => sprintf($strTableHasBeenFlushed,
htmlspecialchars($GLOBALS['table'])),
'reload' => 1,
));
?>
-
$arr) {
$join_query = 'SELECT ' . PMA_backquote($GLOBALS['table']) . '.* FROM '
. PMA_backquote($GLOBALS['table']) . ' LEFT JOIN '
. PMA_backquote($arr['foreign_table']);
if ($arr['foreign_table'] == $GLOBALS['table']) {
$foreign_table = $GLOBALS['table'] . '1';
$join_query .= ' AS ' . PMA_backquote($foreign_table);
} else {
$foreign_table = $arr['foreign_table'];
}
$join_query .= ' ON '
. PMA_backquote($GLOBALS['table']) . '.' . PMA_backquote($master)
. ' = ' . PMA_backquote($foreign_table) . '.' . PMA_backquote($arr['foreign_field'])
. ' WHERE '
. PMA_backquote($foreign_table) . '.' . PMA_backquote($arr['foreign_field'])
. ' IS NULL AND '
. PMA_backquote($GLOBALS['table']) . '.' . PMA_backquote($master)
. ' IS NOT NULL';
$this_url_params = array_merge($url_params,
array( 'sql_query' => $join_query ));
echo ' - '
. '' . $master . ' -> ' . $arr['foreign_table'] . '.' . $arr['foreign_field']
. '
' . "\n";
} // foreach $foreign
unset($foreign_table, $join_query);
?>