|
|
= 40100 ? '' . $fields_collation[$i] . ' | ' . "\n" : ''; ?>
|
$field = $fields_list[$i];
// do not use require_once here
require('./libraries/get_foreign.lib.php');
echo "\n";
// we got a bug report: in some cases, even if $disp is true,
// there are no rows, so we add a fetch_array
if ($foreigners && isset($foreigners[$field]) && isset($disp_row) && is_array($disp_row)) {
// f o r e i g n k e y s
echo ' ' . "\n";
} else if (isset($foreign_link) && $foreign_link == true) {
?>
' . "\n";
for ($j = 0; $j < $cnt_enum_value; $j++) {
echo ' ';
} // end for
echo ' ' . "\n";
} else {
// o t h e r c a s e s
echo ' ' . "\n";
}
?>
|
';
if ($propicon == 'both') {
$titles['Browse'] .= ' ' . $strBrowseForeignValues . '';
}
} else {
$titles['Browse'] = $strBrowseForeignValues;
}
/**
* Not selection yet required -> displays the selection form
*/
if (!isset($param) || $param[0] == '') {
// Gets some core libraries
require('./tbl_properties_common.php');
//$err_url = 'tbl_select.php' . $err_url;
$url_query .= '&goto=tbl_select.php&back=tbl_select.php';
/**
* Gets tables informations
*/
require('./tbl_properties_table_info.php');
/**
* Displays top menu links
*/
require('./tbl_properties_links.php');
if (!isset($goto)) {
$goto = $cfg['DefaultTabTable'];
}
// Defines the url to return to in case of error in the next sql statement
$err_url = $goto . '?' . PMA_generate_common_url($db, $table);
// Gets the list and number of fields
$result = PMA_DBI_query('SHOW' . (PMA_MYSQL_INT_VERSION >= 40100 ? ' FULL' : '') . ' FIELDS FROM ' . PMA_backquote($table) . ' FROM ' . PMA_backquote($db) . ';', NULL, PMA_DBI_QUERY_STORE);
$fields_cnt = PMA_DBI_num_rows($result);
// rabue: we'd better ensure, that all arrays are empty.
$fields_list = $fields_null = $fields_type = $fields_collation = array();
while ($row = PMA_DBI_fetch_assoc($result)) {
$fields_list[] = $row['Field'];
$type = $row['Type'];
// reformat mysql query output - staybyte - 9. June 2001
if (strncasecmp($type, 'set', 3) == 0
|| strncasecmp($type, 'enum', 4) == 0) {
$type = str_replace(',', ', ', $type);
} else {
$type = str_replace(array('binary', 'zerofill', 'unsigned'), '', strtolower($type));
}
if (empty($type)) {
$type = ' ';
}
$fields_null[] = $row['Null'];
$fields_type[] = $type;
$fields_collation[] = PMA_MYSQL_INT_VERSION >= 40100 && !empty($row['Collation']) && $row['Collation'] != 'NULL'
? $row['Collation']
: '';
} // end while
PMA_DBI_free_result($result);
unset($result, $type);
//