/**
* Function to handle updates for internal relations
*
* @param string $destination_db destination database
* @param string $multi_edit_columns_name multi edit column name
* @param string $destination_table destination table
* @param string $destination_column destination column
* @param array $cfgRelation configuration relation
* @param string $db current database
* @param string $table current table
* @param array $existrel db, table, column
*
* @return void
*/
function PMA_handleUpdatesForInternalRelations($destination_db, $multi_edit_columns_name, $destination_table, $destination_column, $cfgRelation, $db, $table, $existrel)
{
foreach ($destination_db as $master_field_md5 => $foreign_db) {
$upd_query = PMA_getQueryForInternalRelationUpdate($multi_edit_columns_name, $master_field_md5, $foreign_db, $destination_table, $destination_column, $cfgRelation, $db, $table, isset($existrel) ? $existrel : null);
if ($upd_query) {
PMA_queryAsControlUser($upd_query);
}
}
}
/**
* Function to handle updates for internal relations
*
* @param array $destination_db destination databases
* @param array $multi_edit_columns_name multi edit column names
* @param array $destination_table destination tables
* @param array $destination_column destination columns
* @param array $cfgRelation configuration relation
* @param string $db current database
* @param string $table current table
* @param array|null $existrel db, table, column
*
* @return string
*/
function PMA_handleUpdatesForInternalRelations($destination_db, $multi_edit_columns_name, $destination_table, $destination_column, $cfgRelation, $db, $table, $existrel)
{
$html_output = '';
$updated = false;
foreach ($destination_db as $master_field_md5 => $foreign_db) {
$upd_query = PMA_getQueryForInternalRelationUpdate($multi_edit_columns_name, $master_field_md5, $foreign_db, $destination_table, $destination_column, $cfgRelation, $db, $table, isset($existrel) ? $existrel : null);
if ($upd_query) {
PMA_queryAsControlUser($upd_query);
$updated = true;
}
}
if ($updated) {
$html_output = PMA_Util::getMessage(__('Internal relations were successfully updated.'), '', 'success');
}
return $html_output;
}
