'; $html .= ''; if ($cfgRelation['pdfwork']) { $pages = PMA_getPageIdsAndNames($db); foreach ($pages as $nr => $desc) { $html .= ''; } } $html .= ''; return $html; } /** * Function to get html for displaying the page edit/delete form * * @param string $db database name * @param string $operation 'edit' or 'delete' depending on the operation * * @return string html content */ function PMA_getHtmlForEditOrDeletePages($db, $operation) { $cfgRelation = PMA_getRelationsParam(); $html = '
'; $html .= PMA_URL_getHiddenInputs($db); $html .= '
'; $html .= ''; $html .= ''; $html .= PMA_getHtmlForPageSelector($cfgRelation, $db); $html .= '
'; $html .= '
'; return $html; } /** * Function to get html for displaying the page save as form * * @param string $db database name * * @return string html content */ function PMA_getHtmlForPageSaveAs($db) { $cfgRelation = PMA_getRelationsParam(); $choices = array( 'same' => __('Save to selected page'), 'new' => __('Create a page and save to it') ); $html = '
'; $html .= PMA_URL_getHiddenInputs($db); $html .= '
'; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= '
'; $html .= ''; $html .= PMA_getHtmlForPageSelector($cfgRelation, $db); $html .= '
'; $html .= PMA_Util::getRadioFields('save_page', $choices, 'same', true); $html .= '
'; $html .= ''; $html .= ''; $html .= '
'; $html .= '
'; $html .= '
'; return $html; } /** * Retrieve IDs and names of schema pages * * @param string $db database name * * @return array array of schema page id and names */ function PMA_getPageIdsAndNames($db) { $cfgRelation = PMA_getRelationsParam(); $page_query = "SELECT `page_nr`, `page_descr` FROM " . PMA_Util::backquote($cfgRelation['db']) . "." . PMA_Util::backquote($cfgRelation['pdf_pages']) . " WHERE db_name = '" . PMA_Util::sqlAddSlashes($db) . "'" . " ORDER BY `page_nr`"; $page_rs = PMA_queryAsControlUser( $page_query, false, PMA_DatabaseInterface::QUERY_STORE ); $result = array(); while ($curr_page = $GLOBALS['dbi']->fetchAssoc($page_rs)) { $result[$curr_page['page_nr']] = $curr_page['page_descr']; } return $result; } /** * Function to get html for displaying the schema export * * @param string $db database name * @param int $page the page to be exported * * @return string */ function PMA_getHtmlForSchemaExport($db, $page) { /* Scan for schema plugins */ $export_list = PMA_getPlugins( "schema", 'libraries/plugins/schema/', null ); /* Fail if we didn't find any schema plugin */ if (empty($export_list)) { return PMA_Message::error( __('Could not load schema plugins, please check your installation!') )->getDisplay(); } $htmlString = '
'; $htmlString .= '
'; $htmlString .= PMA_URL_getHiddenInputs($db); $htmlString .= '
'; $htmlString .= PMA_pluginGetChoice( 'Schema', 'export_type', $export_list, 'format' ); $htmlString .= ''; $htmlString .= PMA_pluginGetOptions('Schema', $export_list); $htmlString .= '
'; $htmlString .= '
'; return $htmlString; } /** * Returns HTML for including some variable to be accessed by JavaScript * * @param array $script_tables array on foreign key support for each table * @param array $script_contr initialization data array * @param array $script_display_field display fields of each table * @param int $display_page page number of the selected page * * @return string html */ function PMA_getHtmlForJSFields( $script_tables, $script_contr, $script_display_field, $display_page ) { $cfgRelation = PMA_getRelationsParam(); $html = '
'; $html .= htmlspecialchars($GLOBALS['server']); $html .= '
'; $html .= '
'; $html .= htmlspecialchars($_GET['db']); $html .= '
'; $html .= '
'; $html .= htmlspecialchars($_GET['token']); $html .= '
'; $html .= '
'; $html .= htmlspecialchars(json_encode($script_tables)); $html .= '
'; $html .= '
'; $html .= htmlspecialchars(json_encode($script_contr)); $html .= '
'; $html .= '
'; $html .= htmlspecialchars(json_encode($script_display_field)); $html .= '
'; $html .= '
'; $html .= htmlspecialchars($display_page); $html .= '
'; $html .= '
'; $html .= htmlspecialchars($cfgRelation['pdfwork']); $html .= '
'; return $html; } /** * Returns HTML for the top menu bar of the designer page * * @param boolean $visualBuilder whether this is visual query builder * @param string $selected_page name of the selected page * * @return string html */ function PMA_getDesignerPageTopMenu($visualBuilder, $selected_page) { $html = '
'; $html .= 'getImgPath('pmd/downarrow2_m.png') . '" />'; $html .= ''; $html .= 'getImgPath('pmd/viewInFullscreen.png') . '" />'; $html .= ''; $html .= 'getImgPath('pmd/exitFullscreen.png') . '" />'; $html .= ''; if (! $visualBuilder) { $html .= 'getImgPath('pmd/bord.png') . '" />'; $html .= 'getImgPath('pmd/page_add.png') . '" />'; $html .= ''; $html .= 'getImgPath('pmd/page_edit.png') . '" />'; $html .= ''; $html .= 'getImgPath('pmd/save.png') . '" />'; $html .= ''; $html .= 'getImgPath('pmd/save_as.png') . '" />'; $html .= ''; $html .= 'getImgPath('pmd/page_delete.png') . '" />'; $html .= ''; } $html .= 'getImgPath('pmd/bord.png') . '" />'; $html .= 'getImgPath('pmd/table.png') . '" />'; $html .= ''; $html .= 'getImgPath('pmd/relation.png') . '" />'; $html .= ''; $html .= 'getImgPath('pmd/display_field.png') . '" />'; $html .= ''; $html .= 'getImgPath('pmd/reload.png') . '" />'; $html .= ''; $html .= 'getImgPath('pmd/help.png') . '" />'; $html .= ''; $html .= 'getImgPath('pmd/bord.png') . '" />'; $html .= 'getImgPath('pmd/ang_direct.png') . '" />'; $html .= ''; $html .= 'getImgPath('pmd/grid.png') . '" />'; $html .= ''; $html .= 'getImgPath('pmd/bord.png') . '" />'; $html .= 'getImgPath('pmd/downarrow1.png') . '" />'; $html .= ''; $html .= 'getImgPath('pmd/bottom.png') . '" />'; $html .= ''; $html .= 'getImgPath('pmd/toggle_lines.png') . '" />'; $html .= ''; if (! $visualBuilder) { $html .= 'getImgPath('pmd/bord.png') . '" />'; $html .= ''; $html .= ($selected_page == null ? __("Untitled") : htmlspecialchars($selected_page)); $html .= ''; $html .= ''; $html .= ($selected_page == null ? '*' : '') . ''; $html .= 'getImgPath('pmd/bord.png') . '" />'; $html .= 'getImgPath('pmd/export.png') . '" />'; $html .= ''; $html .= 'getImgPath('pmd/bord.png') . '" />'; } else { $html .= ''; $html .= ''; } $html .= 'getImgPath('pmd/2rightarrow_m.png') . '" />'; $html .= ''; $html .= '
'; return $html; } /** * Returns HTML for the canvas element * * @return string html */ function PMA_getHTMLCanvas() { $html = '
'; $html .= 'getImgPath('pmd/downarrow1.png') . '" />'; $html .= ''; $html .= 'getImgPath('pmd/downarrow2.png') . '" />'; $html .= ''; $html .= '
'; $html .= '
'; $html .= ''; $name_cnt = count($GLOBALS['PMD']['TABLE_NAME']); for ($i = 0; $i < $name_cnt; $i++) { $html .= ''; $html .= ''; $html .= ''; $html .= ''; } $html .= '
'; $html .= 'getImgPath('pmd/exec.png') . '"/>'; $html .= ''; $html .= ''; $html .= $GLOBALS['PMD_OUT']["TABLE_NAME"][$i]; $html .= '
'; $html .= '
'; // end id_scroll_tab $html .= '
' . __('Number of tables:') . ' ' . $name_cnt . '
'; $html .= '
'; $html .= '
' . '
'; $html .= '
'; $html .= ''; // end layer_menu return $html; } /** * Get HTML to display tables on designer page * * @param array $tab_pos tables positions * @param int $display_page page number of the selected page * @param array $tab_column table column info * @param array $tables_all_keys all indices * @param array $tables_pk_or_unique_keys unique or primary indices * * @return string html */ function PMA_getDatabaseTables( $tab_pos, $display_page, $tab_column, $tables_all_keys, $tables_pk_or_unique_keys ) { $html = ''; for ($i = 0; $i < count($GLOBALS['PMD']["TABLE_NAME"]); $i++) { $t_n = $GLOBALS['PMD']["TABLE_NAME"][$i]; $t_n_url = $GLOBALS['PMD_URL']["TABLE_NAME"][$i]; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; } $html .= ''; $html .= ''; } $html .= ' '; } $html .= ""; } $html .= ""; $html .= "
getImgPath('pmd/exec_small.png') . '" />'; $html .= ''; $html .= '
'; if (isset($tables_pk_or_unique_keys[$t_n . "." . $tab_column[$t_n]["COLUMN_NAME"][$j]])) { $html .= '*'; } else { $html .= ''; $html .= '
"; } return $html; } /** * Returns HTML for the new relations panel. * * @return string html */ function PMA_getNewRelationPanel() { $html = ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= '
'; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; return $html; } /** * Returns HTML for the 'having' panel * * @return string html */ function PMA_getHavingQueryPanel() { $html = ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= '
'; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; return $html; } /** * Returns HTML for the 'aggregate' panel * * @return string html */ function PMA_getAggregateQueryPanel() { $html = ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= '
'; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; return $html; } /** * Returns HTML for the 'where' panel * * @return string html */ function PMA_getWhereQueryPanel() { $html = ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= '
'; $html .= ''; $html .= ''; $html .= ''; $html .= ''; $html .= ''; return $html; } /** * Returns HTML for the query details panel * * @return string html */ function PMA_getQueryDetails() { $html = '
'; $html .= '
'; $html .= '
'; $html .= '
'; $html .= '
'; $html .= '' . __('Active options') . ''; $html .= '
'; $html .= '
'; $html .= ''; $html .= '
'; $html .= '
'; $html .= ' '; $html .= ' '; $html .= PMA_URL_getHiddenInputs($_GET['db']); $html .= '

'; $html .= '
'; return $html; } /** * Return HTML to fetch some images eagerly. * * @return string html */ function PMA_getCacheImages() { $html = ''; $html .= ''; $html .= ''; $html .= ''; $html .= '
'; return $html; } ?>