October 2002 - Developers - lists.phpmyadmin.net

[Phpmyadmin-devel] 2.3.3 freeze....
by Marc Delisle 11 Nov '02

11 Nov '02

and RC1 could occur on Nov. 17, with a release on Dec. 1st. Marc

2 1

[Phpmyadmin-devel] BugFix question
by Robin Johnson 02 Nov '02

02 Nov '02

Hi List, Just a question to ask the list. Alex posted these fixes to libraries/sqlparser.lib.php3: @@ -171,6 +171,10 @@ if (!defined('PMA_SQP_LIB_INCLUDED')) { return $sql; } + // rabus: Convert all line feeds to Unix style + $sql = str_replace("\r\n", "\n", $sql); + $sql = str_replace("\r", "\n", $sql); + $len = $GLOBALS['PMA_strlen']($sql); if ($len == 0) { return array(); This changes newline contents for the query before any parsing is done. I think this should be avoided at this point, as it removes some newlines out of string escaped variables. Eg I might have SELECT 'foo\n\r\n\rbar'; # foo, bar, sepereated by TWO lines we should actually preserve the contents of strings as they are. If anybody can show me a testcase where we actually need this str_replace, then we can revise it, but I can't think of any, so in the name of speed, it should get removed. @@ -227,7 +231,7 @@ if (!defined('PMA_SQP_LIB_INCLUDED')) { // ANSI style -- if (($c == '#') || (($count2 + 1 < $len) && ($c == '/') && ($sql[$count2 + 1] == '*')) - || (($count2 + 2 < $len) && ($c == '-') && ($sql[$count2 + 1] == '-') && ($sql[$count2 + 2] == ' '))) { + || (($count2 + 2 < $len) && ($c == '-') && ($sql[$count2 + 1] == '-') && ereg("(\n|[space])", $sql[$count2 + 2]))) { $count2++; $pos = 0; $type = 'bad'; Intend that it could match broken ANSI comments of '--\n' in addition to the standard '-- '. Should we support this as it is partially supported by MySQL? I say partially, because the MySQL commandline client strips out anything matching '--.*\n', but the actualy MySQL server if it is sent raw commands throws a syntax error on '--\n'. I would say that we should follow the MySQL server in handling the input. If we do keep it, lets change it to use only direct comparisions instead of regular expressions. Regex should be avoided inside the parser, as it makes code much slower. -- Robin Hugh Johnson E-Mail : robbat2(a)orbis-terrarum.net Home Page : http://www.orbis-terrarum.net/?l=people.robbat2 ICQ# : 30269588 or 41961639 GnuPG FP : 11AC BA4F 4778 E3F6 E4ED F38E B27B 944E 3488 4E85

3 5

[Phpmyadmin-devel] structure diff - possible patch
by Eric Persson 31 Oct '02

31 Oct '02

