/** * Function to handle foreign key updates * * @param string $destination_foreign_db destination foreign database * @param string $multi_edit_columns_name multi edit column names * @param string $destination_foreign_table destination foreign table * @param string $destination_foreign_column destination foreign column * @param array $options_array options array * @param string $table current table * @param array $existrel_foreign db, table, column * * @return string */ function PMA_handleUpdatesForForeignKeys($destination_foreign_db, $multi_edit_columns_name, $destination_foreign_table, $destination_foreign_column, $options_array, $table, $existrel_foreign) { $html_output = ''; $display_query = ''; $seen_error = false; foreach ($destination_foreign_db as $master_field_md5 => $foreign_db) { $html_output .= PMA_handleUpdateForForeignKey($multi_edit_columns_name, $master_field_md5, $destination_foreign_table, $destination_foreign_column, $options_array, $existrel_foreign, $table, $seen_error, $display_query, $foreign_db); } // end foreach if (!empty($display_query) && !$seen_error) { $GLOBALS['display_query'] = $display_query; $html_output = PMA_Util::getMessage(__('Your SQL query has been executed successfully.'), null, 'success'); } return $html_output; }
/** * Function to handle foreign key updates * * @param array $destination_foreign_db destination foreign database * @param array $multi_edit_columns_name multi edit column names * @param array $destination_foreign_table destination foreign table * @param array $destination_foreign_column destination foreign column * @param array $options_array options array * @param string $table current table * @param array $existrel_foreign db, table, column * * @return string */ function PMA_handleUpdatesForForeignKeys($destination_foreign_db, $multi_edit_columns_name, $destination_foreign_table, $destination_foreign_column, $options_array, $table, $existrel_foreign) { $html_output = ''; $preview_sql_data = ''; $display_query = ''; $seen_error = false; $preview_sql = isset($_REQUEST['preview_sql']) ? true : false; foreach ($destination_foreign_db as $master_field_md5 => $foreign_db) { list($html, $sql_data) = PMA_handleUpdateForForeignKey($multi_edit_columns_name, $master_field_md5, $destination_foreign_table, $destination_foreign_column, $options_array, $existrel_foreign, $table, $seen_error, $display_query, $foreign_db, $preview_sql); $html_output .= $html; $preview_sql_data .= $sql_data; } // end foreach // If there is a request for SQL previewing. if ($preview_sql) { PMA_previewSQL($preview_sql_data); } if (!empty($display_query) && !$seen_error) { $GLOBALS['display_query'] = $display_query; $html_output = PMA_Util::getMessage(__('Your SQL query has been executed successfully.'), null, 'success'); } return $html_output; }