Управление сайтом

Файловый менеджер

Имя файла	db_datadict.php
Содержимое	<?php /* vim: set expandtab sw=4 ts=4 sts=4: / /* * * @package PhpMyAdmin / /* * Gets the variables sent or posted to this script, then displays headers / require_once './libraries/common.inc.php'; if (! isset($selected_tbl)) { include './libraries/db_common.inc.php'; include './libraries/db_info.inc.php'; } /* * Gets the relations settings / $cfgRelation = PMA_getRelationsParam(); require_once './libraries/transformations.lib.php'; /* * Check parameters / PMA_checkParameters(array('db')); /* * Defines the url to return to in case of error in a sql statement / if (strlen($table)) { $err_url = 'tbl_sql.php?' . PMA_generate_common_url($db, $table); } else { $err_url = 'db_sql.php?' . PMA_generate_common_url($db); } if ($cfgRelation['commwork']) { $comment = PMA_getDbComment($db); /* * Displays DB comment / if ($comment) { ?> <p> <?php echo __('Database comment: '); ?> <i><?php echo htmlspecialchars($comment); ?></i></p> <?php } // end if } /* * Selects the database and gets tables names / PMA_DBI_select_db($db); $tables = PMA_DBI_get_tables($db); $count = 0; foreach ($tables as $table) { $comments = PMA_getComments($db, $table); echo '<div>' . "\n"; echo '<h2>' . htmlspecialchars($table) . '</h2>' . "\n"; /* * Gets table informations / $show_comment = PMA_Table::sGetStatusInfo($db, $table, 'TABLE_COMMENT'); /* * Gets table keys and retains them / PMA_DBI_select_db($db); $indexes = PMA_DBI_get_table_indexes($db, $table); $primary = ''; $indexes = array(); $lastIndex = ''; $indexes_info = array(); $indexes_data = array(); $pk_array = array(); // will be use to emphasis prim. keys in the table // view foreach ($indexes as $row) { // Backups the list of primary keys if ($row['Key_name'] == 'PRIMARY') { $primary .= $row['Column_name'] . ', '; $pk_array[$row['Column_name']] = 1; } // Retains keys informations if ($row['Key_name'] != $lastIndex) { $indexes[] = $row['Key_name']; $lastIndex = $row['Key_name']; } $indexes_info[$row['Key_name']]['Sequences'][] = $row['Seq_in_index']; $indexes_info[$row['Key_name']]['Non_unique'] = $row['Non_unique']; if (isset($row['Cardinality'])) { $indexes_info[$row['Key_name']]['Cardinality'] = $row['Cardinality']; } // I don't know what does following column mean.... // $indexes_info[$row['Key_name']]['Packed'] = $row['Packed']; $indexes_info[$row['Key_name']]['Comment'] = $row['Comment']; $indexes_data[$row['Key_name']][$row['Seq_in_index']]['Column_name'] = $row['Column_name']; if (isset($row['Sub_part'])) { $indexes_data[$row['Key_name']][$row['Seq_in_index']]['Sub_part'] = $row['Sub_part']; } } // end while /* * Gets columns properties / $columns = PMA_DBI_get_columns($db, $table); $fields_cnt = count($columns); if (PMA_MYSQL_INT_VERSION < 50025) { // We need this to correctly learn if a TIMESTAMP is NOT NULL, since // SHOW FULL COLUMNS or INFORMATION_SCHEMA incorrectly says NULL // and SHOW CREATE TABLE says NOT NULL // http://bugs.mysql.com/20910. $show_create_table = PMA_DBI_fetch_value( 'SHOW CREATE TABLE ' . PMA_backquote($db) . '.' . PMA_backquote($table), 0, 1); $analyzed_sql = PMA_SQP_analyze(PMA_SQP_parse($show_create_table)); } // Check if we can use Relations if (!empty($cfgRelation['relation'])) { // Find which tables are related with the current one and write it in // an array $res_rel = PMA_getForeigners($db, $table); if (count($res_rel) > 0) { $have_rel = true; } else { $have_rel = false; } } else { $have_rel = false; } // end if /* * Displays the comments of the table if MySQL >= 3.23 / if (!empty($show_comment)) { echo __('Table comments') . ': ' . htmlspecialchars($show_comment) . '<br /><br />'; } /* * Displays the table structure / ?> <table width="100%" class="print"> <tr><th width="50"><?php echo __('Column'); ?></th> <th width="80"><?php echo __('Type'); ?></th> <?php / <th width="50"><?php echo __('Attributes'); ?></th>/ ?> <th width="40"><?php echo __('Null'); ?></th> <th width="70"><?php echo __('Default'); ?></th> <?php / <th width="50"><?php echo __('Extra'); ?></th>/ ?> <?php if ($have_rel) { echo ' <th>' . __('Links to') . '</th>' . "\n"; } echo ' <th>' . __('Comments') . '</th>' . "\n"; if ($cfgRelation['mimework']) { echo ' <th>MIME</th>' . "\n"; } ?> </tr> <?php $odd_row = true; foreach ($columns as $row) { if ($row['Null'] == '') { $row['Null'] = 'NO'; } $extracted_fieldspec = PMA_extractFieldSpec($row['Type']); // reformat mysql query output // set or enum types: slashes single quotes inside options if ('set' == $extracted_fieldspec['type'] \|\| 'enum' == $extracted_fieldspec['type']) { $type_nowrap = ''; } else { $type_nowrap = ' nowrap="nowrap"'; } $type = htmlspecialchars($extracted_fieldspec['print_type']); $attribute = $extracted_fieldspec['attribute']; if (! isset($row['Default'])) { if ($row['Null'] != 'NO') { $row['Default'] = '<i>NULL</i>'; } } else { $row['Default'] = htmlspecialchars($row['Default']); } $field_name = $row['Field']; if (PMA_MYSQL_INT_VERSION < 50025 && ! empty($analyzed_sql[0]['create_table_fields'][$field_name]['type']) && $analyzed_sql[0]['create_table_fields'][$field_name]['type'] == 'TIMESTAMP' && $analyzed_sql[0]['create_table_fields'][$field_name]['timestamp_not_null']) { // here, we have a TIMESTAMP that SHOW FULL COLUMNS reports as having the // NULL attribute, but SHOW CREATE TABLE says the contrary. Believe // the latter. /* * @todo merge this logic with the one in tbl_structure.php * or move it in a function similar to PMA_DBI_get_columns_full() * but based on SHOW CREATE TABLE because information_schema * cannot be trusted in this case (MySQL bug) / $row['Null'] = 'NO'; } ?> <tr class="<?php echo $odd_row ? 'odd' : 'even'; $odd_row = ! $odd_row; ?>"> <td nowrap="nowrap"> <?php if (isset($pk_array[$row['Field']])) { echo '<u>' . htmlspecialchars($field_name) . '</u>'; } else { echo htmlspecialchars($field_name); } ?> </td> <td<?php echo $type_nowrap; ?> xml:lang="en" dir="ltr"><?php echo $type; ?></td> <?php / <td<?php echo $type_nowrap; ?>><?php echo $attribute; ?></td>/ ?> <td><?php echo (($row['Null'] == 'NO') ? __('No') : __('Yes')); ?></td> <td nowrap="nowrap"><?php if (isset($row['Default'])) { echo $row['Default']; } ?></td> <?php / <td<?php echo $type_nowrap; ?>><?php echo $row['Extra']; ?></td>/ ?> <?php if ($have_rel) { echo ' <td>'; if (isset($res_rel[$field_name])) { echo htmlspecialchars($res_rel[$field_name]['foreign_table'] . ' -> ' . $res_rel[$field_name]['foreign_field']); } echo '</td>' . "\n"; } echo ' <td>'; if (isset($comments[$field_name])) { echo htmlspecialchars($comments[$field_name]); } echo '</td>' . "\n"; if ($cfgRelation['mimework']) { $mime_map = PMA_getMIME($db, $table, true); echo ' <td>'; if (isset($mime_map[$field_name])) { echo htmlspecialchars(str_replace('_', '/', $mime_map[$field_name]['mimetype'])); } echo '</td>' . "\n"; } ?> </tr> <?php } // end foreach $count++; ?> </table> </div> <?php } //ends main while /* * Displays the footer */ PMA_printButton(); require './libraries/footer.inc.php'; ?>