Hi everyone, Some of you might remember I asked for a structure diff earlier, I want to compare 2 tables and get an alter query which would make the target table to look exactly like the original table. I have now made a small hack which almost does this, at least it show the idea of what I want it to be. I added the file diff_tables.php which currently takes ?db as an get argument. It shows the table in that database and you can pick 2 tables to compare and you get a hopefully working alter query. :) I modified left.php to show a link after the num_tables, like (diff) which goes to diff_tables.php with ?db as the database. If you want to try it out, patch your 2.3.2 version of phpmyadmin with the files, or visit http://www.egp.cx/phpMyAdmin-2.3.2/ where I put up a patched version. Please dont destroy the tables to much. :) Some ideas of what to improve: * maintain the order of the fields * maintain keys/indexes and auto_increment fields * make it possible to diff tables between databases * make it possible to diff create table queries * create a nice graphical view over whats added/changed/dropped Do you have any furhter suggestions? Please comment and try it out and think about it. The code is still very hacky, and I might have re-invented the wheel in some places, but I'm not yet familiar with all libraryfiles etc. Best regards, Eric <?php /* Example tables to diff # # Table structure for table `table1` # CREATE TABLE table1 ( tbl_id int(10) unsigned NOT NULL auto_increment, str varchar(100) NOT NULL default '', params enum('y','n','k') NOT NULL default 'n', newfield varchar(10) NOT NULL default '', PRIMARY KEY (tbl_id) ) TYPE=MyISAM; # -------------------------------------------------------- # # Table structure for table `table2` # CREATE TABLE table2 ( tbl_id int(10) unsigned NOT NULL auto_increment, str varchar(10) NOT NULL default '', params enum('y','n') NOT NULL default 'n', PRIMARY KEY (tbl_id) ) TYPE=MyISAM; */ /** * Gets some core libraries */ require('./libraries/grab_globals.lib.php'); $sub_part = '_export'; require('./db_details_common.php'); $url_query .= '&goto=db_details_export.php'; require('./db_details_db_info.php'); $js_to_run = 'functions.js'; require('./libraries/sqlparser.lib.php'); require('./libraries/build_dump.lib.php'); ?> <h1>Diff tables</h1><br> <FORM METHOD=POST ACTION=""> <pre> <? #echo "<pre>"; #var_dump($GLOBALS); #echo "</pre>"; function PMA_table_struct($db, $table){ $struct = array(); $res = PMA_mysql_query('DESCRIBE '.$db.'.'.$table); while( $row = PMA_mysql_fetch_array($res) ){ $struct[$row['Field']] = array( 'type' => $row['Type'], 'null' => $row['Null'], 'key' => $row['Key'], 'default'=> $row['Default'], 'extra' => $row['Extra'] ); } return $struct; } function PMA_diff_length($type){ /* check length */ if( eregi('$([0-9]*)$', $type, $regs) ) $length = $regs[1]; else $length = 0; return $length; } function PMA_diff_type($type){ return $type; /* check type */ if( ereg('^([^(]*)', $type, $regs) ) $type = $regs[1]; else $type = ''; $type = trim($type); return $type; } function PMA_alter_string($field_name, $struct, $alter_type, $first_row=false){ # echo $field_name."\n"; # var_dump($struct); $alter = ''; if( !$first_row ) $alter.=','.chr(10); $alter.=chr(9).$alter_type.' '; $alter.=$field_name.' '; if( $alter_type!='DROP' ){ if( $alter_type=='CHANGE' ) $alter.=' '.$field_name.' '; $alter.=$struct['type']; $alter.=' '.$struct['null']; if( $struct['default']!="" ) $alter.=' DEFAULT "'.$struct['default'].'" '; } return $alter; } function PMA_diff_table_structs($original_table_struct, $target_table_struct, $target_table){ if( is_array($original_table_struct) ) reset($original_table_struct); if( is_array($target_table_struct) ) reset($target_table_struct); $removed_fields = array(); $added_fields = array(); $modified_fields = array(); while( list($field, $field_def)=each($original_table_struct) ){ # echo $field_def['type']." - type:".PMA_diff_type($field_def['type'])."\n"; # echo "length:".PMA_diff_length($field_def['type'])."\n"; if( isset($target_table_struct[$field]) ){ $mod = array(); $target_field_def = $target_table_struct[$field]; $type = PMA_diff_type($field_def['type']); $length = PMA_diff_length($field_def['type']); $target_type = PMA_diff_type($target_field_def['type']); $target_length = PMA_diff_length($target_field_def['type']); if( $type!=$target_type ) $mod[] = 'type'; if( $length!=$target_length ) $mod[] = 'length - '.$length.' - '.$target_length; if( $field_def['null']!=$target_field_def['null'] ) $mod[] = 'null'; if( $field_def['key']!=$target_field_def['key'] ) $mod[] = 'key'; if( $field_def['default']!=$target_field_def['default'] ) $mod[] = 'default'; if( $field_def['extra']!=$target_field_def['extra'] ) $mod[] = 'extra'; if( sizeof($mod)>0 ) $modified_fields[$field] = $mod; }else{ $added_fields[] = $field; } } while( list($field, $field_def)=each($target_table_struct) ){ if( !isset($original_table_struct[$field]) ) $removed_fields[] = $field; } # echo "\nAdded fields:\n"; # var_dump($added_fields); # echo "\nRemoved fields:\n"; # var_dump($removed_fields); # echo "\nModified fields:\n"; # var_dump($modified_fields); if( sizeof($added_fields)>0 || sizeof($removed_fields)>0 || sizeof($modified_fields)>0 ){ $alter_query = 'ALTER TABLE '.$target_table.' '.chr(10); $first_row = true; while( list(, $name)=each($added_fields) ){ if( isset($original_table_struct[$name]) ){ $alter_query.=PMA_alter_string($name, $original_table_struct[$name], 'ADD', $first_row); $last_row_count++; } $first_row = false; } while( list($name, $mod)=each($modified_fields) ){ if( isset($original_table_struct[$name]) ){ $alter_query.=PMA_alter_string($name, $original_table_struct[$name], 'CHANGE', $first_row); $last_row_count++; } $first_row = false; } while( list(, $name)=each($removed_fields) ){ $alter_query.=PMA_alter_string($name, $original_table_struct[$name], 'DROP', $first_row); $last_row_count++; $first_row = false; } $alter_query.=';'.chr(10); }else{ $alter_query = 'No diff'; } return $alter_query; } if( isset($HTTP_POST_VARS['original_table']) && isset($HTTP_POST_VARS['target_table']) ){ $crlf = PMA_whichCrlf(); $original_table = $HTTP_POST_VARS['original_table']; $target_table = $HTTP_POST_VARS['target_table']; #echo "diffing ".$original_table." to ".$target_table."....<br>"; #echo "\n"; #echo "Struct for ".$original_table."\n\n"; $original_table_struct = PMA_getTableDef($db, $original_table, "\n", $err_url); # echo $original_table_struct; #echo "\n\nInfo\n"; $original_table_info = PMA_SQP_analyze(array($original_table_struct)); #var_dump($original_table_info); #echo "\n\nBuilding struct...\n\n"; $original_table_arr_struct = PMA_table_struct($db, $original_table); #var_dump($original_table_arr_struct); #echo "\n\n\n"; #echo "Struct for ".$target_table."\n\n"; #echo PMA_getTableDef($db, $target_table, $crlf, $err_url); #echo "\n\nBuilding struct...\n\n"; $target_table_arr_struct = PMA_table_struct($db, $target_table); #var_dump($target_table_arr_struct); #echo "\n\n\nDiff structs...\n\n\n"; ?> <TABLE cellpadding="0" cellspacing="0" border="0"> <TR> <TD valign="top"> <?echo '<b>'.$original_table.'</b>';?> <table border="<?php echo $cfg['Border']; ?>"> <tr> <td></td> <th> <?php echo ucfirst($strField); ?> </th> <th><?php echo ucfirst($strType); ?></th> <th><?php echo ucfirst($strAttr); ?></th> <th><?php echo ucfirst($strNull); ?></th> <th><?php echo ucfirst($strDefault); ?></th> <th><?php echo ucfirst($strExtra); ?></th> </tr> <? $i=0; while( list($field, $field_def)=each($original_table_arr_struct) ){ ?> <tr bgcolor="<? echo (($i % 2) ? $cfg['BgcolorOne'] : $cfg['BgcolorTwo']);?>"> <td></td> <td> <?php echo $field; ?> </td> <td><?php echo $field_def['type']; ?></td> <td> </td> <td><?php echo $field_def['null']; ?></td> <td><?php echo $field_def['default']; ?></td> <td><?php echo $field_def['extra']; ?></td> </tr> <? $i++; } ?> </table> </TD> <TD align="right" valign="top"> <?echo '<b>'.$target_table.'</b>';?> <table border="<?php echo $cfg['Border']; ?>"> <tr> <td></td> <th> <?php echo ucfirst($strField); ?> </th> <th><?php echo ucfirst($strType); ?></th> <th><?php echo ucfirst($strAttr); ?></th> <th><?php echo ucfirst($strNull); ?></th> <th><?php echo ucfirst($strDefault); ?></th> <th><?php echo ucfirst($strExtra); ?></th> </tr> <? $i=0; while( list($field, $field_def)=each($target_table_arr_struct) ){ ?> <tr bgcolor="<? echo (($i % 2) ? $cfg['BgcolorOne'] : $cfg['BgcolorTwo']);?>"> <td></td> <td> <?php echo $field; ?> </td> <td><?php echo $field_def['type']; ?></td> <td> </td> <td><?php echo $field_def['null']; ?></td> <td><?php echo $field_def['default']; ?></td> <td><?php echo $field_def['extra']; ?></td> </tr> <? $i++; } ?> </table> </TD> </TR> <tr> <td bgcolor="<?echo $cfg['BgcolorOne'];?>" colspan="2"> <b>Alter query:</b><br> <pre> <? $alter_query = PMA_diff_table_structs($original_table_arr_struct, $target_table_arr_struct, $target_table); echo $alter_query; ?> </pre> <br> <br> </td> </tr> </TABLE> <? } ?> </pre> <br><br><br><br><br><br><br><br> <TABLE> <TR> <TD> original table<br> <SELECT NAME="original_table"> <? $i=0; while( $i<$num_tables ){ echo '<option value="'.$tables[$i]['Name'].'">'.$tables[$i]['Name'].'</option>'.chr(10); $i++; } ?> </SELECT> </TD> <TD> target table<br> <SELECT NAME="target_table"> <? $i=0; while( $i<$num_tables ){ echo '<option value="'.$tables[$i]['Name'].'">'.$tables[$i]['Name'].'</option>'.chr(10); $i++; } ?> </SELECT> </TD> </TR> </TABLE> <br> <br> <INPUT TYPE="submit" value="Diff"> </FORM> <? require('./footer.inc.php'); ?> <?php /* $Id: left.php,v 1.107 2002/08/23 08:09:55 rabus Exp $ */ /** * Gets the variables sent to this script, retains the db name that may have * been defined as startup option and include a core library */ require('./libraries/grab_globals.lib.php'); if (!empty($db)) { $db_start = $db; } /** * Gets a core script and starts output buffering work */ require('./libraries/common.lib.php'); require('./libraries/ob.lib.php'); if ($cfg['OBGzip']) { $ob_mode = PMA_outBufferModeGet(); if ($ob_mode) { PMA_outBufferPre($ob_mode); } } /** * Get the list and number of available databases. * Skipped if no server selected: in this case no database should be displayed * before the user choose among available ones at the welcome screen. */ if ($server > 0) { PMA_availableDatabases(); // this function is defined in "common.lib.php" } else { $num_dbs = 0; } /** * Send http headers */ // Don't use cache (required for Opera) $now = gmdate('D, d M Y H:i:s') . ' GMT'; header('Expires: ' . $now); header('Last-Modified: ' . $now); header('Cache-Control: no-store, no-cache, must-revalidate, pre-check=0, post-check=0, max-age=0'); // HTTP/1.1 header('Pragma: no-cache'); // HTTP/1.0 // Define the charset to be used header('Content-Type: text/html; charset=' . $charset); /** * Displays the frame */ // Gets the font sizes to use PMA_setFontSizes(); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="<?php echo $available_languages[$lang][2]; ?>" lang="<?php echo $available_languages[$lang][2]; ?>" dir="<?php echo $text_dir; ?>"> <head> <title>phpMyAdmin</title> <meta http-equiv="Content-Type" content="text/html; charset=<?php echo $charset; ?>" /> <base<?php if (!empty($cfg['PmaAbsoluteUri'])) echo ' href="' . $cfg['PmaAbsoluteUri'] . '"'; ?> target="phpmain" /> <?php // Expandable/collapsible databases list is only used if there is more than one // database to display if ($num_dbs > 1 && !$cfg['LeftFrameLight']) { echo "\n"; ?>  <script type="text/javascript" language="javascript">  </script> <script src="libraries/left.js" type="text/javascript" language="javascript1.2"></script> <noscript> <style type="text/css">  </style> </noscript> <style type="text/css">  </style> <?php } // end if ($num_dbs > 1) else if ($num_dbs == 1) { echo "\n"; ?> <style type="text/css">  </style> <?php } // end if ($num_dbs == 1) else { echo "\n"; ?> <style type="text/css">  </style> <?php } // end if ($num_dbs < 1) echo "\n"; ?> </head> <body bgcolor="<?php echo $cfg['LeftBgColor']; ?>"> <?php if ($cfg['LeftDisplayLogo']) { ?>  <a href="http://www.phpmyadmin.net" target="_blank"><img src="./images/pma_logo.png" width="88" height="31" border="0" alt="phpMyAdmin" /></a> <?php } echo "\n"; ?>  <div id="el1Parent" class="parent" style="margin-bottom: 5px"> <nobr><a class="item" href="main.php?lang=<?php echo $lang; ?>&convcharset=<?php echo $convcharset; ?>&server=<?php echo $server; ?>"><span class="heada"><b><?php echo $strHome; ?></b></span></a></nobr> </div>  <?php // Don't display expansible/collapsible database info if: // 1. $server == 0 (no server selected) // This is the case when there are multiple servers and // '$cfg['ServerDefault'] = 0' is set. In that case, we want the welcome // screen to appear with no database info displayed. // 2. there is only one database available (ie either only one database exists // or $cfg['Servers']['only_db'] is defined and is not an array) // In this case, the database should not be collapsible/expandable if ($num_dbs > 1) { // Light mode -> beginning of the select combo for databases if ($cfg['LeftFrameLight']) { echo ' <form method="post" action="index.php" name="left" target="_parent">' . "\n"; echo ' <input type="hidden" name="lang" value="' . $lang . '" />' . "\n"; echo ' <input type="hidden" name="convcharset" value="' . $convcharset . '" />' . "\n"; echo ' <input type="hidden" name="server" value="' . $server . '" />' . "\n"; echo ' <select name="lightm_db" onchange="this.form.submit()">' . "\n"; echo ' <option value="">(' . $strDatabases . ') ...</option>' . "\n"; $table_list = ''; $table_list_header = ''; $db_name = ''; } $selected_db = 0; // Gets the tables list per database for ($i = 0; $i < $num_dbs; $i++) { $db = $dblist[$i]; $j = $i + 2; if (!empty($db_start) && $db == $db_start) { $selected_db = $j; } $tables = @PMA_mysql_list_tables($db); $num_tables = ($tables) ? @mysql_numrows($tables) : 0; $common_url_query = 'lang=' . $lang . '&convcharset=' . $convcharset . '&server=' . $server . '&db=' . urlencode($db); if ($num_tables) { $num_tables_disp = $num_tables; } else { $num_tables_disp = '-'; } // Get additional infomation about tables for tooltip if ($cfg['ShowTooltip'] && PMA_MYSQL_INT_VERSION >= 32303 && $num_tables && (!$cfg['LeftFrameLight'] || $selected_db == $j)) { $tooltip = array(); $result = PMA_mysql_query('SHOW TABLE STATUS FROM ' . PMA_backquote($db)); while ($tmp = PMA_mysql_fetch_array($result)) { $tooltip[$tmp['Name']] = (!empty($tmp['Comment']) ? $tmp['Comment'] . ' ' : '') . '(' . (isset($tmp['Rows']) ? $tmp['Rows'] : '0') . ' ' . $strRows . ')'; } // end while } // end if // No light mode -> displays the expandible/collapsible db list if ($cfg['LeftFrameLight'] == FALSE) { // Displays the database name $on_mouse = (($cfg['LeftPointerColor'] == '') ? '' : ' onmouseover="if (isDOM || isIE4) {hilightBase(\'el' . $j . '\', \'' . $cfg['LeftPointerColor'] . '\')}" onmouseout="if (isDOM || isIE4) {hilightBase(\'el' . $j . '\', \'' . $cfg['LeftBgColor'] . '\')}"'); echo "\n"; echo ' <div id="el' . $j . 'Parent" class="parent"' . $on_mouse . '>'; if (!empty($num_tables)) { echo "\n"; ?> <nobr><a class="item" href="<?php echo $cfg['DefaultTabDatabase']; ?>?<?php echo $common_url_query; ?>" onclick="if (capable) {expandBase('el<?php echo $j; ?>', true); return false} else {return true}"> <img name="imEx" id="el<?php echo $j; ?>Img" src="images/plus.gif" border="0" width="9" height="9" alt="+" /></a> <?php } else { echo "\n"; ?> <nobr><img name="imEx" src="images/minus.gif" border="0" width="9" height="9" alt="-" /> <?php } echo "\n"; ?> <a class="item" href="<?php echo $cfg['DefaultTabDatabase']; ?>?<?php echo $common_url_query; ?>" onclick="if (capable) {expandBase('el<?php echo $j; ?>', false)}"> <span class="heada"><?php echo $db; ?><bdo dir="<?php echo($text_dir); ?>">  </bdo></span><span class="headaCnt">(<?php echo $num_tables_disp; ?>)</span></a></nobr> </div> <div id="el<?php echo $j;?>Child" class="child" style="margin-bottom: 5px"<?php echo $on_mouse; ?>> <?php // Displays the list of tables from the current database for ($t = 0; $t < $num_tables; $t++) { $table = PMA_mysql_tablename($tables, $t); $url_title = (!empty($tooltip) && isset($tooltip[$table])) ? str_replace('"', '"', $tooltip[$table]) : ''; echo "\n"; ?> <nobr><img src="images/spacer.gif" border="0" width="9" height="9" alt="" /> <a target="phpmain" href="sql.php?<?php echo $common_url_query; ?>&table=<?php echo urlencode($table); ?>&sql_query=<?php echo urlencode('SELECT * FROM ' . PMA_backquote($table)); ?>&pos=0&goto=<?php echo $cfg['DefaultTabTable']; ?>"> <img src="images/browse.gif" width="8" height="8" border="0" alt="<?php echo "$strBrowse: $table"; ?>" title="<?php echo "$strBrowse: $table"; ?>" /></a><bdo dir="<?php echo $text_dir; ?>"> </bdo> <a class="tblItem" id="tbl_<?php echo md5($table); ?>" title="<?php echo $url_title; ?>" target="phpmain" href="<?php echo $cfg['DefaultTabTable']; ?>?<?php echo $common_url_query; ?>&table=<?php echo urlencode($table); ?>"> <?php echo $table; ?></a></nobr><br /> <?php } // end for $t (tables list) echo "\n"; ?> </div> <?php echo "\n"; } // Light mode -> displays the select combo with databases names and the // list of tables contained in the current database else { echo "\n"; // Builds the databases' names list if (!empty($db_start) && $db == $db_start) { // Gets the list of tables from the current database for ($t = 0; $t < $num_tables; $t++) { $table = PMA_mysql_tablename($tables, $t); $url_title = (!empty($tooltip) && isset($tooltip[$table])) ? str_replace('"', '"', $tooltip[$table]) : ''; $table_list .= ' <nobr><a target="phpmain" href="sql.php?' . $common_url_query . '&table=' . urlencode($table) . '&sql_query=' . urlencode('SELECT * FROM ' . PMA_backquote($table)) . '&pos=0&goto=' . $cfg['DefaultTabTable'] . '">' . "\n"; $table_list .= ' <img src="images/browse.gif" width="8" height="8" border="0" alt="' . $strBrowse . ': ' . $table . '" title="' . $strBrowse . ': ' . $table . '" /></a><bdo dir="' . $text_dir . '"> </bdo>' . "\n"; if (PMA_USR_BROWSER_AGENT == 'IE') { $table_list .= ' <span class="tblItem"><a class="tblItem" id="tbl_' . md5($table) . '" title="' . $url_title . '" target="phpmain" href="' . $cfg['DefaultTabTable'] . '?' . $common_url_query . '&table=' . urlencode($table) . '">' . $table . '</a></span></nobr><br />' . "\n"; } else { $table_list .= ' <a class="tblItem" id="tbl_' . md5($table) . '" title="' . $url_title . '" target="phpmain" href="' . $cfg['DefaultTabTable'] . '?' . $common_url_query . '&table=' . urlencode($table) . '">' . $table . '</a></nobr><br />' . "\n"; } } // end for $t (tables list) if (!$table_list) { $table_list = ' <br /><br />' . "\n" . ' <div>' . $strNoTablesFound . '</div>' . "\n"; } $selected = ' selected="selected"'; $table_list_header .= ' <a class="item" target="phpmain" href="' . $cfg['DefaultTabDatabase'] . '?' . $common_url_query . '">' . "\n"; $table_list_header .= ' <span class="heada"><b>' . $db . '</b><bdo dir="' . $text_dir . '">  </bdo></span></a><br />' . "\n\n"; } else { $selected = ''; } // end if... else... if (!empty($num_tables)) { echo ' <option value="' . urlencode($db) . '"' . $selected . '>' . $db . ' (' . $num_tables . ')</option>' . "\n"; } else { echo ' <option value="' . urlencode($db) . '"' . $selected . '>' . $db . ' (-)</option>' . "\n"; } // end if... else... } // end if (light mode) } // end for $i (db list) // Light mode -> end of the select combo for databases and table list for // the current database if ($cfg['LeftFrameLight']) { echo ' </select>' . "\n"; echo ' <noscript><input type="submit" name="Go" value="' . $strGo . '" /></noscript>' . "\n"; echo ' </form>' . "\n"; if (!$table_list) { $table_list = ' <div>' . $strSelectADb . '</div>' . "\n"; } // Displays the current database name and the list of tables it // contains echo "\n" . ' <hr noshade="noshade" />' . "\n\n"; echo $table_list_header; echo $table_list; echo "\n" . ' <hr noshade="noshade" />' . "\n"; } // No light mode -> initialize some js variables for the // expandible/collapsible stuff else { ?>  <script type="text/javascript" language="javascript1.2">  </script> <?php } // end if... else... (light mode) } // end if ($server > 1) // Case where only one database has to be displayed else if ($num_dbs == 1) { $db = $dblist[0]; $tables = @PMA_mysql_list_tables($db); $num_tables = ($tables) ? @mysql_numrows($tables) : 0; $common_url_query = 'lang=' . $lang . '&server=' . $server . '&db=' . urlencode($db); if ($num_tables) { $num_tables_disp = $num_tables; } else { $num_tables_disp = '-'; } // Get additional infomation about tables for tooltip if ($cfg['ShowTooltip'] && PMA_MYSQL_INT_VERSION >= 32303 && $num_tables) { $tooltip = array(); $result = PMA_mysql_query('SHOW TABLE STATUS FROM ' . PMA_backquote($db)); while ($tmp = PMA_mysql_fetch_array($result)) { $tooltip[$tmp['Name']] = (!empty($tmp['Comment']) ? $tmp['Comment'] . ' ' : '') . '(' . (isset($tmp['Rows']) ? $tmp['Rows'] : '0') . ' ' . $strRows . ')'; } // end while } // end if // Displays the database name echo "\n"; ?> <div id="el2Parent" class="parent"> <nobr><a class="item" href="<?php echo $cfg['DefaultTabDatabase']; ?>?<?php echo $common_url_query; ?>"> <span class="heada"><?php echo $db; ?><bdo dir="<?php echo($text_dir); ?>">  </bdo></span><span class="headaCnt">(<?php echo $num_tables_disp; ?>)(<a href="diff_tables.php?db=<?echo $db;?>">Diff</a>)</span></a></nobr> </div> <div id="el2Child" class="child" style="margin-bottom: 5px"> <?php // Displays the list of tables from the current database for ($j = 0; $j < $num_tables; $j++) { $table = PMA_mysql_tablename($tables, $j); $url_title = (!empty($tooltip) && isset($tooltip[$table])) ? str_replace('"', '"', $tooltip[$table]) : ''; echo "\n"; ?> <nobr><a target="phpmain" href="sql.php?<?php echo $common_url_query; ?>&table=<?php echo urlencode($table); ?>&sql_query=<?php echo urlencode('SELECT * FROM ' . PMA_backquote($table)); ?>&pos=0&goto=<?php echo $cfg['DefaultTabTable']; ?>"> <img src="images/browse.gif" width="8" height="8" border="0" alt="<?php echo "$strBrowse: $table"; ?>" title="<?php echo "$strBrowse: $table"; ?>" /></a><bdo dir="<?php echo $text_dir; ?>"> </bdo> <a class="tblItem" id="tbl_<?php echo md5($table); ?>" title="<?php echo $url_title; ?>" target="phpmain" href="<?php echo $cfg['DefaultTabTable']; ?>?<?php echo $common_url_query; ?>&table=<?php echo urlencode($table); ?>"> <?php echo $table; ?></a></nobr><br /> <?php } // end for $j (tables list) echo "\n"; ?> </div> <?php } // end if ($num_dbs == 1) // Case where no database has to be displayed else { echo "\n"; echo '<p>' . $strNoDatabases . '</p>'; } // end if ($num_dbs == 0) echo "\n"; ?> </body> </html> <?php /** * Close MySql connections */ if (isset($dbh) && $dbh) { @mysql_close($dbh); } if (isset($userlink) && $userlink) { @mysql_close($userlink); } /** * Sends bufferized data */ if (isset($cfg['OBGzip']) && $cfg['OBGzip'] && isset($ob_mode) && $ob_mode) { PMA_outBufferPost($ob_mode); } ?>

