'
. '| '
. '' . $myfield_html . ''
. ''
. ' | ';
$html_output .= '';
$foreign_table = false;
$foreign_column = false;
// database dropdown
if (isset($existrel[$myfield])) {
$foreign_db = $existrel[$myfield]['foreign_db'];
} else {
$foreign_db = $db;
}
$html_output .= PMA_generateRelationalDropdown(
'destination_db[' . $myfield_md5 . ']',
$GLOBALS['pma']->databases,
$foreign_db,
__('Database')
);
// end of database dropdown
// table dropdown
$tables = array();
if ($foreign_db) {
if (isset($existrel[$myfield])) {
$foreign_table = $existrel[$myfield]['foreign_table'];
}
$tables_rs = $GLOBALS['dbi']->query(
'SHOW TABLES FROM ' . PMA_Util::backquote($foreign_db),
null,
PMA_DatabaseInterface::QUERY_STORE
);
while ($row = $GLOBALS['dbi']->fetchRow($tables_rs)) {
$tables[] = $row[0];
}
}
$html_output .= PMA_generateRelationalDropdown(
'destination_table[' . $myfield_md5 . ']',
$tables,
$foreign_table,
__('Table')
);
// end of table dropdown
// column dropdown
$columns = array();
if ($foreign_db && $foreign_table) {
if (isset($existrel[$myfield])) {
$foreign_column = $existrel[$myfield]['foreign_field'];
}
$table_obj = new PMA_Table($foreign_table, $foreign_db);
$columns = $table_obj->getUniqueColumns(false, false);
}
$html_output .= PMA_generateRelationalDropdown(
'destination_column[' . $myfield_md5 . ']',
$columns,
$foreign_column,
__('Column')
);
// end of column dropdown
$html_output .= ' | ';
$html_output .= '
';
return $html_output;
}
/**
* Function to get html for Foreign key form
*
* @param array $columns columns
* @param array $existrel_foreign db, table, column
* @param string $db current database
* @param string $tbl_storage_engine table storage engine
* @param array $options_array options array
*
* @return string
*/
function PMA_getHtmlForForeignKeyForm($columns, $existrel_foreign, $db,
$tbl_storage_engine, $options_array
) {
$html_output = '';
// Drop key anchor.
$html_output .= '| ';
if (isset($one_key['constraint'])) {
$drop_fk_query = 'ALTER TABLE ' . PMA_Util::backquote($GLOBALS['table'])
. ' DROP FOREIGN KEY '
. PMA_Util::backquote($one_key['constraint']) . ';';
$this_params = $GLOBALS['url_params'];
$this_params['goto'] = 'tbl_relation.php';
$this_params['back'] = 'tbl_relation.php';
$this_params['sql_query'] = $drop_fk_query;
$this_params['message_to_show'] = sprintf(
__('Foreign key constraint %s has been dropped'),
$one_key['constraint']
);
$js_msg = PMA_jsFormat(
'ALTER TABLE ' . $GLOBALS['table']
. ' DROP FOREIGN KEY '
. $one_key['constraint'] . ';'
);
$html_output .= '';
$html_output .= ' '
. PMA_Util::getIcon('b_drop.png', __('Drop')) . '';
}
$html_output .= ' | ';
$html_output .= '';
$html_output .= '';
$constraint_name = isset($one_key['constraint'])
? $one_key['constraint'] : '';
$html_output .= __('Constraint name');
$html_output .= '';
$html_output .= '' . "\n";
$html_output .= '';
// For ON DELETE and ON UPDATE, the default action
// is RESTRICT as per MySQL doc; however, a SHOW CREATE TABLE
// won't display the clause if it's set as RESTRICT.
$on_delete = isset($one_key['on_delete'])
? $one_key['on_delete'] : 'RESTRICT';
$html_output .= PMA_generateDropdown(
'ON DELETE',
'on_delete[' . $i . ']',
$options_array,
$on_delete
);
$html_output .= '' . "\n";
$html_output .= '' . "\n";
$on_update = isset($one_key['on_update'])
? $one_key['on_update'] : 'RESTRICT';
$html_output .= PMA_generateDropdown(
'ON UPDATE',
'on_update[' . $i . ']',
$options_array,
$on_update
);
$html_output .= '';
$column_array = array();
$column_array[''] = '';
foreach ($columns as $column) {
if (! empty($column['Key'])) {
$column_array[$column['Field']] = $column['Field'];
}
}
$html_output .= '' . "\n";
$html_output .= ' | ';
$html_output .= '';
if (isset($one_key['index_list'])) {
foreach ($one_key['index_list'] as $key => $column) {
$html_output .= '';
$html_output .= PMA_generateDropdown(
'',
'foreign_key_fields_name[' . $i . '][]',
$column_array,
$column
);
$html_output .= '';
}
} else {
$html_output .= '';
$html_output .= PMA_generateDropdown(
'',
'foreign_key_fields_name[' . $i . '][]',
$column_array,
''
);
$html_output .= '';
}
$html_output .= ''
. __('+ Add column')
. '';
$html_output .= ' | ';
$html_output .= '';
$foreign_table = false;
// foreign database dropdown
$foreign_db = (isset($one_key['ref_db_name'])) ? $one_key['ref_db_name'] : $db;
$html_output .= '';
$html_output .= PMA_generateRelationalDropdown(
'destination_foreign_db[' . $i . ']',
$GLOBALS['pma']->databases,
$foreign_db,
__('Database')
);
// end of foreign database dropdown
$html_output .= ' | ';
$html_output .= '';
// foreign table dropdown
$tables = array();
if ($foreign_db) {
$foreign_table = isset($one_key['ref_table_name'])
? $one_key['ref_table_name'] : '';
// In Drizzle, 'SHOW TABLE STATUS' will show status only for the tables
// which are currently in the table cache. Hence we have to use
// 'SHOW TABLES' and manualy retrieve table engine values.
if (PMA_DRIZZLE) {
$tables_rs = $GLOBALS['dbi']->query(
'SHOW TABLES FROM ' . PMA_Util::backquote($foreign_db),
null,
PMA_DatabaseInterface::QUERY_STORE
);
while ($row = $GLOBALS['dbi']->fetchArray($tables_rs)) {
$engine = PMA_Table::sGetStatusInfo(
$foreign_db,
$row[0],
'Engine'
);
if (isset($engine)
&& /*overload*/mb_strtoupper($engine) == $tbl_storage_engine
) {
$tables[] = $row[0];
}
}
} else {
$tables_rs = $GLOBALS['dbi']->query(
'SHOW TABLE STATUS FROM ' . PMA_Util::backquote($foreign_db),
null,
PMA_DatabaseInterface::QUERY_STORE
);
while ($row = $GLOBALS['dbi']->fetchRow($tables_rs)) {
if (isset($row[1])
&& /*overload*/mb_strtoupper($row[1]) == $tbl_storage_engine
) {
$tables[] = $row[0];
}
}
}
}
$html_output .= '';
$html_output .= PMA_generateRelationalDropdown(
'destination_foreign_table[' . $i . ']',
$tables,
$foreign_table,
__('Table')
);
$html_output .= '';
// end of foreign table dropdown
$html_output .= ' | ';
$html_output .= '';
// foreign column dropdown
if ($foreign_db && $foreign_table) {
foreach ($one_key['ref_index_list'] as $foreign_column) {
$table_obj = new PMA_Table($foreign_table, $foreign_db);
$columns = $table_obj->getUniqueColumns(false, false);
$html_output .= '';
$html_output .= PMA_generateRelationalDropdown(
'destination_foreign_column[' . $i . '][]',
$columns,
$foreign_column,
__('Column')
);
$html_output .= '';
}
} else {
$html_output .= '';
$html_output .= PMA_generateRelationalDropdown(
'destination_foreign_column[' . $i . '][]',
array(),
'',
__('Column')
);
$html_output .= '';
}
// end of foreign column dropdown
$html_output .= ' | ';
$html_output .= '
';
return $html_output;
}
/**
* Function to get html for the common form header
*
* @param string $db current database
* @param string $table current table
*
* @return string
*/
function PMA_getHtmlForCommonFormHeader($db, $table)
{
return '