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 append to $m_sContent
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.
this is the 'main' sub to excute sql within this system.
If you write your own sub write something like this:
sub foo{
$m_sContent .= 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.
Multiple Table Actions.
Multiple Database Actions
EditEntry( $table, $id ) In void context param('table') and param('edit') will be used.
EditAction()
In void context param('table') will be used.
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.