2 3

[Phpmyadmin-devel] Analyzer: db, tables, columns, aliases
by Marc Delisle 31 Oct '02

31 Oct '02

Hi, please have a look at version 3 of this patch: https://sourceforge.net/tracker/index.php?func=detail&aid=625463&group_id=2… I would like to merge in a few days so that people who are not familiar with the patch utility can try it on the demo. Files include latest cvs modifications as of now. Marc

2 1

[Phpmyadmin-devel] Improvement to phpMyAdmin 2.3.0
by Ian.Davidson＠tayside.pnn.police.uk 31 Oct '02

31 Oct '02

Background A Data Dictionary had to be produced for our MySQL databases and we found that there was no functionality to do this. A page was written and I incorporated it into our version of phpMyAdmin. It was also noticed that the print view did not print too well for each individual table so the file for this was tweaked to enable proper printing. Files Changed tbl_printview.php3 db_details_structure.php3 - to include a link to the db_datadict.php3 file lang/english-iso-8859-1.inc.php3 - to include $strDataDict db_datadict.php - new file which produces the full data dictionary and prints each table at the start of a new page. header.inc.php3 - to include a .print style <<db_details_structure.php3>> <<db_datadict.php3>> <<header.inc.php3>> <<tbl_printview.php3>> <<english-iso-8859-1.inc.php3>> Our development team have all seen this change and have been very positive about it. I think this would be a good addition to any future releases of phpMyAdmin. Could you please let me know what you think Thanks Ian Davidson Analyst Programmer Internet email is not to be treated as a secure means of communication. TAYSIDE POLICE monitors all internet email activity and content. ** This communication is intended for the addressee(s) only. Please notify the sender if received in error. Unauthorised use or disclosure of the content may be unlawful. Opinions expressed in this document may not be official policy. Thank you for your co-operation. © TAYSIDE POLICE.

