Action: means the sub is called from GUI.pm via do('tables.pl'); eval('sub()');
Sometimes it is possible that parameters will be used instead of param('table') values.
For example SaveNewTable() calls ShowNewTable( 'table', 'column count' ).
again if CREATE TABLE failed.
Action:
Shows a form to create a new table.
Action: Dont call direct.
Action: table will be print
in void context param( 'table' ) will be used.
Action
Export the Database.
In void context $m_sCurrentDb db will be used.
$formated_string = HighlightSQl();
todo: HighlightSQl as html and link to mysql documentation.
In void context param('table') and param('column') will be used.
Action: In void context param('table') and param('column') will be used.
this is the 'main' sub to excute sql within this system.
If you write your own sub write something like this:
sub foo {
print qq( #requestURI( url,id,txt ) <a href="javascript:requestURI('$ENV{SCRIPT_NAME}?action=bar&foo=true','bar','bar');">bar</a>);
}
sub bar{
ExecSql('select * from bar') if param('foo');
Action: Excute SQL with the "SQL Editor".
Call this to show the table overview.
Action:Multiple Table Actions.
Action: Multiple Database Actions
EditEntry( $table, $id ) In void context param('table') and param('edit') will be used.
Action: SaveUpload
action: downLoadFile ( col, table, param)
Action: In void context param ( 'table' ) will be used.
Action: In void context param('table') will ne used.
private
action:
create the Table Menu and CreateDatabase CreateUser CreateTable ChangeCurrentDb SqlEditor SqlSearch forms.
the rights for $m_hUserRights will be initialized
return a <select><option>...</option></select> with the Tables from the current DB.
returns a <select><option>...</option></select> with the Databases GetDatabases(name, selected Databases)
(select) GetUsers(name, selected)
Action;
return the data types GetTypes( selected type, select_name, table, field , \$hrSet );
To install MySQL::Admin, copy and paste the appropriate command in to your terminal.
cpanm
cpanm MySQL::Admin
CPAN shell
perl -MCPAN -e shell install MySQL::Admin
For more information on module installation, please visit the detailed CPAN module installation guide.