/admin/phpmyadmin/

Имя	Дата	Размер
..	2026-10-02
examples	2013-04-27
js	2013-04-27
libraries	2015-04-04
locale	2013-04-27
setup	2013-04-27
themes	2013-04-27
ChangeLog	2012-10-10	27 кб.
Documentation.html	2012-10-10	252 кб.
Documentation.txt	2012-10-10	176 кб.
LICENSE	2012-10-10	18 кб.
README	2012-10-10	2 кб.
README.VENDOR	2012-10-10	1 кб.
RELEASE-DATE-3.5.2.2	2012-10-10	29 байт
browse_foreigners.php	2012-10-10	11 кб.
bs_disp_as_mime_type.php	2012-10-10	1 кб.
bs_play_media.php	2012-10-10	2 кб.
changelog.php	2012-10-10	4 кб.
chk_rel.php	2012-10-10	363 байт
config.inc.php	2012-10-10	374 байт
config.inc.php.sample	2012-10-10	374 байт
config.sample.inc.php	2012-10-10	4 кб.
db_create.php	2012-10-10	4 кб.
db_datadict.php	2012-10-10	8 кб.
db_events.php	2012-10-10	773 байт
db_export.php	2012-10-10	3 кб.
db_import.php	2012-10-10	466 байт
db_operations.php	2012-10-10	22 кб.
db_printview.php	2012-10-10	7 кб.
db_qbe.php	2012-10-10	30 кб.
db_routines.php	2012-10-10	964 байт
db_search.php	2012-10-10	13 кб.
db_sql.php	2012-10-10	1 кб.
db_structure.php	2012-10-10	24 кб.
db_tracking.php	2012-10-10	8 кб.
db_triggers.php	2012-10-10	728 байт
docs.css	2012-10-10	3 кб.
enum_editor.php	2012-10-10	5 кб.
export.php	2012-10-10	28 кб.
favicon.ico	2012-10-10	18 кб.
file_echo.php	2012-10-10	2 кб.
gis_data_editor.php	2012-10-10	17 кб.
import.php	2012-10-10	17 кб.
import_status.php	2012-10-10	953 байт
index.php	2012-10-10	6 кб.
license.php	2012-10-10	730 байт
main.php	2012-10-10	17 кб.
navigation.php	2012-10-10	25 кб.
phpinfo.php	2012-10-10	349 байт
phpmyadmin.css.php	2012-10-10	1 кб.
pmd_display_field.php	2012-10-10	2 кб.
pmd_general.php	2012-10-10	35 кб.
pmd_pdf.php	2012-10-10	4 кб.
pmd_relation_new.php	2012-10-10	4 кб.
pmd_relation_upd.php	2012-10-10	2 кб.
pmd_save_pos.php	2012-10-10	2 кб.
prefs_forms.php	2012-10-10	3 кб.
prefs_manage.php	2012-10-10	14 кб.
print.css	2012-10-10	1 кб.
querywindow.php	2012-10-10	6 кб.
robots.txt	2012-10-10	26 байт
schema_edit.php	2012-10-10	4 кб.
schema_export.php	2012-10-10	1 кб.
server_binlog.php	2012-10-10	6 кб.
server_collations.php	2012-10-10	3 кб.
server_databases.php	2012-10-10	10 кб.
server_engines.php	2012-10-10	5 кб.
server_export.php	2012-10-10	2 кб.
server_import.php	2012-10-10	477 байт
server_plugins.php	2012-10-10	7 кб.
server_privileges.php	2012-10-10	107 кб.
server_replication.php	2012-10-10	17 кб.
server_sql.php	2012-10-10	743 байт
server_status.php	2012-10-10	76 кб.
server_synchronize.php	2012-10-10	56 кб.
server_variables.php	2012-10-10	6 кб.
show_config_errors.php	2012-10-10	574 байт
sql.php	2012-10-10	37 кб.
tbl_addfield.php	2012-10-10	8 кб.
tbl_alter.php	2012-10-10	7 кб.
tbl_change.php	2012-10-10	49 кб.
tbl_chart.php	2012-10-10	6 кб.
tbl_create.php	2012-10-10	14 кб.
tbl_export.php	2012-10-10	3 кб.
tbl_get_field.php	2012-10-10	1 кб.
tbl_gis_visualization.php	2012-10-10	7 кб.
tbl_import.php	2012-10-10	624 байт
tbl_indexes.php	2012-10-10	9 кб.
tbl_move_copy.php	2012-10-10	3 кб.
tbl_operations.php	2012-10-10	32 кб.
tbl_printview.php	2012-10-10	14 кб.
tbl_relation.php	2012-10-10	23 кб.
tbl_replace.php	2012-10-10	23 кб.
tbl_row_action.php	2012-10-10	5 кб.
tbl_select.php	2012-10-10	10 кб.
tbl_sql.php	2012-10-10	1 кб.
tbl_structure.php	2012-10-10	39 кб.
tbl_tracking.php	2012-10-10	28 кб.
tbl_triggers.php	2012-10-10	144 байт
tbl_zoom_select.php	2012-10-10	17 кб.
themes.php	2012-10-10	822 байт
transformation_overview.php	2012-10-10	2 кб.
transformation_wrapper.php	2012-10-10	3 кб.
url.php	2012-10-10	391 байт
user_password.php	2012-10-10	4 кб.
view_create.php	2012-10-10	5 кб.
view_operations.php	2012-10-10	3 кб.
webapp.php	2012-10-10	1 кб.

/admin/phpmyadmin