2 1

[Phpmyadmin-devel] Re: Phpmyadmin-devel digest, Vol 1 #418 - 1 msg
by Lo�c 29 Oct '02

29 Oct '02

Hi list! Chris Simmons asked: >I wanted to know if the searching was possible, say >for example, searching for a particular string as >fieldname, and reporting what table it was in. Click on the "Search" tab at the right frame after having selected a database. Loïc ___________________________________________________________________ Haut Débit: Modem offert soit 150,92 euros remboursés sur le Pack eXtense de Wanadoo ! Profitez du Haut Débit à partir de 30 euros/mois : http://www.ifrance.com/_reloc/w

1 0

[Phpmyadmin-devel] Re: Phpmyadmin-devel digest, Vol 1 #418 - 1 msg
by Chris Simmons 28 Oct '02

28 Oct '02

Hi all... I've been a long time lurker, long time user of php and your most excellent tool, phpMyAdmin. I wanted to know if the searching was possible, say for example, searching for a particular string as fieldname, and reporting what table it was in. The reason I ask is that I'm working on a fairly in depth project which deals with multiple languages, and I have several thousand rows already worth of material that is used for configuration data, language strings, etc. I thought it would be handy to have a quick search function where you can pop in some text, and it'd spit out what tables it lives in. Thanx in advance to any curious coders on the list willing to tackle this. Thanx again for a most excellent tool. Hopefully, when my project completes phase I, you'll see what I've been quietly working on too. (phpMyJobs, already at sourceforge.) Laters all. -Chris Simmons, Avid BeOS User, php geek. ;-)

1 0

[Phpmyadmin-devel] Rep: Myadmin
by Lo�c 27 Oct '02

27 Oct '02

Hi all! Evandro Veloso Gomes asked: >Do you put "striptags()" in querys result. Yep, we did. Why? Loïc ___________________________________________________________________ Haut Débit: Modem offert soit 150,92 euros remboursés sur le Pack eXtense de Wanadoo ! Profitez du Haut Débit à partir de 30 euros/mois : http://www.ifrance.com/_reloc/w

1 0

[Phpmyadmin-devel] Setting up phpmyadmin
by Bo Parker 27 Oct '02

27 Oct '02

I have seen this issue crop up several times in the forums but have found no resolution. I am running iis on Windows 2000, php 4.2.3 and phpMyAdmin 2.3.2. I have configured config.inc.php and when I reference index.php I get the error: Fatal error: Failed opening required './libraries/grab_globals.lib.php' (include_path='.;c\php\pear') in c:\inetpub\wwwroot\phpmyadmin\index.php on line 8 I wasn't sure if Winzip was unzipping a subdirectory called "libraries" so I created one of those but got a blank index when I tried that. I've opened my php.ini file and changed the include_path = '.' and "." and I removed the semicolon as well to be sure it wasn't read as a comment. I still get the error, but the "include_path=" just changes to read whatever I change the above to. I am new to php development (3 days young) and need some help. If this is the wrong list ot post this to, I am sorry. Please direct me to the proper list. I am about to start pullin my hair out over this one. Thanks, Bo Parker boparker(a)mindspring.com

2 1

[Phpmyadmin-devel] Returned mail--"translation"
by postmaster 25 Oct '02

25 Oct '02

File attachment: large.pif The file attached to this email was removed because it was infected with the W32.Klez.H@mm virus.

1 0